Re: Unable to Locate Server

I'm not an ASP expert but it would appear that your ASP page thinks it is
trying to make a remote database connection while you think your database is
local. I would suggest you read up on connection strings and see if yours
needs to be changed to point to a local database. If you post your
connection string we may be able to determine if there's a problem with it.
Are you using the copy of SQL Express that came with Visual Studio or
another database?

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"onecorp" <onecorp@xxxxxxxxxxxxxxxx> wrote in message
news:507167C5-5C9D-4C18-8F49-510F66C346A0@xxxxxxxxxxxxxxxx
>I am a beginner to SQL..........I am trying to use the database quickstarts
> in the ASP.Net SDK 2.0 but have encountered the error listed below. (The
> quickstarts are being accessed off line having down loaded them from the
> Visual Studio disc / utilizing Windows XP Professional).
>
>
> The information I have read to date refers to accessing the server from a
> remote computer, however, I am trying to access it from a local machine
> only.
> Can anyone assist (in plain English for a beginner to understand) please ?
>
> Thanking you in anticipation.
>
> 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


.

Relevant Pages

  • Re: Connecting a remote workstation to a domain
    ... If you have more than a couple of remote workstations connecting to the SBS ... server via VPN, you really need to consider a Terminal Server in the main ... "Log in using a dial up connection" checkbox, ... roaming profile then synchronizes with the server over the VPN); ...
    (microsoft.public.windows.server.sbs)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: Problem with Web based client
    ... Seems like you are having problems accessing the web server on the PC you ... > My remote desktop connection works fine when I connect with a Remote ...
    (microsoft.public.windowsxp.work_remotely)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
Loading