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.
How on earth I would install DA Toolset without this guide? Thank you very much.
I want to give two tips for others:
1. DO NOT install the default option in Toolset - SQL 2005, instead as this guide says install SQL 2022. I had trouble with uninstalling SQL 2005.. 2. Double check everything and try to understand what you're doing.
At one point I forgot that I had choose the default option for the server name and I've tried to connect with non-existing one.. XD
During connecting with server I get this "Not trustworthy Certification authority" message" It say the connection is working but Certificate chain ist nit trustworthy. I do not now to handle that.
Beautiful — but why is it all shown in pictures? Were there no free screen recording programs available when this guide was released? No free video editing software? It's hard to believe a guide like this was published in 2022. The Stone Age is over.
Two reasons: 1. I'm a software engineer, not a content producer. 2. I hate videos.
I made this guide as a way to give the tiniest bit of something back to the modding community that's given me so much over so many years. I had seen some complaints about getting SQL Server and the toolkit up and running and knew this was something I could do to help others.
Nobody wants to listen to my goofy butt faff around on a video stream for 10 minutes and badly narrate software installation. Making this guide took me about an hour in capturing and annotating screenshots and writing everything up. It'd have taken me a whole lot longer than that to put together a terribad video that people would have suffered through.
I also greatly prefer reading and diagrams to video for the overwhelming majority of stuff I need to learn. That's my own preference, and it's not a value judgement against someone else who prefers their content in a different format. So if I create something, it's going to be in my preferred format.
I'm a bit of a curmudgeon like that. Get off my lawn. :-P
Nothing in my guide is proprietary or even particularly special. If someone wants to use it as the basis for creating a good video tutorial, be my guest.
God, i wish I could get this working like others :( But at the end when I try to open my toolset and keep getting a "Unable to initialize the graphics engines" error. Does anyone know what to do? I can't find anyone else who ahs mentioned this error
Edit: omg I'm a fool... For some reason the toolset defaulted to a non existing game path (Fixed by manually finding the right one in the ConfigureToolset
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 ><
59 comments
"Uninstall everything that references SQL Server and try again" is a good troubleshooting step if everything is being weird.
I want to give two tips for others:
1. DO NOT install the default option in Toolset - SQL 2005, instead as this guide says install SQL 2022. I had trouble with uninstalling SQL 2005..
2. Double check everything and try to understand what you're doing.
At one point I forgot that I had choose the default option for the server name and I've tried to connect with non-existing one.. XD
It say the connection is working but Certificate chain ist nit trustworthy.
I do not now to handle that.
It's hard to believe a guide like this was published in 2022.
The Stone Age is over.
1. I'm a software engineer, not a content producer.
2. I hate videos.
I made this guide as a way to give the tiniest bit of something back to the modding community that's given me so much over so many years. I had seen some complaints about getting SQL Server and the toolkit up and running and knew this was something I could do to help others.
Nobody wants to listen to my goofy butt faff around on a video stream for 10 minutes and badly narrate software installation. Making this guide took me about an hour in capturing and annotating screenshots and writing everything up. It'd have taken me a whole lot longer than that to put together a terribad video that people would have suffered through.
I also greatly prefer reading and diagrams to video for the overwhelming majority of stuff I need to learn. That's my own preference, and it's not a value judgement against someone else who prefers their content in a different format. So if I create something, it's going to be in my preferred format.
I'm a bit of a curmudgeon like that. Get off my lawn. :-P
Nothing in my guide is proprietary or even particularly special. If someone wants to use it as the basis for creating a good video tutorial, be my guest.
Edit: omg I'm a fool... For some reason the toolset defaulted to a non existing game path (Fixed by manually finding the right one in the ConfigureToolset
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 ><