So I have run a trace but it doesn't tell me anything.....it doesn't tell me what client it is coming from or anything.

It is a sql login, and I can only assume the application has the incorrect password hard coded in somewhere, but I am not sure where.

My main concern is...

Thanks for the replys.

We have implemented Always on, so my answers are based on my experience.

Always On - SQL Server 2012 Enterprise edition -

1- Does Requires to pay for an extra license...

Thanks for the responses, I was not expecting it to be easy but to make it worse, the connection between the two systems is over a microwave link... :w00t:

Resolved..

ALTER AVAILABILITY GROUP [Microsoft SQL Server (CLIENT-AGL-SOSS)] needed [ ]

Resolved..

ALTER AVAILABILITY GROUP [Microsoft SQL Server (CLIENT-AGL-SOSS)] needed [ ]

Please excuse my newbie question....

ALTER AVAILABILITY GROUP N'Microsoft SQL Server (CLIENT-AGL-SOSS)' RESTART LISTENER 'RHSPSQLOC00-001'

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'Microsoft SQL Server (CLIENT-AGL-SOSS)'.

How would I...

Thank you for the reply !!

Sorry but a Cr@ppy question with a bad answer...

Depending on version and database will depend on the result you will get....

For all those who offered advice, thank you. The problem was not SQL or the alias or even setting up the alias, it was the Windows Server itself.

Fortunately it was...

MikaS (7/26/2014)

I think there might be something wrong with the alias you're creating. In the Add Network Library Configuration page check the following:

Server alias: This is the alias name to...

Hi,

I have tried host name, ip I have copied the connection from a working SSMS connection and still the same network error !!

The protocol is set to TCP/IP and I have tried using the 32 and 64bit app.

Still get the following:

TITLE: Connect to Server

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

Cannot connect to fred.

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

ADDITIONAL INFORMATION:

A network-related or instance-specific error...