Hi BettyB, 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

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

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

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

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?

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

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

--
BettyB.
www.flamingo-code.com

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

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