Help : "error: 40 - Could not open a connection to SQL Server"

I'm using VS2005 and SQL2000. I created a database name "myDatabase" inSQL Server 2000 and built a website that connet to this database. WhenI'm running this website in VS2005 IDE (press F5 or Ctrl-F5),everything is OK. I publiced this site. When I connect to database onmy computer, everything is OK also, but when I connect to database onanother computer, an error occurred like this :
"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) (Microsoft SQL Server, Error: 2)"
Now, I don't know how to fix it. Pls help me as soon as possible.
Regards.
By default, SQL Server 2005 doesn't have TCP/IP connectivity enabled after installation. To enable TCP/IP connectivity, go to SQL Server Configuration Manager, select the Network Configuration Node, select TCP/IP and set it to Enabled. After enabling TCP/IP connectivity, you should be able to connect.|||

I'm getting the same error but when I try to access my SQL Database on my Web Hosts server. How do I enable TCP/IP on their server if I don't have access to it?

|||Is the username, password, database name, and address of the SQL server correct?

Help - Very Odd Restore Issues

All,
Sql 2000 sp3, Server 2000 sp4
I am trying to restore a db to my testing server. I can
successfully restore it to my development server. But when
I try to restore it to my test server I get the following
error:Server: Msg 3205, Level 16, State 2, Line 1
Too many backup devices specified for backup or restore;
only 64 are allowed.
Both servers are on the same service packs for windows and
sql. I use the same script, only chnging the drive
letters. Any ideas at all? The restore script is below:
restore database member from
disk = 'u:\member_data_1.bak',
disk = 'u:\member_data_2.bak',
disk = 'u:\member_data_3.bak'
with stats = 1,
move 'MemberData00_01' to 'f:\MemberData00_01.MDF',
move 'MemberData01_01' to 'g:\MemberData01_01.NDF',
move 'MemberData01_02' to 'h:\MemberData01_02.NDF',
move 'MemberData01_03' to 'i:\MemberData01_03.NDF',
move 'MemberData01_04' to 'j:\MemberData01_04.NDF',
move 'MemberData01_05' to 'f:\MemberData01_05.NDF',
move 'MemberData01_06' to 'g:\MemberData01_06.NDF',
move 'MemberData01_07' to 'h:\MemberData01_07.NDF',
move 'MemberData01_08' to 'i:\MemberData01_08.NDF',
move 'MemberIndex01_01' to 'j:\MemberIndex01_01.NDF',
move 'MemberIndex01_02' to 'f:\MemberIndex01_02.NDF',
move 'MemberIndex01_03' to 'g:\MemberIndex01_03.NDF',
move 'MemberIndex01_04' to 'h:\MemberIndex01_04.NDF',
move 'MemberData02_01' to 'i:\MemberData02_01.NDF',
move 'MemberData02_02' to 'j:\MemberData02_02.NDF',
move 'MemberData02_03' to 'f:\MemberData02_03.NDF',
move 'MemberData03_01' to 'g:\MemberData03_01.NDF',
move 'MemberData03_02' to 'h:\MemberData03_02.NDF',
move 'MemberData03_03' to 'i:\MemberData03_03.NDF',
move 'MemberData04_01' to 'j:\MemberData04_01.NDF',
move 'MemberData04_02' to 'f:\MemberData04_02.NDF',
move 'MemberData04_03' to 'g:\MemberData04_03.NDF',
move 'MemberIndex02_01' to 'h:\MemberIndex02_01.NDF',
move 'MemberIndex02_02' to 'i:\MemberIndex02_02.NDF',
move 'MemberIndex03_01' to 'j:\MemberIndex03_01.NDF',
move 'MemberIndex03_02' to 'f:\MemberIndex03_02.NDF',
move 'memberIndex04_01' to 'g:\MemberIndex04_01.NDF',
move 'MemberIndex04_02' to 'h:\MemberIndex04_02.NDF',
move 'MemberData05_01' to 'i:\MemberData05_01.NDF',
move 'MemberData05_02' to 'j:\MemberData05_02.NDF',
move 'Member_Log' to 'u:\Member_Log.LDF',
move 'member_1_Log' to 'u:\Member_Log2'
Thanks in advance,
Gary AbbottHi,
Did you tried RESTORE FILELISTONLY command to identify the Logical and
physical names as well
as try RESTORE VERIFYONLY command .
Syntax of both commands:
RESTORE FILELISTONLY FROM disk='c:\backup\dbname.bak'
RESTORE VERIFYONLY FROM disk='c:\backup\dbname.bak'
Thanks
Hari
MCDBA
"Gary Abbott" <anonymous@.discussions.microsoft.com> wrote in message
news:1120901c40f5c$29dd3fb0$a101280a@.phx
.gbl...
> All,
> Sql 2000 sp3, Server 2000 sp4
> I am trying to restore a db to my testing server. I can
> successfully restore it to my development server. But when
> I try to restore it to my test server I get the following
> error:Server: Msg 3205, Level 16, State 2, Line 1
> Too many backup devices specified for backup or restore;
> only 64 are allowed.
> Both servers are on the same service packs for windows and
> sql. I use the same script, only chnging the drive
> letters. Any ideas at all? The restore script is below:
> restore database member from
> disk = 'u:\member_data_1.bak',
> disk = 'u:\member_data_2.bak',
> disk = 'u:\member_data_3.bak'
> with stats = 1,
> move 'MemberData00_01' to 'f:\MemberData00_01.MDF',
> move 'MemberData01_01' to 'g:\MemberData01_01.NDF',
> move 'MemberData01_02' to 'h:\MemberData01_02.NDF',
> move 'MemberData01_03' to 'i:\MemberData01_03.NDF',
> move 'MemberData01_04' to 'j:\MemberData01_04.NDF',
> move 'MemberData01_05' to 'f:\MemberData01_05.NDF',
> move 'MemberData01_06' to 'g:\MemberData01_06.NDF',
> move 'MemberData01_07' to 'h:\MemberData01_07.NDF',
> move 'MemberData01_08' to 'i:\MemberData01_08.NDF',
> move 'MemberIndex01_01' to 'j:\MemberIndex01_01.NDF',
> move 'MemberIndex01_02' to 'f:\MemberIndex01_02.NDF',
> move 'MemberIndex01_03' to 'g:\MemberIndex01_03.NDF',
> move 'MemberIndex01_04' to 'h:\MemberIndex01_04.NDF',
> move 'MemberData02_01' to 'i:\MemberData02_01.NDF',
> move 'MemberData02_02' to 'j:\MemberData02_02.NDF',
> move 'MemberData02_03' to 'f:\MemberData02_03.NDF',
> move 'MemberData03_01' to 'g:\MemberData03_01.NDF',
> move 'MemberData03_02' to 'h:\MemberData03_02.NDF',
> move 'MemberData03_03' to 'i:\MemberData03_03.NDF',
> move 'MemberData04_01' to 'j:\MemberData04_01.NDF',
> move 'MemberData04_02' to 'f:\MemberData04_02.NDF',
> move 'MemberData04_03' to 'g:\MemberData04_03.NDF',
> move 'MemberIndex02_01' to 'h:\MemberIndex02_01.NDF',
> move 'MemberIndex02_02' to 'i:\MemberIndex02_02.NDF',
> move 'MemberIndex03_01' to 'j:\MemberIndex03_01.NDF',
> move 'MemberIndex03_02' to 'f:\MemberIndex03_02.NDF',
> move 'memberIndex04_01' to 'g:\MemberIndex04_01.NDF',
> move 'MemberIndex04_02' to 'h:\MemberIndex04_02.NDF',
> move 'MemberData05_01' to 'i:\MemberData05_01.NDF',
> move 'MemberData05_02' to 'j:\MemberData05_02.NDF',
> move 'Member_Log' to 'u:\Member_Log.LDF',
> move 'member_1_Log' to 'u:\Member_Log2'
> Thanks in advance,
> Gary Abbott
>|||I get the exact same error trying to run anyone of those
commands. I am now doing a new backup to only one backup
file. I'll try that.
Gary

>--Original Message--
>Hi,
>Did you tried RESTORE FILELISTONLY command to identify
the Logical and
>physical names as well
>as try RESTORE VERIFYONLY command .
>Syntax of both commands:
>
> RESTORE FILELISTONLY FROM
disk='c:\backup\dbname.bak'
> RESTORE VERIFYONLY FROM disk='c:\backup\dbname.bak'
>
>
>Thanks
>Hari
>MCDBA
>
>"Gary Abbott" <anonymous@.discussions.microsoft.com> wrote
in message
> news:1120901c40f5c$29dd3fb0$a101280a@.phx
.gbl...
when
following
and
>
>.
>