Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > BOOK: Beginning ASP.NET 1.0
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old July 23rd, 2004, 05:14 PM
Friend of Wrox
 
Join Date: May 2004
Location: Ardabil, Ardabil, Iran.
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
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>>~~
  #2 (permalink)  
Old July 24th, 2004, 04:58 AM
Friend of Wrox
 
Join Date: Oct 2003
Location: Cairo, , Egypt.
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
  #3 (permalink)  
Old August 8th, 2004, 05:21 PM
Friend of Wrox
 
Join Date: May 2004
Location: Ardabil, Ardabil, Iran.
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
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.


  #4 (permalink)  
Old August 14th, 2004, 05:13 AM
Friend of Wrox
 
Join Date: May 2004
Location: Ardabil, Ardabil, Iran.
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Any One Help me how i can coonect local computer

  #5 (permalink)  
Old August 16th, 2004, 12:07 PM
Friend of Wrox
 
Join Date: May 2004
Location: Ardabil, Ardabil, Iran.
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
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.

  #6 (permalink)  
Old August 16th, 2004, 12:30 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
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
  #7 (permalink)  
Old April 15th, 2007, 03:48 PM
Registered User
 
Join Date: Apr 2007
Location: , , .
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?



 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 02: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



All times are GMT -4. The time now is 03:26 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.