unable to connect sql server 2000 on network
We have sql server 2000 instance on a machine say "comp1".The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the "comp1" via run and give password then i am able to connect through SSMS Can someone give a solution so that users dont need to know computer's password to work on sql server
Software/Hardware used:
Software/Hardware used:
ASKED:
March 29, 2012 1:19 PM
UPDATED:
April 11, 2012 3:07 PM
Answer Wiki:
Are you trying to connect via Windows authentication? If so they you either need to have all the computers on a Windows domain or the account that you are logged into your computer with needs to have an account on the SQL Server with the same username and password.
To see all answers submitted to the Answer Wiki: View Answer History.
I use sql authentication
There is no domain here all systems are independent i.e workgroup The problem is users who need to query data first need to connect in run on start menu as \comp1
then give
username administrator
password-pass
in connect dialog box
to work on queries and SQL server authentication is used then too its not working unless you connect to box on which its running So people are able to access files on the system “comp1″ when they are supposed to only work with queries
I always use SQL authentication
Thanks for answering
psingh16
Msg 17,level 16 State 1
Microsoft ODBc SqlServer Driver DNETLIB Sql Server does not exist or access is denied
But once you connect after giving password of computer it connects instantly
Hope there may be some way out