Hello Everyone and thanks for your help in advance. I am racking my brains on this one. I have a new installation of Windows 2003 Server combined with SQL Server 2000. I have ASP.Net pages that are working perfectly fine on a test server. However, when I try the web pages on the new server, I am presented with the error message:

SQL Server Does Not Exist or Access Denied

I have verified that the server is allowing both Windows and SQL Server authentication. I have installed all of the latest services packs. In the web.config file, I am using the following connection string:

server=(local);uid=sa;pwd=password;database=Northw ind

I cannot figure out what the problem is. Any help is greatly appreciated. Thanks.

Does the SQL server reside on the same machine or you are trying to connect to the one on old test server?

_________________________
- Vijay G
Strive for Perfection

I feel that u had ur test database on local test machine. But now u r trying to run on another machine. The connection string says to connect to a local server which I am sure doesn't exist /installted on the machine u r running the page.

In ur web.config file or anywhere use the connectioj string with the server name like

server=MyServer;uid=sa;pwd=password;database=North wind.





B. Anant

Also, change your uid to something other than the sa. Keep this to an account that does not have many rights to the SQL Server database.



Sal