hi guys,

i think i know the anser to this already but dont want to have to face up to it

i am using Visual Studio 2005 with its built in SQL server.
i have copied my website over to the server and am now getting an error of:


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)

Source Error:


i think this is because there is no sql server on the server.
do i need to install sql express on the server to get access to the databases i have created in VS2005???

or should the aspx files i have created be able to access the MDF files??

try using the exact SQL Server Instance like

ABC\SQL2005