mibuso.com

Microsoft Business Solutions online community
It is currently Thu Apr 24, 2014 12:34 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: [Solved] Microsoft SQL Server 2012 Compatibility with NAV = YES
PostPosted: Wed May 09, 2012 4:45 pm 
Offline

Joined: Fri Jul 09, 2004 3:14 am
Posts: 146
Location: Virginia Beach VA
Country: United States (us)
Is Microsoft SQL Server 2012 Compatible with NAV 2009R2 (or above) ?

Thanks.

Confirmed by MS :thumbsup:

_________________
Joe

http://www.commercesystemsgroup.com


Last edited by Joe Mathis on Mon Aug 13, 2012 1:16 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV
PostPosted: Wed May 09, 2012 5:36 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8986
Location: 3rd rock from sun
Country: United States (us)
It works but there is no ms official document

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV
PostPosted: Wed May 09, 2012 6:51 pm 
Offline

Joined: Fri Jul 09, 2004 3:14 am
Posts: 146
Location: Virginia Beach VA
Country: United States (us)
Thanks Ara3n!

Client is going to buy new SQL and I wasn't sure if it would work as I haven't installed it anywhere yet.

I'll get it installed and tested on my dev server sometime soon... :mrgreen:

I didn't' expect any issues, but you sometimes never know.

Will wait a little on the solved though...

_________________
Joe

http://www.commercesystemsgroup.com


Top
 Profile  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV
PostPosted: Wed May 09, 2012 9:04 pm 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2773
Location: MA
Country: United States (us)
As stated above, there is no official word on support from MS. I've been told that they intend to "fully" support it for NAV 2013. But I've not heard anythign concerning prior versions. So that's anyone's guess.

In terms of puchasign SQL, my recommendation would be to purchase the latest version (2012) but to be sure the license includes downgrade rights. Then you have the ability to swap back to an earlier version.

_________________
There are no bugs - only undocumented features.


Top
 Profile E-mail  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV
PostPosted: Wed May 09, 2012 10:20 pm 
Offline

Joined: Fri Jul 09, 2004 3:14 am
Posts: 146
Location: Virginia Beach VA
Country: United States (us)
Thanks bbrown.

I know that you can use 2012 CALS on older versions, not too sure about downgrade of actual software though...
Had not seen that anywhere before, only upgrade. But just because I haven't seen something doesn't mean it doesn't exist. :D

_________________
Joe

http://www.commercesystemsgroup.com


Top
 Profile  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV
PostPosted: Wed May 09, 2012 10:33 pm 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2773
Location: MA
Country: United States (us)
Whether or not you have downgrade rights depends on your license. Not every classic product license comes with downgrade rights. Typically license purchased thru the retail channel do not. And many times OEM licenses don't either. They are typically only available thru licenses acquired under volume agreements. But this can vary. So read the license.

_________________
There are no bugs - only undocumented features.


Top
 Profile E-mail  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV
PostPosted: Wed May 16, 2012 10:15 am 
Offline

Joined: Sat Jul 31, 2004 7:08 pm
Posts: 191
Location: Hidden Village
Country: Malaysia (my)
I won't make a rust by deploying SQL 2012 with Navision 2009 R2. You guys go ahead to try at customer 8)


Top
 Profile  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV
PostPosted: Wed May 16, 2012 1:17 pm 
Offline

Joined: Wed May 16, 2012 1:11 pm
Posts: 1
Country: Spain (es)
Hi everybody,

What about NAV 5 and SQL Server 2012?

I've been testing it in my test server and i did not find anything bad.

I've created new customers and contacts, new keys, new users, sync them to the database, and assign some roles. I've also tried to backup and restore the database, register some accounting and some orders shippings and invoices and until today everything works fine.

Could you suggest what else would be worth to try to find out any incompatibility?

Thanks

Miki


Top
 Profile E-mail  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV
PostPosted: Wed May 16, 2012 7:28 pm 
Offline

Joined: Fri Aug 06, 2004 9:30 pm
Posts: 1024
Location: Richardson
Country: United States (us)
Since NAV 5 is not supported except through extended support, I recommend you find out if extended support will include SQL Server 2012 and what executable and build level you need to be at.

_________________
David Machanick
http://mibuso.com/blogs/davidmachanick/


Top
 Profile  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV
PostPosted: Fri Aug 10, 2012 12:18 pm 
Offline
Microsoft employee

Joined: Thu Aug 30, 2007 10:25 am
Posts: 36
Location: Denmark
Country: Denmark (dk)
Microsoft SQL Server 2012 is supported on Microsoft Dynamics NAV 2009SP1 and Microsoft Dynamics NAV 2009 R2.
We posted the official support statement on the Dynamics NAV Team Blog and on Partner Source (I think it was July 13th) - so please refer to that for detailed information.

http://blogs.msdn.com/b/nav/archive/2012/07/13/compatibility-update-with-microsoft-sql-server-2012.aspx

_________________
Best regards,
Jens Møller-Pedersen [MSFT]

This posting is provided 'AS IS' with no warranties, and confers no rights.


Top
 Profile  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV
PostPosted: Mon Aug 13, 2012 1:13 pm 
Offline

Joined: Fri Jul 09, 2004 3:14 am
Posts: 146
Location: Virginia Beach VA
Country: United States (us)
I just saw the e-mail about it. Client is on it and everything is working as expected... will go back and change it to solved and maybe edit the subject.

_________________
Joe

http://www.commercesystemsgroup.com


Top
 Profile  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV = YES
PostPosted: Sun Dec 23, 2012 4:12 pm 
Offline

Joined: Fri May 04, 2007 8:26 am
Posts: 18
Location: Currently in Dubai
Country: India (in)
Does it mean that I cannot user SQL Server 2012 with NAV 5.0 sp1?

I put a copy of NAV 5.0 SP1 databse in SQL Server 2012. When I try to access I get the following error :

"The trace flag 4616 is not set on the server ASW-TDB01. You must set this flag and restart the server before you can connect using Microsoft Dynamics NAV."

As per my inderstanding setting trace flag is not a requirement in newer versions of SQL server.

Can anyone confirmt that NAV 5.0 sp1 is compatiable with SQL Server 2012 ?

Thanks


Top
 Profile E-mail  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV = YES
PostPosted: Sun Dec 23, 2012 5:44 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8986
Location: 3rd rock from sun
Country: United States (us)
It's not required in newer version of NAV. You still need to set it for older version of NAV.

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV = YES
PostPosted: Thu Dec 27, 2012 6:37 pm 
Offline

Joined: Wed Jul 11, 2012 4:43 pm
Posts: 3
Country: Argentina (ar)
Nav 5 work with SQL Server 2012, but first we have to set trace the flag 4616 in the sql instance.
How to set trace it?
Just, with the following script...

DBCC TRACEON (4616,-1)


Top
 Profile E-mail  
 
 Post subject: Re: Microsoft SQL Server 2012 Compatibility with NAV = YES
PostPosted: Thu Dec 27, 2012 7:14 pm 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2773
Location: MA
Country: United States (us)
guiyote wrote:
Nav 5 work with SQL Server 2012, but first we have to set trace the flag 4616 in the sql instance.
How to set trace it?
Just, with the following script...

DBCC TRACEON (4616,-1)


Don't forget to also set it as a startup parameter for SQL.

_________________
There are no bugs - only undocumented features.


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Exabot [Bot] and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: