The Beer House

kooltech · May 8th, 2006, 07:55 PM

I have a managed server and shared SQL database. I also have Visual Studio 2005 and SQL Server 2005 and cannot get the connection stream to connect to the shared SQL database instead of the App_Data folder where the database is stored locally.

Can anyone point me in the right direction on how to solve this issue? And also to copy the database files to the remote database.

Thanks!
Keith

KoolTech

englere · May 8th, 2006, 10:31 PM

When you say "managed server", I assume you mean a commercial shared hosting account? The book has a chapter on deployment that covers that. You can't copy SQL files to a shared server, instead, you can use Sql Server Management Studio to copy the database contents.

Your connection string will have to point to the SQL Server you want to use. By default it's setup for App_Data.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to change the image of "The Beer House"?	dr_ran	ASP.NET 2.0 Basics	0	May 31st, 2008 10:48 AM
About User Profiles in the beer house	ssomchai	BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0	3	February 25th, 2008 11:28 PM
Beer House developer	plb	BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0	47	February 18th, 2008 02:11 PM
The Beer House Arabic Localization	nesrine	ASP.NET 2.0 Professional	1	February 21st, 2007 12:04 PM
Problem with forum of the beer house	kherrerab	BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0	2	August 31st, 2006 03:33 PM