Tip: How to connect to a database with different credentials in SQL Server Management Studio | Shwuzzle

Tip: How to connect to a database with different credentials in SQL Server Management Studio

filed in Tips on Jan.06, 2012

If you are logged into your machine with a username that doesn’t have access to a certain SQL Server database you can launch SQL Server Management Studio with different credentials. This allows you to use Windows Authentication with a different username when connecting to the database server.

runas /user:DOMAIN\USERNAME “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”

Tags: microsoft, sql server, tips

2 Stars

3 Stars

4 Stars

5 Stars

(No Ratings Yet)

Loading ...

Leave a Reply

You must be logged in to post a comment.

Recent Posts
Recent Comments

Categories
- Algorithms (9)
- Artificial Intelligence (7)
- Complexity and Computability (2)
- Computer Science (14)
- Cryptography (2)
- Data Structures (1)
- Distributed Systems (1)
- Education (13)
- Gaming (8)
  - PC (5)
- Hardware (8)
- Miscellaneous (11)
- Operating Systems (22)
  - Android (1)
  - Linux (10)
  - Mac OS X (4)
  - Unix (7)
  - Windows (2)
- Programming (49)
  - C/C++ (6)
  - Java (1)
  - Javascript (5)
  - Perl (2)
  - PHP (1)
  - SQL (2)
- Projects (8)
  - Applications (2)
  - Labs (1)
  - Scripts (2)
  - Web Applications (1)
- Security (1)
- Tutorials (13)
  - Tips (11)
Archives
- May 2013 (2)
- April 2013 (3)
- February 2013 (1)
- January 2013 (9)
- December 2012 (2)
- October 2012 (2)
- July 2012 (1)
- June 2012 (1)
- May 2012 (3)
- March 2012 (3)
- February 2012 (2)
- January 2012 (8)
- December 2011 (7)
- November 2011 (4)
- October 2011 (3)
- September 2011 (2)
- August 2011 (6)
- July 2011 (1)
- June 2011 (3)
- May 2011 (4)
- April 2011 (5)
- March 2011 (3)
- February 2011 (6)
- January 2011 (10)
- December 2010 (8)
- November 2010 (7)
- October 2010 (2)
- September 2010 (14)
- August 2010 (11)

Account
- Register
- Log in

Follow Us On Twitter