Have bee running development website successfuly. However have been seeing the above mesage for the last day and a hal when trying to run the website. Development environment is Visual Studio.net 2003 and SQL server 2000.

SQL server installed locally, so not trying to hit the network. This problem was intermittent, but now appears to be permanent. Connection string/logon details have not changed and are still valid.

Where are you getting this error message? On a web page...or SQL enterprise manager?

http://mynameissteve.com

Hi, it is occuring on a web page. It seems to be occurring as soon as the page tries to open the connection in web.config

Web.config points to the correct database and local machine name.

Have noted a couple of other things: 1) The website and sql server instance are installed/running on the same pc. However, can connect to this SQL server instance and database from another pc using the same development environment without any problems.

2) If I change the web.config on the affected machine so that the connection string points to another sql server instance on another pc, this works without any problems.
This suggests that the problem is with local installation of SQL server on machine affected.

Make sure you can coonnect via manager using the username/password in the config file. Use the surface area tool and make sure remote connections are allowed.

--

Joe (Microsoft MVP - XML)

"Make sure you can coonnect via manager using the username/password in the config file. Use the surface area tool and make sure remote connections are allowed."


Not sure what you mean here. The user and password is sa, password. Also, am not sure what you mean by the "surface area tool"

Have solved this one. My user account permissions on local machine were set to OLAP administrator. Don't know who did it, but setting permissions back to administrator sorted the problem.


Thanks