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

Discussion in 'Databases' started by jimspicer, Apr 9, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. 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
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    did you attach or install the membership database to your SQL server?
     
  3. 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
     
  4. Bruce

    Bruce DiscountASP.NET Staff

    thanks for the follow up post!
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page