Not associated with a trusted SQL Server connecti

yoord · July 23rd, 2004, 04:14 PM

i get this error when i am trying to connecting to my local sql server
any one to help me how i can do to solve this problem

Quote:

quote:Login failed for user 'ASPNET'. Reason: Not associated with a trusted SQL Server connection.

thanx in advance.
YoOrD.

alyeng2000 · July 24th, 2004, 03:58 AM

grant dbaccess to the account in the Sql connection string

Ahmed Ali
Software Developer

yoord · August 8th, 2004, 04:21 PM

hi Ahmed thanx for your reply.
i did some thing like this:
i was add a login name like IUSR_MZZ (db_own,dbaccess,..)
and use it for connection but i get this error again
i get same error again.
this is the whole code i am using for this goal

Code:

 

	Quote:
	
	
		
			
				quote:string con="user id=[IUSR_MZZ];password=;";

Code:



	Quote:
	
	
		
			
				     con+="initial catalog=member; server=mzz;connection Timeout=30;";

the error is:

Quote:

quote:

Quote:

System.Data.SqlClient.SqlException: Login failed for user '[IUSR_MZZ]'. Reason: Not associated with a trusted SQL Server connection. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at ASP.checking_connection_to_db_aspx.Page_Load()

Regards
YoOrD.

yoord · August 14th, 2004, 04:13 AM

Any One Help me how i can coonect local computer

yoord · August 16th, 2004, 11:07 AM

I found where i do wrong is that:
i Must Create a loging role in my local sql server machine
like "machine/ASPNET" and give it some permissions to access database
tables.
Thanx .
YoOrD.

bmains · August 16th, 2004, 11:30 AM

Hey,

If you want to use the user account, add integrated security=false to the connection string, to login with your user account. Your user account should have a password that you need to put in the connection string.

Brian

palulu · April 15th, 2007, 02:48 PM

Quote:

quote: I found where i do wrong is that:
i Must Create a loging role in my local sql server machine
like "machine/ASPNET" and give it some permissions to access database
tables.
Thanx .
YoOrD.

How did you make this?