NAV 5.0 SQL server Requirements

FinnKnudsen

Hello

We have no knowlegde on NAV but some on SQL server. We intend to use a Microsoft SQL server 2008 standard for storing the NAV 5.0 database. The OS will be Windows server 2008 standard.

Which SQL server 2008 components below are required by NAV 5.0 ?
SQL Server Database Engine
Analysis Services
Reporting Services
Integration Services
Replication
Management tools
Documentation

Can we use SQL default instance or named instance as we like ?
Can we choose Security mode (Windows Authentication or Mixed Mode Authentication) as we like ?
Do a "How to install SQL server for using with NAV" description exist ?

Our Microsoft NAV partner claims to our surprise, not to know the answers to the above simple questions. In advance, thanks for any reply.

Finn

ara3n

FinnKnudsen wrote:

Hello

We have no knowlegde on NAV but some on SQL server. We intend to use a Microsoft SQL server 2008 standard for storing the NAV 5.0 database. The OS will be Windows server 2008 standard.

Which SQL server 2008 components below are required by NAV 5.0 ?
SQL Server Database Engine
Analysis Services
Reporting Services
Integration Services
Replication
Management tools
Documentation

SQL Server Database Engine
Although You would want to install reporting services if you want to write you own sql reports.

Can we use SQL default instance or named instance as we like ?

yes

Can we choose Security mode (Windows Authentication or Mixed Mode Authentication) as we like ?

yes. i suggest mixed mode.

Do a "How to install SQL server for using with NAV" description exist ?

On installation CD you'll find a doc or documentation folder with pdf documents.

Our Microsoft NAV partner claims to our surprise, not to know the answers to the above simple questions. In advance, thanks for any reply.

thats sad

DenSter

FinnKnudsen wrote:

Our Microsoft NAV partner claims to our surprise, not to know the answers to the above simple questions.

I am surprised that they don't know, I'm pretty sure that Microsoft requires all NAV partners to be certified on SQL Server. You should insist that they aqcuire this knowledge, and if they don't I'd consider lodging a complaint with Microsoft. These are rudimentary things that everyone working with NAV on SQL Server should know, especially NAV partners.

bbrown

I will usually also install Integration Services. As this is needed to build Maintenance Plans.

Alex_Chow

The answers to these questions are on the Installation and Configurations training manual. One of the tests the solution partner must pass in order to become an solution partner for NAV.

You may have spoken to a junior person in that company.

ara3n

bbrown wrote:

I will usually also install Integration Services. As this is needed to build Maintenance Plans.

I don't think SSIS is needed to run Maintenance plans. All you are running is T-SQL task. You can utilize SSIS but I don't think it's required.
Can you find the source?


Here is a thread that mentions that after 2k5 sp2 it's not required.

http://sql-server-performance.com/Commu ... 52569.aspx

bbrown

ara3n wrote:

bbrown wrote:

I will usually also install Integration Services. As this is needed to build Maintenance Plans.

I don't think SSIS is needed to run Maintenance plans. All you are running is T-SQL task. You can utilize SSIS but I don't think it's required.
Can you find the source?


Here is a thread that mentions that after 2k5 sp2 it's not required.

http://sql-server-performance.com/Commu ... 52569.aspx

That is correct. You do not need SSIS to run the plans. Since the plans are nothing more than T-SQL scripts they can be writtten freeform. In fact, I tend to save my script and then just edit the server and database names as I reuse them on different system. But you do need it to edit a plan or to build one using the graphical interface.

FinnKnudsen

Thanks for all the Answers.

Our Microsoft NAV partner finally also have supplied the same information as you do : Only the database engine is nessesary, but reporting services allow for your own reporting.

When we supply the server and the Microsoft NAV partner supply the NAV software, we do - unfortuately - not have access to the NAV documentation before, but only after the server is created.

/Finn

DenSter

I'm starting to wonder about your partner... I don't know the details of your agreement with them of course, but when you purchase the software, you should get the product disk, regardless of whether your partner installs it on any server.