Groups | Blog | Home
all groups > sql server clients > february 2007 >

sql server clients : SQL Server on workgroup !


Rogers
2/22/2007 3:32:55 PM
I have two servers ServerA and ServerB, both are on the workgroup, I don't
wanna install domain controller, I have installed SQL Server 2000 on ServerA
and now I want to add windows account of ServerB into SQL Server (ServerA)
like ServerB\UserName? but it gave me an error.

I am wondering is there any way I can do that?


Thanks

Sue Hoegemeier
2/22/2007 10:07:54 PM
You won't get that working with the domain prefix. What you
can do though is create the same accounts with the same
passwords on ServerA for the accounts on ServerB. That's
about as close as you can get in that scenario.

-Sue

On Thu, 22 Feb 2007 15:32:55 -0500, "Rogers"
[quoted text, click to view]
AddThis Social Bookmark Button