Thursday, July 5, 2012

SQL Server Management Studio Tips

How do I indicate a different port number when connecting to the server using SQL management Studio?

127.0.0.1,6283 add a comma between the ip and port

How do I Connect To A Database Using Windows Authentication With Different Credentials Using SQL Server Management Studio?

runas /netonly /user:domain\name "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

2 comments:

  1. These are indeed very helpful information. Those who are in charge of remote server management are surely grateful of this article. Thank you for posting.

    ReplyDelete
  2. A very informative article on SQL server management. Those who are in-charge of technical support tasks will surely find this post helpful. Thanks for sharing.

    ReplyDelete

Thanks for adding to the conversation. I'll update your post shortly.