0

I connect to an SQL Server instance with SQL Server Management Studio (SMSS) where the server name that includes a back slash to designate the instance, (eg: DevServer.Company\Frontend). I authenticate using Windows Authentication from an account different than the one I use to log into my computer. To do this, I currently launch SSMS using runas /netonly

runas /netonly /user:DOMAIN\my_username "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Ssms.exe"

This works, but is a bit inconvenient. As an alternative, I tried adding the login to the Windows Credential Manager with the network address DevServer.Company\Frontend:1433. However, I get an error saying, "This information cannot be saved." Saving credentials for a different server that doesn't contain a backslash works just fine.

What is the correct way to store credentials in the Windows Credential Manager for an SQL Server where the server name includes a backslash to specify the instance?

enter image description here

Stevoisiak
  • 123

1 Answers1

0

Try without it just <server>:<port> because a named instance maps to one port anyway. Kindly report back if it works!

Ivan R.
  • 1