I was trying to upload my site to my remote server with CrystalTech (host) but I get the following error:
Server Error in '/' Application.
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)
Description:
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
anyone help?
You will need to find a host that DOES offer Sql Server support. Or you can mess about converting the whole thing to run with MS Access, but that is a fair amount of work.
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.
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.
None
0 Points
45 Posts
Error after uploading Personal Site Starter Kit
Apr 15, 2007 09:00 PM|fsdama|LINK
Hi,
I was trying to upload my site to my remote server with CrystalTech (host) but I get the following error:
Server Error in '/' Application.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)
Description: 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 anyone help?
Thanks in advance.
All-Star
194857 Points
28100 Posts
Moderator
Re: Error after uploading Personal Site Starter Kit
Apr 16, 2007 04:17 AM|Mikesdotnetting|LINK
Participant
833 Points
227 Posts
Re: Error after uploading Personal Site Starter Kit
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.
Check out our tutorials for going live on GoDaddy
Member
51 Points
38 Posts
Re: Error after uploading Personal Site Starter Kit
Apr 17, 2007 03:34 PM|jeric2k5|LINK
Hey,
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.
~Eric