Problem with SQL Server connection from a Linux machine [closed]

Question

On a Linux machine, I run a java application that accesses a SQL Server instance on a Windows machine. When I run this application I get the below error:

07-Dec-2012 15:09:40 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
[org/springframework/jdbc/support/sql-error-codes.xml]
07-Dec-2012 15:09:41 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\media\baks\mydbbak.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 15105).
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:111)
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)

....
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\media\baks\mydbbak.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 15105).
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4615)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:649)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
    ... 7 more

If I run the exact same application from my local Windows machine it works fine.

Any ideas why it fails when I run the application from Linux?

Answer 1

So the issue here is a path issue as you see in the comments on the question. There was an issue with the path being used in the restore script that u123 was using. The path was not correctly typed and this led to the error as there was no file there. This is a case of the error message being quite useful but missing some helpful text (namely - the actual error message from windows)

To understand the troubleshooting approach that I used here to investigate this one:

1.) Find the error message(s).. In this case:

Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\media\baks\mydbbak.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 15105)

2.) So a restore is being attempted and it is failing because the backup device can't be opened. SQL didn't retrieve the text of the windows error message, but we still have the windows error ID.

3.) I happen to know that the windows error 3 is a path issue. But if you didn't know that you can open up a command prompt and type NET HELPMSG 3 this shows us the OS error for 3.. In our case: The system cannot find the path specified.

4.) It is obviously a case where the path is invalid. The path isn't right, so double check the path and the issue should be resolved, as the OP discovered through the comments.