I'm still not sure where i went wrong the first time, but i finally got around to uninstalling every speck of SQL off my PC today. Now with a clean install, I proceeded to follow the instructions again and am happy to report that the Dragon Age Toolset is running on my computer once more! thank you for this walk-through <3
I'm glad you figured it out! Sorry I wasn't able to be more helpful before. SQL Server has a really complex installation, so partial installs and old installs can leave a really complex matrix of stuff to untangle.
"Uninstall everything that references SQL Server and try again" is a good troubleshooting step if everything is being weird.
holy s#*! you're actually a lifesaver. i'm like really dumb, so it took me like 5 hours but i did get it working eventually. your instructions were amazing!
(Windows 11, DAO UE via steam) I have tried this several times and the furthest I get is step 13, it fails and gives this message:
TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore of database 'bw_dragonage_content' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) ------------------------------ ADDITIONAL INFORMATION: Microsoft.Data.SqlClient.SqlError: File "bw_dragonage_content" cannot be restored over the existing "C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\bw_dragonage_content.mdf". Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files, or WITH MOVE to identify an alternate location. (Microsoft.SqlServer.Smo) For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=17.100.40.0&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Update: Ah, I needed to use the Option -> Replace during this step :)
I have been trying to get the toolset to work. Initially I was having issues with the toolset not seeing the database when setting it up (no drop down) even though I saw it in my sql database. I decided to reinstall everything and start from scratch but now I can't get the database into my sql. It keeps giving me an error when I try to restore the database. I am not sure what happened.
I think I have it working now. I had to overwrite a previous backup that was stored somewhere. I also must have missed the screen where I rename my server (I was getting slightly different options than the pictures.). Once I put in my SQL server name, it seems to have worked.
hi! sorry if its a dumb question. im kind of stuck at step 18, up until this point everything worked well but now i cant seem to have an option to select bw_dragonage_content databse from the dropdown list, and when i try to add it i get an error that says
[Microsoft OLE DB Driver fro SQL Server]: Login failed for user 'pc name'. [Microsoft OLE DB Driver fro SQL Server]: Cannot open database "bw_dragonage_content" requested by the login. The login failed.
maybe theres some little step that i somehow overlooked, or does it have something to do with admin rights on my pc? im just reaaally bad with all this pc stuff, so thank in advance for any advice ><
You're a life saver, oh my god. I was trying and trying to install the tool kit with no success since SQL 2005 isn't supported anymore on my system, thanks to you I finally got it working. I would endorse a million times if I could <333
Note to anyone reading the comments who had the same little hiccup I had: if SSMS gives you the error message "The certificate chain was issued by an authority that is not trusted" when you try to connect to server, you can easily get past this by clicking on the right most tab "Additional Connection Parameters" and copy/paste "Encrypt=false" into the box, then try connecting again. It worked for me (thank you, google!)
I'm sorry, I followed your tutorial in order to install the Toolset (10/10 tutorial by the way) but now I can't start a new game anymore... the game gets stuck on the "Loading..." while I can hear the intro video with Duncan's voice playing...
can anyone help? when i get to the server management step, it won't let me access the sql server
here is the error message A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
The certificate chain was issued by an authority that is not trusted
That's the clue. Click the "Options >>" button in the dialog and check the "Trust server certificate" box.
You'll have to do the same thing in the DA Toolset right before you click "Test Connection" -- there's another "Trust server certificate" checkbox you'll need to check.
54 comments
"Uninstall everything that references SQL Server and try again" is a good troubleshooting step if everything is being weird.
TITLE: Microsoft SQL Server Management Studio
Update: Ah, I needed to use the Option -> Replace during this step :)------------------------------
Restore of database 'bw_dragonage_content' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
------------------------------
ADDITIONAL INFORMATION:
Microsoft.Data.SqlClient.SqlError: File "bw_dragonage_content" cannot be restored over the existing "C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\bw_dragonage_content.mdf". Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files, or WITH MOVE to identify an alternate location. (Microsoft.SqlServer.Smo)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=17.100.40.0&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
[Microsoft OLE DB Driver fro SQL Server]: Login failed for user 'pc name'.
[Microsoft OLE DB Driver fro SQL Server]: Cannot open database "bw_dragonage_content" requested by the login.
The login failed.
maybe theres some little step that i somehow overlooked, or does it have something to do with admin rights on my pc? im just reaaally bad with all this pc stuff, so thank in advance for any advice ><
Note to anyone reading the comments who had the same little hiccup I had: if SSMS gives you the error message "The certificate chain was issued by an authority that is not trusted" when you try to connect to server, you can easily get past this by clicking on the right most tab "Additional Connection Parameters" and copy/paste "Encrypt=false" into the box, then try connecting again. It worked for me (thank you, google!)
here is the error message
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
That's the clue. Click the "Options >>" button in the dialog and check the "Trust server certificate" box.
You'll have to do the same thing in the DA Toolset right before you click "Test Connection" -- there's another "Trust server certificate" checkbox you'll need to check.