[thelist] .NET 2.0 Login Control Error

[Tim Gaunt]

Hi Casey,

You should have "SQL Server Management Studio" under Start > All Programs >
Microsoft SQL Server 2005 Express, if not you can download it from the
Microsoft site [1].

Run it and it will ask you to log in to an instance of SQL Server -it should
default to your local instance and windows authentication so click "OK".
Once in there, there is a tree node "Security", expand that and then
"Logins" (or users but I forget atm). Then right click and add a new login.

HTH


Tim
[1]
http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-
94B8-5A0F62BF7796&displaylang=en

---------------------
We’re doing a 96 mile canoe race (the Cheshire Ring Race) in aid of charity
and I’m going to keep pimping the message out shamelessly until we reach our
target of £2,000! For more information –or to donate– go to
www.paddlathon.co.uk

-----Original Message-----
From: Casey Crookston [mailto:caseyc at IntelliSoftmn.com] 
Sent: 05 May 2007 23:04
To: info at thesitedoctor.co.uk; thelist at lists.evolt.org
Subject: RE: [thelist] .NET 2.0 Login Control Error

Thanks Tim.  I am almost following you... Not sure how to access the SQL
Server management Studio.  

Start > All Programs > Microsost SQL Server 2005 Express > Configuration
Tools > ???

Am I headed in the right direction here?  Or should I be looking inside
of VS 2005?

Casey



-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Tim Gaunt
Sent: Saturday, May 05, 2007 3:48 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] .NET 2.0 Login Control Error

You need to ensure that ASPNET has access to the database, to do this,
log
onto the machine's SQL Server Express instance (using SQL Server
Management
Studio) and add a new login of: MachineName\ASPNET (in this case I would
think it's LocalHost).

You may also find you need to add "NT Authority\SYSTEM" as well.

HTH

Tim