My Server A is hosting a database in SQL 2005 64 bit and the "Allow Remote Connection" is ON on the Server A, however on Server B, when I tried to use OSQL to access and login to the server A database via ODBC, it does not work. I test the ODBC connection on Server B, it works fine. Any idea? Server B is my app server which will call osql in a batch program to backup the database in Server A.
I used this syntax, "osql -U sa -P password -D ODBCtoServerA
But the result is..
Login failed for user "sa"