My laptop is in domain A but my SQL server is in domain B and only uses Windows Authentication.
There is no trust relationship between the domains.
How can I open SSMS and manage my SQL instance?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
My personal preference is to use ShellRunAs - to run the application with a different set of user credentials. That way you can run SSMS as a user from domain B, and use the windows authentication goodness.
No one has followed this question yet.
dbo Permission Issue
Members in Multiple Domain Groups
Login Error for Windows Login
Finding the user's login