December 11, 2008 at 8:34 am
I have SQL Server 2005 and SQL Server 2008 Express running on the same machine. I have the 2005 version set up to use TCP/IP port 1433. It can be accessed remotely with no problem. In the SQL Server Configuration Manager, I set up the SQLEXPRESS edition to use port 1434 (this port has been allowed access through the firewall). When I try to restart the SQLEXPRESS service, I get the error "The SQL Server (SQLEXPRESS) service terminated with service-specific error 10048". The SQL Server error log has "Server TCP provider failed to listen on [ 'any' 1434]. Tcp port is already in use." However, when I run netstat, I don't see any process using 1434. What could be wrong? I have another server in which I was successful in remotely connecting to the SQL EXPRESS 2008 edition, but that server does not have any other version of SQL Server on it.
December 11, 2008 at 8:47 am
I'd suggest trying a different port
I thought port 1434 is used by SQL Browser, but that's UDP
On startup, SQL Server Browser starts and claims UDP port 1434
December 11, 2008 at 11:36 am
I heard that also and stopped SQL Server Browser. Plus nothing showed up as using port 1434. And I tried another port as well (also not being used) with the same error message showing up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply