Quote:
|
Originally Posted by Will I think the basic problem comes down to the fact that I'm running MS SQL Server Express on my PC, but am trying to publish my website on a web host that has provided me with a MS SQL Server 2005 Database. |
SQL Server Express is a cut down version of SQL Server 2005 - it's the same database engine with a few limitations and fewer of the tools. The issue is how to get a copy of your local database on to the server, and ensuring that the web app that you say you've uploaded has appropriate permissions to access it.
When they say they provide you with MS SQL Server 2005, what they mean is that they're running it (the full version) on their server, and give you space there to set up your own databases.
Have they actually given you any tools to create and manage your databases, or do they expect you to have them yourself?