Jeff gave a nice option but ill give another thought

right click database, select Backup, select backup type and try...

32000

have you tried using ip and sql authentication from local system whether it is connecting or not.

There is no large imports and the data from this we are taking it to a tempory table and then we are processing it for our use.

any other guess before...

As said by above users in 32 bit editions do you have /PAE /3GB in boot.ini file and "Lock pages in memory" should be given access for SQL server service...

what do you mean by "cannot connect"?

Is it on different domain or something else?

Is that 2005 box using an alias user to take backup?

Other than Kerberos no other way for windows authentication?

On source it is possible but i fear not possible in target server as it will be restoration mode.

why does he want that?

if i run a query on SSMS using linked server with my windows login.

i got this error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'"

yes

NO

What happens if you use...

not working

my id is sysadmin on both servers, i get same error

but the service id which is mapped on sql services is working am i missing something.

we have two accounts one that is running sql agent and the one i am trying

when i execute it using the first one looks fine

the second one i have updated...

Try these

1. using the sql server port number

2. using the sql server ip address , if this resolves the issue the server might have improper name change , i...

if it is temp db space issues why are you worrying about other stuff.

can you post the complete errror and tempdb size and drive details with free space).