SQL Server Error

sabzam

Hi Everybody,

I was running a process onto Navision, and got an error message due to lack of memory. As soon as I re-opened Navision the following error cropped out:
Cannot open user default database. Login Failed. As a result of this error I couldn't open the Navision Database. Does anyone have any idea the reason behind this error?

Regards,

Steve

bbrown

The user's default database setting is pointing to a database that is unavailable. Either it does not exist or is in a status that makes it unavailable for login. When setting up NAV SQL users leave their default database to MASTER. There is no reason to change it.

kriki

[Topic moved from 'NAV/Navision' forum to 'SQL General' forum]