Tuesday, February 14, 2012

Cannot connect to ms sql server 2005

http://server5.pictiger.com/img/990335/computers-and-electronic-gadgets/connection.jpg

I don't know how to connect sql server 2005 with sqljdbc.jar which is used in Netbeans IDE 5.5
how can I solve the above problem?

thx a lot

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

is this url correct?

You need to post all of the information needed for anyone to help you with your problem.

(No one is likely to go to your url out of concern for malware, Trojans, etc.)

|||

Are you trying to use runtime connection.

Try this

jdbc:sqlserver://Owncomputername\SQLEXPRESS

Server management studio shows name like this:

OWNCOMPUTERNAME\SQLEXPRESS

Is TCP/IP enabled at server configuration manager (protocols for SQLEXPRESS).

If you havent setup you server read this thread faq.

|||In the sql server 2005, I'm using windows authenication method to login.
jdbc:sqlserver://DCPRJ007\SQLEXPRESS;

and I use this connection URL, but it said that "Login failed for user. The user is not associated with a trusted SQL server connection."

How can I solve this problem?
thank you|||

your server is configured for Windows Authenticaton ...but you are using SQL Server for connectivity...

refer : http://support.microsoft.com/kb/555332

http://support.microsoft.com/kb/889615

Madhu

No comments:

Post a Comment