No matter what I do, I can't get the toolset working. It gives me "Unable to Connect to Database" or some such crap like that. I'm running Windows 8 64, and whenever I install the MSQ-whatever it says it's not compatible. Tried installing 2008 and 2012, and none of them work either.
Problem with Toolset
Débuté par
G_Admiral_Thrawn
, mai 10 2013 05:17
Retour en haut
#2
Posté 12 mai 2013 - 05:15
sea-
-
- Members
- 264 messages
Be sure you are using the default settings and make sure to create the default database when you install. I would then install SQL 2012 and update your database that you installed with the Toolset. I have done this successfully on Windows 7, but Windows 8 breaks compatibility with old software even more and you might be out of luck.
#3
Posté 13 mai 2013 - 02:56
dr.drummie
-
- Members
- 51 messages
in my case it works, just ignore compatibility settings and go to the end with sql2005, another (potential) problem is if you already have database and you want to transfer it to this computer (like me, so now all my "projects" are, well, dead.. 
)..
)..
#4
Posté 14 mai 2013 - 04:04
PotentPotions
-
- Members
- 320 messages
I'm running Windows 8 Pro x64, and no, it does NOT like SQL Express 2005. I fought with Windows for about a week before I hit upon something that worked. This was my solution, and it works without issues.
I'm assuming you have already tried installing the Toolset and therefore have all of the directories and files on your hard drive that it would have installed. For simplicity's sake, I'm also going to assume you are using your C: drive as your install location, and installed everything to it's default path. I'm certain if your installation is in another location, you can figure out where you need to go. :-)
First, download a free copy of SQL Express 2012 which includes the Management Studio. You will need it to hook up the database after you do the install.
Next, go to the directory where the Toolset installed SQL Server 2005 and the database files. (C:\\Program Files (x86)\\DAODB in my case.) Go down until you find the DATA subdirectory. It should contain two files, bw_dragonage_content.ldf and bw_dragonage_content.mdf. Go up a level, right click on the DATA directory and select copy. Paste that copy in a safe location you can find easily later. I put mine on my D: drive in a directory labelled Toolset Database Backup.
Now you need to go to Control Panel and select Programs and Features and uninstall SQL Server 2005 Express. I had you copy that directory in case the uninstaller cleans up that folder by deleting it. Don't do anything with the Toolset install. If it's already installed, then you'll be good to go shortly. Reboot if necessary.
Next, install SQL Server 2012 Express with Management Tools using the default settings unless you have a specific path, etc that you want it to install in. Just remember where you installed it. :-) When it asks you for a name for the database instance it's installing, name it BWDATOOLSET (that's what the Toolset names the default database. You don't have to keep that name if you would rather name it something else. I just found it simpler to remember that way.)
Once the installer finishes, go back to where you put that DATA folder and either cut or copy it then navigate to the directory where your new install of SQL Express 2012 is located. (C:\\Program Files\\Microsoft SQL Server\\MSSQL11.BWDATOOLSET in my case.) Inside is a directory MSSQL. Open it and paste that DATA directory inside. It will likely insist you grant Admin Rights since it's a protected directory location.
Once that's done, you need to start up Management Studio. Connect to the database. It should show you as connected (computer name, server name, version, etc) the first subheading should be Databases. Right click on Databases and select Attach. Click Add and navigate to that DATA folder you just pasted in. Select the bw_dragonage_content.mdf file and click on Ok.
The database should now show as attached, and you should see various subheadings. You can now close the Management Studio.
Navigate to the Tools directory of your Dragon Age game install folder. (C:\\Program Files (x86)\\Dragon Age\\tools) and run ConfigureToolset.exe. Give it the install path to your game and click Next. UNcheck the box that says Use the default database, then select the name of your SQL Server instance, then click on the ... icon and select the server name and then the database on the server. (YOURCOMPUTERNAME\\BWDATOOLSET and bw_dragonage_content respectively) then click on Test Connection. It should report that it can connect just fine.
Now you can fire up the Toolset. If it comes up but doesn't show any resources, (not unusual) click on File, Manage Modules and select Single Player and click Open. The Palette Window should now populate with the various bits of the game. If it's still empty, that's not uncommon either. Click on Tools, Builder, Builder to Builder Load, then go to your C:\\Program Files (x86)\\Dragon Age\\tools\\DatabaseUtilities directory and select core.dadbdata. When the importer opens up, click on Check All, make sure the radio button under StringIDs is set on Use Theirs, then click Ok and let your computer process the data. Depending on your processor, this may take a while as it's a lot of stuff. :-)
When it finishes the import, everything should be available to you, and the Toolset should work just fine. If you accidentally have the box in the settings checked that tells the Toolset to Check Out everything automatically, then you will find that all of the resources are checked out to you. To find out for sure and correct the problem, mouse over to the Palette Window and select All, then click the little triangle pointing down and select Only show resources checked out to me. If everything on the list is still there, then you will need to check everything back in. Easiest way to do that is to then check the Hide folders box, select a portion of the list (don't try doing it all in one whack as I can pretty much guarantee you will lock up your machine. Mine's a 8 core AMD monster development machine and it locked up when I did that on my first attempt... Just saying... :-) Right click on your selected section and select either Undo Checkout or Check in. Either works just fine. It will ask you for verification if you select Undo Checkout or request that you attach a comment to the files if you select check in.
In any case, that's what I did, and I can confirm that the Toolset is up, running and doing as it's supposed to do, it's just accessing SQL Express 2012 x64 for it's resources instead of SQL Express 2005. I've had no problems using it to create and share stuff. It rus cleanly under Windows 8 without having to use Compatibility Mode -- If you want to be able to save things in the Toolset or Dragon Age directories in the Program Files (x86) directory though, you WILL need to navigate to the Toolset executable file, right click, select Compatibility, Change settings for all users, and choose to Run as Administrator. Otherwise it will drive you nuts with errors that it can't access that location when you try to save things there due to the Admin Rights issues Windows 8 has.
There may be easier ways of accomplishing this, but this worked for me and so I offer it up for other frustrated Windows 8 users. If you run into any problems, feel free to PM me and I'll be happy to help.
I'm assuming you have already tried installing the Toolset and therefore have all of the directories and files on your hard drive that it would have installed. For simplicity's sake, I'm also going to assume you are using your C: drive as your install location, and installed everything to it's default path. I'm certain if your installation is in another location, you can figure out where you need to go. :-)
First, download a free copy of SQL Express 2012 which includes the Management Studio. You will need it to hook up the database after you do the install.
Next, go to the directory where the Toolset installed SQL Server 2005 and the database files. (C:\\Program Files (x86)\\DAODB in my case.) Go down until you find the DATA subdirectory. It should contain two files, bw_dragonage_content.ldf and bw_dragonage_content.mdf. Go up a level, right click on the DATA directory and select copy. Paste that copy in a safe location you can find easily later. I put mine on my D: drive in a directory labelled Toolset Database Backup.
Now you need to go to Control Panel and select Programs and Features and uninstall SQL Server 2005 Express. I had you copy that directory in case the uninstaller cleans up that folder by deleting it. Don't do anything with the Toolset install. If it's already installed, then you'll be good to go shortly. Reboot if necessary.
Next, install SQL Server 2012 Express with Management Tools using the default settings unless you have a specific path, etc that you want it to install in. Just remember where you installed it. :-) When it asks you for a name for the database instance it's installing, name it BWDATOOLSET (that's what the Toolset names the default database. You don't have to keep that name if you would rather name it something else. I just found it simpler to remember that way.)
Once the installer finishes, go back to where you put that DATA folder and either cut or copy it then navigate to the directory where your new install of SQL Express 2012 is located. (C:\\Program Files\\Microsoft SQL Server\\MSSQL11.BWDATOOLSET in my case.) Inside is a directory MSSQL. Open it and paste that DATA directory inside. It will likely insist you grant Admin Rights since it's a protected directory location.
Once that's done, you need to start up Management Studio. Connect to the database. It should show you as connected (computer name, server name, version, etc) the first subheading should be Databases. Right click on Databases and select Attach. Click Add and navigate to that DATA folder you just pasted in. Select the bw_dragonage_content.mdf file and click on Ok.
The database should now show as attached, and you should see various subheadings. You can now close the Management Studio.
Navigate to the Tools directory of your Dragon Age game install folder. (C:\\Program Files (x86)\\Dragon Age\\tools) and run ConfigureToolset.exe. Give it the install path to your game and click Next. UNcheck the box that says Use the default database, then select the name of your SQL Server instance, then click on the ... icon and select the server name and then the database on the server. (YOURCOMPUTERNAME\\BWDATOOLSET and bw_dragonage_content respectively) then click on Test Connection. It should report that it can connect just fine.
Now you can fire up the Toolset. If it comes up but doesn't show any resources, (not unusual) click on File, Manage Modules and select Single Player and click Open. The Palette Window should now populate with the various bits of the game. If it's still empty, that's not uncommon either. Click on Tools, Builder, Builder to Builder Load, then go to your C:\\Program Files (x86)\\Dragon Age\\tools\\DatabaseUtilities directory and select core.dadbdata. When the importer opens up, click on Check All, make sure the radio button under StringIDs is set on Use Theirs, then click Ok and let your computer process the data. Depending on your processor, this may take a while as it's a lot of stuff. :-)
When it finishes the import, everything should be available to you, and the Toolset should work just fine. If you accidentally have the box in the settings checked that tells the Toolset to Check Out everything automatically, then you will find that all of the resources are checked out to you. To find out for sure and correct the problem, mouse over to the Palette Window and select All, then click the little triangle pointing down and select Only show resources checked out to me. If everything on the list is still there, then you will need to check everything back in. Easiest way to do that is to then check the Hide folders box, select a portion of the list (don't try doing it all in one whack as I can pretty much guarantee you will lock up your machine. Mine's a 8 core AMD monster development machine and it locked up when I did that on my first attempt... Just saying... :-) Right click on your selected section and select either Undo Checkout or Check in. Either works just fine. It will ask you for verification if you select Undo Checkout or request that you attach a comment to the files if you select check in.
In any case, that's what I did, and I can confirm that the Toolset is up, running and doing as it's supposed to do, it's just accessing SQL Express 2012 x64 for it's resources instead of SQL Express 2005. I've had no problems using it to create and share stuff. It rus cleanly under Windows 8 without having to use Compatibility Mode -- If you want to be able to save things in the Toolset or Dragon Age directories in the Program Files (x86) directory though, you WILL need to navigate to the Toolset executable file, right click, select Compatibility, Change settings for all users, and choose to Run as Administrator. Otherwise it will drive you nuts with errors that it can't access that location when you try to save things there due to the Admin Rights issues Windows 8 has.
There may be easier ways of accomplishing this, but this worked for me and so I offer it up for other frustrated Windows 8 users. If you run into any problems, feel free to PM me and I'll be happy to help.
