Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
guides:using_a_shared_database [2015/08/18 13:13]
127.0.0.1 external edit
guides:using_a_shared_database [2016/07/09 09:14] (current)
81.171.74.114 [MS SQL Server (By Bugmaniac)]
Line 70: Line 70:
  
 The first time you start ComicRack with these new settings ComicRack will create the structure in the database, copy all your local entries to the database (this can take some time) and delete your local database. The first time you start ComicRack with these new settings ComicRack will create the structure in the database, copy all your local entries to the database (this can take some time) and delete your local database.
 +
 +====  MS SQL Server (By Bugmaniac) ====  ​
 +
 +Log in to SQL Management Studio as your '​sa'​ user.
 +
 +Create a '​comicrack'​ logon.
 +
 +Give that logon the following roles: dbcreator,​public,​securityadmin,​serveradmin,​sysadmin (Probably overkill but thats how I got it working)
 +
 +Now log into management studio using the newly created '​comicrack'​ login.
 +
 +Create a new database called '​comicdb'​ (Its up to you where to store the db files but I suggest you don't put them on your system disk)
 +
 +Next up double click on the '​comicrack'​ login and select ​ 'User Mapping'​. make sure '​comicdb'​ is mapped (ticked) and has user '​comicrack'​ and Default Schema '​dbo'​
 +
 +Now edit the comicrack.ini file (Which in my case us here: "​c:​\Users\[YOUR_USER_NAME]\AppData\Roaming\cYo\ComicRack\"​
 +
 +Setup your data source as follows: (This example used SQLExpress but its the same for the full SQL Server)
 + 
 +DataSource=mssql:​Server=SERVER\SQLEXPRESS;​Database=comicDB;​Uid=comicrack;​Pwd=[COMICRACK_SQL_LOGIN_PASSWORD_HERE];​
 +
 +If your PC is called AWESOMENAMEFORAPC and your SQL Instance was installed as SQLROCKS then the string would look like this:
 +
 +DataSource=mssql:​Server=AWESOMENAMEFORAPC\SQLROCKS;​Database=comicDB;​Uid=comicrack;​Pwd=[COMICRACK_SQL_LOGIN_PASSWORD_HERE];​
 +
 +Save and exit comicrack.ini
 +
 +Now fireup Comic Rack and it will pause on the loading screen while it connects to SQL and created the db content.
 +
 +Once its done it will have imported all your info from the ComicDB.xml file into your nice ans shiny db!
 +
 +
 +
  

Navigation