error:40 connecting with sql server 2000

Hi
I am getting this really annoying error that I cant resolve.
I have created a website that accesses a SQL SERVER 2000 database and
it works perfectly on my home machine. The error has occurred when I
have transferred it to my hosts server.
This is the 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: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)
This is my connection string:
<add key="ConnectionString" value="Provider=sqloledb;Data
Source=hostsserver****,1433;Initial
Catalog=db******;User Id=dbo*******;Password=********; "/>
It says I am trying to connect to a SQL SERVER 2000 database as this is
what I devloped the site on so I do not know why it thinks I am trying
to connect to SQL SERVER 2005.
Can anyone help?Is your host database server and your home database server the same? It looks
like that your host database server is in SQL Server 2005.
By the way do you use outside host provider? If yes, you might want to
consider giving them an e-mail. Looking at the connection string, I don't see
any problem:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;UserId=Your_Username;Password=Your_Password;" .
So I am thinking that the host database server might be on different port
number than 1433 or use a named instance?
Lucas
"chrisbarber1@.gmail.com" wrote:
> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the 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: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>|||Thanks for your reply.
> Is your host database server and your home database server the same?
Yes both are on sql server 2000
> By the way do you use outside host provider? If yes, you might want to
> consider giving them an e-mail.
The host providor has been absolutely hopeless.
> So I am thinking that the host database server might be on different port
> number than 1433 or use a named instance?
I'll look in to this although on the hosts control panel definately
says 1433.
Any other ideas?|||<chrisbarber1@.gmail.com> wrote in message
news:1149755323.823279.142210@.u72g2000cwu.googlegroups.com...
> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the 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: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
It really sounds like the ISP is full of it and somehow your site is trying
to connect to a 2005 server with remote connections turned off.
> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>|||Check the value of instance config parameter: "remote access" and see
whether it is enabled..
> sp_configure 'remote access'
Jayesh
<chrisbarber1@.gmail.com> wrote in message
news:1149755323.823279.142210@.u72g2000cwu.googlegroups.com...
> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the 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: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>