Unable to connect to Microsoft SQL Server Database

Submitted by watsonro on Thu, 03/10/2011 - 09:22
in

I just installed AT 2.0 and Microsoft SQL Server Express and am trying to get everything working. I immediately got this error message when attempting to initialize the database using the maintenance program:

"an sql error occured when checking if database is empty"

I have created a brand new install with a blank DB and it continues to give me the same error. I am able to connect just fine when setting up and OBDC connection to the SQL server but not with the AT application

Any help would be great.

‹ Server Space Java VM or no Java VM? ›

Still Receiving Errors

Submitted by watsonro on Mon, 03/14/2011 - 11:27.

I corrected my connection string and I am now receiving a different error. I have tested connection via ODBC and locally on the server successfully:

Connection String:

jdbc:sqlserver://10.5.0.102:3406;databaseName=Archivist_Toolkit

Error that I am receiving:

com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Constants'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source)
at org.archiviststoolkit.util.DatabaseConnectionUtils.testDbConnection(DatabaseConnectionUtils.java:51)
at org.archiviststoolkit.Main.connectAndTest(Main.java:391)
at org.archiviststoolkit.Main.main(Main.java:198)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.zerog.lax.LAX.launch(DashoA10*..)
at com.zerog.lax.LAX.main(DashoA10*..)

.java:51)
at org.archiviststoolkit.Main.connectAndTest(Main.java:391)
at org.archiviststoolkit.Main.main(Main.java:198)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.zerog.lax.LAX.launch(DashoA10*..)
at com.zerog.lax.LAX.main(DashoA10*..)

Re: Connectivity

Submitted by annie_ucsd on Mon, 03/21/2011 - 11:32.

Hi,

Just in case you didn't receive email:

After creating a blank database (and before you can connect to the AT), you need to run the AT Maintenance program. Here’s the link to the instructions for initializing the database with Maintenance program: http://archiviststoolkit.org/support/InitializeDatabase

Best wishes,
Annie