Solved

sql server is no longer listening on tcp 1433

Posted on 2012-03-23
2
599 Views
Last Modified: 2012-06-27
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
Comment
Question by:FREDARCE
2 Comments
 
LVL 4

Accepted Solution

by:
pwnbasketz earned 500 total points
ID: 37759802
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
 
LVL 77

Expert Comment

by:arnold
ID: 37760468
Use the SQL server configuration tool, and check the tcp configuration for the SQL server instance.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQl Query to find x consecutive Nbrs in a Table 30 97
AD and SQL Server 2016 2 28
SQL R 21 25
Get Next number from Stored Procedure 8 22
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question