Umbraco cannot connect with database while installing for first time
I installed umbraco version 7.6.x but I am trying to connect to my database in
Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Home 6.3
but it does not connect to my database which I have created here. I am using Custom Connection String because selection server name and Integrated Authentication did not work either. While trying Custom Connection String I could connect with another database which was restored and it has 2008 compatibility mode because it is backed up from Sql Server 2008. I tried changing only the db name but does not work for new created one while I can connect with Visual Studio using the same connection string. I tried to set the new created db to 2008 compatibility mode as well but does not work.
Umbraco cannot connect with database while installing for first time
I installed umbraco version 7.6.x but I am trying to connect to my database in
but it does not connect to my database which I have created here. I am using Custom Connection String because selection server name and Integrated Authentication did not work either. While trying Custom Connection String I could connect with another database which was restored and it has 2008 compatibility mode because it is backed up from Sql Server 2008. I tried changing only the db name but does not work for new created one while I can connect with Visual Studio using the same connection string. I tried to set the new created db to 2008 compatibility mode as well but does not work.
Any idea what is the problem in this case ?
Hi Rajmond
Can you share connection string with us?
Thanks,
Alex
Here is the connection string.
Server=localhost\SQLEXPRESS;Database=DbName;Trusted_Connection=True;
Can you try to connect to your database with SQL management studio?
Hi You might not have mixed mode enabled on your SQL Server. Here is how to fix that. https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode#SSMSProcedure
Hi Paul, yes that was the reason :) Thanks for the reply
is working on a reply...