SQL Server - Database Stuck in a 'Restoring' State

SQL Server - Database Stuck in a 'Restoring' State

Sometimes during a restore of a database in SQL Server the restoration process will hang in a 'Restoring' state. You will typically be able to tell if this is the case if the Database 'icon' within SQL Server Management Studio has a (Restoring...) annotation next to the Database name in the list view.

To fix this issue do the following:

1. Log into SQL Server Management Studio
2. Select the database with the issue.
3. Click the 'New Query' button.
4. Use the following SQL Command - (replace DatabaseName) >>  Click 'Execute'.

RESTORE DATABASE DatabaseName
WITH RECOVERY

Adding users in NAV 2013

Adding users in Nav 2013

To add users in NAV 2013 you must do the following: 

1. Open up NAV 2013

2. Ensure you are logged on as a user who has the relevant privileges to add users. 

3. Navigate to >> Departments/Administration/IT Administration/General/Users

4. New

5. Select the elipses '...'  and search for a user on your Domain, eg. DOMAIN\username 

6.  Once the Windows User has been selected you can then add the relevant permissions (I will cover this in more detail on another post). 

Andy~

Client User Settings.config

Client User Settings.config

This is present for both NAV2009 (Only applicable for RTC) and NAV2013. 

This file holds information about previous connection details used so you don't have to constantly input the connection details to your server each time you log in. However - this doesn't mean it can't cause you issues, so it is good to know how to delete this / amend this file. 

Deleting this file is not an issue generally (apart from losing your connection details - so I'd take a note). After  deleting the file and logging back into NAV a new 'Clientusersettings.config' will be generated. 

Symptoms of a broken ClientUserSettings.config

• Incorrect connection details saved and you want to remove. 
• Old connection details that need removing. 

These are typically held in the following location:

NAV2009 RTC - C:\Users\support\AppData\Local\Microsoft\Microsoft Dynamics NAV

NAV2013 - C:\Users\support\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\70

Please note you can edit the file to add connection details also - see screenshot below. 

Andy~

Windows User Setup - NAV 2009 SP1 / R2

 To set up a Windows User in Navision you must do the following: 

1. Open the Database normally. 
2. Tools >> Security >> Windows Logins

3. Insert a new line (scroll to the bottom of the table). 

4 Type in the relevant username and domain.

 5. Press the Up/Down key to take the focus off of the line. This will insert the user into the Database.
 6. You can then highlight the user again and press the 'Roles' button. This is where you can assign different user roles. Eg. 'Super'

~Andy

Delete Your ZUP!

The ZUP file

Sometimes the ZUP file needs to be deleted. This is because the file will get corrupted and as a result can cause issues within NAV. eg, connection issues, inability to open forms. 

The ZUP file does the following:

• Saves user personalization. Ie. column layouts.
• Saves connection history - Server, database details. 
• Can save certain filters. 

How to Delete your ZUP file: 

Windows XP - Computer >> C: >> Documents and Settings >> (userfolder) >> Application Data>> fin.zup

Windows 7/8 - Computer >> C: >> Users >> (usersfolder) >> AppData (May be hidden) >> Roaming >> fin.zup

Either delete this - or cut this to another location.

~Andy