Nav 2009 SP1 SQL option - post installation tasks

Business Central/NAV Technical Forum
1

Hi
I have successfully installed and configured nav 2009 SP1 SQL classic client connected to SQL Server 2012, and I created a blank database. Then I restored a backup (the backup is from an untouched Nav database including the demo tenant).
Is there anything I need to configure on SQL Server or Nav SQL classic client level before I create user accounts?

Patrick

2

Did you read the manual?

3

Yes I read the manual.

In addition (to enable the object change listener) I changed the owner on SQL Server level in Security\Schemas of $ndo$navlistener to domain\user (this user will have the role-ID Super in Nav).

Then I run this query:

ALTER DATABASE DatabaseName SET ENABLE_BROKER;

GRANT CREATE PROCEDURE TO [DOMAIN\user];

GRANT CREATE QUEUE TO [DOMAIN\user];

GRANT CREATE SERVICE TO [DOMAIN\user];

GRANT VIEW DEFINITION TO [DOMAIN\user];

GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [DOMAIN\user];

GRANT RECEIVE ON QueryNotificationErrorsQueue TO [DOMAIN\user];

GRANT REFERENCES ON CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] TO [DOMAIN\user];

GO

Now I will upload my own Nav license file to the SQL Server and add user accounts.

I only have the documentation files on the Nav 2009 SP1 DVD. The topics concerning installation Nav with SQL Server are rather fragmented. And I am not sure, which points are important for my small environment: My SQL Server 2012 is separated and there are a few clients which will connect to the database. I have chosen the SQL Server (and not the standard database) because I feel more comfortable if the infrastructure grows.

One of the next step seems to be to connect with role tailored client

Is there anything important before?
Tell me, if you have not enough information.

Patrick

4

Indeed setting up NAV 2009 NST and RTC is a mess … The annoying part is to set up the User Delegation [:@] etc.

On MSDN you could find several “Walkthroughs”: http://msdn.microsoft.com/en-us/library/dd568710.aspx

These are kind of “step-by-step” guidelines to implement several NAV scenarios.

Also, make sure you have installed the required “Extended Stored Procedures” xp_ndo_enumusersids and xp_ndo_enumusergroups!
With NAV 2009 SP1 you’ll also need Traceflag 4616 fired up!

Hope this could help you!

5

Ok, thanks for your information.
I will check all this.

Nice to see, that after my simple restore (Extended stored Procedures are placed correctly), I can open the demo tenant [:)]