Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8
This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 by Chris Hart, John Kauffman, David Sussman, Chris Ullman; ISBN: 9780764588501
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 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 Search this Thread Display Modes
  #31 (permalink)  
Old May 29th, 2006, 02:18 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi BettyB,
Quote:
quote:but I doubt that using SQL Server Express to work my way thru the beginning ASP.NET book will give me the information to enable me to use true SQL Server 2005.
Oh, I completely agree with you. When you want to run the applications in a production environment, it's important to realize how you should configure the servers and database.

But if you feel it's stopping you from making progress with the book, using the Express Edition might be a good way to continue for now. In the mean-time, you can gain more knowledge about configuring SQL Server. That at least doesn't stop you from continuing with the book.

Anyway, you may want to take a look at the second half of this FAQ: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=290

To understand what account you need to add to SQL Server, this might help as well: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=287

I started on an article that explains all these steps in full detail, outlining common .NET 2 scenario's with SQL Server 2000 and 2005. I just haven't found the time to complete it yet....

What I meant with my first question is this: SQL Server understands two authentication mechanisms: SQL Server authentication and Windows Authentication. In the first, you pass in a user name and a password, while in the second you use the account details for the running process (e.g. your own account, or ASPNET or Network Service in most scenario's). The error message you posted (about not being associated with a trusted connection) seems to indicate you try to open a connection with SQL Server authentication (e.g. a user name and a password in the connection) and that SQL Server rejects the connection because it's configured to only allow Trusted connections.

However, according to this article: http://support.microsoft.com/kb/889615/en-us you may also get that error when "you are trying to connect to a SQL Server database from a Windows account that does not have sufficient permissions to connect to the server.". In that case, the first FAQ I posted might help.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
  #32 (permalink)  
Old May 30th, 2006, 10:33 AM
Authorized User
 
Join Date: Dec 2004
Location: , , USA.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bettyb1656
Default

Hi Imar,

I have installed 2005 Express and reinstalled Web Dev Express. I got the Wrox United app to work after I deleted the web site and all the backup files.

I was using a connection string without a user id or password so I assume I was trying to connect with Windows authentication. Is there configuration information in the code other than the connectin string? It probably is a permissions problem but when I try to follow the various instructions I have found I am told I need to do A, B, and C but I can do A and B and C fails or I can do A and C but B fails. To me it is a catch 22.

I will take a look at your quickdoc links.

Thanks

--
BettyB.
www.flamingo-code.com
  #33 (permalink)  
Old May 30th, 2006, 01:51 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Quote:
quote:I have found I am told I need to do A, B, and C but I can do A and B and C fails or I can do A and C but B fails. To me it is a catch 22.
Welcome to the weird world of computer programming and configuration... ;)

Just kidding; the first FAQ I linked to shows you (very briefly) how to add a user to SQL Server. The other FAQ explains how to find out the user that you need to add in SQL Server.

Hopefully, the two FAQs can help you sort out the problem.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
  #34 (permalink)  
Old May 31st, 2006, 07:20 PM
Authorized User
 
Join Date: Dec 2004
Location: , , USA.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bettyb1656
Default

I can handle the programming. I've been doing that for over 40 years. It's the SQL configuration that I'm having trouble with. I just got the Apress book "Beginning SQL Server 2005 for Developers". Looks like it might do the trick.

--
BettyB.
www.flamingo-code.com
  #35 (permalink)  
Old June 4th, 2006, 05:14 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi BettyB,

Earlier this week I said I was working on an article about configuring SQL Server 2000 / 2005 in combination with an ASP.NET application.

The article is finished and you can find it here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

Hope you find it useful. Feedback or comments is welcome....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Niedoenou by Brainpower (Track 5 from the album: Even Stil) What's This?
  #36 (permalink)  
Old June 8th, 2006, 02:51 PM
Authorized User
 
Join Date: Dec 2004
Location: , , USA.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bettyb1656
Default

Hi Imar,

"The article is finished and you can find it here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395".

I followed this article and I now have the Wrox United site working on my machine using full SQL Server 2005. Thank You!!!

I did have to add 'select' permisions. I can't tell anyone how I did it since Web Dev Express 2005 what is set after you do it and then look for permissions, etc. using the property item.

Thanks again,
BettyB.


--
BettyB.
www.flamingo-code.com
  #37 (permalink)  
Old June 8th, 2006, 02:53 PM
Authorized User
 
Join Date: Dec 2004
Location: , , USA.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bettyb1656
Default

Sorry, that should be Web Dev Express 2005 doesn't show me what is set after I do it.

--
BettyB.
www.flamingo-code.com
  #38 (permalink)  
Old June 8th, 2006, 03:12 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

You're welcome. Glad it's all working now.

I should update my article and add a link to the download page for "SQL Server Management Studio Express". This is a management tool, similar to SQL Server Management Studio, which is free and can be used against the Express Edition of SQL Server.

With that tool, configuring an express edition is very similar to using the commercial version of the tool.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
  #39 (permalink)  
Old June 8th, 2006, 03:44 PM
Authorized User
 
Join Date: Dec 2004
Location: , , USA.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bettyb1656
Default

I was incorrect when I said I used Web Dev Express 2005 to add permissions. I used SQL Server Management Studio.

--
BettyB.
www.flamingo-code.com
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
reg conn to sql server 2005 from vb.net 2005.. veda SQL Server 2005 2 July 1st, 2008 12:16 AM
Wrox.com SQL Server 2005 Articles jminatel SQL Server 2005 6 April 10th, 2008 08:59 AM
SQL SERVER 2005 STANDARD (not express) proslambano BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 8 January 8th, 2007 08:55 PM
no wrox books on sql server 2005 connect2sandeep SQL Server 2000 4 September 1st, 2005 02:24 PM
Can we install SQL Server on WinXP Pro? dotnetwhizkid SQL Server 2000 6 August 26th, 2003 03:33 AM



All times are GMT -4. The time now is 05:57 PM.


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