yes i can.
Database Instance Name is SQLExpress running on said server, and the Database name is Test, its an sql server 2005 DB running on port 1433
I have changed the cofig file somewhat, here is what the new property name now looks like:
<property name="connection.url">jdbc:sqlserver://lonisi106\SQLExpress:1433;DatabaseName=Test</property>
I am getting an error that looks like this now:
[java] 13:00:23,430 INFO DriverManagerConnectionProvider:86 - connection properties: {user=sa, password=****}
[java] 13:00:23,531 WARN SettingsFactory:103 - Could not obtain connection metadata
[java] com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'.
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
[java] at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
I assume that where it says password, that is just a standard 4 character asterik?
|