Installation and deployment
Version 7.x > Installation and deployment > Database Setup failure Kentico 7 on Win 8, SQL 2012 Express View modes: 
User avatar
Member
Member
budgens-gmail - 2/18/2013 3:35:11 PM
   
Database Setup failure Kentico 7 on Win 8, SQL 2012 Express
After carefully following the pdf directions to install Kentico 7 locally on Windows 8 and choosing SQL logon. When clikcing the link that the web installer provides it sends me to
http://localhost/KenticoCMS7/default.aspx which then forwards to this page
http://localhost/KenticoCMS7/cmsinstall/install.aspx . I'm selecting SQL Server account and using the SA username and password I created when installing SQL Server express.
I've also tried the "Use integrated Windows authentication" but to no avail.
Made the changes in SQL Config manager i.e. enable TCP in IP2, Dynamic Ports Blank, Restarte SQL service
It just doesn't work. I get this error message below.
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).
Thanks

User avatar
Certified Developer 12
Certified Developer 12
kentico-jx2tech - 2/18/2013 4:08:41 PM
   
RE:Database Setup failure Kentico 7 on Win 8, SQL 2012 Express
What is the SQL Server name that you are using? If it is Express, you might to check the default instance, .\SQLExpress , is being used.

User avatar
Member
Member
budgens-gmail - 2/18/2013 4:40:58 PM
   
RE:Database Setup failure Kentico 7 on Win 8, SQL 2012 Express
Thanks so much. I inserted .\SQLExpress into the server name or IP address and used the previously created SA password and that did it.

User avatar
Kentico Support
Kentico Support
kentico_radekm - 2/20/2013 1:39:11 AM
   
RE:Database Setup failure Kentico 7 on Win 8, SQL 2012 Express
Hello.

This issue as well as other common issues with SQL Server are also described here: http://devnet.kentico.com/docs/devguide/sql_server_connection_problems.htm

Best Regards,
Radek Macalik