I do not know anything about SQL, so hopefully someone can help me out.
Installed SQL 2005 on a new server. Restored a database from SQL7.
The database I restored is called "train" for example and in that database is a user called "train_user"
I cannot connect to the obdc data source using this "train_user". I do not know if the password didn't carry over during the migration and don't even know how to check or change this password. I don't know if this user needs certain
privileges to be able to access the SQL server? They are the db owner of the database that I restored.
The application I am trying to launch gives me the odbc error. This info is stored in an ini file. If I change this info to sa, then I can access the application.
If I need to provide more info, I can do that, but hopefully someone understands what is going on or what I need to do to fix it.
Here is the error code:
Error: 18456, Severity: 14, State: 5.
View Complete Post