I write this blog to you because recently, I had a somewhat surprising licensing issue concerning SQL Server and Microsoft Dynamics NAV.
It all began with our Sales departement.
They had a very "hot" prospect (not going to mention the name). It would become a very intersting project: 65 users, multi language, multi site, many transactions, huge reporting challenge, lots of integrations with our own integration framework ... anyway: an opportunity to show what NAV is made of .
Our sales departement wanted to use the SQL Server runtime license in the Dynamics NAV licensing model. Until then, we had no experience with this licensing model, or runtime version of SQL Server, so I said: let's contact Microsoft to see if it supports 64 bit. The answer was "yes", so we decided to go for the runtime license. Customer happy, we happy, yippiekayee.
When we received the runtime version, I noticed it was a 32 bit version. So I contacted Microsoft: "hey, you sent the wrong one". And the ball started rolling. There seemed to be NO 64 bit runtime (embedded) version of SQL Server. And Microsoft isn't going to make one either (in the near future). Djeez. It has been a struggle for a while because Microsoft misunderstood me, and I misunderstood Microsoft. Namely, you can install the runtime version on a 64 bit operating system, but the SQL Server version is 32 bit, so there is no advantage whatsoever... .
We're still negociating with Microsoft in how we're going to handle this license wise, because there is no way I'm going to install a 32 bit version of SQL Server . I'm sure we will work out a acceptable solution.
This is what you have to remember:
My communication with Microsoft went through our PABS (Partner Advantage Business Solutions) agreement, which was very responsive. Very positive.
One downside though was the fact that I noticed that not many people actually know how the Runtime License work. I'm sure they will sort it out, and there will be a comprehensive paper in the near future. Until then, you can contact Microsoft or you can use this information.
My understanding with the runtime license is you can't use external programs to access the database either, if you want to run some web services or something to connect to your database you need the full version
Note: Microsoft SQL Server 2005 Standard Runtime Edition is sold on a per “NAMED” user basis. This requires a customer to license a SQL User for each person accessing the system. The number of SQL users must be equal to or greater than the number of Professional users on the license. Microsoft SQL Server 2005 Standard Runtime Edition is licensed only as a platform to the Navision product. A full SQL license is required to support any third party products including, but not limited to, other Microsoft products not sold on the Navision price list.