Evan Sims

This took me the better part of the afternoon to figure out, so hopefully I can save someone else the time.

1. Install the Dragon Age Toolset, ensuring that you uncheck the “Install SQL Server 2005″ option.
2. Download the x64 versions of SQL Server 2005 Express Edition and SQL Server Management Studio Express.
3. Install Server and Management Studio with the default settings.
4. Open Management Studio Express and connect with the default settings.
5. Right click “Databases” and select “New Database.” Set the name to “dragonage_toolset” and press OK.
6. Select “dragonage_toolset” from the list on the left and click the “New Query” button in the toolbar.
7. Paste the contents of this file in the blank window, and click the “Execute” button in the toolbar. You may see some warnings, but that’s OK.
8. Repeat the process, this time pasting the contents of this file.
9. Close Management Studio Express.
10. Run “ConfigureToolset.exe” from your Toolset installation folder.
11. Click next on the first screen. On the “Content Database” dialog, uncheck “Use the default database” and paste the following into the Database field:
    Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dragonage_toolset;Data Source=MACHINE-NAME\SQLEXPRESS
    You will want to change “MACHINE-NAME” to match the name of your PC in all capital lettering.
12. Press Next, and then press Finish. Start the Toolset and you should be good to go.

Hope this helps!

° Top     # Permalink to this article

Filed under Gaming, Tips. Tagged with Design, dragon age, sql server, toolset.

• Wilmer Lindau
  January 25, 2010 at 6:03 pm
  

  

  Hi Evan, trying this out now, I hope it works. But thanks anyway for sharing, have been trying to make this work for 2 days now.

  Thanks.

  Wilmer Lindau.

  Reply

• enigma28
  December 4, 2009 at 4:51 am
  

  

  Hey Even, I just had a thought, would this work with the Steam installed version of the game also? or would something need to be changed for that?

  Reply

• D.Law
  December 2, 2009 at 10:23 pm
  

  

  Thanks! Even works for 32 bit.

  Reply

• BigNameTheF*cker
  December 1, 2009 at 9:55 am
  

  

  you told us to download the 64x version of sql server 2005 but never told us to install it, think that might be the problem?

  Reply

• manidu
  November 23, 2009 at 8:26 am
  

  

  Hey guys & Evan,

  to prevent executing the db-scripts with errors, try the following other solution:

  In the Management Studio Express right click on “Databases…” and select “Restore Database…” (maybe named different, I am using the german version!).

  In the first field (“to database”) write “bw_dragonage_content”.
  For the second field, first select “from medium” and select the file “bw_dragonage_content.bak” from your “\Dragon Age\tools\dbbak” folder.
  A dataset is appearing in the list, select it in the column “restore”, then press OK.

  If an error show’s up, try to set full rights for the MSSQL-folder named in the error for all users over the explorer. It will work then, and you have the original database without any error.

  Worked for me… ;)

  Ah, of course you have to change your settings with the ConfigureToolkit.exe, just use the wizard on the second page, it will show available servers and databases. If it still doesn’t work, you maybe also have to start the “SQL GUI Manager” (or similar) and select “add new administrator”, which will grant SQL admin access to your current user if done properly… ;)

  Reply

• DocVego
  November 17, 2009 at 7:45 pm
  

  

  Thumbs up, works like a charm for me!

  Reply

• Evan Sims
  evansims.com
  November 14, 2009 at 1:07 pm
  

  

  Hi guys,

  Thanks; it appears we’re missing a step here somewhere and are failing to get all the data imported into the database. I’ve noticed this as well, and am investigating how to fix it. Stay tuned to this thread for updates.

  Reply

• shreddog
  November 14, 2009 at 7:32 am
  

  

  Thanks for posting this. Alas it didn’t work for me. What a piece of overcomplicated bullshit software :(

  Reply

• Daim
  November 12, 2009 at 5:16 pm
  

  

  Thanks a lot, actually works to make the editor running. However, once I am in, I experience some problems, i.e. I cannot access placeables, creatures, etc. Can it be that some links are not set correct?

  Reply

• Dan Porter
  November 11, 2009 at 10:29 pm
  

  

  Hey hows it going,

  I followed your instructions and I could not get the Toolset to load… I keep getting the message that states ‘unable to connect to the database.’ I followed your instructions to the letter…with no success… Also, I am getting a lot of errors when executing the creation of the temp tables/tables in the above-mentioned links you provided…

  Any help would be appreciated…

  Dan

  Reply

• Dele
  November 11, 2009 at 8:02 am
  

  

  unfortuantely i get many errors when i copy and paste those files into the query.

  will the names of those queries also matter?

  Reply

• Patrick
  November 11, 2009 at 1:50 am
  

  

  This worked for me. I’ve been struggling with it for the last couple days. Thanks a lot!

  Reply

• Evan Sims
  evansims.com
  December 2, 2009 at 5:02 pm
  

  

  3. Install Server and Management Studio with the default settings.

  Reply

• Evan Sims
  evansims.com
  December 4, 2009 at 12:16 pm
  

  

  Yup! I’m actually using the Steam version myself.

  Reply

Communicating with Twitter API...