NAV 2013 BACKUP AND RESTORE PROBLEM

bsfartiyal

I backup latest configuration of NAV 2013 database and restore to another server
and add instance.

instance is running and development mode is running but when login through RTC and web client it show error as below :-

win server is win 2012
sql server 2012
nav 2013


help ??

regards
B.s.Fartiyal

mohana_cse06

Error message please..

bsfartiyal

mohana_cse06 wrote:

Error message please..

You are not authorized to sign in. Verify that you are using valid credentials and that you have been set up as a user in Microsoft Dynamics NAV.

mohana_cse06

Check this
http://blogs.msdn.com/b/nav/archive/2012/10/03/manually-restoring-the-nav-2013-demo-database.aspx

bsfartiyal

mohana_cse06 wrote:

Check this
http://blogs.msdn.com/b/nav/archive/2012/10/03/manually-restoring-the-nav-2013-demo-database.aspx

Try it but database not stored as per procedure.

regards

B.S.Fartiyal

mohana_cse06

Sorry I didnt get you

anand_murthu

Hi Fartiyal,

You can do one thing. :idea:
Open your available databases from ssms (Sql Server Management Studio).
1. Go to Demo Database NAV (7-0) and expand it. Expand Tables. you will find a table named dbo.user.
2. Right click there to get an option 'Edit Top 200 rows'. click here and move to windows security id. copy it.
3. Now go to the new restored database. expand it ->
for exapmle: restored DB- Tables-dbo.user-right click-'Edit Top 200 rows'
4. Pick any login and paste copied windows security id to it.
press tab.

Now open your RTC. It will run.
For better clarification i am attaching here the screenshots.Go through it.

Please revert back for this suggestion. 8)

thanks, Anand

bsfartiyal

anand_murthu wrote:

Hi Fartiyal,

You can do one thing. :idea:
Open your available databases from ssms (Sql Server Management Studio).
1. Go to Demo Database NAV (7-0) and expand it. Expand Tables. you will find a table named dbo.user.
2. Right click there to get an option 'Edit Top 200 rows'. click here and move to windows security id. copy it.
3. Now go to the new restored database. expand it ->
for exapmle: restored DB- Tables-dbo.user-right click-'Edit Top 200 rows'
4. Pick any login and paste copied windows security id to it.
press tab.

Now open your RTC. It will run.
For better clarification i am attaching here the screenshots.Go through it.

Please revert back for this suggestion. 8)

thanks, Anand

I have tried but not success, and try to another method

if we restore backup to another server , windows user id as is restore, so change the current windows id to relevant user through SSMS, it's working.