Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Trying to connect to 2008 - error?

Author  Topic 

jakc
Starting Member

1 Post

Posted - 2009-05-20 : 20:20:23
I need to get to grips with SQL Server 2008 and thought this would be a good place to start.

I need to create a connection file to connect to SQL Server but it is giving me an error. We have been provided with a java exe that should create the connection file for me, but I have to feed in the parameters about my database in order for it to create the file.
I have successfully done this on another machine that hooks into MS SQL 2005, but having trouble with 2008.

jdbc:sqlserver://localhost:1433;databaseName=dekho

This is the java exe:


Returns this:


>SQL Service running
>Database name is dekho
> username + password are correct, have reset password to be double sure.
>1433 is correct TCP port in SQL Server 2008



1. Can anyone provide me some info on how to further troubleshoot?
2. Has anything changed between 2005 + 2008, perhaps the JDBC driver that could be causing me the issue?

Like I said, used identical settings on different machine with 2005 and it created an output file.
3. Perhaps I can test this connection elsewhere to see if the problem lies with the java exe?

Really appreciate any help that you can offer.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-05-20 : 23:07:10
The easiest way to troubleshoot it is to telnet to the database server from the client: telnet DbServerName 1433

Does the telnet go to a blank screen or an error?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -