Manual database installation - Revision history

Ibelieveicanfall at 11:51, 21 June 2017

2017-06-21T11:51:00Z

Skyruiner: /* Configuring the toolset to use this database */

2016-01-24T11:45:32Z

‎Configuring the toolset to use this database

Sim2er at 21:06, 27 March 2015

2015-03-27T21:06:46Z

Sunjammer: Removing another rogue space

2011-08-07T23:33:52Z

Removing another rogue space

Sunjammer: Reformatting for consistency

2011-08-07T23:33:09Z

Reformatting for consistency

Sunjammer: Removing rogue space

2011-08-07T23:32:21Z

Removing rogue space

Sunjammer: Updating links, reformatting instructions

2011-08-07T23:31:42Z

Updating links, reformatting instructions

Kelamor: Add languages bar

2011-02-04T08:10:38Z

Add languages bar

Deckard76: /* 64 Bit Issues */

2010-05-04T16:57:53Z

‎64 Bit Issues

Barrett R: /* Installing SQL Express 2005 */ added warning/issue for XP SP3 users

2010-03-22T06:09:45Z

‎Installing SQL Express 2005: added warning/issue for XP SP3 users

@@ Line 5: / Line 5: @@
 Download the SQL Express 2005 installer. The SQLEXPR.EXE package supports installing onto both 32-bit and 64-bit (WOW install) operating systems. Alternatively the smaller SQLEXPR32.EXE  can be used to install SQL Server Express 2005 on 32-bit operating systems. You can download the latest version (SP4) from:
-http://www.microsoft.com/download/en/details.aspx?id=184
+https://www.microsoft.com/en-au/download/details.aspx?id=21844
 Run the installer and accept all of the default options that it presents  to you throughout the install process. You may wish to give your SQL  server a name other than default during this step (the toolset installer  uses the name "BWDATOOLSET" by default).

@@ Line 85: / Line 85: @@
 [[File:Configure toolset database selection window.png|thumb|center]]
-This is where you'll select the database that the toolset uses.
+This is where you'll select the database that the toolset uses. Be sure to change the name of the server from BWDATOOLSET to the name of your actual server. This information can be accessed from the services panel if you are unsure. The default for MySQL is SQLEXPRESS.
 The ConfigureToolset application currently (as of 1.01) doesn't set a registry entry that the toolset also needs in order to find the database properly. You'll need to set this manually. The key you'll need to update is "DefaultDatabaseConnection" located here:

@@ Line 91: / Line 91: @@
 <pre>
 HKEY_LOCAL_MACHINE\SOFTWARE\BioWare\Dragon Age\Toolset\Environment
 </pre>

@@ Line 21: / Line 21: @@
 The solution is to rollback to Windows XP Service Pack 2; install SQL Express 2005; and then then re-update to SP3. Note this is very time consuming and can cause problems for other programs, like Internet Explorer, but has been confirmed to work.
- Alternatively, install SQL Express 2008. It will still give a warning about MSXML6 during the install, but unlike 2005 the warning doesn't fail the install.
+Alternatively, install SQL Express 2008. It will still give a warning about MSXML6 during the install, but unlike 2005 the warning doesn't fail the install.
 == Installing SQL Server Management Studio Express ==

@@ Line 15: / Line 15: @@
 MSXML6 will then be reinstalled when you rerun the SQL Express 2005 installer.
-:'''''Potential issue for users with Windows XP Service Pack 3''''': SP3 has its own ingrained version of MSXML6 which interferes with SQL Express 2005's installation of MSXML6. Even the '''Windows Installer CleanUp''' will be unable to remove it.
+=== Potential issue for users with Windows XP Service Pack 3 ===
-: The solution is to rollback to Windows XP Service Pack 2; install SQL Express 2005; and then then re-update to SP3. Note this is very time consuming and can cause problems for other programs, like Internet Explorer, but has been confirmed to work.
+SP3 has its own ingrained version of MSXML6 which interferes with SQL Express 2005's installation of MSXML6. Even the '''Windows Installer CleanUp''' will be unable to remove it.
-: Alternatively, install SQL Express 2008. It will still give a warning about MSXML6 during the install, but unlike 2005 the warning doesn't fail the install.
+The solution is to rollback to Windows XP Service Pack 2; install SQL Express 2005; and then then re-update to SP3. Note this is very time consuming and can cause problems for other programs, like Internet Explorer, but has been confirmed to work.
 == Installing SQL Server Management Studio Express ==

@@ Line 1: / Line 1: @@
-The MSSQL Server Express 2005 installer packaged with the toolset is one of the more common sources of installation failure. If other troubleshooting techniques fail, you may wish to install it manually as a separate step from toolset installation. This could also allow you to substitute different versions of the SQL server (note that BioWare has only specifically tested the toolset with the 2005 Express version, but users have reported success with the 2008 version as well).
+The Microsoft SQL Server Express 2005 installer packaged with the toolset is one of the more common sources of installation failure. If other troubleshooting techniques fail, you may wish to install it manually as a separate step from toolset installation. This could also allow you to substitute different versions of the SQL server (note that BioWare has only specifically tested the toolset with the 2005 Express version, but users have reported success with the 2008 version as well).
 == Installing SQL Express 2005 ==
-First, download the SQL Express 2005 installer. Here is the home page with information about SQL Server Express:
+Download the SQL Express 2005 installer. The SQLEXPR.EXE package supports installing onto both 32-bit and 64-bit (WOW install) operating systems. Alternatively the smaller SQLEXPR32.EXE  can be used to install SQL Server Express 2005 on 32-bit operating systems. You can download the latest version (SP4) from:
-http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx
+http://www.microsoft.com/download/en/details.aspx?id=184
-NOTE: If the setup fails due to MSXML6 failing - Go here
+If the set up fails due to an issue with MSXML6, download the '''Windows Installer CleanUp''' utility to remove MSXML6:
 http://support.microsoft.com/kb/968749
-and download the Windows Installer CleanUp utility to remove MSXML6 and let it reinstall.
+ MSXML6 will then be reinstalled when you rerun the SQL Express 2005 installer.
-*'''''Potential issue for Windows XP users with Service Pack 3:''''' SP3 has its own ingrained version of MSXML6 which interferes with SQL Express 2005's installation of MSXML6. Even the Installer Cleanup will be unable to remove it. Solutions: Rollback to Service Pack 2, install SQL Express 2005, then re-update to SP3 (very time consuming, can break some other programs like IE, but confirmed to work). Alternatively, install SQL Express 2008. It will still give a warning about MSXML6 during the install, but unlike 2005 the warning doesn't fail the install.
-Depending on your hardware, download either the 32 or 64 bit installer from this page:
+: Alternatively, install SQL Express 2008. It will still give a warning about MSXML6 during the install, but unlike 2005 the warning doesn't fail the install.
-−
-http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx
-−
-Run the installer and accept all of the default options that it presents to you throughout the install process. You may wish to give your SQL server a name other than default during this step (the toolset installer uses the name "BWDATOOLSET" by default).
 == Installing SQL Server Management Studio Express ==
-The bare install of SQL Express 2005 relies on the command line for most of its configuration and management. To provide a more powerful and user-friendly GUI, Microsoft has supplied the free application SQL Server Management Studio Express. Download it here:
+Working with a basic installation of SQL Express 2005 relies on a command line interface for most of its configuration and management. Microsoft SQL Server Management Studio Express provides a powerful and more user-friendly GUI. You can download the latest version (SP4) from:
-http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796 or
+http://www.microsoft.com/download/en/details.aspx?id=7011
-http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx (same location as SQL Express 2005)
-Install the management studio, again picking the default options presented through the install process.
+Ensure you download the correct version for your operating systems and install SQL Server Management Studio Express, again, accepting the default options presented through the install process.
-===SQL Server Management Studio Express installation issues===
+=== SQL Server Management Studio Express installation issues ===
-====64 Bit Issues====
+=== 64 Bit Issues ===
 In Windows Vista and Windows 7 if you get an error 29506 the SSMSE cannot change the rights of the database because it is running from your user space. Try the following:
@@ Line 42: / Line 39: @@
 * Type '''SQLServer2005_SSMSEE.msi''' (Enter) and the installer should now work without errors.
-====Cannot connect to <computername>\BWDATOOLSET error when starting SQL Server Management Studio Express====
+=== Cannot connect to <computername>\BWDATOOLSET error when starting SQL Server Management Studio Express ===
 Error Text:
 {{Dashedborder|Cannot connect to <ComputerName>\BWDATOOLSET.

← Older revision		Revision as of 08:10, 4 February 2011
Line 102:		Line 102:
	See [[Bug: ConfigureToolset application fails to set a registry key]] for more on this bug.		See [[Bug: ConfigureToolset application fails to set a registry key]] for more on this bug.

		+	{{Languages}}
	[[Category:Database]]		[[Category:Database]]

← Older revision		Revision as of 06:09, 22 March 2010
Line 13:		Line 13:

	and download the Windows Installer CleanUp utility to remove MSXML6 and let it reinstall.		and download the Windows Installer CleanUp utility to remove MSXML6 and let it reinstall.
		+	*'''''Potential issue for Windows XP users with Service Pack 3:''''' SP3 has its own ingrained version of MSXML6 which interferes with SQL Express 2005's installation of MSXML6. Even the Installer Cleanup will be unable to remove it. Solutions: Rollback to Service Pack 2, install SQL Express 2005, then re-update to SP3 (very time consuming, can break some other programs like IE, but confirmed to work). Alternatively, install SQL Express 2008. It will still give a warning about MSXML6 during the install, but unlike 2005 the warning doesn't fail the install.