SQLDBAgeeks
Contact Us
Home
Contact
Services
Thursday, August 12, 2010
How to change the default port in MS SQL server ---2005 2008
By default MS SQL server 2005 uses dynamic ports. You have to change the port to static if needed.
Go to SQL server configuration
>Protocols for MSSQL
>click TCPIP
>IP Address
>remove dynamic port
>TCP port
change to your specific port
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment