Connection Refused Error when Connecting to SQL 2005 Express

Hi everyone!

I know there are lot of questions and answers regarding my problem, however I tried have many solutions on google without success. I wonder if its because I use a 64 bit version of Windows and SQL 2005 Express. It is also my first time using Eclipse Birt.

Currently have installed:
Windows 7 Professional 64-Bit
Eclipse BIRT Designer Version 2.5.2.v20100208 Build <2.5.2.v20100210-0630>
SQL 2005 EXPRESS for 64-Bit
JDBC Driver: jtds-1.2.5 (from http://jtds.sourceforge.net/)
Database Name: SQLEXPRESS
Driver Class: net.sourceforge.jtds.jdbc.Driver (jtds v1.2)
Driver URL: jdbc:jtds:sqlserver://localhost:1433/SQLEXPRESS

When I use BIRT and try to connect SQL 2005 (Hosted Locally) with no Username and Password, I get the following error with the:

?There is an error in get connection, Network error IOException: Connection refused: connect.?

I tried to use the Microsoft SQL Server 2005 JDBC Driver (Version 1.2) and I get the following error with the same URL:

?Selected driver cannot parse the given url.?

Anyone know what I am doing wrong or what I am missing? Any help is much appreciated!!!

-3TheOne

Find more posts tagged with

Comments

palgan

Hi,

I have never used jtds driver, only sqljdbc from Microsoft. There are some pitfalls you can fall into when playing with SQL Server and JDBC, so first of all make sure that:

1) You are using latest version from Microsoft: sqljdbc_3.0.1301.101_enu.exe

2) Check which authentication mode you use on your SQL Server: it is either Windows Authentication (Integrated) or SQL Server Authentication. I don't think you can connect to SQL Server without username & password / or without explicity indicating Windows Authentication.

3) Check which Java Runtime Environment you have. There are two drivers: sqljdbc.jar and sqljdbc4.jar, you will need JRE 5.0 for the first, and JRE 6.0. for the latter. In case you are using Windows Authentication with SQL Server make sure you have installed sqljdbc_auth.dll properly. Check with documentation included - it is really comprehensive. Pay special attention to part: "Connecting to SQL Server with the JDBC Driver"

4) Try to build similar string: jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;integratedSecurity=true;
Pay attention to semicolons, case-sensitiveness. The error you have got suggests malformed connection string.

Connecting to SQL Server 2005 works just fine for me.

Hope it helps.

P.

3TheOne

Hi Palgan,

Thank You for supplying me with solutions. I will give it a shot and let you know how it goes.

Thank You again!

-3TheOne

3TheOne

I have installed sqljdbc_3.0.1301.101_enu.exe and JDK 6 Update 20 (JRE). And, I created a new Login which is NAME-LAP\NAME (Windows Authentication).

Using the new driver in BIRT, I use the following URL:
jdbc:sqlserver://localhost:1433;databaseName=SQLEXPRESS;integratedSecurity=true;

Username: NAME-LAP\NAME
Password field is blank.

I get the following error:

"There is an error in get connection, The TCP/IP connection to the host localhost, port 1433 has failed. Error:"Connection refused:connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at theport, and that no firewall is blocking TCP connections port."

So, what i did was going into the SQL Server Config Manager, and Enabled TCP/IP for Protocols for SQLEXPRESS. I turned of the Firewalls, too.

But, I get the same error. I think I am setting up the Database Wrong? Any help would be appreciated.

Thank You again Palgan for trying to help me!

-3TheOne

palgan

Hi again! 
 
You've got different error message this time: at least we know, that there's a problem with connecting to server... I am not sure, but I think that protocol / port / firewall are OK. Message says that connection was refused so credentials problems would be my guess. 
 
I assume that you: 
 
1) properly installed sqljdbc_auth.dll (I suppose, 64-bit version in your case) 
 
2) have database named SQLEXPRESS on your server (SQLEXPRESS can also be a default instance name, please note the difference!) 
 
3) you are able to log on Windows with new NAME-LAP\NAME and then log on SQL Server via, for example, SQL Server Management Studio and browse data, etc. 
 
Now you can try: (1) connecting to a different database - AdventureWorks if you already installed it, or (2) build a new connection string leaving both username & password fields empty: "integratedSecurity=true" indicates that Windows mechanism is responsible for authentication. 
 
Hope it'll work for you! 
 
P.

3TheOne

Hey again!

1. I am pretty sure that I have sqljdbc_auth.dll (for x64) installed. How do I verify to be absolutely sure? I read the instructions regarding it and it seems like that I dont have to do anything other than copying the file to the same folder where sqljdbc4.jar is, under C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu.

2. Yes, the database and instance are named SQLEXPRESS.

3. When I log on Windows, I use NAME and password to login. I created a new Login name, NAME-LAP\NAME,under Security tab (not within the SQLEXPRESS\Security) in SQL Server Management. Under User Mapping, SQLEXPRESS is checked.

Sorry, I do not have AdventureWorks DB. However, I created a new Database named NEW this time. Using the URL:
jdbc:sqlserver://localhost:1433;databaseName=NEW;integratedSecurity=true;

Giving me the same error like on my 2nd post.

I greatly appreciate your time helping me! =D

-3TheOne

palgan

Hi,

No success, then? I'm afraid I'm running out of ideas... :unsure:
That's probably because I'm much more Linux / MySQL guy these days, but let me have another try:

- Your JRE is 32bit or 64bit?

Quote: "If you are running a 32-bit Java Virtual Machine (JVM), use the sqljdbc_auth.dll file in the x86 folder, even if the operating system is the x64 version. If you are running a 64-bit JVM on a x64 processor, use the sqljdbc_auth.dll file in the x64 folder."

- File sqljdbc_auth.dll should be in a system path visible to Windows. I remember copying it to C:\Windows\system32\ on WindowsXP. Sorry, but I don't know how it translates to Windows7. Make sure the directory you mentioned is either available as system path or just put the file somewhere similar to C:\Windows\system32\. Putting sqljdbc_auth.dll in the same directory as sqljdbc4.jar is not enough unless the directory is in system path.

Quote: "To use integrated authentication, copy the sqljdbc_auth.dll file to a directory on the Windows system path on the computer where the JDBC driver is installed".

I'm sure you have followed quoted instructions closely, it's just double-checking.

Good luck!

P.

3TheOne

Hey there again!

Yea, I prolly didn't put it into the right folder. I just put it there anyways in Windows\System32, sqljdbc_auth.dll (x64)

. Additionally to that, I read somewhere that even if the ports are shown in the Sever Config Manager as a certain port #, it can be else. And there were instructions how you could check it by looing at the registry. I found out that the port was dynamic and it was 49159 instead of the default 1433 which I assumed.

Now, I get a different error:

"There is an error in get connection, Login failed for user ''. The user is not associated with a trusted SQL Server connection."

I also tried it with NAME-LAP\NAME. Same Error.

Then, I changed the Server Authentication, to Select SQL Server and Windows Mode. Without Success.

You have helped me a lot! THANK YOU! =D

-3TheOne

palgan

Hey there! 
 
Without success..? :huh: 
 
But at least we know that connection is established, and problem is related to authentication. If you are sure that switched to SQL Authentication properly, you should try building a new connection string removing "integratedSecurity=true" and providing username & password - check with documentation for examples. SQL Authentication requires username & password. 
 
But I think that sorting out Windows Authentication properly and building connection with "integratedSecurity=true" would be the best solution which will pay in future as this authentication mode is recommended by Microsoft. 
 
All the best! 
 
P.

3TheOne

Hey there!

Yea, I should try to have intergratedSecurity in the URL string. However, I was able to connect to a remote database. It is just i can't connect to my own local SQL database that i set up which I find weird.

Thank You for looking into this me!

-3Theone