sql server is no longer listening on tcp 1433

We had an issue where our SQL 2008 Express server rebooted and for some reason it's no longer listening on tcp 1433.
It has changed to 53300
Can someone tell me how I can change it back to 1433?

thanks
FREDARCEAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
pwnbasketzConnect With a Mentor Commented:
Not sure if it's the same in SQL 2008 Express, but I would imagine it is.  I'm wondering if the listener was somehow configured to listen on a dynamic port.  Regardless, I would try the following first.  Let me know if you have any luck:

http://support.microsoft.com/kb/823938

As always, make sure you backup the registry hive before you ever monkey with it =)
0
 
arnoldCommented:
Use the SQL server configuration tool, and check the tcp configuration for the SQL server instance.
0
All Courses

From novice to tech pro — start learning today.