On SQL Server 2005 Express Edition (I don’t know how’s on full version, never had a license for it) the default connection model is through named pipes and TCP/IP is disabled.
If you want to connect to it from Oracle SQL Developer using jTDS driver it will throw a generic connection failure, as he is trying just TCP/IP. The error looks like this:
In ordrer to enable TCP/IP you have to do a few steps:
1. From SQL Server Configuration Manager, go and expand “Network Configuration”, choose “Protocols for SQL Server Express” and enable TCP/IP
2. Open TCP/IP properties page, go to the second tab “IP Addresses” and in the last field called “IPAll – TCP Port” enter your port number. You might want to choose 1433.
3. Restart SQL Server Express service.
4. Try again from SQL Developer. This time will work!
Good luck,
Andrei
Related posts:
Thanks a lot Andrei, that’s just the problem I encountered.
great! that was the idea, to share things that I came across with.
Thanks, you saved the day.
THANKS !!!
I was looking for a solution for the SQL connection.
[…] Enable TCP/IP on SQL Server 2005 Express Edition » Andrei DANEASA (tags: sqlserver microsoft configuration) Interesting Links […]
Great answer. Solved my problem. Thanks.
AWesomeeeeeeeeeeeeeee
Great Answer.solved my problem…Thanks dude.
Great article!
But if the button “Retrive database” does not appear, which may be the cause ?
Thanks!
[…] http://www.webxpert.ro/andrei/2009/05/31/enable-tcpip-on-sql-server-2005-express-edition/ […]