I have just tried setting up a Umbraco 7.1.8 installaton with the stater kit pre-installed using SQL Server Express 2014, on my local machine, and I have no problem installing Umbraco using the SQL Server Express 2014.
I've just tried moving a copy from a 2008 server to a 2014 server and it doesn't work. Web site remained in same place, just updated the connection string to point to the new connection.
My site is running 4.11.8
the backend complained that:
SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Named Pipes were initially disabled but they are on and all services restarted but same error.
Which says to me the connection string is wrong, but it looks ok to me. It's The exact same as the old one bar one number on the end of the server is different.
Thanks for the reply. Actually it was the string! My DBA didn't give me the proper server name. Using 2014 I needed to use the instance name as well which he didn't give me and I just used the server name...like I had been doing when it was running on 2008.
What's the best way to get Umbraco to connect to the server over IP instead of Named Pipes then? Might as well sort that out now seeing as I have a new server to play with.
SQL Server 2014 Support?
I can't find a definitive answer on whether Umbraco supports SQL Server 2014.
The requirements state SQL Server 2008 and I've seen an answer on here saying 2012 works OK.
Has anyone tried 2014 yet?
Hi Rob,
I have just tried setting up a Umbraco 7.1.8 installaton with the stater kit pre-installed using SQL Server Express 2014, on my local machine, and I have no problem installing Umbraco using the SQL Server Express 2014.
Hope that you can use this information.
/Dennis
I've updated the docs, any version higher than 2008 should work just fine.
I've just tried moving a copy from a 2008 server to a 2014 server and it doesn't work. Web site remained in same place, just updated the connection string to point to the new connection.
My site is running 4.11.8
the backend complained that:
Named Pipes were initially disabled but they are on and all services restarted but same error.
The main site home page gives:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="noNodes.aspx.cs" Inherits="umbraco.presentation.config.splashes.noNodes" %>Which says to me the connection string is wrong, but it looks ok to me. It's The exact same as the old one bar one number on the end of the server is different.
The connection string is probably fine, the configuration of SQL server seems not to be.
Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes ProviderSo it looks like you're using a named pipe, can remember exactly how to set those up but they usually need setting up in a normal SQL installation.
Thanks for the reply. Actually it was the string! My DBA didn't give me the proper server name. Using 2014 I needed to use the instance name as well which he didn't give me and I just used the server name...like I had been doing when it was running on 2008.
What's the best way to get Umbraco to connect to the server over IP instead of Named Pipes then? Might as well sort that out now seeing as I have a new server to play with.
Thanks
is working on a reply...