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


  • John ben 78 posts 293 karma points
    Aug 02, 2017 @ 08:26
    John ben
    0

    connection string with windows authentification sql serveur 2008

    Hi

    i was using sql authentification here is my connection string 

    <add name="umbracoDbDSN" connectionString="server=*****;database=*****;user id=sa;password='****'" providerName="System.Data.SqlClient" />

    but when i switched to windows authentification with my client could'nt detect my database

    here is my connection string

    <add name="umbracoDbDSN" connectionString="server=*****;database=*****;Integrated Security=True; providerName="System.Data.SqlClient" />

    Best regards

    Copy Link
  • David Hutson 48 posts 379 karma points
    Aug 02, 2017 @ 09:33
    David Hutson
    100

    Hi,

    There is not much to go on from your message but it's most likely a permissions issue.

    Have you checked how the app pool identity is setup that is running the Umbraco site in IIS.

    Take a look at these articles https://blogs.msdn.microsoft.com/ericparvin/2015/04/14/how-to-add-the-applicationpoolidentity-to-a-sql-server-login/

    https://www.syncfusion.com/kb/6897/how-to-add-permission-for-iis-application-pool-to-access-sql-server-database

    Hopefully this will help.

    Dave

    Copy Link
  • John ben 78 posts 293 karma points
    Aug 02, 2017 @ 13:29
    John ben
    0

    Thanks dude , great help

    Just had to change my config in the pool so that it can access the database in my system.

    Best regards

    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