Connect different Windows User in SQL Server Management Studio (2005 or later)

by

While there’s no way to connect to multiple servers as different users in a single instance of SSMS, what you’re looking for is the following RUNAS syntax:

runas /netonly /user:domain\username program.exe

When you use the /netonly switch, you can log in using remote credentials on a domain that you’re not currently a member of, even if there’s no trust set up. It just tells runas that the credentials will be used for accessing remote resources – the application interacts with the local computer as the currently logged-in user, and interacts with remote computers as the user whose credentials you’ve given.

You’d still have to run multiple instances of SSMS, but at least you could connect as different windows users in each one.

For example: `runas /netonly /user:domain\username ssms.exe`

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. sql server 2008 management studio not checking the syntax of my query
  3. Is the NOLOCK (Sql Server hint) bad practice?
  4. How to create a table from select query result in SQL Server 2008 [duplicate]
  5. How to create composite primary key in SQL Server 2008
  6. Parse comma-separated string to make IN List of strings in the Where clause
  7. OPTION (RECOMPILE) is Always Faster; Why?
  8. sql runs fast in ssms slow in asp.net
  9. Sub queries in check constraint
  10. Rename column SQL Server 2008
  11. How do I use structural annotations to set SQL type to Date in model first approach
  12. Sql Server deterministic user-defined function
  13. Compare DATETIME and DATE ignoring time portion
  14. Split function in SQL Server 2008
  15. Remove numbers from string sql server
  16. How to enable Ad Hoc Distributed Queries
  17. How do I edit a table in order to enable CASCADE DELETE?
  18. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  19. SQL Server SELECT LAST N Rows
  20. WHERE Clause to find all records in a specific month
  21. How can I group by date time column without taking time into consideration
  22. The transaction log for the database is full
  23. Select SQL Server database size
  24. Check if a parameter is null or empty in a stored procedure
  25. Cannot Resolve Collation Conflict
  26. Execute sp_executeSql for select…into #table but Can’t Select out Temp Table Data
  27. Display next event date
  28. Select rows where column value has changed
  29. Issues with SQL comparison and null values
  30. How do you read XML column in SQL Server 2008?

Leave a Comment