Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community
Forums » Microsoft Dynamics NAV / Navision » NAV / Navision - Microsoft SQL Server » SQL 2005 login false with error 4064

SQL 2005 login false with error 4064

rated by 0 users
This post has 2 Replies | 2 Followers

Top 500 Contributor
Male
Posts 40
Points 580
Reply
binto0002 Posted: 08-01-2008 11:29

Dear all.

I am loginning into NAV 5.0 by my account (not SA account). NAV appears this message:

"The following SQL server errors occured:
4064,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] Can not open user default database. Login faifed."

 Could you please help me fix this problem? Thank you very much!

binhtt
  • | Post Points: 20
Top 75 Contributor
Male
Posts 302
Points 4,405
Reply
babrown replied on 08-01-2008 12:49

This error is caused by having a user's default database set to a database that does not exist.  Most likely because its been deleted.  Go into Management Studio and reset the user's default database to on ethat exist. Suggestion is to reset it to the default of MASTER since this never gets deleted.

 

  • | Post Points: 20
Top 500 Contributor
Male
Posts 40
Points 580
Reply
binto0002 replied on 08-01-2008 13:23

 Thanks BABROWN so much! I have got it!

Best wish to you! Yes

binhtt
  • | Post Points: 5
Page 1 of 1 (3 items) | RSS

Copyright Dynamics User Group, 1995-2008, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.