unable to connect sql server 2000 on network

30 pts.
Tags:
Microsoft SQL Server 2000
SSMS
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Psingh16
    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
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following