November 19, 2006 at 10:57 am
I have 2 machines running Windows XP pro on a home network. I have SQL Server 2000 installed on both machines. When i try to register the other machines instance 'Login failed for user 'username'.
one machine is called WOOD, the other machine is called LAPTOP - they both have named instances of SQL Server running.
But I cant seem to add a new user like "Wood\user1" to the LAPTOP machine or add
"LAPTOP\user1" to the WOOD. It does not see the WOOD Domain
???very confused???
November 20, 2006 at 6:01 am
You don't actually have a domain. WOOD and LAPTOP are either the computer names or the workgroup names. The easiest way to share the servers would be to change the SQL Server security settings for both instances to mixed mode. Then, register the other server using either the sa account, or a newly created SQL Server login.
November 20, 2006 at 11:36 am
Your windows account, when not in a domain, is MachineName\UserName. MachineName is the name of the computer itself, not the name given to the SQL Server instance. If you don't know the computer's name, right click on "My Desktop" and click properties.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply