SDK Quickstart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

myleslawrence - 18 Jul 2005 22:38 GMT

I hope this is the correct forum for this because I'm at wits end.
I have a Win 2003 server, SQL server 2000 and the .Net framework sdk
installed.

The ASP.NET VB Quickstart tutorials have web form examples some of which
connect to the database.
They do not work and I get 'server does not exist or access denied' when I
try to run any of the database examples.

If I revert back to asp and write a simple asp program that does an ADODB
connections and select, it works just fine. Anybody help me on this? Is
there an in which these are supposed to be installed?

Reply to this Message

Tony - 19 Jul 2005 10:36 GMT

Hi,

IIRC you have to assign permissions to the ASPNET user along the lines of -

osql -E -S (local)\NetSDK -Q "sp_grantlogin '<machinename>\ASPNET'"
osql -E -S (local)\NetSDK -d <database> -Q "sp_grantdbaccess 'DEVTOP\ASPNET'"
osql -E -S (local)\NetSDK -d <database> -Q "sp_addrolemember 'db_owner',
'<database>\ASPNET'"

There is information about this under a link called "Configuration Details"
in the "Step 2: Set up the Quickstarts " paragraph on the Quickstarts opening
page. That takes you to "ConfigDetails.htm" which has a para called "Granting
Access to the ASPNET user".

HTH.

> I hope this is the correct forum for this because I'm at wits end.
> I have a Win 2003 server, SQL server 2000 and the .Net framework sdk
[quoted text clipped - 8 lines]
> connections and select, it works just fine. Anybody help me on this? Is
> there an in which these are supposed to be installed?

Reply to this Message

SDK Quickstart

Free Magazines