Copied to clipboard

Flag this post as spam?

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


  • Alistair Jenkins 92 posts 315 karma points
    Jan 05, 2018 @ 11:54
    Alistair Jenkins
    0

    Incorrect connection string for local MSSQL database

    I am trying to set up a local instance of Umbraco for development purposes and I'm having trouble getting the connection string right for the SQL database.

    I have an MS SQL database installed using MS SQL Server 2017 (Developer Edition) on a PC called CVN-AL. It uses Windows Authentication. I've tried various connection strings like:

    <add name="umbracoDbDSN" connectionString="Server=CVN-AL;Database=cvnsitesdb;User ID=CVN\alistair;Password=********" providerName="System.Data.SqlClient" />
    

    with no success. Can anyone tell me what the right way to phrase this would be?

  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    Jan 05, 2018 @ 14:08
    Alex Skrypnyk
    0

    Hi Alistair

    Can you connect to database with mssql management studio and this connection string?

    Is "User ID=CVN\alistair" right user?

    Thanks,

    Alex

  • Alistair Jenkins 92 posts 315 karma points
    Jan 05, 2018 @ 15:11
    Alistair Jenkins
    100

    Hi Alex,

    Thanks for replying. I eventually found a solution on another post. I replaced the string with this one:

    <add name="umbracoDbDSN" connectionString="Server=CVN-AL;Database=cvnsitesdb;Integrated Security=True" providerName="System.Data.SqlClient" />
    

    which worked fine.

    Cheers, Alistair

  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    Jan 05, 2018 @ 15:38
    Alex Skrypnyk
    0

    Hi Alistair

    Glad that you found a solution.

    Thanks,

    Alex

Please Sign in or register to post replies

Write your reply to:

Draft