I am trying to run my web application on my development computer and I am having issues connecting to the hosting site database. I am using asp.net membership tables as well.
Error: InnerException = {"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."}
tvb2727
Participant
922 Points
1270 Posts
Problem connecting to hosting site database
Jan 26, 2013 08:19 PM|LINK
I am trying to run my web application on my development computer and I am having issues connecting to the hosting site database. I am using asp.net membership tables as well.
Error: InnerException = {"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."}
Connection String:
<connectionStrings> <add name="ApplicationServices" connectionString="data source=hostingsiteserver;Integrated Security=SSPI;Initial Catalog=tablename;User ID=userid;Password=pw;" providerName="System.Data.SqlClient"/> </connectionStrings>teddy_q
Member
712 Points
139 Posts
Re: Problem connecting to hosting site database
Jan 26, 2013 08:23 PM|LINK
Use the Standard connection string. Integrated Security=SSPI requires both the web & database server be in the same network.
http://www.connectionstrings.com/sql-server-2008
tvb2727
Participant
922 Points
1270 Posts
Re: Problem connecting to hosting site database
Jan 26, 2013 08:25 PM|LINK
Thanks. That was it.