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"
Posted by at

2 comments:

  1. AnonymousDecember 9, 2013 at 9:06 PM

    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. JReyesJanuary 27, 2014 at 10:25 PM

    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.

Subscribe to: Post Comments (Atom)