Microsoft KB Archive/872905

= How to install and to configure MSDE 2000 for ASP.NET applications =

Article ID: 872905

Article Last Modified on 4/4/2007

-

APPLIES TO


 * Microsoft Visual Studio .NET 2003 Professional Edition
 * Microsoft Visual Studio .NET 2003 Enterprise Architect
 * Microsoft Visual Studio .NET 2003 Enterprise Developer
 * Microsoft Visual Studio .NET 2003 Academic Edition
 * Microsoft Visual Studio .NET 2002 Professional Edition
 * Microsoft Visual Studio .NET 2002 Enterprise Architect
 * Microsoft Visual Studio .NET 2002 Enterprise Developer
 * Microsoft Visual Studio .NET 2002 Academic Edition

-



INTRODUCTION
This step-by-step article describes how to obtain and to install Microsoft SQL Server Desktop Engine (also known as MSDE 2000). This article also explains how to include the Pubs database, and this article includes commands that are used to grant permissions for the ASPNET account so that the ASPNET account can access the server and the Pubs database.

Install MSDE 2000
MSDE 2000 is a free downloadable and redistributable version of SQL Server. MSDE 2000 can be used in client applications or in Web applications. You can obtain MSDE 2000 from the Microsoft Download Center. To download MSDE 2000, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyId=A0DAC778-60A6-4B11-8AA8-BF12261A303A&displaylang=en

To install MSDE 2000 on your computer, follow these steps:  Locate the Sql2kdesksp3.exe file that you downloaded to your computer. Double-click the Sql2kdesksp3.exe file to extract all the MSDE installation files to a folder. By default, the path is C:\Sql2ksp3\Msde. Click Start, and then click Run. The Run dialog box appears. Type cmd in the Open box, and then click OK. The Command Prompt window appears. Change to the folder where you saved the installation files, and then run the following command:

Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=

Note  is a placeholder for your password.

Include the Pubs database
This MSDE 2000 does not contain the sample Pubs database. The Pubs database is included in Microsoft .NET Framework Software Development Kit (SDK) samples. To include the database, run the following command at the command prompt:

OSQL.EXE -E -S \VSDOTNET -i &quot; :\ \instpubs.sql&quot; -o C:\instpubs.out

Notes   is a placeholder for your computer name.  is a placeholder for the hard disk drive where you have installed Visual Studio .NET.</li>  is a placeholder for the path of the Instpubs.sql file.

In Microsoft Visual Studio .NET 2003, the default location is the following:

SDK\v1.1\Samples\Setup

For Microsoft Visual Studio .NET 2002 the Instpubs.sql file is available in the following location:

FrameworkSDK\Samples\Setup

</li></ul>

Grant permissions to the ASPNET account
To grant permissions to the ASPNET account so that the ASPNET account can access the server and the Pubs database, follow these steps:  Start the MSSQL$VSDOTNET service:  Click Start, and then click Run. The Run dialog box appears.</li> Type services.msc in the Open box, and then click OK. The Services window appears.</li> In the right pane, right-click MSSQL$VSDOTNET under Name, and then click Start.</li></ol> </li> un the following command at the command prompt to grant permission to the ASPNET account so that the ASPNET account can access the server:

osql -E -S COMPUTER_NAME\VSDOTNET -Q &quot;sp_grantlogin 'COMPUTER_NAME\ASPNET'&quot;

Note  is a placeholder for your computer name.</li> Run the following command at the command prompt to grant permission to the ASPNET account so that the ASPNET account can access the Pubs database:

osql -E -S COMPUTER_NAME\VSDOTNET -d Pubs -Q &quot;sp_grantdbaccess 'COMPUTER_NAME\ASPNET'&quot;

Note  is a placeholder for your computer name.</li></ol>

<div class="references_section">