How to Install SQL Server 2005 Express for TntMPD.DataServer

Top  Previous  Next

This guide will help you properly install SQL Server 2005 Express onto your computer.  SQL Server 2005 Express is made available by Microsoft for no cost.  However in some deployment models, a commercial edition of SQL Server 2005 must be used.  Check the System Requirements to learn more.

 

Note:
It is recommended that you install SQL Server 2005 and TntMPD.DataServer onto the same computer.  However, you may install SQL Server 2005 and TntMPD.DataServer onto separate computers.  But you will have to enable "remote connections" using the "SQL Server Surface Area Configuration" tool.  Also, you will have to install the "Connectivity Tools" component of SQL Server 2005 onto each client where TntMPD.DataServer is installed.

 

 

 

Download and Install Microsoft .NET Framework 2.0.

 

http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5

 

(Note that it may already be installed on your computer if you have the "C:\windows\Microsoft.NET\Framework\v2.0.50727" folder.)

 

 

 

Download and Install Microsoft SQL Server 2005 Express.

 

http://www.microsoft.com/downloads/details.aspx?FamilyID=11350b1f-8f44-4db6-b542-4a4b869c2ff1

 
a. Include all "Database Services" including "Replication", and include "Connectivity Components".

SQL2005ExpressFeatureSelection copy

 

b. Choose "Mixed Mode" for authentication, and remember the password you provide.

SQL2005ExpressAuthenticationMode

 

Note:
"Mixed Mode" authentication is not necessarily required. TntMPD.DataServer supports SQL Server with "Windows Authentication Mode Only" as long as TntMPD.DataServer and the instance of SQL Server you wish to work with are running on the same computer.  Also you must run TntMPD.DataServer with an NT account that has "sysadmin" privileges in SQL Server.  Hint: You may right-click on TntMPD.DataServer and "Run as..." in order to use the desired NT user account.

 

 

 

Optional:  Download and Install Microsoft SQL Server Management Studio Express.

 

http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

 

 

 

Next Step: Install TntMPD.DataServer