We're having an issue here at school with trying to access a SQL
Server database from a .NET application. As a department, we roll out
a generic image to all of our lab computers. For some reason we were
getting "SQL Server does not exist or access denied" errors (
http://www.isy.vcu.edu/~cstewart/sqlerror.jpg ). One of the lab
machines in the lab worked fine and could connect without any issues.
As a quick fix, we re-imaged 3 of the machines that didn't work with
the one that did work. That resolved the issue for the current class
that needs to do this.
Today I went and downloaded one of the starter kits from asp.net (
http://asp.net/Default.aspx?tabindex=9&tabid=47 ). I downloaded the
package, installed it, and chose to do a remote install for SQL
Server. As requested, I logged into our central SQL Server machine
(the same server as mentioned above) using Query Analyzer from my
workstation and ran the 3 SQL scripts to create the needed database. I
double checked the user login given by the program and I can login via
Query Analyzer just fine. Yet when I run the application in VS.NET or
just locally in IE, I get the "SQL Server does not exist or access
denied" error mentioned above. The few people that have been working
with this problem are stumped. We all think there is some security
setting that hasn't been set properly which isn't allowing me to
connect to the database via the code.
Also, we tried to run the application on a machine outside of the
domain and it worked fine. The database was found and connected to
without any issues. I'd really appreciate any feedback as this has
really crippled our Universities opportunity to experiment with .NET.