sql server connect: Hi There,
I'm using windows xp and sql server 2000.
I installed sql server to my pc and it's workin so fine.

When I log in to my windows with a domain server my sql server connection
fails.
What must I do to fix this problem. Is it related with sql
server-properties-security.

Thakns for your time....

I taking a guess here:

When you log onto your machine, the machine name becomes the DOMAIN name, so
that "MyMachine\User" is your full security context. If that was how you
installed SQL Server, then "MyMachine\User" probalby had administrative
rights on the computer.

However, when you log into a Windows Domain, your security context is
"DomainName\User" which may NOT have administrative rights on the machine.

There are a couple of things you can try: If you set up your SQL instance as
Mixed Authentication (SQL Server and Windows) then log in using the 'sa'
account. If you went with strictly Windows Authentication, then log into SQL
Server using the MyMachine\User context and add DomainName\User as a SQL
Server Login, and make that account a member of the sysadmin fixed server
role.

Hope this helps! Good luck.

Todd C

[quoted text, click to view]