Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > BOOK: Beginning ASP.NET 1.0
|
BOOK: Beginning ASP.NET 1.0
This is the forum to discuss the Wrox book Beginning ASP.NET 1.0 with C# by Chris Goode, John Kauffman, Christopher L. Miller, Neil Raybould, S. Srinivasa Sivakumar, Dave Sussman, Ollie Cornes, Rob Birdwell, Matt Butler, Gary Johnson, Ajoy Krishnamoorthy, Juan T. Llibre, Chris Ullman; ISBN: 9780764543708
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 1.0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 23rd, 2004, 04:14 PM
Friend of Wrox
 
Join Date: May 2004
Posts: 120
Thanks: 0
Thanked 1 Time in 1 Post
Default Not associated with a trusted SQL Server connecti

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.
__________________
       YoOrD .
Beauty is not on the face
Beauty is on the heart
~~<<Ghibran Khalil>>~~
The Following User Says Thank You to yoord For This Useful Post:
 
Old July 24th, 2004, 03:58 AM
Friend of Wrox
 
Join Date: Oct 2003
Posts: 336
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alyeng2000
Default

grant dbaccess to the account in the Sql connection string

Ahmed Ali
Software Developer
 
Old August 8th, 2004, 04:21 PM
Friend of Wrox
 
Join Date: May 2004
Posts: 120
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.


 
Old August 14th, 2004, 04:13 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 120
Thanks: 0
Thanked 1 Time in 1 Post
Default

Any One Help me how i can coonect local computer

 
Old August 16th, 2004, 11:07 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 120
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.

 
Old August 16th, 2004, 11:30 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

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
 
Old April 15th, 2007, 02:48 PM
Registered User
 
Join Date: Apr 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?








Similar Threads
Thread Thread Starter Forum Replies Last Post
migrating from sql server 2000 to sql server 2005 abinashpatra SQL Server 2005 2 December 1st, 2006 03:45 PM
not associated with a trusted SQL Server Connectio chiefouko SQL Server 2000 4 September 27th, 2006 01:14 PM
Not associated with a trusted SQL Server connectio blajorthemajor SQL Server 2000 0 February 10th, 2006 07:30 PM
not associated with a trusted SQL Server Connectio jamesbie SQL Server 2000 1 February 24th, 2005 04:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.