Guess the post above did not like the conn string example
I have some v5 sites that I need to upgrade to 6 but they have many modules and potential fail points so I want to try the upgrades on offline clones at first.
I am still on XP but have a nice PD utility call ProIIS that lets me run multiple local host sites easily.
http://jetstat.com/iisadmin/
OK - I have my site and its DB with a localhost alias. I create a new website and set up the permissions.
My problem is around the location of the DB. Online I run my DNN sites on a semi-dedicated server. The DB is on a different box.
My question is how do I attach the localhost DB and where do I put it?
On my other local host sites the DB is in the app data folder. I have tried putting the backed up DB in this folder and have messed around with connection strings but all I ever get is the DNN install page. I think this is probably just a connection string issue but I am unsure how to proceed.
There are quite few online guides to this but none seem to deal with the location / connection of the DB.
Example of the live site connection string
"SiteSqlServer" connectionString="Server=SERVERNAME;Database=DBName;uid=USERName;pwd=Password;" providerName="System.Data.SqlClient"
I really hope someone can point me in the right direction and that this post makes sense.
Thanks
Ian