I had a problem connecting to SQL Server 2000 from Visual Studio 2003.
I could connect with Query Analyser, Enterprise Manager and Visual Web Developer 2005 Express.
I tried lots of combinations of (local), localhost and mymachinename based on previous experience but nothing worked. I also restarted the server to no effect.
The error returned was "sql server does not exist or access denied", which was standard microsoft horseshit.
When running from Visual studio trap the mysqlconnection.open() statement in a try catch statement to get this error message, otherwise you get a much less useful and more generic message along the lines of "System Error".
In the end I fiddled with the Server properties and set the "Audit level" from "None" to "All" and unticked "Allow other servers to connect remotely .... using rpc". The server reset and everything started working.
No idea why.
This link is also helpful with some bakground on the (local), localhost, mymachinename type issues.
change (local) to localhost and what's the difference
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment