Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Rajmond Burgaj 5 posts 86 karma points
    Jul 14, 2017 @ 22:38
    Rajmond Burgaj
    0

    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.

    Any idea what is the problem in this case ?

    Copy Link
  • Alex Skrypnyk 5908 posts 22603 karma points MVP 4x admin c-trib
    Jul 16, 2017 @ 21:37
    Alex Skrypnyk
    0

    Hi Rajmond

    Can you share connection string with us?

    Thanks,

    Alex

    Copy Link
  • Rajmond Burgaj 5 posts 86 karma points
    Jul 17, 2017 @ 09:18
    Rajmond Burgaj
    0

    Here is the connection string.

    Server=localhost\SQLEXPRESS;Database=DbName;Trusted_Connection=True;

    Copy Link
  • Alex Skrypnyk 5908 posts 22603 karma points MVP 4x admin c-trib
    Jul 17, 2017 @ 09:57
    Alex Skrypnyk
    0

    Can you try to connect to your database with SQL management studio?

    Copy Link
  • Paul Seal 428 posts 2354 karma points MVP 3x c-trib
    Jul 17, 2017 @ 10:16
    Paul Seal
    100

    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

    Copy Link
  • Rajmond Burgaj 5 posts 86 karma points
    Dec 29, 2017 @ 14:53
    Rajmond Burgaj
    0

    Hi Paul, yes that was the reason :) Thanks for the reply

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies