Subject:DB to XML Data Source: Can't connect to SQL Server DB Author:Greg Woodruff Date:25 Feb 2005 02:04 PM
I get the following error when attempting to connect to MS-SQL DB:
java.sql.SQLException: [StylusStudio][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
at ZC.jdbc.jxtr.JXTRDriverConfig.translateSQLException(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriverConfig.createSQLException(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.stylusstudio.DataDirectStub.connect(DataDirectStub.java:130)
at com.stylusstudio.DataDirectStub.getConnection(DataDirectStub.java:399)
My connection criteria:
Database Type: Microsoft SQL Server
Server URL: //localhost:1433;DataBaseName=Northwind
Username: sa
Password:
(NOTE: Password is blank)
Subject:DB to XML Data Source: Can't connect to SQL Server DB Author:Ivan Pedruzzi Date:25 Feb 2005 02:12 PM
Greg,
Most likely your server is not configured to use the TCP-IP transport.
Run the network utility to add TCP-IP
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe"
Which Stylus Studio build are you running (Help->About)?
Subject:DB to XML Data Source: Can't connect to SQL Server DB Author:Greg Woodruff Date:25 Feb 2005 04:00 PM
No luck. I am running Windows XP Pro with SP 2 but Windows Firewall is Off.
All registry settings noted in the MS Kb article are as expected with
exception to named instance setting:
HKLM/Software/Microsoft/Microsoft SQL Server/mssql$<instancename>/MSSQLServer/SuperSocketNetLib/Tcp
(it does not exist in my registry).
Subject:DB to XML Data Source: Can't connect to SQL Server DB Author:Greg Woodruff Date:28 Feb 2005 12:12 PM
I've restarted everything as well as rebooting my computer but no change.
I wrote TCP socket client/server console apps to test the ability to
connect to port 1433 via TCP and it worked fine.
Could this be a Java Virtual Machine issue? This is the version I'm using:
1.4.2_07-b05 Java HotSpot(TM) Client VM Sun Microsystems Inc.
debug mode port:8000
Subject:DB to XML Data Source: Can't connect to SQL Server DB Author:Ivan Pedruzzi Date:28 Feb 2005 02:39 PM
>Could this be a Java Virtual Machine
>issue? This is the version I'm using:
>1.4.2_07-b05 Java HotSpot(TM) Client VM
>Sun Microsystems Inc.
> debug mode port:8000
Subject:DB to XML Data Source: Can't connect to SQL Server DB Author:Tony Lavinio Date:02 Mar 2005 12:26 PM
In your test app, were you connecting with the same credentials (user=sa
and no password)? SQL Server can run in a mode where the SQL security is
disabled and it uses the operating system security, in which case 'sa'
won't be allowed to connect.
You can try this by starting SQL Query Analyzer and trying to connect
with the radio button set to "SQL Server authentication" which is the
mode that the JDBC driver would be using.