ASP.NET 2.0 Quickstart Tutorials on Vista Ultimate using IIS7 and SQL Server 2005 (not SQLExpress)

Apr 5 2007 11:52 AM

Hi All,

Does anyone know how to install the ASP.NET 2.0 Quickstarts on a PC running Vista Ultimate with IIS7.0 and SQLServer 2005? The manula installation instructions for installing the Quickstart databases don't work with SQLServer 2005. For example, what are the equivalent commands for steps 3 and 4 but using SQL Server 2005 instead of SQLExpress? (see the following):

  • Install the Quickstart Sample databases. From the SDK command prompt change to the SDK\v2.0\samples\setup folder and run the following commands
    1. sqlcmd -E -S (local)\SQLExpress -i InstPubs.sql
    2. sqlcmd -E -S (local)\SQLExpress -i InstNwnd.sql
    3. sqlcmd -E -S (local)\SQLExpress -i InstGrocer.sql
    4. sqlcmd -E -S (local)\SQLExpress -i InstContacts.sql
    5. sqlcmd -E -S (local)\SQLExpress -i InstPhotos.sql
    6. sqlcmd -E -S (local)\SQLExpress -i Inst_FileSystemSQL.sql
    7. aspnet_regsql.exe -S (local)\SQLExpress -E -A all
  • Grant the ASP.NET User account access to the databases. On Windows Server 2003 the ASP.NET process runs under NT AUTHORITY\NETWORK SERVICE. In all other cases it runs under MACHINENAME\ASPNET.
    1. sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin <ASP.NET User Account>"
    2. sqlcmd -E -S (local)\SQLExpress -d Pubs -Q "sp_grantdbaccess <ASP.NET User Account>"
    3. sqlcmd -E -S (local)\SQLExpress -d Pubs -Q "sp_addrolemember 'db_owner', <ASP.NET User Account>"
    4. sqlcmd -E -S (local)\SQLExpress -d NorthWind -Q "sp_grantdbaccess <ASP.NET User Account>"
    5. sqlcmd -E -S (local)\SQLExpress -d NorthWind -Q "sp_addrolemember 'db_owner', <ASP.NET User Account>"
    6. sqlcmd -E -S (local)\SQLExpress -d GrocerToGo -Q "sp_grantdbaccess <ASP.NET User Account>"
    7. sqlcmd -E -S (local)\SQLExpress -d GrocerToGo -Q "sp_addrolemember 'db_owner', <ASP.NET User Account>"
    8. sqlcmd -E -S (local)\SQLExpress -d Contacts -Q "sp_grantdbaccess <ASP.NET User Account>"
    9. sqlcmd -E -S (local)\SQLExpress -d Contacts -Q "sp_addrolemember 'db_owner', <ASP.NET User Account>"
    10. sqlcmd -E -S (local)\SQLExpress -d Photos -Q "sp_grantdbaccess <ASP.NET User Account>"
    11. sqlcmd -E -S (local)\SQLExpress -d Photos -Q "sp_addrolemember 'db_owner', <ASP.NET User Account>"
    12. sqlcmd -E -S (local)\SQLExpress -d FileSystemSQL -Q "sp_grantdbaccess <ASP.NET User Account>"
    13. sqlcmd -E -S (local)\SQLExpress -d FileSystemSQL -Q "sp_addrolemember 'db_owner', <ASP.NET User Account>"
    14. sqlcmd -E -S (local)\SQLExpress -d ASPNETDB -Q "sp_grantdbaccess <ASP.NET User Account>"
    15. sqlcmd -E -S (local)\SQLExpress -d ASPNETDB -Q "sp_addrolemember 'db_owner', <ASP.NET User Account>"
  • James Giustino