SDK Quickstart -- dotnet sdk

myleslawrence
7/18/2005 2:38:01 PM

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?

Tony
7/19/2005 2:36:10 AM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet sdk

dotnet sdk : SDK Quickstart