Last post Apr 17, 2007 03:34 PM by jeric2k5
Apr 15, 2007 09:00 PM|fsdama|LINK
I was trying to upload my site to my remote server with CrystalTech (host) but I get the following error:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I read somewhere on CrystalTech's forums that they do not support .mdf files. But there is a needed ASPNETDB.MDF file for storing usernames, passwords, etc.. The database has to be converted to a SQL SERVER file, but dont know how or what else to do. Can
Thanks in advance.
Apr 16, 2007 04:17 AM|Mikesdotnetting|LINK
Apr 16, 2007 11:21 AM|SalmonTraining|LINK
CrystalTech offers SQL Server on all but the cheapest of its ASP.NET 2.0 hosting plans.
The first thing you need to do is use the control panel to create a new SQL Server database. That's the simple part - the next steps are to install the security tables and code into that database, and then add the database part of the Personal Starter Kit.
If you look at the CrystalTech forums, you'll see a few other people have gone through the process.
Apr 17, 2007 03:34 PM|jeric2k5|LINK
I received the same error message you have encountered when I was going through the process of deploying the starter kit to a Godaddy hosting account but I cannot remember how I fixed it because I'm currently not at home BUT I can help you with the SQL server
file. Well if you have to create a SQL server file all you have to do is follow this link,
http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx. To summarize it though you need to download a program that can simply convert the databases into SQL documents then you can copy
and past the code into a Query box when you manage your databases through your hoster. Afterwards you need to modify the connection strings in your web.config file so that it points to the hoster's database. All of this information is within the link and if
you need anymore assistance I'm here to help because I have already completed this frustrating deployment process. Good luck :-D.