PDA

View Full Version : Question about connecting to sql server 2000


rockmouse
08-15-2007, 10:18 AM
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

bruce
08-16-2007, 06:10 AM
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 (http://www.DiscountASP.NET)