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!
Is it possible to run the toolset with a remote sql server
Débuté par
Dweebster666
, nov. 07 2009 10:54
#1
Posté 07 novembre 2009 - 10:54
#2
Posté 28 décembre 2009 - 08:42
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
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
Posté 28 décembre 2009 - 09:04
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.
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
Posté 28 décembre 2009 - 09:07
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.
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
Posté 28 décembre 2009 - 09:10
You probably didn't see my second comment, but I've got it working now. Thanks for trying to assist tho.





Retour en haut






