Home » SQL & PL/SQL » Client Tools » Connect to mssql\express 2008 (SQLDeveloper 3)
Connect to mssql\express 2008 [message #491957] Sat, 29 January 2011 02:22 Go to next message
Al_Petro
Messages: 14
Registered: January 2011
Junior Member
Hi All!
I have installed and loaded a mssql\express database on my pc for migration testing. When I test a connection from sqldeveloper 3 receive "Failure -Test failed Cannot connect to Microsoft SQL Server on localhost. I am using windows authentication and SQL Server authentication and the default port 1433. And it is 1433.
Thanks in advance

[Updated on: Sat, 29 January 2011 02:26]

Report message to a moderator

Re: Connect to mssql\express 2008 [message #492339 is a reply to message #491957] Sat, 29 January 2011 10:15 Go to previous messageGo to next message
Littlefoot
Messages: 21333
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What steps did you take? Does this blog entry help?
Re: Connect to mssql\express 2008 [message #492351 is a reply to message #492339] Sun, 30 January 2011 01:31 Go to previous messageGo to next message
Al_Petro
Messages: 14
Registered: January 2011
Junior Member
Thank you for response.
I've installed third party JDBC drives for SQL Server and I have SQLServer tab on Oracle SQLDeveloper. I've seen the blog you have pointed to. But I found it confusing to set the name of connection as name of one of databases of the SQL Server (as I understood it). I certainly will try now.
Re: Connect to mssql\express 2008 [message #492419 is a reply to message #492351] Mon, 31 January 2011 01:40 Go to previous messageGo to next message
Al_Petro
Messages: 14
Registered: January 2011
Junior Member
I've installed SQL Server 2008 (No "express"!) on another PC. Enabled port 1433. Ping works. But problem hadn't gone.
May be:
1. User I used (sa) doesn't have needed privileges? What to use?
2. I steel don't have access to port 1433. How to check?
3. Firewall is blocking access. What exactly should I do in it (Firewall user interface don't offer me SQLServer in its lists).
Hope answer is in this scope.
Re: Connect to mssql\express 2008 [message #492590 is a reply to message #492419] Tue, 01 February 2011 05:52 Go to previous messageGo to next message
Al_Petro
Messages: 14
Registered: January 2011
Junior Member
Thank you Littlefoot!
Finally I found msdn.microsoft.com/en-us/library/ms190944.aspx
(I cannot use links until I have posted more than 5 messages)
And did the next steps:
1. Enabled MSSQLSERVER->TCP/IP protocols.
2. Opened port 1433 in the Windows firewall for TCP to access Database Engine.
3. Opened port 1434 in the Windows firewall for UDP to access SQL Server Browser.
4. Activated SQL Server Browser.
5. Named connection "MSSQLSERVER".
It can be I did unneeded steps, but it works now.
Thank you for you help.
Best regards!
Re: Connect to mssql\express 2008 [message #492614 is a reply to message #492590] Tue, 01 February 2011 07:34 Go to previous message
Littlefoot
Messages: 21333
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you for the feedback! I'm glad you made it work.
Previous Topic: sql*plus history
Next Topic: Oracle SQL Developer Connection
Goto Forum:
  


Current Time: Sun Jan 21 09:33:06 CST 2018

Total time taken to generate the page: 0.01375 seconds