Posts Tagged ‘SQL Server 2005’
Where’s port 1433 in SQL Server 2005?
Ever wonder why after installing SQL Server 2005 you encounter this problem?
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)
I also encountered the same problem using our products in Control Manager 5.0, InterScan Web Security Suite 3.1 and InterScan Messaging Security Suite 7.0 (using MSSQL 2005) that I’m unable to telnet port 1433 and unable to find this port listening using netstat.
Here’s what I did:
NOTE: In this example, I used my Vista Ultimate PC installed with VS 2005 SP1 and MS SQL Server 2005 Sp1 + SQL Management Studio. I also assume you double check already that there’s no firewall and/or any other program that could block the port 1433. Otherwise, you can visit the Microsoft site for further details – http://support.microsoft.com/kb/914277
- Go to Start > Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager
- Click [+] SQL Server 2005 Network Configuration (32bit) and select Protocols for MSSQLSERVER
- Right-click the TCP/IP and select Enabled. You will be notified that in order for the changes to take effect you need to restart the SQL Server related services
- Right-click again the TCP/IP and select Properties; click the IP Addresses tab
- You should select Yes for the Enabled parameter as shown in the image with red circle around it
- Click Apply and OK to close
- Once you’ve returned to SQL Server Configuration Manager, select SQL Server 2005 Services and restart both the services
- Check if you’re able to logon now
Hope this helps! Any suggestions/comments are highly appreciated.
