Hard time connecting
-
Hello all,
I have just installed sql2000 on another computer in my home and for some reason i am not able to get a connection from vb.net to the server. i have even set a new login and role and nothing will work,, ACCESS DENIED!!
Can someone please tell me what to look for?
erik
Dam again!
-
Do you have your own domain setup at home, or are you just in a workgroup?
If you're using a workgroup then make sure you haven't specified "Windows Only" for the authentication mode. Windows authentication only works in the Windows Domain security model.
For the workgroup, you'll need to make sure that the SQL username and password you're trying to use has a) been granted access to the server by creating a login, and b) been granted access to the database by creating a user.
Take a look at "Managing Security" in Books Online and it'll provide details on how to set the authentication modes and create users.
--------------------
Colt 45 - the original point and click interface
-
I am not on a network; i just for some reason can not seem to get loged into this sql2000.
Not sure what to look for..??
Dam again!
-
I got it. Under Server Roles i had to add my role..
Dam again!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply