MS SQL database for AsP website
Posted on 2012-03-22
I finally got MS Sql server Express running on my Windows 7 Pro 64bit machine after a bit of cajolling.
I'm new to this so bear with me. I have built a website before using MS Access, the Access database gets uploaded to the webserver to allow connections, how do i set an sql database up so it can be accessed by my web hosting server?
This is the first step of many i am sure so i want to get the theory right. obviously i don't want to upload the whole SQL server instance, just the database files, i guess, does this mean i install the new instance in the sql server folder on my C: drive and the data file in inetpub (to test)?
I'm using Dreamweaver to create the site, test it locally then upload to my web hosting service when it all works.
This is probably a very basic question as i can't find anything about it when i search on google, all comments seem to be about setting up the SQL server and instances, they then jump to connection strings nobody talks about how the 2 meet.