windows login from remote client machine

Question

Hi,

   How can access sql server 2005 from client machine using windows authentication.

  Both the sql server machine and the client machine are using XP pro.

 I am able to connect using the sql server authentication.

Thanks

---

~Sr. Database Analyst~

Answer 1

Do you have a domain ? If not, then the only chance is to have the same user name as well as password on both machines. At least that worked in the past as a workaround.

-Jens

---

Jens K. Suessmeyer http://blogs.msdn.com/Jenss

Answer 2

Hi,

If your id is domain user account you can add that to Remote Desktop Users group and your sql server allow remote connections should be enabled.

Then you can go to run--> type mstsc

Give your windows login name

windows password

and Domain

to connect to sql server.

Hope this helps!!

---

Regards, Vishal Srivastava