Installing MSDE for Microsoft Visual Studio .NET 2003

Visual Studio .NET 2003 does not include Microsoft SQL Server Desktop Engine (MSDE). To download MSDE, go to http://go.microsoft.com/fwlink/?linkid=13962.

Information from the Microsoft Site

MSDE 2000 for Developers Using Visual Studio .NET
This download will extract files necessary to install the latest version of MSDE 2000 for Visual Studio .NET customers. This version of MSDE includes up-to-date security features, including protection from the W32.Slammer worm.

Quick Info
File Name:
sql2kdesksp3.exe
Download Size:
70805 KB
Date Published:
8/21/2003
Version:
8.00.0760.03

Overview
This download applies to developers using Microsoft Visual Studio .NET 2003, Microsoft Visual Studio .NET 2002, Microsoft Visual Basic .NET, Microsoft Visual C++ .NET, Microsoft Visual C# .NET, and Microsoft Visual J# .NET. The download will install the latest version of MSDE 2000 complete with SP3a.

This version of MSDE 2000 includes up-to-date security including protection from the W32.Slammer worm as detailed in PSS Security Response Team Alert - New Worm: W32.Slammer. It includes all of the files that are required to install a new instance of MSDE or to upgrade all existing instances of MSDE.
System Requirements
· Supported Operating Systems: Windows 2000, Windows Server 2003, Windows XP

--------------------------------------------------------------------------------

Instructions
1. Click the Download link to start the download.

2. Do one of the following:

o To start extracting files required to install MSDE immediately, click Open or Run this program from its current location.

o To copy the download to your computer for installation at a later time, click Save or Save this program to disk.

3. If you choose Save this program to disk, locate the file where you saved it, and double-click the .exe file to extract all files required to install MSDE on your computer.

4. After extracting the MSDE installation files, open an MS-DOS command prompt and change to the directory where you extracted the files. MSDE extracts to C:\sql2ksp3\MSDE by default. Run the following command to set up MSDE for Visual Studio .NET. Replace YourSAPassword with the systems administrator's password that you would like to use:


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

I used the following command:

Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=0 SAPWD=SHAIL SecurityMode=SQL

Notes from me: After that you can use the database from query analyser not from enterprise manager because it is msde. I used msde2000A.exe file to install msde on my system. You can get this file from the microsoft site.
For information on MSDE setup options, consult the article Customizing Desktop Engine Setup.exe on MSDN®. http://go.microsoft.com/fwlink/?LinkId=13960

Additional Information

Rebooting

After completing the installation described above, reboot the computer to start the SQL Server Service Manager. It should startup automatically. After rebooting, you should see the MSSQL Server icon in the tray on the task bar.

Errors in Connecting (thanks to Chris Deweese for this information).

If the SQL Server Service Manager does not appear in the task bar or if you experience errors trying to connect to SQL Server, your computer may need the TCP/IP protocol enabled for the server. Do the following:

1. Open My Computer and go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn and look for a file named SVRNETCN.Exe. This is the default directory after installing MSDE.

2. Double-click the file to run it – it is named "SQL Server Network Utility"

3. Select the option to enable TCP/IP

4. Close the program and reboot your computer


On restart, you should see the MSSQL Server icon in the task bar.


Converting an Access Database File to an SQL Server Database


You will need two databases for use in CMIS 460, the MMABooks database and the AccountsPayable database. Both of these are available from the server site for the course as Microsoft Access databases. You will need to convert these Access databases to SQL Server databases.

First, load the databases onto your computer – I suggest you use the directory where you save all of your CMIS 460 work as you may need to reuse the databases at a later time. These notes will demonstrate how to convert the AccountsPayble database.

Open the AccountsPayble.Mdb database file (double-click the database's icon).


From within Microsoft Access, select the Tools -> Database Utilities menu option and the Upsizing Wizard option (see the figure below).

Select the option displayed for creating a new database file. Click the Next button.

The next window specifies the SQL Server installation you want to use – this will default to the SQL Server name on your computer or the entry (local). You can find the SQL Server installation name by opening the Sql Server Service Manager (the icon in the lower right corner of your computer screen).

Pay particular attention to the name that SQL Server generates for the database. SQL Server adds the letters "SQL" to the end of the database name. You should delete these letters so your database is named the same as my database – this makes it easier to grade.

Click the Next button.

Select all tables to be exported to SQL Server as shown in this figure, then click Next.

The next window is used to specify the table attributes to export. You need to export the data also. Do NOT check the box for creating only the table structure. Click the Next button.

Next the Upsizing Wizard asks if you want to modify the existing application or create a new one. Just select the No Application Changes radio button. Click the Next button.

Finally, if all succeeds, you'll arrive at the finish. Click the Finish button as shown here.

As the database converts, a window with a progress bar will display the status of the conversion.

After the conversion finishes, MS Access will display an Upsizing Wizard report – you may wish to examine the report to ensure that the conversion went without problem.

If there were no problems, repeat the process with the MMABooks.Mdb database file.

When you are finished, you can close MS Access – you will only need it if you decide to rebuild your database. Should you need to rebuild the database, you must first delete the existing files. This requires deleting both the *.mdf and *.ldf files located at: C:\Program Files\Microsoft SQL Server\MSSQL\Data. You can now use the directions given above to upsize the MS Access database file versions again to create new SQL Server databases..

END OF NOTES

This information taken from : http://www.siue.edu/~dbock/cmis460/msde.htm Link