Aller au contenu

Photo

Is it possible to run the toolset with a remote sql server


  • Veuillez vous connecter pour répondre
4 réponses à ce sujet

#1
Dweebster666

Dweebster666
  • Members
  • 1 messages
Hi

I'm not very keen on installing SQL server om my game computer as it destroyes the performance.

But I do have another SQL server 2008 that I have on a seperate server.

Does anyone know if the toolset will work with a remote server?

When I try it the connection test works fine but then the toolset will not work and gives the error "Unable to connect".

BTW how do you enable the debug logs (if there are any?) for the toolkit?

Thanks for the help!

#2
StickymaddnessZA

StickymaddnessZA
  • Members
  • 3 messages
1 month, no replies? Really? :(



I have the exact same problem. I don't want SQL running on my game pc either.



Connection test to my remote sql server works fine, but I get the same "Unable to connect" error on startup

#3
StickymaddnessZA

StickymaddnessZA
  • Members
  • 3 messages
Ok, got this sorted.



The error is because the database data doesn't exist, I thought the tool would of created it, but anyhow. Follow http://social.biowar...agonage_content to create the database with the default data, be sure to change your mdf and ldf paths as your box running SQL won't have the default path (program files\\dragon age\\)



Get the db restored, and you'll now be able to fire up the editor.

#4
JJM152

JJM152
  • Members
  • 301 messages
Have you tried changing the connection string?



Go into the DefaultSettings.xml file and modify this line:



<DefaultDatabaseConnection>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=bw_dragonage_content;Data Source=.\\SQLEXPRESS</DefaultDatabaseConnection>



Try something like, "Data Source=some.ip.address\\SQLEXPRESS" if that doesn't work, then you may have to change the security settings to add a user/password. The format for the connection string looks to be pretty standard, so you can probably just look up what you need from http://www.connectio...sql-server-2005



Good luck.

#5
StickymaddnessZA

StickymaddnessZA
  • Members
  • 3 messages
You probably didn't see my second comment, but I've got it working now. Thanks for trying to assist tho. :P