Configuring SQL Server 2000

Could someone point me in a direction of a good online tutorial of how to set up correctly a SQL Server 2000 installation.

I have looked myself but get lots of Book Reviews and PHP links:-(

The reason I ask is because I am trying to access the NorthWind database using the Programming ASP.NET examples, and unfortunately I get the error "SQL Server does not exist or access denied."

The connection string is "server=local; database=NorthWind" and I have given IUSR_ the right to perform a SELECT on all fields in NorthWind, but I know that this not the best way of doing things.

What I need is a point in the right direction.

Thanks.

Edit: I have changed the connection string to the "server=MOURNBLADE; uid=sa; pwd=MyPW; database=northwind" and made sure that sa has access rights to all tables and still no joy - gives me the error of "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."

Can anyone give me any pointers?

Managed to get it working!

For some reason when I ran a google search earlier I recieved very few hits, none of which were particularly helpful. I ran the search again and got a lot more positive hits. The fix? I was using Windows Authentication. I needed to use 'Mixed Mode'. I can't put it anymore succinctly than ScriptLogic does:

Quote:

Using the SQL Enterprise Manager: 1.) Expand a Server group. 2.) Right-click a server name, and then click Properties. 3.) Click the Security tab. 4.) Under Authentication, click the SQL Server and Windows option button. 5.) Restart SQL Server in order for the change to take effect.

http://www.google.com/search?q=%22N...:en-US:official

The first link in this google search answered your question, complete with screen shots