Login failed for user ''. The user is not associated with a trusted SQL Server connec

Hi,
I am working on a new installation. My replicate to SQL Server 2005 seems to be ok and the default.aspx page renders correctly. When I try and "login" (using Membership tables in db) I get the error "Login failed for user ''. The user is not associated with a trusted SQL Server connection."

My connection strings are:

<clear />
<addname="ASPNETDBConnectionString"
connectionString="Data Source=tcp:sql2k510.discountasp.net;Initial Catalog=SQL2005_618021_******;User ID=SQL2005_618021_*******_user;Password=********;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
<addname="LocalSqlServer"
connectionString="Data Source=tcp:sql2k510.discountasp.net;Initial Catalog=SQL2005_618021_********;User ID=SQL2005_618021_********_user;Password=*******;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient"/>

The login controls and code worked ok local. Any help will be appreciated.

TIA,
Jim Spicer

 

membership tables

Hi Bruce,
Yes. I combined the system database with the ASPNETDB.mdf file created by VWD...and tested it locally before replicating the entire database to SQL Server 2005.

Jim

 

found a solution

I found a solution to my "login failed..." problem. SQL Server 2005 does not appear to support Integrated Security or User Instance. When I removed these two params from the connection strings, the login succeeds. There is an informative article on these issues here:
http://blogs.msdn.com/sql_protocols...ted-with-a-trusted-sql-server-connection.aspx

Jim Spicwer