When our website is deployed to the production server, I get a "Login Failed...untrusted domain" error when I try to log in using the log in form provided by visual studio. From the error logs I see that the website is trying to log in to the SQL server
AppNetServices database with the local administrator...of course, this won't work. I am very new to asp.net so I am not sure where the website is getting the hostname\administrator user from. The log on works on the development server but not the production
server.
I have no idea what to check or what needs fixing. Any help would be greatly appreciated! Thanks in advance!
I can't find the machine.config file. I am trying to use Windows authentication...should I use SQL authentication instead? My connectionstring is the following:
hmelton67
Member
12 Points
45 Posts
Untrusted Domain Error
May 21, 2012 03:08 PM|LINK
When our website is deployed to the production server, I get a "Login Failed...untrusted domain" error when I try to log in using the log in form provided by visual studio. From the error logs I see that the website is trying to log in to the SQL server AppNetServices database with the local administrator...of course, this won't work. I am very new to asp.net so I am not sure where the website is getting the hostname\administrator user from. The log on works on the development server but not the production server.
I have no idea what to check or what needs fixing. Any help would be greatly appreciated! Thanks in advance!
Sparkers
Contributor
2086 Points
470 Posts
Re: Untrusted Domain Error
May 21, 2012 03:18 PM|LINK
Could you please check the connection string in the We.Config and also see the db settings.
sukumarraju
All-Star
16971 Points
2999 Posts
Re: Untrusted Domain Error
May 21, 2012 03:49 PM|LINK
Taken from the service where the app is hosted.
Add fully qualified/connectionString with username and password in Web.config for the ASPNETServices database.
Refer http://weblogs.asp.net/sukumarraju/archive/2010/01/17/configuring-web-application-to-utilise-asp-net-application-services-database.aspx
Let me know further queries.
EDIT: Also refer
http://stackoverflow.com/questions/858678/sql-server-2008-login-failed-the-login-is-from-an-untrusted-domain-and-cannot
Application Architecture Guide 2.0
My Blog
Twitter
hmelton67
Member
12 Points
45 Posts
Re: Untrusted Domain Error
May 21, 2012 05:20 PM|LINK
I can't find the machine.config file. I am trying to use Windows authentication...should I use SQL authentication instead? My connectionstring is the following:
Datasource=SQL2;Inital Catalog=AppNetServices;Integrated Security=True
Thanks!
Sparkers
Contributor
2086 Points
470 Posts
Re: Untrusted Domain Error
May 21, 2012 06:32 PM|LINK
Does your Production Server Use a DB called SQL2?
While Configuring teh Connection String try to use SQL Connection..