I have windows 7 Ultimate, 64bit. I have installed SQL Server 2008 Express and have created a database in it.
I have a jar that helps me create a connection file to connect to this database. I have used this on several other computers (XP/Win2003) and it has worked fine.
However, testing the connection gives me a connection refused.
So I started troubleshooting by first installing the Telnet client and trying to hit SQL Server Express. No joy:
This is my home PC. No Windows Firewall running. Default install of SQL Server (port number is 1433) Can hit SQL Server in SQL Server Mgmt Studio fine.
- Why is Telnet failing?
- How to troubleshoot further?
Thanks.
答え1
Have you enabled TCP/IP as a connection option for the instance in SQL Server Configuration Manager?
答え2
Check that your protocols are enabled in Start\Microsoft SQLServer\Configuration tools\Configuration manager.
On the task bar to the left, select SQL Server Network Configuration, and enable Shared Memory, Named Pipes and TCP/IP.
Select SQL Server Services and restart SQL Server Browser and SQL Server.
See if that helps