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

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.

 

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.)

 

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?

 

You should be all set, your express product can connect to your DASP remote DB.

 

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)

 

Hello Bruce,

I already looked at that thread. Are you saying you can't use SQL Express DB? I already attached the mdf file.

 

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