>>------------------------------
>>ADDITIONAL INFORMATION:
>>
>>Cannot open user default database. Login failed.
>>Login failed for user 'user name'. (Microsoft SQL Server, Error: 4064)
>>
>>For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476>
>The link should give you the answer. What have you set as the default database for this user? Have you given the user sufficient permissions to access this default database?
All I did was to create this user through the SSMS interface. For now I decided to get going in the different direction, will play with this user on Monday.
If it's not broken, fix it until it is.
My Blog