[thelist] ASP.Net - Setting up SQL Express

[j s]

I set up a couple of grid pages, on an intranet, and want to restrict access to them.  Was aiming for Windows authentication.  SQL Express was installed on the C: drive of windows 2003 server with .Net 3, IIS 6.  D: the intranet installed on it.  Ran aspnet_regsql.exe to generate aspnetdb.  TCP/IP was enabled in the SQL Server Configuration Manager.  I have a dummy account set up with active directory called aspdata.  
In the web.config file it has
<clear />
<add name="LocalSQLServer" connectionString="Server=.\SQLEXPRESS:Database=aspnetdb;Trusted_Connection=Yes;">
<authentication mode="Windows" />
<identity impersonate="true" userName="aspdata at xxx.com" password="xxx">

In Visual Studio 2005, when I click on the web site administration tool  - then - Security an error comes back 
Cannot open database "aspnetdb" requested by the login. The login failed. Login failed for user 'xxx\ASPDATA'. 

So I tried to set up a login account in SQL Server Management Studio Express - still didn't work.

I had trouble updating the tables from the grid pages - and one of the things Microsoft recommended was using impersonation.  This is set up and working.

A while ago I set this up on my laptop flipped the database over to full sql and it ran fine - I didn't have to add alot of extra stuff in the web.config file.  So what ever is wrong - I need a really good guide to explain this.  

So Ken - I know you are a real guru at this.  Any ideas?  

Thanks
JS
----- Original Message ----
From: Ken Schaefer <Ken at adOpenStatic.com>
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Sent: Tuesday, March 4, 2008 10:01:49 PM
Subject: Re: [thelist] ASP.Net - Setting up SQL Express

Hi,

What is "over the network"? 

When you say "you have setup a login" - what exactly did you do?

What is the exact error message you are getting?

When you say you want to use impersonation - which user are you impersonating?

Cheers
Ken

-----Original Message-----
From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of j s
Sent: Wednesday, 5 March 2008 9:12 AM
To: thelist at lists.evolt.org
Subject: [thelist] ASP.Net - Setting up SQL Express

Hello,

I'm having an incredibly difficult time setting up sql express for and .net windows authetication.  Does anyone know of a really complete guide to do this?  It's over a network - sql express is on c: and the intranet sits on d: of the server.  I've been using impersonation and an error msg comes up Cannot open database aspnetdb requested by the login.  The login failed.  I've created a login for this on sql express - but it's not working.

Thx
--

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !