Ok I get the same error every time i trie to connect to my SQL server (local or my IP). I used user name sa, then i tried to create a new login same as sa but nothing happend and the same crap ://// Plz help me
Printable View
Ok I get the same error every time i trie to connect to my SQL server (local or my IP). I used user name sa, then i tried to create a new login same as sa but nothing happend and the same crap ://// Plz help me
I'm not particularly experienced with troubleshooting SQL Server, but the error message makes me suspect that you did not enable SQL authentication for your server.
Quote:
Originally Posted by Bruenor1
and maybe something with the DBScripts :P
how to enable SQL authentication for your server?
(This is assuming you are using SQL Server 2000 and have enterprise manager set up so that you can access your server.)
In enterprise manager, right-click on your server and select Properties. Go to the Security tab, where you will find a box labeled "Security". Make sure that the authentication is set to "SQL Server and Windows", not "Windows only".