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.
sc config “service name” start= disabled
you need a space between = and the start status
If you’ve mounted someone elses vista/win7 C drive on your vista/win7 box you may need to take ownership of the whole drive in order to backup their profile. Right click on drive -> Properties -> Security -> Advanced -> Owner tab -> Select your username. Press Apply/Ok
“I fucking just contracted smallpox. Nearly 26 lets go rape a fucking triceratop.”
Would be better if yonkers started with that
