Aller au contenu

Photo

v1.01 - Unable To Connect To Database!


86 réponses à ce sujet

#51
pittlers

pittlers
  • Members
  • 29 messages

Malcroix wrote...

PROBLEM SOLVED.

I performed a manual database recovery and manually redirected the Toolset to see the new database. Here's the guide I used:

http://social.biowar...se_installation

This solution worked for me. Toolset launched!



  They removed the program from the site, and the workaround isn't applicable.  HOWEVER, I found a mirror at softpedia.com, and I am sure it can be found other places.  This is the only thing I have found that works to fix the problem.  Thanks!

#52
Neo_The_Hero

Neo_The_Hero
  • Members
  • 7 messages
Hi

I've just tried to install and open the toolset, but I also get the 'Unable to connect to the database' message !

I honestly thought they had provided us (A.K.A their customers) with a permanent fix for this issue by now.

Anyway, I have read through this thread as well as the Wiki, but as I don't have a degree in computer science I'm afraid the method described doesn't make much sense to me.

Bottom line: does there exist an easy fix for solving the problem or should I just hit 'Un-install" and forget all about it ?

EDIT:

My operating systems is Windows 7 Ultimate 64-bit

Modifié par Neo_The_Hero, 09 octobre 2010 - 11:22 .


#53
Neo_The_Hero

Neo_The_Hero
  • Members
  • 7 messages
Hi again

I'm still fighting this piece of crap toolset and haven't gotten any further Posted Image

However, I have discovered that i seem to miss to files:

bw_dragonage_content.ldf

and

bw_dragonage_content.mdf

So I'll guess this means that I have to do a manual database installation which I'll try.

As a side remark I would like to say that I really don't understand how BioWare can get away with this ill-treatment of their customers. I'm sure they violate at least one (and hopefully a lot more) act in the consumer legislation.

Maybe one with a lot of time (and money) should drag'em around the courthouse a few time - I would almost guarrantee that this would work wonders.

Anyway, I'll give it one more attempt and cross my fingers...

#54
ladydesire

ladydesire
  • Members
  • 1 928 messages
It wouldn't, since the error given is a rather generic one that could mean just about anything, which Bioware has actually said on a few occasions.

#55
Neo_The_Hero

Neo_The_Hero
  • Members
  • 7 messages

ladydesire wrote...

It wouldn't, since the error given is a rather generic one that could mean just about anything, which Bioware has actually said on a few occasions.


Well, that really helps building up of courage to try another time (I'm not flaming you - just trying to be funny !)

Reading through the flow chart in the Wiki it is the only thing i can think of trying right now as the missing files seemingly cannot be found on my harddrive.

Also, I cannot understand why BioWare don't provide us with a fix for these problems - one could get the impression that they simply don't care (I could be wrong on this one though...)

#56
Neo_The_Hero

Neo_The_Hero
  • Members
  • 7 messages
Hi

I've tried to install SQL Server Management Studio Express using the Wiki guide, but ran into a problem when I reached the part where I'm typing: SQLServer2005_SSMSEE.msi into the  Command Prompt, because when I hit Enter I get some sort of message saying that SQLServer2005_SSMSEE.msi is not a known program (or something like that).

I'm pretty sure that:

1. I ran the Command Prompt as administrator

2. I spelled SQLServer2005_SSMSEE.msi correctly (with capital letters where needed)

Any help will be much appriciated (that would include the BioWare guys !)

Modifié par Neo_The_Hero, 17 octobre 2010 - 03:06 .


#57
Davir

Davir
  • Members
  • 37 messages
Look here

1
http://boker.dk/ff1.png

2
http://boker.dk/ff2.png

3
http://boker.dk/ff3.png

4.
http://boker.dk/ff4.png

5
Be sure that the first line is where you install Dragon Age
when you did it so you can start creating your own module or mod
here
hope it can help someone here

Modifié par Davir, 17 octobre 2010 - 09:52 .


#58
Neo_The_Hero

Neo_The_Hero
  • Members
  • 7 messages
Thank you very much - I'll have a closer at it and give it a try

Well, I'll guess I'm just a tad too stupid, because I can seem get the picture you've shown on image ff2.png - how do I get the small "Select users or groups" to appear ?

(It is a real embarrassment for me !)

Anyway, thank you for helping me out - you're doing a great job.

EDIT:

I found the menu by clicking on Add - I'll guess I learnt something new there !

However, now my problem is that I don't know what to write in the form where you have wrote Lars - should I put my own name in there or is it something else ?

I'm sorry  for asking what might seem to be a stupid question, but I don't really know wtf I'm doing in those menus, so I just try to do it like you show me to do.

Modifié par Neo_The_Hero, 19 octobre 2010 - 08:25 .


#59
Davir

Davir
  • Members
  • 37 messages
No, you must provide your account name you login with your PC / Windows
Also your Administrator account

#60
Neo_The_Hero

Neo_The_Hero
  • Members
  • 7 messages

Davir wrote...

No, you must provide your account name you login with your PC / Windows
Also your Administrator account


Hi

Thank you for the clarification - I'm not sure whether or not I have such a name as I didn't pay much attention when a friend of mine helped with installing Win7 on my computer.

Anyway, I'll try a few names and if I come up empty then I'll call my buddy to see if he remembered what we did !

#61
pandamonium411

pandamonium411
  • Members
  • 5 messages
I'm having similar problems, but all the guides to get it working again are giving me issues. I downloaded Dragon Age via Steam, so several of my important files are in different locations. I also appear to be missing a lot of the folders/files that other users instruct you to go to (like DragonAge/tools--I have a Toolset folder, but there's no data or backup folder in it). If anyone has the patience to PM me or IM me, it'd be much appreciated. Otherwise I don't know if I'll ever be able to get it working until someone creates a patch or Bioware fixes it >.>

#62
DraculaCronqvist

DraculaCronqvist
  • Members
  • 4 messages
I tried everything that's on the wiki, still my toolset can not conect to the database...

This is just stupid. Seriously, how about making a toolset that's easy to install, without trying *hours* to get it to work, to no avail.

#63
RobinLongstride

RobinLongstride
  • Members
  • 1 messages
Well folks I finally got it to work after many many tries and analysis of the issue:

Here´s the thing: EA made an algorithm for the toolset installation that fails at some points and here they are:

First, if you have followed the issue at: http://social.biowar...to_the_database
maybe you have realized it doesn´t always works. Well, thing is they ARE right in the way they solve the problem, but have some key things missing.

The part where they tell you to make a "Full Manual Install" is the first thing to start with ´cause:

First
The SQL package they put on the toolset fails at some point (I guess with some troubles with MSXML6 or something). This issue is perhaps related to the SP3 version they use that presents conflicts with some PCs.

And Second (and the key thing of this story):
They missed the part of the algorithm that directs your computer to search on the database of YOUR SQL server, that is your PC ! So here is the trick:

First:
Uninstall everything: Toolset, SQL, SQL Studio AND those entries they tell you to erase at the end of http://social.biowar...to_the_database , "Other Miscellaneous Solutions", on the third suggestion.

Second:
Install Toolset WITHOUT SQL 2005, and WITHOUT database.

Third:
Go to http://www.microsoft...us/express.aspx and download SQL 2005. Install it. Well who could tell ! they don´t use SP3 in this file, good thing for us cause now there´s no trouble with MSXML6 protection again !

Fourth
Go to http://www.microsoft...press-down.aspx and download the friendly User Interface to handle SQL, the SQL Studio.

5th
Follow the steps suggested at http://social.biowar...to_the_database for a "Full Manual Install" so you can make the databases. Don´t forget that it saves it in C:\\\\\\\\Program Files *or Archivos de Programa for us spanish users*\\\\\\\\Microsoft SQL Server\\\\\\\\MSSQL.1\\\\\\\\MSSQL\\\\\\\\Data regardless of where you have your game or SQL 2005 installed, D:\\\\\\\\, F:\\\\\\\\ or whatever

6th
Well here´s the trick: You have to configure the server (your PC): open the SQL Studio but don´t do nothing. In the opening screen, where it asks for Server Name, Authentication, bla bla, it leaves you standing at Server Name, and shows you the name of your real server, your PC !
Hit Ctrl+C
That is, copy that name

7th
Open the Toolset Config and tell it you are going to set your server yourself (second screen for configuring the "Database"). That is, uncheck the default setting and hit the other one, and the [...]

8th
After you hit the [...] it thakes you to a dialog box where you can imput the name of your server on the 1st step. Stand in that line, erase that crap of .\\\\\\\\BWDATOOLwhatever. Hit Ctrl+V to paste the name of your PC as a SQL server.

9th
Hit the Try Conection button at the end of the Dialog. It should tell you It´s a success.

10th
Go to the next line (2. step of that dialog), the "Database on the Server" and open the options. That´s where your beloved bw_dragonage_content shold be. Select it.

11th
Say ok to everything and go out of the Config thingy.

12th
Go to the Registry and edit this path:
HKEY_LOCAL_MACHINE\\\\\\\\SOFTWARE\\\\\\\\BioWare\\\\\\\\Dragon Age\\\\\\\\Toolset\\\\\\\\Environment
and in this entry:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=bw_dragonage_content;Data Source=.\\\\\\\\BWDATOOLSET
change it where it says .\\\\\\\\BWDATOOLSET for your PC id (Ctrl+V again!)
then close the registry.

13th and after a long jorney :
Open the Toolset and ... Enjoy !

Modifié par RobinLongstride, 27 janvier 2011 - 07:05 .


#64
docfraiser

docfraiser
  • Members
  • 242 messages
okay I have a problem here...everytime I try to install a new data name it says the following:TITEL: Microsoft SQL Server Management Studio Express

------------------------------



Fehler bei Erstellen für Datenbank 'bw_dragonage_content'. (Microsoft.SqlServer.Express.Smo)



Hilfe erhalten Sie durch Klicken auf: http://go.microsoft....se&LinkId=20476



------------------------------

ZUSÄTZLICHE INFORMATIONEN:



Ausnahme beim Ausführen einer Transact-SQL-Anweisung oder eines Transact-SQL-Batches. (Microsoft.SqlServer.Express.ConnectionInfo)



------------------------------



CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Fehler: 262)



------------------------------

so what do I need to do right now??? thanks

#65
Marduksdragon

Marduksdragon
  • Members
  • 181 messages

RobinLongstride wrote...

Well folks I finally got it to work after many many tries and analysis of the issue:

Here´s the thing: EA made an algorithm for the toolset installation that fails at some points and here they are:

First, if you have followed the issue at: http://social.biowar...to_the_database
maybe you have realized it doesn´t always works. Well, thing is they ARE right in the way they solve the problem, but have some key things missing.

The part where they tell you to make a "Full Manual Install" is the first thing to start with ´cause:

First
The SQL package they put on the toolset fails at some point (I guess with some troubles with MSXML6 or something). This issue is perhaps related to the SP3 version they use that presents conflicts with some PCs.

And Second (and the key thing of this story):
They missed the part of the algorithm that directs your computer to search on the database of YOUR SQL server, that is your PC ! So here is the trick:

First:
Uninstall everything: Toolset, SQL, SQL Studio AND those entries they tell you to erase at the end of http://social.biowar...to_the_database , "Other Miscellaneous Solutions", on the third suggestion.

Second:
Install Toolset WITHOUT SQL 2005, and WITHOUT database.

Third:
Go to http://www.microsoft...us/express.aspx and download SQL 2005. Install it. Well who could tell ! they don´t use SP3 in this file, good thing for us cause now there´s no trouble with MSXML6 protection again !

Fourth
Go to http://www.microsoft...press-down.aspx and download the friendly User Interface to handle SQL, the SQL Studio.

5th
Follow the steps suggested at http://social.biowar...to_the_database for a "Full Manual Install" so you can make the databases. Don´t forget that it saves it in C:\\\\\\\\\\\\\\\\Program Files *or Archivos de Programa for us spanish users*\\\\\\\\\\\\\\\\Microsoft SQL Server\\\\\\\\\\\\\\\\MSSQL.1\\\\\\\\\\\\\\\\MSSQL\\\\\\\\\\\\\\\\Data regardless of where you have your game or SQL 2005 installed, D:\\\\\\\\\\\\\\\\, F:\\\\\\\\\\\\\\\\ or whatever

6th
Well here´s the trick: You have to configure the server (your PC): open the SQL Studio but don´t do nothing. In the opening screen, where it asks for Server Name, Authentication, bla bla, it leaves you standing at Server Name, and shows you the name of your real server, your PC !
Hit Ctrl+C
That is, copy that name

7th
Open the Toolset Config and tell it you are going to set your server yourself (second screen for configuring the "Database"). That is, uncheck the default setting and hit the other one, and the [...]

8th
After you hit the [...] it thakes you to a dialog box where you can imput the name of your server on the 1st step. Stand in that line, erase that crap of .\\\\\\\\\\\\\\\\BWDATOOLwhatever. Hit Ctrl+V to paste the name of your PC as a SQL server.

9th
Hit the Try Conection button at the end of the Dialog. It should tell you It´s a success.

10th
Go to the next line (2. step of that dialog), the "Database on the Server" and open the options. That´s where your beloved bw_dragonage_content shold be. Select it.

11th
Say ok to everything and go out of the Config thingy.

12th
Go to the Registry and edit this path:
HKEY_LOCAL_MACHINE\\\\\\\\\\\\\\\\SOFTWARE\\\\\\\\\\\\\\\\BioWare\\\\\\\\\\\\\\\\Dragon Age\\\\\\\\\\\\\\\\Toolset\\\\\\\\\\\\\\\\Environment
and in this entry:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=bw_dragonage_content;Data Source=.\\\\\\\\\\\\\\\\BWDATOOLSET
change it where it says .\\\\\\\\\\\\\\\\BWDATOOLSET for your PC id (Ctrl+V again!)
then close the registry.

13th and after a long jorney :
Open the Toolset and ... Enjoy !


This worked beautifully. Thank you so much.

#66
UvornKnejt

UvornKnejt
  • Members
  • 4 messages
This is all fine and great, but you would imagine that bioware would make a permanet solution to all of this after the game has been out for over a year? Why should I (the customer) spend hours figuring out these things in order to fix a crappy program, when I am in fact only trying to use the toolset to fix some of the bugs already in the game? I find it very frustrating that problems such as missing quest rewards persist after all this time? It shouldnt be that hard to patch? FFS mass effect wasn't this buggy? Why do we have to fiddle around with all this junk when playing on the PC?

#67
Marduksdragon

Marduksdragon
  • Members
  • 181 messages

UvornKnejt wrote...

This is all fine and great, but you would imagine that bioware would make a permanet solution to all of this after the game has been out for over a year? Why should I (the customer) spend hours figuring out these things in order to fix a crappy program, when I am in fact only trying to use the toolset to fix some of the bugs already in the game? I find it very frustrating that problems such as missing quest rewards persist after all this time? It shouldnt be that hard to patch? FFS mass effect wasn't this buggy? Why do we have to fiddle around with all this junk when playing on the PC?


You don't really have to fiddle with anything. Most of what is broken doesn't significantly impact gameplay-- it's just annoying. That's probably why it isn't patched. Well, that and the oncoming DA2.

Far as the toolset, the fix isn't all that long if you follow robin's instructions. Most of the time is really waiting for things to install and update, not actually running around making the programs see each other properly.

Personally I'm glad they even bother giving us a toolset, even if it's fiddly, because I like to tinker. They could just say "No." Ala Sten about the whole thing.

#68
SpiriT_Of_Jazz

SpiriT_Of_Jazz
  • Members
  • 14 messages
 This worked like a charm for the Unable to Connect to Database problem.
 Windows 7, 32bt.

http://social.biowar...er_Installation

#69
SpiriT_Of_Jazz

SpiriT_Of_Jazz
  • Members
  • 14 messages
Double post, sorry.

Modifié par SpiriT_Of_Jazz, 13 février 2011 - 05:23 .


#70
ladydesire

ladydesire
  • Members
  • 1 928 messages

UvornKnejt wrote...

This is all fine and great, but you would imagine that bioware would make a permanet solution to all of this after the game has been out for over a year? Why should I (the customer) spend hours figuring out these things in order to fix a crappy program, when I am in fact only trying to use the toolset to fix some of the bugs already in the game? I find it very frustrating that problems such as missing quest rewards persist after all this time? It shouldnt be that hard to patch? FFS mass effect wasn't this buggy? Why do we have to fiddle around with all this junk when playing on the PC?


Did you look in the Projects section here, or on DA Nexus, to see if anyone had already done some bug fixes like what you want to do?

#71
Miragem

Miragem
  • Members
  • 2 messages

RobinLongstride wrote...

Well folks I finally got it to work after many many tries and analysis of the issue:

Here´s the thing: EA made an algorithm for the toolset installation that fails at some points and here they are:

First, if you have followed the issue at: http://social.biowar...to_the_database
maybe you have realized it doesn´t always works. Well, thing is they ARE right in the way they solve the problem, but have some key things missing.

The part where they tell you to make a "Full Manual Install" is the first thing to start with ´cause:

First
The SQL package they put on the toolset fails at some point (I guess with some troubles with MSXML6 or something). This issue is perhaps related to the SP3 version they use that presents conflicts with some PCs.

And Second (and the key thing of this story):
They missed the part of the algorithm that directs your computer to search on the database of YOUR SQL server, that is your PC ! So here is the trick:

First:
Uninstall everything: Toolset, SQL, SQL Studio AND those entries they tell you to erase at the end of http://social.biowar...to_the_database , "Other Miscellaneous Solutions", on the third suggestion.

Second:
Install Toolset WITHOUT SQL 2005, and WITHOUT database.

Third:
Go to http://www.microsoft...us/express.aspx and download SQL 2005. Install it. Well who could tell ! they don´t use SP3 in this file, good thing for us cause now there´s no trouble with MSXML6 protection again !

Fourth
Go to http://www.microsoft...press-down.aspx and download the friendly User Interface to handle SQL, the SQL Studio.

5th
Follow the steps suggested at http://social.biowar...to_the_database for a "Full Manual Install" so you can make the databases. Don´t forget that it saves it in C:\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\Program Files *or Archivos de Programa for us spanish users*\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\Microsoft SQL Server\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\MSSQL.1\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\MSSQL\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\Data regardless of where you have your game or SQL 2005 installed, D:\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\, F:\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ or whatever

6th
Well here´s the trick: You have to configure the server (your PC): open the SQL Studio but don´t do nothing. In the opening screen, where it asks for Server Name, Authentication, bla bla, it leaves you standing at Server Name, and shows you the name of your real server, your PC !
Hit Ctrl+C
That is, copy that name

7th
Open the Toolset Config and tell it you are going to set your server yourself (second screen for configuring the "Database"). That is, uncheck the default setting and hit the other one, and the [...]

8th
After you hit the [...] it thakes you to a dialog box where you can imput the name of your server on the 1st step. Stand in that line, erase that crap of .\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\BWDATOOLwhatever. Hit Ctrl+V to paste the name of your PC as a SQL server.

9th
Hit the Try Conection button at the end of the Dialog. It should tell you It´s a success.

10th
Go to the next line (2. step of that dialog), the "Database on the Server" and open the options. That´s where your beloved bw_dragonage_content shold be. Select it.

11th
Say ok to everything and go out of the Config thingy.

12th
Go to the Registry and edit this path:
HKEY_LOCAL_MACHINE\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\SOFTWARE\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\BioWare\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\Dragon Age\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\Toolset\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\Environment
and in this entry:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=bw_dragonage_content;Data Source=.\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\BWDATOOLSET
change it where it says .\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\BWDATOOLSET for your PC id (Ctrl+V again!)
then close the registry.

13th and after a long jorney :
Open the Toolset and ... Enjoy !


I've followed to the best of my abilities but now I get the error: Location of the game build either not specified or the update program was never run to copy the build onto your computer. >_> Atleast it feels like I'm one step closer to getting this crackhead program to work... :bandit:


UPDATE

Twas a tiny tweak that needed a nudge. I got it working!!! Amen halleluja peanutbutter! Thank you for the solution!

Modifié par Miragem, 25 février 2011 - 10:20 .


#72
Franagocu2009

Franagocu2009
  • Members
  • 1 messages
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAARRRRRRRRRRRRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGGGGGGGGGGG, i hate the toolset

#73
LoveToFlyGuy

LoveToFlyGuy
  • Members
  • 5 messages
I know this is a fairly old thread, but I thought I would post *my* solution to the "*CAN* connect to database, but TS won't run" issue posted earlier (~1 year ago) by @LOST_PriNcEsS & @jpdipity.

For me the issue was related to processor affinity. I went from a (TS working) P4 with hyper-threading system to a PhenomIIx6 (hex-core, TS *not* working) system. When I manually limit processor affinity in task manager to core 0 & 1, it works perfectly - every time! I hope this helps!

#74
YellowWing

YellowWing
  • Members
  • 7 messages
Long live the Aurora Toolset i say ......gezzzz this toolset seems ito be a mess and the one NWN2 has was no picknick it dose`nt have a UNDO just keep`s pasteing pasteing to no end

#75
YellowWing

YellowWing
  • Members
  • 7 messages
a year as gone by and yet