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


  • 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

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

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

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

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

    it's in appSettings under umbracoDbDSN

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

     

    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