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


  • 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?

    Copy Link
  • Alex Skrypnyk 5908 posts 22603 karma points MVP 4x 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

    Copy Link
  • 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

    Copy Link
  • Alex Skrypnyk 5908 posts 22603 karma points MVP 4x admin c-trib
    Jan 05, 2018 @ 15:38
    Alex Skrypnyk
    0

    Hi Alistair

    Glad that you found a solution.

    Thanks,

    Alex

    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