PDA

View Full Version : Is possible to use the standard SQL Server 2005 Express that comes with the Classified Starter Kit?

TonyP
10-03-2006, 01:21 AM
Since I am just starting out, I am not really that interested in trying to use SQL Server 2005 yet. If so, why do I keep getting this error?

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 copied everything over from my local machine.
wisemx
10-03-2006, 01:44 AM
If you don't have a DB server account you have the option to use XML or Access for your data on-line.

(You don't actually need Access, you can create an Access DB in code.)
TonyP
10-03-2006, 02:23 AM
I already purchased a SQL Server 2005server account, but do you have to have a server account in order to use the basic SQL Express that comes with the classified starter kit?
wisemx
10-03-2006, 02:45 AM
You should be all set, your express product can connect to your DASP remote DB.
TonyP
10-03-2006, 04:46 AM
Ok, I got the front of the site working now, but I still get the following error whenever I try to login:


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)
bruce
10-03-2006, 06:09 AM
this error means that your application is trying to connect to a SQL Express DB.


See http://community.discountasp.net/default.aspx?f=25&m=10797on how to install the Classified Starter Kit.


Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)
TonyP
10-03-2006, 06:40 AM
Hello Bruce,

I already looked at that thread. Are you saying you can't use SQL Express DB? I already attached the mdf file.
joelnet
10-03-2006, 08:47 AM
This is correct. SQL Express is not made for a shared hosting environment, you will not be able to use SQL Express.


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET