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
How to verify if a SQL Account is still used?
Can't connect to SQLEXPRESS server remotely from SSMS - Login failed
logins to sa
Error 18456 NT AUTHORITY\SYSTEM