Re: SQL Server Mode

tech-pete (techpete@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I see in the last post by Erland, for a workgroup using windows
authentication the computers have to use the same user/password. I have 4
setup in a workgroup and all are using the same username and password the
only thing different is the computer name for each computer and I cannot
connect to the computer that has the SQL database.

You never said which operating system you have, did you?

Most likely, you need to change a local security policy. On Vista, you
find Local Security Policy on the Start Menu under Administrative tools.
Expand "Local Policies" and then "Security Options". Scroll down until you
find "Network access: Sharin and security model for local accounts". Set
this to Classic.

On XP I don't recall that you find this equally easy under the Start Menu,
but you can run gpedit.msc from the command line. Then you will enter on
a higher note, but Computer Configuration -> Security Settings will lead
you to Local Policies.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages