NAV2013 Upgrade

BenSydney

Hi,
We are in the process of performing a test upgrade for one of our clients.
We are busy with going through the steps and are getting the following error message when we try to do the initial accessing of the database with the RTC (Task 11 in the upgrade documentation):

The SELECT permission was denied on the object 'User Property', database XXXX, schema 'dbo'

We can access the database via the 'Development Environment' without any issues.

Any help with resolving will be greatly appreciated.

Regards,
Ben

ara3n

Which one is task 11?

sydaus

ara3n wrote:

Which one is task 11?

In page 20 in the file UpgradingNAV2013.pdf
Task11: Step 2 Data Conversion

BardurKnudsen

I think it is documented somewhere; you need to be dbowner on the database (the dbo schema).
The reason for this is that we have a few SQL scripts in the upgrade code that need direct access to the database, hence the user WHO runs the upgrade must have full access to the database. So please check if you are set up as dbowner.

Joe_Mathis

Doing the exact same thing today.

Message I get when trying to run the page is:

---

Microsoft Dynamics NAV Development Environment

---

There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity.

---

OK

---

I have a servicetier setup and running.
If I try to just run the RTC, I get your error message.

I did use a dbo login when upgrading

BenSydney

Hi,

Confirming that the user that is attempting to start the data conversion step is 'dbo'.

Any other ideas?

Regards,
Ben

BenSydney

Hi,

I could get passed the problem by changing the login account of the NAV Server service.
It was set to 'Network Service' but if I change to specific user with 'dbo' schema then it works.

Regards,
Ben

Joe_Mathis

I just got it running when logging straight in to the RTC client.

Followed clausl's advice on this post
http://www.mibuso.com/forum/viewtopic.php?t=55197

Yes that solved the issue I just did the following:

1. Open SQL Studio
2. Double clicked on the "NT AUTHORITY\NETWORK SERVICE" user under "Security / Logins"
3. Selected "User Mapping"
4. Check marked the database I needed access to
5. And copied in "$ndo$navlistener" into "Default Schema" for selected database
6. And at last checked marked:
db_datareader
db_datawriter
db_ddadmin

Then without restarting service or RTC it just worked

/Claus Lundstrøm

After doing this I got a message that I wasn't a Authorized user :x .

The upgrade does do away with the (2000000053) Windows Access Control and the (2000000054) Windows Login tables when running the upgrade so I guess it kind of makes sense.

Anyways to overcome that I used a modified version of Waldo's script to get into the SQL database.

You have to find the Windows Security ID.
To get the SID, open a command prompt and type:

wmic useraccount get name,sid

Then replace the database, domain/user, and put in the SID in the following script.

USE [Database to use]
DECLARE @USERSID uniqueidentifier, @WINDOWSSID nvarchar(119), @USERNAME nvarchar(50)
SET @USERNAME = '<domain\user>'
SET @WINDOWSSID = '<windows security id>'
SET @USERSID = NEWID()
INSERT INTO [dbo].[User]
([User Security ID],[User Name],[Full Name],[State],[Expiry Date],
[Windows Security ID],[Change Password],[License Type])
VALUES
(@USERSID,@USERNAME,'',0,'1753-01-01 00:00:00.000',@WINDOWSSID,0,0)
INSERT INTO [dbo].[User Property]
([User Security ID],[Password],[Name Identifier],[Authentication Key],[WebServices Key],[WebServices Key Expiry Date])
VALUES
(@USERSID,'','','','','1753-01-01 00:00:00.000')
INSERT INTO [dbo].[Access Control]
([User Security ID],[Role ID],[Company Name])
VALUES
(@USERSID,'SUPER','')
GO

Hope it helps.