Setup for ASP.NET Walkthroughs/Tutorials

[Nus Pieds]

Hi,

I'm trying to use the QuickStart tutorials
(http://localhost/quickstart/aspplus/)--specifically the
data-access ones but I can't seem to run them because of a
security setup error for the pubs database.

I have SQL Sever installed and running with all the sample
databases (Northwind, Pubs, etc.). What exactly do I need
to do in SQL Server manager to make these QuickStart
examples run?

I did a View Code on the "DataGrid1.aspx" example and the
connection is:

MyConnection = New SqlConnection("server=(local)
\NetSDK;database=pubs;Integrated Security=SSPI")

I'm not an SQL Server expert, so I am presuming that I
have to create a "NetSDK" user or something and grant that
user access to the pubs database? If so, how do I do that?

Thanks,

NP

 

[Carl Prothman [MVP]]

I'm trying to use the QuickStart tutorials
(http://localhost/quickstart/aspplus/)--specifically the
data-access ones but I can't seem to run them because of a
security setup error for the pubs database.

Nus,
Since the connection is using "Integrated Security=SSPI" and ASP.NET worker
process defaults to the local ASP.NET User account, you will need to give
the local ASPNET user account permission to access the QuickStart tutorial
database within the "(local)\NetSDK" Sql Server instance.

For more info, see

HOW TO: Configure SQL Server Security for .NET Applications
http://support.microsoft.com/default.aspx?scid=kb;en-us;815154

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com

 

[Nus Pieds]

Carl,

I followed the instructions on the KB article and
completed that successfully, but...
permission to access the QuickStart tutorial
database within the "(local)\NetSDK" Sql Server instance.<<

What exactly is the "NetSDK Sql Server instance"? I have
SQL Sever running and there's a pubs database, Nortwind,
etc. I fished around the QuickStart pages, looking for
a "setup" or prerequisites documentation. Is there some
sort of database import/setup I need to peform for the
QuickStart that will create the "NetSDK" stuff?

Thanks,

NP

 

[Carl Prothman [MVP]]

The NetSDK instance is running, but encountered a "login
failed" error for ASPNET. I found a ConfigSamples.exe in
the QuickStart directory and I ran that and, afterwards,
it worked fine.

Nus,
Cool! It's good to hear you got it working! ;-)

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com