When user tried to connect to sql server, gets following error:
SQLState '28000' SQL Server Error: 18456 Micorsoft SQL Server Native Client 10.0 SQL Server login faile for user abc\xyz. Connection failed: SQLState '42000' SQL Server Error: 4064 Micorosft SQL server Native Client 10.0 SQL Server cannot open user default database. Login failed.
On SQL Server side, I changed default database for that group as master. But still error. Actually user is testing in ODBC Interface. User is member of AD group and that group have permissions on database.
Have you tried changing the database explicitly in the connection string?
================================================= We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry
Connection failed
Posted - 11/02/2012 : 16:47:37
