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
Upto how many databases we could connect with the help of a login?
SQL Server LOGIN issue
Server role of public trumps db_owner and prevents SSMS from displaying database list?
How to copy logins/permissions from one server to anathor server?