Copied to clipboard

Flag this post as spam?

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


  • Anthony Candaele 1197 posts 2049 karma points
    Jan 20, 2011 @ 15:41
    Anthony Candaele
    0

    using a connectionstring for windows authentication

    Hi,

    I am migrating my Umbraco website from my development machine to the production server.

    On the production server the database is accessed through windows authentication

    How can I adjust the connection string in the web.config file of my Umbraco website so that I can acces the database with Windows Authentication?

    Thanks for your help,

    Anthony Candaelel

  • Tom Smith 98 posts 172 karma points
    Jan 20, 2011 @ 15:46
    Tom Smith
    0

    Hi Anthony.

    I've had success with username=servername\windowsusername and password=windowspassword

    Hope this helps,

    Tom

  • Tom Smith 98 posts 172 karma points
    Jan 20, 2011 @ 15:50
    Tom Smith
    0

    In fact, if you open up SQL Server on your server, you should see your windows login under security -> logins. You can then copy the username exactly as it appears. (Tested on SQL server 2008 R2)

  • Anthony Candaele 1197 posts 2049 karma points
    Jan 20, 2011 @ 15:52
    Anthony Candaele
    0

    ok,

    But if I look in my web.config file, this is the only connectionstring I can locate:

    <connectionStrings>
        <remove name="LocalSqlServer" />
        <!--<add name="LocalSqlServer" connectionString="server=.\sqlexpress;database=aspnetdb;user id=DBUSER;password=DBPASSWORD" providerName="System.Data.SqlClient"/>-->
      </connectionStrings>

    as your see the connectionstring is commented out

  • jc 64 posts 101 karma points
    Jan 20, 2011 @ 15:57
    jc
    1

    it's in appSettings under umbracoDbDSN

  • Anthony Candaele 1197 posts 2049 karma points
    Jan 20, 2011 @ 16:16
    Anthony Candaele
    1

    Ok,

    I got my connection working with this connection string:

    <add key="umbracoDbDSN" value="server=server\SQLEXPRESS;Initial Catalog=databasename;Integrated Security=True" />

    Thanks a lot for your help, I just published my first Umbraco-site on a production server:

    www.sexpert-vlaanderen.ugent.be *

    greetings,

    Anthony

    * it's not a porn-site folks, it's scientific research :)

     

Please Sign in or register to post replies

Write your reply to:

Draft