Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 609
  • Last Modified:

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
0
FREDARCE
Asked:
FREDARCE
1 Solution
 
pwnbasketzCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now