SQL Server 2005 Express on Server and Navision 5.0[5 client]

andy76

Hello,

I ask you if SQL Server 2005 Express on a server with various client pc(probably 5) is fully and completely supported by Microsoft Dynamics Navision 5.0 SP1.

I know that SQL Server 2005 Express should be supported in installation standalone [with client and dbms on same machine].

We have a customer that has already installed SQL Server 2005 Express on a server for the use of another application and I want to know if it can be used/exploited also for Navision without inconvenience.

On the manuals and documentation I have found no official information about that.

Thank you

bbrown

It is not supported. First it will severly limit the database growth. It only allows a DB up to 4 GB.

andy76

I don't understand if it is not supported at all or if it is possible to use it having a DB smaller than 4 Gb.

bbrown

SQL Express is a free edition of SQL Server that is intended for learning and building desktop and small server applications and for redistributon by ISVs.

It is not officially supported for NAV. Besides, if you customer is hesitating to spent the small amount for a SQL Standard server license, are they a real customer?

andy76

I agree with you but in this case we have already SQL Express installed and operative for another application.

Adding SQL Server 2005 complete [not Express] should require other activities for setup and reconfiguring also this application or sell an entire new server.

The question was also for my personal interest. I think that it could run also on Express version.


Thank you

bbrown

andy76 wrote:

I agree with you but in this case we have already SQL Express installed and operative for another application.

Adding SQL Server 2005 complete [not Express] should require other activities for setup and reconfiguring also this application or sell an entire new server.

The question was also for my personal interest. I think that it could run also on Express version.


Thank you

First, if the server was specified and configured to run SQL Express then it is likely severely underspeced for NAV. You would be doing you customer a great service in selling that new computer. The goal should be to arrive at the right solution, not the cheapest or even the most expensive.

Technically it will run within the limitations of SQL Express. SQL Express supports a maximum DB size of 4 GB, only 1 processor, and only 1 GB of RAM. Even a small NAV system is going to quickly outgrow this.

Also keep in mind that the only extra cost we are talking about is the SQL license. You need to do the same work to implement. I know you mentioned the need to install the new SQL, but is that really a lot of work?

kine

NAV is supported on "Dedicated" server - it means no other databases etc. on the server. If there is something, it is on your own risk (it is mainly because performance etc.).

It means - yes, you can use it, but do not request any support around this...

kriki

[Topic moved from Navision forum to SQL General forum]