Question about connecting to sql server 2000

Discussion in 'Databases' started by rockmouse, Aug 15, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. rockmouse

    rockmouse

    Hi Everyone,

    I am useing sql server 2000, everything is fine except if I run my asp.net2 project locally and connecting to the live sql server, the error is "System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.".

    My connection string is "server=mssql02.discountasp.net;database=DB_395941_tmimports;integrated security=SSPI;user id=<myusername>;password=<mypassword>;" I am using role management control.

    Does anyone know how to fix this error?

    Thanks a lot

    Michael
     
    rockmouse, Aug 15, 2007
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Try this


    "Data Source=tcp:mssql02.discountasp.net;Initial Catalog=DB_395941_tmimports;User ID=DB_395941_tmimports_user;Password=******;"


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Aug 16, 2007
    #2
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