Difference between revisions of "User:Allan Smith/sandbox"

From Dragon Age Toolset Wiki
Jump to: navigation, search
(cleaning out the sand)
 
Line 1: Line 1:
Note:If you were looking here for unable to connect issues, I have moved it all out of my sandbox into a real page located at [[Unable to connect to the database]]
 
  
Test edits for the configure toolset article
 
==Databases==
 
[[Image:databases window.png]]
 
 
'''Usage'''
 
 
This window is used to define the database instance that the toolset is connecting to.  This window can be used to:
 
*Connect the toolset to the proper location if for some reason it is pointing to the wrong location and is giving the [[Unable to connect to the database]] error.  If there is a valid instance of SQL server with a valid Dragon Age database in it, then you may be able to solve the problem by adjusting your configuration here.
 
*Switch between databases. If you have set up multiple instances of SQL Server or have multiple databases set up in an instance of SQL Server, you can use this utility to switch between them.
 
 
===Default Database Settings===
 
If you leave the "Use the default database" checkbox checked, the toolset will try to connect to the standard location.  If your toolset is currently able to connect to the database, and you are not trying to connect it to another database, just leave this checkbox checked.
 
 
===Custom Database Settings===
 
For advanced configuration, uncheck the "Use the default database" checkbox and then click on the ellipsis button ([[Image:ellipsis.png]]) to open the data link properties window.  The Data Link Properties window open.  This window can be used to connect to different Servers or instances and to different databases on a selected server.
 
 
[[Image:Data Link Properties Window.png]]
 
 
 
You should only need to make changes on the "Connection" tab, ''only make changes on the other tabs if you know what you are doing''.
 
 
1. Select or enter a server name:
 
 
::This field shows which database you are connecting to.  In a default installation, this should display .\BWDATOOLSET
 
::If you have done a manual installation of SQL Server, this value will likely need to be changed to .\SQLEXPRESS as that is the default on a manual installation.  The dropdown list does not always populate properly, so you may just need to type in the correct entry here.
 
 
2. Enter information to log on to the server:
 
 
::Unless you changed this option while installing SQL Server manually, this field should be left as is with the "Use Windows NT Integrated Security" selected.  This is the default setting when SQL is installed by the toolset, and also if you accept the defaults on a manual installation.
 
 
3. Select the database on the server
 
::Make sure  "Select the database on the server" is checked.  Select "bw_dragonage_content" from this list.
 
 
::''note:'' If you have created a different database, or restored your database to a different name, select or type it in this box.  If you have multiple databases set up on the server, this is how you switch which one the toolset is using.
 
 
When you have finished changes on this window, press the "Test Connection" button.  If you get the message "Test connection succeeded" then you should be good to carry on.  Hit all the remaining "OK" and "Finish" buttons and
 
you should be good to go!
 

Latest revision as of 22:09, 5 March 2010