Reason to Upgrade:
Desktop Engine (MSDE) has several limitations, including a maximum file storage size of 2GB and a maximum of 5 concurrent connections locally (25 for websites). Over time you may reach these limits and will lose the ability to storage projects on the server (you will still be able to create them locally). SQL Express increases that storage limit to 4GB. The steps below will show you how to upgrade your existing MSDE database to SQL Express to allow room for growth.
Before you begin make a backup and download the following files:
Backup:
Ø C:\Program Files\D-Tools\SI 4 ß Backup the entire SI4 folder
Ø C:\Program Files\Microsoft SQL Server\MSSQL$DTOOLSMSDE\ ß Backup the entire Data folder
Download:
1. Download SQL EXPRESS 2005 - Click Here
2. Download SQL Server Management Studio Express – Click Here
If your MSDE database only has one instance running (DTOOLSMSDE) choose Option 1. If you have more than one instance running, scroll down to Option 2.
1. Install SQL Server 2005 OVER the existing instance of DTOOLSMSDE
Note: If you have more than one instance, you will need to select “Named Instance and enter the proper instance name”
There is no need to change the .INI files or anything as the instance name, username and password are the same.
1. Install SQL Server 2005 with a new instance
2. Uncheck “Hide advanced configuration options” as pictured below
3. Choose Mixed Mode authentication and set a password (this password needs to also be the same in the .ini files for LANSync and Business Manager)
a. DToolsMastertable
b. DToolsProject40
c. DToolsUsers
d. DToolsMasterTable
e. DToolsMasterTable_log
f. DToolsProjects40
g. DToolsProjects40_log
h. DToolsUsers
i. DToolsUsers_log
j. Login Name: d-toolsprojects
k. Password: d-toolsprojectsadmin
Note: Under “Default Database: select DToolsUser
a. You will need to run this query on each of the following Database files as pictured below (DToolsMasterTable, DToolsProjects40, DToolsUsers)
Ø You will see the following confirmation that one orphaned user was fixed
a. D-ToolsBusinessManager.ini
b. D-ToolsLanSyncV4.ini
c. Change the Datasource name to the new instance (sometimes this format works YOUR_SERVER_NAME\)
d. Add UserName “sa” and password = password set in step 3