156 réponses à ce sujet

[Excedrin]

Well after 3 1/2 hours of attempting to get this piece of garbage running with the "Unable to connect to database" error and after reading every thread on this forum as well as re-reading the wiki over and over, I finally found the freaking problem.



It might help others from experiencing this nightmare and I'll try to explain this in english for those not highly technical:



The problem for me was this:



Running Vista 32bit, SQL Express 2005 already installed (MS Accounting) here's the problem:



The connection string is incorrect: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=bw_dragonage_content;Data Source=.\\BWDATOOLSET"



The installation does not create a data source: .\\BWDATOOLSET nor does loading the backup create it.



In my install I have SQLExpress as the only datasource/Engine and installing the toolset loads the database into that 'Engine'.



So to fix the problem change this: "BWDATOOLSET"

to "SQLExpress" (without the quotes)



If the name of your engine is different, use whatever name appears in your management console.



Best of luck to those having this freaking problem.

[sand beagle]

nevermind, i got past the "unable to connect to database" error by using:
http://social.biowar...troubleshooting
and
http://social.biowar...se_installation

i just changed .\\\\BWDATOOLSET to username\\SQLEXPRESS in the toolset config. I am using windows 7 x64 just so you know, and the command line thing was useless.

Modifié par sand beagle, 25 novembre 2009 - 01:10 .

[SteamPunks]

I just though of this but if you are using a steam version like I am then I believe there is a character limit on the file name. Steam users break the limit and there are fixes on the bioware site. Anything that could hopefully help someone.

[Nikki503]

MoxinRift wrote...

Haven't read all of this, so may be superfluous - but I got on the right path after reading Smergo's post. His command didn't work for me though, so I did the following:

1. Make sure you have all rights to the whole Dragon Age program folder (I really hate Vista sometimes ..)
2. Uninstall the toolset.
3. Run the installer as administrator.
4. Set the toolset to run as administrator.
5. Run the damn thing.

This finally worked for me. Thanks a lot to Smergo.

I also have vista and My computer makes me enter my admin password everytime I run the toolset.  My toolset seems to work fine, but when I run the game, the mods do not show up.  I'm thinking it's the admin thing that's the problem.  Anyone know how to fix this?

[Nikki503]

Ok, I now know for a fact that the problem is my toolset exporting the mods to the admin's documents folder. I tested it by logging into my admin account and running the game where they worked perfectly. I tried moving the folders to the addins folder on my user, but it is still not working. Is there another file that I need to move? How do I change the export directory to the correct one?

[grallonsphere]

Excedrin wrote...

...

The connection string is incorrect: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=bw_dragonage_content;Data Source=.\\\\BWDATOOLSET"

The installation does not create a data source: .\\\\BWDATOOLSET nor does loading the backup create it.

In my install I have SQLExpress as the only datasource/Engine and installing the toolset loads the database into that 'Engine'.

So to fix the problem change this: "BWDATOOLSET"
to "SQLExpress" (without the quotes)

Nah - this doesn't work either.  I open the configure toolset utility and specify your modified string and still getting an 'unable to connect' error.  It's almost as if Bioware didn't want us to use this thing!  A good thing I didn't have to pay for it.



G.

[SithLordExarKun]

Wow now im having this issue when it was fine 6 hours ago...

[skinnbone]

when the sql installer comes up it wont even install the loadin bar just stays in one spot and wont move been in the same spot for 2 hrs... do i even need the sql thing

[6Darko6Majere6]

i did just as smergo wrote, but it still would not work. i think that dragon age toolset dont work in norway. i strongly believe that. bioware hate norwegians. or just me.

[I HAS A FLAVOUR]

bump

[SteamPunks]

When does the tool set 1.01 come out? I just downloaded the file today and it says its still 1.00. On the wiki it states that a lot of tool set problems are fixed in 1.01.


EDIT: I'm using a steam dragon age and I just managed to fix my problem and get the tool set working. 

I followed the instructions at http://social.biowar...se_installation

and if you have steam also follow http://social.biowar...tion_with_Steam

Modifié par SteamPunks, 04 décembre 2009 - 11:00 .

[Lord Sinner]

1.01 same problem.

[Andaarse]

wnec doing the ""c:\\Program Files (x86)\\Microsoft SQL Server\\90\\Tools\\Binn\\SQLCMD.EXE" -S .\\BWDATOOLSET -E -Q "RESTORE DATABASE bw_dragonage_content FROM DISK = 'd:\\Program Files (x86)\\Steam\\SteamApps\\common\\dragon age origins\\tools\\dbbak\\bw_dragonage_content.bak' WITH MOVE 'bw_dragonage_content' TO 'd:\\Program Files (x86)\\Steam\\SteamApps\\common\\dragon age origins\\tools\\toolssql\\Data\\bw_dragonage_content.mdf', MOVE 'bw_dragonage_content_log' TO 'd:\\Program Files (x86)\\Steam\\SteamApps\\common\\dragon age origins\\tools\\toolssql\\Data\\bw_dragonage_content.ldf'" " command, if u get any problems with "missing paths, just make em, atleast thats what i had to do with my \\toolssql\\data\\ folder, after i did that, the command workd, and i got my toolset up and running, also this the paths i use is addapted to steam folders ;P anyway ty for the info that let me fix this (: been trying for 2 days now hehe

[lorosas]

have the problem to but i can't understand anything like this because i don't undersand the computer-language ! I have installed a SQL server by installing the toolset but i don't know anything about it !!!

[angry_peon]

I have an annoying problem too. I try to make a manual database install via SQL manager, using the toolset wiki guide. Everything went well up to this step: http://social.biowar...rite_option.png
My problem is that under "Original File Name", instead of the path to the .bak file, wich I chose exactly as pointed out here: http://social.biowar...base_backup.png (example: c:\\program files\\dragon age\\tools\\dbbak\\bw_dragonage_content.bak), I only see the .bak file. I can start the restoration at this point, and it even says it was succesfull, but at the target-location no files are created. No wonder, seeing that SQL doesn't seem to keep track from where it should get the .bak... It really starts getting on my nerves.

Modifié par Varhjhin, 30 décembre 2009 - 10:57 .

[Seraph798]

I tried doing what Smergo recommended, but I couldn't find toolssql in the tools folder. Does anyone know where to find the folder? I have Vista if that matters.

[worleyjon28]

I am about to try Smergo's method and praying it will work!

[worleyjon28]

Absolutely nothing worked for me or i dont know what im doing. Either one is very likely. i will just have to wait for bioware to fix the problem themselves or tell me how to in a simpler fashion.

[Razhathael]

Seraph798 wrote...

I tried doing what Smergo recommended, but I couldn't find toolssql in the tools folder. Does anyone know where to find the folder? I have Vista if that matters.

This. there is no such thing as toolssql in my folder, using vista too.
And for the poster above me, trust me, Bioware won't fix this, we have to do a lot of programming crap in order to get something like this working, it's the exact same thing as with downloadable content, it just...Doesn't work properly unless you fix it yourself... :<

[Ceneen]

I got it working now - thanks to a friend who did the trouble-shooting and did get some grey hairs due to this. I will post here the procedures and please try not to ask back, as I couldn't explain any of it, my friend could only answer, but he got no access here.

The problem I had happened to appear:

When I did run the ToolSet, it couldn't connect to the database, so my friend tried to restore the database as described on several sources, including this thread, with using the following command line (be sure to only have single backslashes in the whole paths, this forum seems to add more):

sqlcmd -S .\\BWDATOOLSET -E -Q "RESTORE DATABASE bw_dragonage_content FROM DISK = 'C:\\Program Files\\Dragon Age\\tools\\dbbak\\bw_dragonage_content.bak' WITH MOVE 'bw_dragonage_content' TO 'C:\\Program Files\\DAODB\\bw_dragonage_content.mdf', MOVE 'bw_dragonage_content_log' TO 'C:\\Program Files\\DAODB\\bw_dragonage_content.ldf'"

He did get a connection refused response in the output then and the command failed overall. My friend did the following then to address the issue:

1) In the 'SQL Server Configuration Manager' (via start menu), left click 'SQL Server 2005 Services', there should be a 'SQL Server (BWDATOOLSET)' running to the right.

2) Right click 'SQL Server (BWDATOOLSET)' and select 'Properties'

3) Instead of using the option 'Build-In Account', he selected a specific account via 'This Account:'. The account he  did specify now was named exactly after my XP user account and we even used the same password. Now we both do not know if the exact phrasing there is necessary or even recommended, but it helped me anyway in the end.

4) He did run the command line now again (the one stated above) and it did go through and created 'bw_dragonage_content.mdf' and 'bw_dragonage_content.ldf' in the directory 'C:\\Program Files\\DAODB'

5) Running the Toolset now worked without any further configuration.

I hope this helps some people at least and I am sorry with not being able to respond any questions further, as I could not explain a single bit sadly.

Modifié par Ceneen, 11 janvier 2010 - 01:48 .

[Ubasti]

I installed the game and the toolset to another computer today, with exactly the same specs as the one I used to have it installed. In the other computer the toolset worked, now I'm getting this. I use XP SP3.

And I still don't understand where and how I would have to put that command line (and why). I am a complete idiot what comes to Windows system since I'm usually a Mac user. Tried to look the Wiki, but my mind just went blank.

Edit: And it also seems that the installation didn't went as it should have, I have ni folder in the start menu, from which I would be able to uninstall the toolset, so now I don't even know how to do that.

Modifié par Ubasti, 11 janvier 2010 - 07:39 .

[Ubasti]

Ceneen wrote...

I got it working now - thanks to a friend who did the trouble-shooting and did get some grey hairs due to this. I will post here the procedures and please try not to ask back, as I couldn't explain any of it, my friend could only answer, but he got no access here.

The problem I had happened to appear:

When I did run the ToolSet, it couldn't connect to the database, so my friend tried to restore the database as described on several sources, including this thread, with using the following command line (be sure to only have single backslashes in the whole paths, this forum seems to add more):

sqlcmd -S .\\\\BWDATOOLSET -E -Q "RESTORE DATABASE bw_dragonage_content FROM DISK = 'C:\\\\Program Files\\\\Dragon Age\\\\tools\\\\dbbak\\\\bw_dragonage_content.bak' WITH MOVE 'bw_dragonage_content' TO 'C:\\\\Program Files\\\\DAODB\\\\bw_dragonage_content.mdf', MOVE 'bw_dragonage_content_log' TO 'C:\\\\Program Files\\\\DAODB\\\\bw_dragonage_content.ldf'"

He did get a connection refused response in the output then and the command failed overall. My friend did the following then to address the issue:

1) In the 'SQL Server Configuration Manager' (via start menu), left click 'SQL Server 2005 Services', there should be a 'SQL Server (BWDATOOLSET)' running to the right.

2) Right click 'SQL Server (BWDATOOLSET)' and select 'Properties'

3) Instead of using the option 'Build-In Account', he selected a specific account via 'This Account:'. The account he  did specify now was named exactly after my XP user account and we even used the same password. Now we both do not know if the exact phrasing there is necessary or even recommended, but it helped me anyway in the end.

4) He did run the command line now again (the one stated above) and it did go through and created 'bw_dragonage_content.mdf' and 'bw_dragonage_content.ldf' in the directory 'C:\\\\Program Files\\\\DAODB'

5) Running the Toolset now worked without any further configuration.

I hope this helps some people at least and I am sorry with not being able to respond any questions further, as I could not explain a single bit sadly.

I checked the folder DAOB, and it already had those files. *bashes her head to the table few times in frustration*

[Ceneen]

Ubasti wrote...

I checked the folder DAOB, and it already had those files. *bashes her head to the table few times in frustration*

As far as I understood it, there were two problems on my PC:

1) Due to a faulty installation (even though the install went through flawlessly, aka no errors), the ToolSet couldn't connect to the database. I guess that is what those two files mdf and ldf are about?!?

2) The restoration process didn't work initially due to account restrictions and only did procede as soon as my friend changed the account who is allowed to access.

From what we read here and in the wiki, there are many different problems that could arise and would show in almost the same way (unable to connect). It took the better half of a day for us (or rather more for him) to get this going and hopefully it helps one or two others.

[Ubasti]

Yeah, I just hoped it would solve my problem. I've now gone through the whole troubleshooting phase explained in the wiki, and nothing helps. I've updated everything on my computer I can think of (or know how to update). I guess the last option is to uninstall the SQLServer and reinstall it manually.

Well, have to say that at least I've learned tons about Windows system while going through this.

Oh, one thing, I tried to do the backup restore thing, but I got this message in the log:

+=================================================================+
+=================================================================+
Backup Batch File initated on ti 12.01.2010 at  9:51:38,31
using the following config.ini settings:
         -------------------------------------------
         Backup/Restore Config file
         [SQL Server Name]
         .\\\\BWDATOOLSET
         [Database Name]
         bw_dragonage_content
         [Path to Directory to Save new Backup files to]
         c:\\\\Backups\\\\
         [Name of New Backup File]
         DABackup001.bak
         [Path to Directory Containing Existing Backup Files]
         c:\\\\Backups\\\\
         [Name of Existing Backup File to Restore]
         DABackup001.bak
         -------------------------------------------
 
Following command line being executed:
sqlcmd -S .\\\\BWDATOOLSET -E -Q "BACKUP DATABASE bw_dragonage_content TO DISK = 'c:\\\\Backups\\\\DABackup001.bak'"
 
Msg 927, Level 14, State 2, Server PELIXP\\\\BWDATOOLSET, Line 1
Database 'bw_dragonage_content' cannot be opened. It is in the middle of a restore.
Msg 3013, Level 16, State 1, Server PELIXP\\\\BWDATOOLSET, Line 1
BACKUP DATABASE is terminating abnormally.
 
Backup file will be found at: c:\\\\Backups\\\\DABackup001.bak
 
Batch File completed at  9:51:45,57
+=================================================================+
+=================================================================+
 
 
 
+=================================================================+
+=================================================================+
Restore Batch File initated on ti 12.01.2010 at  9:52:02,34
using the following config.ini settings:
         -------------------------------------------
         Backup/Restore Config file
         [SQL Server Name]
         .\\\\BWDATOOLSET
         [Database Name]
         bw_dragonage_content
         [Path to Directory to Save new Backup files to]
         c:\\\\Backups\\\\
         [Name of New Backup File]
         DABackup001.bak
         [Path to Directory Containing Existing Backup Files]
         c:\\\\Backups\\\\
         [Name of Existing Backup File to Restore]
         DABackup001.bak
         -------------------------------------------
 
The backup file c:\\\\Backups\\\\DABackup001.bak does not exist. Restore process aborted
 
Batch File completed at  9:52:08,37
+=================================================================+
+=================================================================+


So it didn't work either. And I just wonder what is that "middle of restore" that it claims the bw_dragonage_content is in?
 

Modifié par Ubasti, 12 janvier 2010 - 08:01 .