Download from Microsoft SQL2000SampleDb.msi for SQL Server 2000 (1.5MB file dated 4/8/2004). This is not available from CodePlex. Running this results only in the creation of folder 'C:SQL Server 2000 Sample Databases' containing. This book need me to download SQL2000SampleDb.msi from MS site, but I only got the following message when I was trying to download and save it. Internet Explorer cannot download SQL2000SampleDb.msi from download.microsoft.com. The connection with the server was reset. Could anyone tell me what I am doing with something wrong. Download the sample database file SQL2000SampleDb.msi. Expand the files: Double click on the downloaded file MSDE2000A.exe to expand the files. Download file SQL2000SampleDb.msi 3. Run it - you'll get seven files, one of them - ReadMeSQL2000SampleDbS. Follow the instructions.
Click this link to go to the download page. Click the Download button to download SQL2000SampleDb.msi, and click Save in the dialog box that appears. Specify your installation location (such as the desktop) and click Save. When the download is complete, click Close. Run the SQL2000SampleDb.msi file to start the installation process.
Using Microsoft SQL Server 2000 and/or MSDE 2000 (the Microsoft SQL Server Desktop Engine) with Visual Studio .Net 2003
by Jeff Charles
Updated about 12/31/2004
Some key points:
(1) You may have to enter your computerinstance in the Server combo box of MSDE's SQL Server Service Manager dialog box (it may not find them automatically).
(2) If you use both computer name and MSDE instance name, you have to separate them with a backslash (), NOT a forward slash (/).
(3) You may have to use the Connect to Database button in Visual Studio's Server Explorer, to connect and make the databases visible.
Further details and references are in this page's content below.
(1) You may have to enter your computerinstance in the Server combo box of MSDE's SQL Server Service Manager dialog box (it may not find them automatically).
(2) If you use both computer name and MSDE instance name, you have to separate them with a backslash (), NOT a forward slash (/).
(3) You may have to use the Connect to Database button in Visual Studio's Server Explorer, to connect and make the databases visible.
Further details and references are in this page's content below.
Some preliminary reference information:
To find out your computer name, to use when running osql statements:
My Computer - right click
Properties - click
Computer Name tab - click
Full computer name: antec2003
You can also find your computer name in Visual Studio:
View->Server Explorer
Expand the line Servers and you should see your computer name.
If you expand subsequent lines, it will also be included under
SQL Servers, in front of the backslash and the instance name.
To check on what services are running (e.g. SQL Server):
My Computer - right click
Manage - click
Services and Applications - double click
Services - double click
Look for service name 'MSSQL$VSDOTNET'
(shows status as 'started' if it's running, not stopped)
- double click on that service name
Log On tab - click
Allow service to interact with desktop - check this box?
(I don't know if this checkbox helps anythng, but it might)
Using MSDE - the Microsoft SQL Server Desktop Engine ..
Download MSDE:
http://www.microsoft.com/sql/msde/downloads/default.asp
Use link 'Download MSDE 2000 Release A' to go to
http://www.microsoft.com/sql/msde/downloads/download.asp
Select language and click 'Go' to go to the next page
At bottom of that page, click the link 'MSDE2000A.exe'
to download the file MSDE2000A.exe.
(or from http://www.microsoft.com/sql/msde/downloads/default.asp
Use link 'SQL Server 2000 Service Pack 3a' to go to
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Select language and click 'Go' to go to the next page
At bottom of that page, click the link 'sql2kdesksp3.exe'
to download the file sql2kdesksp3.exe, instead of MSDE2000A.exe.
Either one should work, for a new installation.)
Also from http://www.microsoft.com/sql/msde/downloads/default.asp
Use link 'Northwind and pubs Sample Databases' to go to
the next page containing sample database downloads.
Download the sample database file SQL2000SampleDb.msi.
Expand the files:
Double click on the downloaded file MSDE2000A.exe to expand the files.
InstallShield puts them in a default folder called c:MSDERelA.
It should say 'The package has been delivered successfully'.
Sm g925a firmware. In c:MSDERelA there is a readme file called ReadmeMSDE2000A.htm'
if you want more info.It also has an addendum online at
http://support.microsoft.com/?kbid=829925.
However, I will describe the MSDE setup later;
the document references may not be needed.
Double click on the sample database downloaded file SQL2000SampleDb.msi
to expand the sample database script files.
The Windows installer wizard puts the sample database scripts in
c:Program FilesMicrosoft SQL Server 2000 Sample Database Scripts.
(And they then appear in the Control Panel /
Add or Remove Programs list.)
The wizard says to follow the instructions in the readme
to complete the installation.The readme is called
ReadMe_SQL2000SampleDbScripts.htm, in the directory noted above.
However, I will describe the sample database setup later;
the document references may not be needed.
(If using the book 'Murach's C#', by Joel Murach and Doug Lowe,
then after downloading the book's support files
at murach.com's site as cshp_allfiles2003.exe, double click on
that downloaded file to unzip the files into c:MurachC#.NET
and c:C#.NET.)
Setup:
To set up MSDE:
Go to a command prompt
(i.e., Start->All Programs->Accessories->Command Prompt).
Use the cd command to change directories as follows:
cd c:MSDERelA
Run this command:
setup instancename=vsdotnet sapwd=myownpwd
where myownpwd is the password you want to use as
your system administrator password.
(Further info on MSDE setup is at
http://msdn.microsoft.com/library
/en-us/distsql/distsql_84xl.asp?frame=true
which is the same as
http://go.microsoft.com/fwlink/?LinkID=13960,
and you can also see
http://go.microsoft.com/fwlink/?linkid=13962
although that page may be unreliable.)
The Windows installer will complete the installation and
display a message stating that you must restart your system
for the changes to MSDE to take effect.After saving any
open data files, restart your system.
There will now be a directory called
c:Program FilesMicrosoft SQL Server
Your instancename should appear under that as:
c:Program FilesMicrosoft SQL ServerMSSQL$VSDOTNET
Go to Start->All Programs->Startup->Service Manager.
The SQL Server Service Manager window will open.
The 'Server' combo box is empty.
And the status bar at the bottom says 'Not Connected - '.
If you click or double click on the
'Start/Continue' arrow button at this point,
(and/or click the 'Refresh services' button), a message
will say 'The specified server name is invalid',
or 'This service control cannot be completed as no service has
been selected', or nothing will happen.
Type into the 'Server' combo box:
antec2003vsdotnet
(using a backslash, not a forward slash)
where antec2003 is your computer name (see instructions at the
top of this document to find your computer name)
and vsdotnet is the instancename of your MSDE instance
(used in the MSDE setup command previously).
Note: if a forward slash is used to separate the computer name
and the instance name, you'll get an error message saying
'The network path was not found', when you click the
'Refresh services' button.You must use a backslash,
not a forward slash.
Click the 'Refresh services' button.
The status bar at the bottom of the window will say:
Running - antec2003vsdotnet - MSSQLServer
where antec2003 is your computer name and vsdotnet
is your MSDE instance name.
If you check on what services are running, at this point,
(see instructions near top of this document),
there will be a service with the name 'MSSQL$VSDOTNOT'
(where VSDOTNET is your instance name)
and its status will be 'Started'.
You can also see the services that are running by going into
Visual Studio .NET 2003, Server Explorer.Expand the
lines for: Servers, antec2003 [your computer name],
Services.Then the service MSSQL$VSDOTNET will show below
that (where VSDOTNET is your instance name).
Also, in Visual Studio, Server Explorer, you can expand the
lines for: Servers, antec2003 [your computer name],
SQL Servers, ANTEC2003VSDOTNET [your computer and instance].
Under that you will see some databases,
such as master, model, msdb, and tempdb.
You will not yet see the Northwind or pubs databases--
we will set them up shortly.
To set up the Sample Databases (from SQL Server--Northwind and pubs):
Go to a command prompt
(i.e., Start->All Programs->Accessories->Command Prompt).
Use the cd command to change directories as follows:
cd c:Program Files
Microsoft SQL Server 2000 Sample Database Scripts
Do a 'dir' command and make sure that instnwnd.sql and
instpubs.sql files are there.
Run this ODBC SQL (osql) command:
osql -E -S antec2003vsdotnet -i instpubs.sql
-o myoutputlog1.txt
![Sql2000sampledb Msi Download Sql2000sampledb Msi Download](/uploads/1/0/8/0/108075575/587504969.png)
where antec2003vsdotnet is your computerinstance name
(be sure to use a backslash, not a forward slash).
Log file name numbers can be incremented on later runs.
The -i and -o files are the input and output files.
Note: if you use a forward slash, you'll get error
messages in the output log file as follows:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Changed the forward slash to a backslash.
Got an error:
Could not obtain exclusive lock on database 'MODEL'.
Her last words meaning. Retry the operation later.
Closed Visual Studio, and the SQL Server Service Manager.
Reran the osql command as above.Checked the output log
file.It looks okay.
![Msi Msi](/uploads/1/0/8/0/108075575/196589486.png)
Now when you go back into Visual Studio, Server Explorer,
and expand the lines: Servers, antec2003 [your computer
name], SQL Servers, ANTEC2003VSDOTNET
[your computerinstance], you should see a new database
listed, called 'pubs'.It contains tables such as
publishers, authors, and jobs.
(If necessary, you can click the 'Refresh'
button in Visual Studio--Server Explorer, or
close and reopen Visual Studio, or stop and start
the MSDE server, or reboot your computer.)
Run this ODBC SQL command (similar to above, only for the
Northwind database, instead of the pubs database)
after closing Visual Studio to avoid conflict:
osql -E -S antec2003vsdotnet -i instnwnd.sql
-o myoutputlog2.txt
where antec2003vsdotnet is your computerinstance name
(be sure to use a backslash, not a forward slash).
Ran the osql command.Checked the output log
file.It looks okay.
Now when you go back into Visual Studio, Server Explorer,
and expand the lines: Servers, antec2003 [your computer
name], SQL Servers, ANTEC2003VSDOTNET
[your computerinstance], you should see a new database
listed, called 'Northwind'.It contains tables such as
Orders, Products, and Customers.
(If necessary, you can click the 'Refresh'
button in Visual Studio--Server Explorer, or
close and reopen Visual Studio, or stop and start
the MSDE server, or reboot your computer.)
(Further info on osql is at
http://support.microsoft.com/default.aspx?scid=
kb;en-us;325003
and
http://msdn.microsoft.com/library/en-us/coprompt
/cp_osql_1wxl.asp?frame=true . )
To set up the sample databases from the VB textbook CD
(Advanced Programming Using Visual Basic .NET,
by Bradley and Millspaugh):
Use the instructions in the file 'InstallingSQLServerFiles.doc'
on the textbook CD.
To set up the sample databases from the book 'Murach's C#':
Use the instructions in the support files download for the book,
after unzipping the download file.The instruction file
name is 'Readme for 2003 download.pdf'.
Or you may have to just copy the .mdf and .ldf files from the
Murach database directory over to
'c:Program FilesMicrosoft SQL Server
MSSQL$VSDOTNETData' (if you used the normal naming;
where VSDOTNET is your MSDE instance name), and then
use the 'Connect to Database' button in Server Explorer
as described below under 'Operation'.
Operation:
Whenever you restart your machine, if the server icon exists in the
Notification Area on the right side of the task bar, double-click
it to open the SQL Server Service Manager window.If the icon does
not display in the Notification Area, open the SQL Server Service
Manager by using Start->All Programs->Startup->Service Manager.
If the Server combo box is empty, type in Vmware workstation 15.0 0 license key.
antec2003vsdotnet
(your computerinstance) into the Server combo box
and click on the 'Refresh services' button.
The status bar at the bottom of the window should then say:
Running - antec2003vsdotnet - MSSQLServer
(using your computer name and MSDE instance name).
If necessary to get it running, close Visual Studio,
click the 'Refresh services' button, and then
click or double click the 'Start/Continue' arrow button.
In Visual Studio, Server Explorer, you should be able to
double click on a data base and have its data rows display in the
Visual Studio edit area.That is, you should be able to
expand the lines: Servers, antec2003 [your computer name],
SQL Servers, ANTEC2003VSDOTNET [your computerinstance],
Northwind [the database name you want to use], Tables.
Then you should be able to double click on a table
(for example, Products) and have its rows display.
If not, and you get a login screen instead,
then click on the database name to highlight it,
and then click on the 'Connect to Database' button
at the top of the Visual Studio--Server Explorer window.
A 'Data Link Properties' dialog box will appear.
On the 'Connection' tab page, fill in antec2003vsdotnet
(your compterinstance) in item 1, choose 'Use Windows NT
Integrated security' in item 2, and choose
'Attach a database file as a database name' in item 3
and fill in the database name in the first box below that
(for example, Northwind) and navigate to
the database's .mdf file in the bottom box.
(The mdf file should be in 'c:Program FilesMicrosoft SQL Server
MSSQL$VSDOTNETDatanorthwind.mdf' if you used
the normal naming; where VSDOTNET is your MSDE instance name,
and northwind.mdf is the file name for the database you want.)
Then click the 'Test Connection' button and make sure
you get the message 'Test connection succeeded'.
Now when you expand the lines in Server Explorer and
double click on the database's table name (such as Products),
the table should open in the Visual Studio edit area.
(You can close it without closing all of Visual Studio
by using the appropriate small 'x' close button for that document.)
For Windows XP Professional Service Pack 2 (August 2004), see
'Microsoft SQL Server - FAQ: How Windows XP Service Pack 2 (SP2)
Affects SQL Server and MSDE', at:
http://www.microsoft.com/sql/techinfo/administration
/2000/security/winxpsp2faq.asp
For info about applying SQL Server Service Pack 3a,
including on trial software, see:
http://www.microsoft.com/sql/downloads/2000/sp3.asp
This web page states, among other things, that:
SQL Server 2000 SP3a:
Improves serviceability for SQL Server 2000 Evaluation
Edition. SP3a enables service pack upgrades for trial
software. In the past, service packs have not been
applicable to trial software.
Return to top of pageReturn to Home Page
Sql2000sampledb Msi Download Free
Copyright © 2004 Jeffrey A. Charles; all rights reserved.
In this book we will create a sample reporting application and we need to install some tools to be ready to start. We will use Microsoft Visual Studio 2012 to design our sample reporting application, Crystal Reports to design the reports, Microsoft SQL Server 2008 as the database engine, and Northwind as a sample database. We will have to install all these applications before we get started.
In this chapter, we will cover the following topics:
- Installing Microsoft Visual Studio 2012
- Installing Crystal Reports
- Installing Microsoft SQL Server 2008
- Installing Northwind database
Since we are going to use Microsoft Visual Studio to create our sample reporting application, let's begin by installing it on our machine.
Microsoft Visual Studio 2012 source can be downloaded from the Microsoft website by going to the following URL:
We will use the premium edition in our sample. After downloading the source, extract it, and double-click on the
vs_premium.exe
file to begin the installation.Now that we have downloaded and extracted the source file, let's install it on our machine.
- License agreement: As we can see in the following screenshot, we can change the installation directory by clicking on the Browse button and selecting the directory in which we wish to install the files. Check the I agree to the License terms and conditions. checkbox to complete the installation and click on the Next button.
- Optional features: As we can see in the following screenshot, we can customize the installation features in Visual Studio. In our reporting sample application, we need Microsoft SQL Server Data Tools and, therefore, we can deselect all other features. But it is better to install all the features on our machine. After we select the features, click on the INSTALL button.
- Installation process: As we can see in the following screenshot, the dialog box simply displays the status of the installation process. This may take several minutes.
- Setup successful: After a few minutes, a dialog box will pop up telling us that we have successfully installed Visual Studio on our machine.
Now that we have finished installing Visual Studio, let us install Crystal Report.
Crystal Reports source can be downloaded from the SAP website at the following URL: http://www.sap.com/index.epx.
Following are the steps to download Crystal Reports:
- Click on the Free Trials link as we see in the following screenshot:
- Click on SAP Crystal Reports, developer version for Microsoft Visual Studio as we see in the following screenshot:
- Click on Download SAP Crystal Reports, developer version for Microsoft Visual Studio now, as shown in the following screenshot:
- As we see in the following screenshot, if you have an account, click on log in now else register and click on Download Now to start the download.
This version is compatible with Microsoft Visual Studio 2012. After downloading the source, double-click on the
CRforVS_13_0_5.exe
file to begin installation.- Installation language: Select Englishlanguage and click on the OK button as we see in the following screenshot:
- Welcome: Read notes and warnings in this dialog box and click on the Next> button as shown in the following screenshot:
- License Agreement: Read the License Agreement carefully. Then select the I accept the License Agreement checkbox and click on the Next button as we see in the following screenshot:
- Confirmation: As shown in the following screenshot, click on the Next button to begin the installation. It will take a few minutes to finish installing the software on our machine.
- Successfully installed: This step tells us that Crystal Reports is installed successfully and asks us if we wish to install 64-bit runtime. Select the checkbox and click on the Finish button as we see in the following screenshot:
Now let's install SQL Server 2008.
Microsoft SQL Server 2008 source can be downloaded from the Microsoft website at:
Following are the steps to download Microsoft SQL Server 2008:
- Search for SQL Server 2008 r2 service pack 2 by typing in
download sql server 2008 r2 service pack 2
as we see in the following screenshot: - Select Downloads and click on the first result:
- Click on Download:
- Choose a compatible version of SQL Server 2008 with your windows. I have Windows 7, 64-bit so I select the
SQLServer200BR2SP2-KB2630458x64-ENU.exe
version of SQL Server 2008 as we see in the following screenshot. Click on the Next button to begin the download. - After we finish downloading, we can find a file named
SQLServer2008R2SP2-KB2630458-x64-ENU.exe
; double-click on the downloaded file to begin the installation.
Following are the steps to install Microsoft SQL Server 2008:
- SQL Server Installation Center: As we see in the following screenshot, select Installation, and click on the New SQL Server stand-alone installation or add features to an existing installation link.
- Setup Support Rules: As shown in the following screenshot, Microsoft checks for problems that occur during the installation in order to fix them before the installation process starts. If any of the checks fail, click on Show details >> to find out what went wrong. Correct it, and then click on Re-run. If the test is completed successfully, click on OK.
- Product Key: As shown in the following screenshot, we can enter the product key by selecting the Enter the product key: radio button and filling in the product key. To proceed without entering a product key, select Specify a free edition: for evaluating SQL server 2008 and click on Next.
- License terms: After reading the terms and conditions, select the I accept the license terms checkbox and click on Next.
- Setup Support Files: Simply click on Next to complete installation.
- Setup Support Rules: As shown in the following screenshot, Microsoft checks for problems that might occur while installing SQL Server Setup Support files. If there are any problems, we need to fix it before we finish installation. If there are no issues, we can complete the installation and click on Next>.
- Feature Selection: As shown in the following screenshot, we will choose what feature we will install on our machine. For basic installation, we need to install only Database Engine Services and Management Tools – Basic. But it is always better to install all the features. After choosing what features you want on your machine, click on Next.
- Instance Configuration: As shown in the following screenshot, we can choose to keep Default instance name MSSQLSERVER, or change it to any other name. It is recommended that you keep the default name though. On the other hand, we can change the installation directory to any other directory that has the required space. Click on Next.
- Disk Space Requirement: Simply click on Next to complete the installation.
- Server Configuration: As shown in the following screenshot, we will set up Service Accounts that will be used to run SQL Server. We will use the built-in network service account for all services (this account does not require a password) because we are installing SQL Server on our machine. In the Account Name column, select NT AUTHORITYNETWORK SERVICE for all the services and click on Next>.
- Database Engine Configuration: As shown in the following screenshot, we will choose the authentication security mode. There are two types of authentication:
- Windows Authentication: When a user connects through a Microsoft Windows user account, SQL Server validates the account name and password using information in the Windows operating system. This is the default authentication mode, and is much more secure than Mixed Mode.
- Mixed Mode: This authentication mode allows users to connect by using Windows Authentication and SQL Server Authentication. Users who connect through a Windows user account can use trusted connections that are validated by Windows. If you choose Mixed Mode Authentication, you must set strong passwords for all SQL Server logins.
- Choose Mixed Mode (SQL Server authentication and Windows authentication) and enter the password (let's say we use
asd123
as SQL Server password). Retype the password to confirm it and click on Add Current User. When this is done, click on Next>. - Analysis Services Configuration: If we don't choose analysis service in the feature selection dialog, we will skip this step. Click on Add Current User and then click on Next.
- Reporting Services Configuration: This step, like the previous one, will be skipped if we don't choose Reporting Services Configuration in the feature selection dialog. Keep the default options and click on Next.
- Error and Usage Reporting: This step asks us if we wish to send the error information to Microsoft. Keep the option selected and click on the Next button.
- Installation Rules: This dialog checks if there are any processes or other installations running, which will interrupt the installation of SQL Server 2008. If there are any issues, we have to fix it before installation. If there are no issues, click on Next.
- Ready to Install: This step displays all the features that will be installed on our machine. Click on Install to complete installation.
- Installation Progress: SQL server will now be installed on our machine. After the installation process is done, we will see a table of all the features that have been installed on our machine.
- Complete: We will see a small dialog box telling us that Microsoft SQL server installation has been completed successfully. Click on Close to close this dialog box. Then we will see the main installation center. We can close it. Now you will have to restart the machine.
Installing Northwind database in Microsoft SQL Server 2008
Now that we have finished installing Microsoft SQL Server, let us install the Northwind database.
Northwind database source can be downloaded from the Microsoft web site at:
- Search for the Northwind database download by typing in
download Northwind database
as shown in the following screenshot: - Click on the first result as we see in the following screenshot:
- Click on Download as shown in the following screenshot to start the download:
- After we finish downloading, we will get a file named
SQL2000SampleDb.msi
. Double-click on this file to begin the installation.
Following are the steps to install the Northwind database:
- Welcome Dialog: As shown in the following screenshot, it is simply a welcome dialog. Click on the Next button.
- License Agreement: Select theI Agree radio button and click on Next as shown in the following screenshot:
- Choose Installation Options: We will leave the default settings as we see in the following screenshot and click on Next.
- Confirm Installation: We can now install the Northwind database on our machine and click on Next.
- Installing the Database: As shown in the following screenshot, the database scripts will be installed on our local drive.
- Installation Complete: After the scripts have been installed, we will find a folder named
SQL Server 2000 Sample Databases
created in theC:
. We will use one of these files to install the Northwind database into SQL Server 2008. - Open SQL Server Management Studio: From the Start menu select All Programs, then select Microsoft SQL Servers 2008, and click on SQL Server Management Studio.
- Connect to SQL Server 2008: As shown in the following screenshot, select Database Engine from the Server type: menu, Server name: is localhost (or '.'), which represents our machine. The Authentication type is SQL Server Authentication, the same option that we selected during installation. The Login name is
sa
, which represents the default user of SQL Server, and the password isasd123
or the password you had entered while installing the SQL Server. After filling in all the fields, click on Connect. - Create Northwind database in SQL Server 2008: Open
C:SQL Server 2000 Sample Databases
. This is where the database scripts are installed. Drag thefilenamedinstnwnd.sql
file, which contains all SQL scripts required to create the Northwind database on our server, and drop it in SQL Server Management Studio. As we can see in the following screenshot, click on the Execute button to run the scripts. - After all scripts are executed correctly, we will see Northwind in our databases, as can be seen in the following screenshot:
Sql2000sampledb Msi Download Windows 10
In this chapter, we learned how to set up all the tools we will need to complete our sample application. In the next chapter, we will start with the design of our application and we will see that this application contains most types of Crystal Reports.