I've set up MS SQL 2000 on Win XP(Pro).When I log into the system using my account and try to access the sql server through my webpg, I get the following error - SQL Server does not exist or access denied. I have attached the details below.

My system is the server and I'm using IIS to run the webpg. MS SQL was installed with 'mixed' authentication and my account id was also added into Security/Login. And there are no probs connecting to the database in Enterprise Manager.Could there be any configuration problem?

warmest regards,Nim

Details:Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

I also have the same problem.All last week plus the better part of this morning, my application could open the database with no errors. Now after restarting my machine, I keep getting a server error that SQL Server does not exist.Pasted below is the error page. Please help...

SQL Server does not exist or access denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Do you have a firewall in between the web server and the database server? If so, have you punched a hole in the firewall for the port that SQL Server is using? If so, then are you referring to this port in your connection string? If not, did you create an alias on the web server? An alias can be created using Client Network Utility if you have SQL Client Tools installed on the web server or you can manually add a string value to the registry. I've posted how to do this several times in the forums, so just search for it.

Hi TaraThe SQL Server database is local to my machine, so the firewall should not be an issue since that's on the network.I will search on creating an alias on the web server and let you know if I was successful.Thanks much

Just because it is auto start doesn't mean that it is started right now. It could have stopped. Please check the services applet in Admin Tools in Control Panel to verify. The name that you have specified in the connection string, can you ping it?

What's your email so that I could do screenshots and email you everything? I also noticed that everytime I restart my app, when I check the server the explorer, the connection to the db is broken and needs to be refreshed. Although this doesn't fix the problem either...so frustrating!!

So is this the name of your machine: VNASIBI-3RJ2051? Is that the name that you are using when you connect to SQL Server via Query Analyzer or Enterprise Manager? Is NewProjects the name of the database?

HiYes, my machine name is VNASIBI-3RJ2051.In my Enterprise Manager, I get two options, Local and production. Same as Query Analyzer. However, on the network, others see my system name. I also tried to open the webpage on another network machine by typing http://VNASIBI-3RJ2051/NewProjects/Webform1.aspx, I got an error message that it cannot be accessed remotely because of "I think" network security