I've been workink with a WebService locally using a
connection string with 'data source=(local)' for a number
of weeks and I wanted to move my database onto our
production server, Zeus.
So i change the connection string to 'data source=Zeus'.
When I Preview Data in Visual Studio .NET every thing
works but when i access the database from my WebService
it returns:

"System.Data.SqlClient.SqlException: SQL Server does not
exist or access denied."


Since it does exist and I can access it from Visual
Studio .NET it must be and access issue.

I've not had any luck adding ASPNET to my list of logins
in SQL Server nor making inetinfo.exe run under another
user identity by changing the machine.config processModel
tag.

If anyone has any ideas, well, reply, I suppose.

Thanks in advance.

If you're comfortable with Microsoft Network Monitor, then make a quick
trace of the connection attempt from the client machine (IIS). Otherwise,
try making a Test ODBC DSN to the same server. If it fails, note the OS
Error, and search the kb for this.

Example : OS Error 53 = Network name not found (Usually WINS name
resolution issue) connection tried using Named Pipes
OS Error 11001 == Host not found (Usually DNS problem)
connection tried using TCP.
Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.