Wow, I never thought of trying sqlcmd.

Strangely enough, I can connect to sa using sqlcmd

Is it possible that registry entries could cause this? Or would reinstalling SSMS fix this? I don't want to try to many things as this is a live environment

Is there anyone with any more ideas/suggestions? Or anyone who has experienced this before?

Regards

Yes

Yes

Yes and

No, character sets are same on both servers

I have also tried a incorrect password on the 2nd server and it threw out the same error in the alert log.

SSMS

These timezones really suck. Any one awake that have suggestions?

Hi Johan,

Yes, But, both the sa and my test account are enabled and I can connect to both from another server.

Here is the SQL error log details:

Login failed for user...

Here is the detailed error: - Strange though as in the sql server error log it shows state 8

===================================

Cannot connect to primepims.

===================================

Login failed for user 'sa'. (.Net SqlClient Data Provider)

------------------------------

For...

I have mixed authentication enabled

I think this is SQL Authentication related. I just created a new login with sql authentication. I can't connect with this from the local server however I can remotely

Asked the networkd guys to check the dns as well, doesn't seem to be at fault.

What is strange is that when I log on this server and try to connect...

No, I checked this by creating a new login with same password and that worked.

Thanks Chris!!

I will have a look at that

Not sure my replies are going through. The column issue has been resolved.

Getting the following errors:

OLE DB provider "SQLNCLI10" for linked server "23.23.209.111" returned message "Protocol error in TDS stream".

OLE...

The copy database was a bit older and didn't contain that column. I created a new test db and restored this mornings backup.

Ran the query, but it errors out with...