Changing SQL Server 2005 Port

Writing by shivdev on Monday, 29 of October , 2007 at 4:15 pm

Having trouble getting your application connecting to SQL Server 2005? You probably think there’s something wrong with JDBC driver or your connection URL etc. It could be – but for me it turned out that default installation of SQL Server 2005 configured it to port 1036 instead of the default 1433. Who Knows? Don’t Ask. Maybe 1433 was in use by some other program or by SQL Server 2005 because it didn’t get uninstalled correctly.

Looked around for a bit and here’s a nice link if you want to read how.

• SQL Server Browser Service

Or you can simply

• Click Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager
• Go to SQL Server 2005 Network Configuration
• Right Click on TCP/IP
• Click the IP Addresses Tab
• Change the port in the IPAll section

Leave a comment

Category: SQL DB

• Add this post to
• Del.icio.us -
• Digg -
• -
• Tweet -

No comments yet.

You must be logged in to post a comment.