Hey Folks. Is it possible to login to SQL express on my Winhost site which I created using Webmatrix, and connect using Visual Studio? I can't get my SQL Management studio to work, and so I don'[t have time to keep playing with it. So, I thought I'd write a VB Frontend to a SQL Express db on the hosted site? Is that possible? I mean is it possible to connect to the SQL Express db which was created by Webmatrix and hosted by Winhost? What would I need? Just a connection string? I want to add a windows Frontend to my clients computer so that they can update this database from time to time.. I realize I can do it over the web, but I want to see how it works with VB, etc, and Windows and remotely.. Thanks so much.. Tim
SQL Express is not supported on our web servers. Please read our knowledge base article here: http://support.Winhost.com/KB/a622/do-you-support-ms-sql-express-databases.aspx You will have to upsize your SQL Express Database to SQL 2008 or SQL 2012 and change the web.config file connection string to point the SQL server. Then please our knowledge base article on how to transfer your local SQL database to our SQL database here: http://support.Winhost.com/KB/a1049/how-to-transfer-your-local-sql-database-to-Winhost.aspx
