Can you all help shed some light on my DSN creation problem?
1)I add a System DSN with the SQL Server driver
2)Use (local) for the server
3)SQL Server Authentication
4)Enter the Logon ID and Password I want to use
5)Hit next and get an error
SQL Server Error: 4064
[Micorsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default database. Logon failed
I am not sure what the error is indicating. Up to this point there has been no reference to a database in the set-up of the DSN.
What default database is the error referencing?
The database I want to use with the DSN, has a user created with the name that I am using in the Logon ID of the DSN set-up.
I can gladly add more info as needed to help with resolution dialogue.