When working with DBXL and other
applications, you need SQL. Some organizations deal with multiple SQL
instances and this can create a problem if some SQL instances are on
different domains. When we attempt to connect an SQL instance using SQL
Server Management Studio, we might encounter an error that reads: ‘Cannot generate SSPI context’.Here’s a workaround if you find yourself in a similar situation:
1. Launch command prompt (cmd).
2. Use “runas” to launch SQL Server Management Studio. Specifying the userdomain\useralias of the account user.
For SQL Server 2008 Management Studio, the command will be similar to this:
runas /netonly /user:userdomain\useralias
"C:\Program Files\Microsoft SQL
Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
For Microsoft SQL Server Management Studio 2005, you’ll use this:
runas
/netonly /user:userdomain\useralias "C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
Note: This should work on Vista, Windows 7 and Windows Server 2008, but has not been tested with 2003 or XP.