cannot open user default database odbc error

[lsgtechuser]

There is a SQL dev server we have that crashed over the weekend. there wasn't a backup of the OS HD just of the raid array where all the sqlserver DBs are located. After rebuilding and re-installing sql server, the dbs were successfully re-attached.
When I create a user (the setup is mixed windows + sql) to connect to DatabaseX and set the default db for the user to Databasex I get the error "cannot open user default database" whether connecting locally or remotely.
If I set the users default db to be master, they can connect with no error. noteatabaseX is setup to have multiusers not in singleuser mode.

I can't figure out why this is occuring. the only thing that is different about the reinstall is that the instance name is now different from what it previously was. Is this the issue?
Any help would be greatly appreciated.

 

[ptheriault]

What is the status of Database X. Have you checked your log files. Was database x loaded without any errors?

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[lsgtechuser]

Never mind I figured it out. I ended up deleting the username that had been associated with the database added it again associated it with a login and it worked fine.