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
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,
I've had success with username=servername\windowsusername and password=windowspassword
Hope this helps,
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)
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
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:
* it's not a porn-site folks, it's scientific research :)
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted