I need help connecting to my SQL Server 2005 database that runs on a non-standard port. The default port 1433 is not being used in my setup. When I open SQL Server Management Studio and try to establish a connection, I cannot figure out where to enter the custom port number. I have tried different approaches but keep getting connection failures. The server is definitely running and accessible, but I think the issue is that Management Studio is trying to connect using the default port instead of the one my database is actually listening on. What is the correct way to specify a custom port number in the connection dialog? Is there a specific format I need to follow when entering the server name?
Oh interesting! Are you running multiple instances? The comma method sometimes fails with firewall issues - check if that port’s actually open on your network. What’s the exact error message when it fails?
yep, just throw a comma and the port after your server name like servername,1435. it’s easy peasy for those custom ports!