SQL Power Software Forum

How does one connect to an SQL Server database? I've downloaded the JAR and added it to the list of drivers. I've created a data source, the hostname and port. What do I put for PL Schema Owner? Is ODBC Data Source Name needed?

No matter what I try, I get "Error during initial database probe"

Hi Norman,

You can leave "PL Schema Owner" and "ODBC Data Source" blank. They are for integration with our ETL tool, which does not ship with the Architect.

The SQL Server 2000 driver from Microsoft actually consists of 3 jar files: msbase.jar, msutil.jar, and mssqlserver.jar. You need to add all 3 of them to the list of drivers.

If that doesn't solve your problem, please do this: Right-click on the "Error during initial database probe" item in the tree, and select "Show Exception Details." On that panel, hit the "Show Details" button. Copy the whole detail message (a Java stack trace) and paste it into the forum. We will then be able to offer you more specific assistance.

Hope to hear from you soon.

None of those JAR files are included in the latest release from Microsoft, in sqljdbc_1.1.1501.101_enu.tar.gz.

Seems the problem is that Power*Architect is expecting the wrong class package. It is really com.microsoft.sqlserver.jdbc.SQLServerDriver, but it wants com.microsoft.jdbc.sqlserver.SQLServerDriver

Aha, it looks like the new SQL Server driver has a different package naming scheme than the previous versions.

You can work around this problem by editing the "JDBC Driver Class" line for that connection in your pl.ini file.

We do intend to overhaul the database connection config process before the Architect's 1.0 release. The final version will allow you to define your own new database connection types, and also to use multiple versions of the same JDBC driver at the same time (this is necessary when the source databases for one project include a mix of Oracle 8i, 9i, and 10g).

Please let us know if the pl.ini edit worked for you!

Then I needed to change the URL to: jdbc:sqlserver://hostname:1433 The default one was invalid.

Hi guys,

I have similar problem: no connection to any of Microsoft SQL Servers (7, 2000, 2005). Tried your solution but it does not work for me.

I would appreciate any help.

Regards,
Mike

Hi. I have a similar problem. I can´t connect to a SQL Server 200 server. I keep getting the connection refused message.

Message when using jdts 1.2.5 driver
java.lang.RuntimeException: ca.sqlpower.sqlobject.SQLObjectException: Couldn't connect to database: Network error IOException: Connection refused: connect

Message when using Ms driver
ca.sqlpower.sqlobject.SQLObjectException: Couldn't connect to database: The TCP/IP connection to the host XXXX, 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 the port, and that no firewall is blocking TCP connections to the port.".

I´m using SQL Power Architect version 1.0.6. I tried jtds driver, Ms 3.0 jdbc driver. I´ve checked my network setting and everithing is ok (i had tried with another modelling tool and was able to connect).

Could soeone even give me a hint with this. I´d appreciate any help.

Thanks in advance,
Albert.

Even if the database is on the same computer as SQL Power Architect you will need to configure SQL Server for "remote access" by making sure that the it will listen for connections on port 1433. This link does a good jon of explaining how to configure for remote access:

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

Good luck.

oradbapro