Created On: 01 November 2010
Problem:
Mapping a shared drive on a Windows server either 2003 or 2008 to access a SQL server 2005, user can get a 9D,4060, which is the following SQL server error:
42000 4060 - Cannot open database "db-name" requested by the login. The login failed.
42000 4060 - Cannot open database "db-name" requested by the login. The login failed.
Resolution:
The user must have the following variable added to the configuration file: A_MSSQL_DEFAULT_CONNECTION Server-name
Incident #2484619