Jul 08
sql server 2008 & port 1433
There’s hundreds of guides about how to do this. I’m putting this here as a reminder to myself.
By default sql server 2008 doesn’t bind to a tcp/ip port.
Open SQL Server Configuration Manager on the sql server and select SQL Server Network Configuration (32 or 64bit). You’ll see a list of protocols, right click on TCP/IP and Enable it. Now right click again and go to Properties. Go to the IP Addresses tab.
You may want to set the port for IP1 & IP2. The TCP Port may be blank, enter 1433 in the field. Scroll down to the bottom and you’ll see IPAll. Enter 1433 in the TCP Port box. Press Apply & Save. You’ll now need to restart your instance of SQL Server.
Do netstat -an | find 1433 and you should see sql server LISTENING on port 1433.
5 notes
-
emileeyou89 liked this
-
skunkmuffin posted this
