Upgrade Problem With Security Logins

Using a backup and recovery method i have moved databases from sql server 2000 to sql server 2005.
I have found orphand users for each database after moving
Found orphand users from the statement below
use databasename
fo exec sp_change_users_login 'Report'

to fix i did the following
EXEC sp_change_users_login 'Auto_Fix','Mary',NULL,'Password'
go
exec sp_changedbowner 'sa','dbo'
go

then set db chaining to true
exec sp_dboption 'databasename','db chaining','true'


Now in the management studio i login with sql server authentication using username and password.i get the error mentioned below.
But using 2005 management studio i login with sql authentication to 2000 database it works fine.
Why is this error??

How to i test id all my logins are working fine.


TITLE: Connect to Server
------------------------------

Cannot connect to SQL-CENTRALInstanceSQL2005.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

please let me know