hi , i am getting an error since i have a few databases offline

still lots of syntax errors

what about if you just remove the publication from the table select * from MSpublications , would that work too?

I checked the antivirus and it has no blocking for the port.

sorry, but i don't know what you mean with telneting...

did you ever solve that issue, i am having the same error

issue fixed , i needed to add the ip address to the relay.

what would be the user account that is the 'sender' ? the sql server agent login account? does it need a role?

thanks i will check that.

Oldest active transaction:

SPID (server process ID): 210

UID (user ID) : -1

Name ...

yes, this is a biztalk database and has a lot of uncommitted transactions. So that is the reason?

sorry but can you tell me the steps to register the dll?

I tried that copying the dll from the other instance that is working in the server and still the same error 🙁

yes it is the correct instance and the latest error log i have which is weird because as you say it doesn't have anything for today.

when i try to...

thanks, i just have lot of failed logins, last one being:

2010-09-22 08:25:00.46 Logon Error: 18456, Severity: 14, State: 8.

2010-09-22 08:25:00.46 Logon ...

i can't start the instance, i can't see the sql error log for the instance I can't start