Unable to Connect (BWDATOOLSET running)

#1
Guest_dewkl_*

Posté 07 mai 2010 - 09:24

Guests

I have SQL server (BWDATOOLSET) server running with the access set to "built in account: local system".

I noticed in toolset configuration manager it doesn't list at all, instead it says "S001372950BC4\\\\\\\\\\\\\\\\SQLEXPRESS" with the chosen database "bw_dragonage_content". It can't connect to this database when i try "test connection". [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.[/b]

Shouldn't the listed server say BWDATOOLSET there somewhere? Should I set the path myself? How do I find the path to the SQL Server (BWDATOOLSET)?

I've been following this: http://social.biowar...to_the_database
I'm at the point "Is the Toolset correctly pointing to database?" which I'm not sure about. I've attempted to set the correct registry value, but it doesn't seem to help.

Modifié par dewkl, 07 mai 2010 - 09:30 .

Retour en haut

#2
RecklezzRogue

Posté 08 mai 2010 - 02:57

Members
193 messages

take a look here (known issues)

http://social.biowar...hp/Known_issues

Retour en haut

#3
Guest_dewkl_*

Posté 08 mai 2010 - 03:08

Guests

It just redirects to the same page I've been using.

Retour en haut

#4
RecklezzRogue

Posté 08 mai 2010 - 04:25

Members
193 messages

o - there used to be a pointer to a registry fix which I needed to do to get my DB connected...guess it moved...

Retour en haut

#5
Guest_dewkl_*

Posté 08 mai 2010 - 11:59

Guests

I did the "Is the Toolset correctly pointing to database?"-part if that is what you are pointing to.

The problem is not that the toolset can't find the database (it might become a problem later), but that the configuration manager can't connect/find the database. Services.msc says that the database is running, but I can't find it through the config manager.

Modifié par dewkl, 09 mai 2010 - 12:00 .

Retour en haut

#6
Misara_DO

Posté 09 mai 2010 - 07:43

Members
1 messages

I had this issue aswell and the problem for me (looks like a hundred things give this same message) was that the database and the two folders that should contain it (tollssql and Data) were missing. Happened everytime I tried to reinstall the toolset, no clue why.

Check your Dagon Age folder for Dragon Age\\\\tools\\\\toolssql\\\\Data The database should be inside the last one, they are two bw_dragonage_content named files.

If they are not there try this:

Copied from www.giantbomb.com Dragon Age forums, solution posted by Althox.

Run the "cmd" and write:

-tips for dummies like me (Misara). It only worked at C:\\\\> so use cd\\\\ command to go back to the root of the drive. Using copy-paste worked, so no need to write it all. Copy the opening and closing " if doesn't work.

"C:\\Program Files\\Microsoft SQL Server\\90\\Tools\\Binn\\"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\\Dragon Age\\tools\\toolssql\\Data\\bw_dragonage_content.mdf', MOVE 'bw_dragonage_content_Log' TO 'C:\\Program Files\\Dragon Age\\tools\\toolssql\\Data\\bw_dragonage_content.ldf'"

Important: Change the path to Dragon Age directories with the path on your own computer and make sure to create any missing folders before writing that thing. I had to create \\toolssqls and \\Data inside my Dragon Age\\\\tools\\\\ directory first for this thing to work.

What this thing will do is extract the missing Database files and copy them into the folder where they should be. Once I did this, the toolset worked fine.

Hope this works for you too, I almost went crazy trying different things before finding this (and making it work >.< ).

Edit: All \\ were doubled into \\\\ (one bar into two) when posting this O.o Possibly they will reproduce even more after this editing so everytime you see a \\ bar or a lot of them in the command text (or everywhere else) it is just a single one!

Modifié par Misara_DO, 09 mai 2010 - 07:51 .

Retour en haut

#1 Guest_dewkl_* Posté 07 mai 2010 - 09:24

#2 RecklezzRogue Posté 08 mai 2010 - 02:57

#3 Guest_dewkl_* Posté 08 mai 2010 - 03:08

#4 RecklezzRogue Posté 08 mai 2010 - 04:25

#5 Guest_dewkl_* Posté 08 mai 2010 - 11:59

#6 Misara_DO Posté 09 mai 2010 - 07:43