Solved : message: Cannot open user default database. Using master database instead

Error message: Cannot open user default database. Using master database instead.

this mean user that used to access database don't have default database set in it's property.

Open MsSQL Server Management Studio->Security->Logins->user->properties you will get this dialog, then make sure you have default database selected fot he user.

Original Source : http://www.phpfreaks.com/forums/index.php?topic=229739.0

Posted in: mssql,php