Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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
Hi Anthony.
I've had success with username=servername\windowsusername and password=windowspassword
Hope this helps,
Tom
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)
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
it's in appSettings under umbracoDbDSN
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 :)
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
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
Hi Anthony.
I've had success with username=servername\windowsusername and password=windowspassword
Hope this helps,
Tom
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)
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
it's in appSettings under umbracoDbDSN
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 :)
is working on a reply...