Hello,

It would help us if you could provide a create table and some example data as detailed here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

With this we know we are using the same data types as...

If further assistance would be useful then can you provide some sample data? I'm not sure of the data that's kept in each table.

• This reply was modified 6 years, 1 months ago by as_1234. Reason: Rephrased reply

I think this might be a network routing issue rather than SQL. Can you ping or traceroute the server from the local desktop or laptop?

Thank you for your help.

All,

Thanks for your help.

Both,

Thank you for your help.

Jonathan: Thanks, I hadn't realised it had rounded to an int. Am I correct in thinking that AVG will return an int if it receives an...

Alejandro Santana,

Thanks for the update.

SPN's is outside of my knowledge unfortunately. The information here might help you https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability?view=sql-server-ver15

Where did you find the error message?

Thanks. The screenshot says that it failed during the post login stage so I think the connection attempt started. Is there anything in the Windows Event Log?

I don't know exactly...

Sorry I don't know the cause of this at the moment. Is there anything in the SQL server logs at the time of the failed connection?

I am just looking at the 1st point in your original post again. I think there should be four possible combinations?:

1. AD account connecting to the listener
2. AD account connecting...

When you change between an AD account and a local SQL instance are you using the same Windows login on the same machine? I'm guessing you already checked but I...

I don't think Glen_A will be able to enable readable secondary as they are using Standard Edition?

As an addition to Jonas' idea perhaps the reply needs to come from an account that has existed for a certain length of time and/or has a certain number of...

Sqltester1: Jeff Moden is correct. Sorry I didn't think of the possibility of using the ID column. Perhaps let us know if you are able to pivot the data in...