how to connect SQL Srvr 2005 Exprs instances with backslash

Postby abifarrah » Mon Feb 27, 2012 3:12 am

Hi, recently I've just installed the DbSchema, and Im really fascinated by it,
but the problem is, everytime I wanted to connect to the SQL Server 2005 database in my localhost PC (with this computer, default port radio button chhecked) or the server one (with I wrote : localhost\SQLExpress),
the application gives a message
Error
java.net.ConnectException: Connection refused: connect Network error IOException: Connection refused: connect
although I already followed all the requisition, I still couldnt connect my schema to a real database server.
I thought maybe its because the instances have a backslash (" \ ") on the name, is it matter?

Please Mr. Admin, help me :-)
abifarrah
 
Posts: 1
Joined: Mon Feb 27, 2012 3:04 am
 

Re: how to connect SQL Srvr 2005 Exprs instances with backs

Postby donose.mihai » Mon Feb 27, 2012 6:50 am

To connect to an instance of the SQL server database, go to the advance option in the connection management window and add to the string ;instance=YOUR_INSTANCE_NAME

The full string should look like this:

jdbc:jtds:sqlserver://YOUR_SERVER:PORT/DATABASE;instance=INSTANCE_NAME


Also configure your sql server just like in this video

http://www.youtube.com/watch?v=j60N0c7U-DE
donose.mihai
 
Posts: 354
Joined: Thu Apr 07, 2011 11:05 am
 

Re: how to connect SQL Srvr 2005 Exprs instances with backs

Postby william070707 » Tue Feb 28, 2012 11:54 am

Hi,
This video is really useful,it showed here step by step how to do it. I appreciate you for posting it here
God never made his work for man to mend Image
william070707
 
Posts: 15
Joined: Thu Feb 23, 2012 4:14 pm
 

Return to DbSchema Issues

cron