Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Integrated security on a machine not on a domain

Author  Topic 

sherrer

64 Posts

Posted - 2011-04-01 : 12:10:29
I am trying to connect ssms to a server using integrated security that is on a different domain as the Win 7 machine that I am on. I can use runas /netonly /user:domain\user ssms.exe to start ssms which pops up a window to enter the domain password for the user in the runas statement. The application starts and I have no problem connecting to the server. What I would like to do is save the credentials so that I don't have to enter the password everytime. I have tried to use the credential manager in Win 7 to save the domain credentials, but when trying to connect to a server in ssms all I get is "Login failed for user ''" Does anyone know a solution?
   

- Advertisement -