Log into another XP machine's SQL Server with a different userid? (WORKGROUP, not domain)
- by Eric H.
I have two machines at home, both XP Pro SP3. I have no domain controller, so they're both just in WORKGROUP.
How can I, using Windows Authentication, log into an instance of SQL Server running on the other machine?
Whenever I try it, it seems to try to login as 'Guest', even though I have entered the machine name (OTHER-DESKTOP), and login (OTHER-DESKTOP\otheruser) in the User Accounts Control Panel box.
It works fine if I use sql server name and password, so I know the server is running.
Any clues?