I red your stairway series 6..

There are two node FCI configured as below

Server Instance Node 1

Role - Primary

Availability Mode - synchronize

Failover Mode - Automatic

Connection in Primary Role - Allow...

Hi Perry Thanks for reply..

I studied some document internet both IPs are not be same.

1. Cluster IP unique IP - 10.xx.xxx.22

2. AG Listener unique IP - 10.xx.xxx.23

I Configured above...

I want to know, does cluster IP and Listener IP both are same? or should be entered different IP on both side in alwayson AG configuration?

thanks

Hello Mr. Perry..

What I am asking,

1. I should enter the unique IP address in access point administration portion while creating cluster group.

Application connection string which IP address to be...

Thanks for your replay..

I am not a developer. but I will try my best.

Could you give me any example for how will change existing nested cursor to set based...

Thanks Perrry for your replay...

Can always On setup by using standalone SQL instance with local HD, In this scenario, Does it require to meets pre -requisites on both the nodes?...

1. We are not using shared storage for current setup of always On availability group due to budgets constraints.. can be able to configure without SAN shard storage?

2. My requirement...

Thank you Mr. Perry for your wonderful article.. I will ask question if any doubts...

Hi

Today user reported to me, there is summary report not generated and application side throwing deadlock victim error by using as below view in application side..

So I have...

Hi.. I am really sorry for late updating due to some another migration task.

Please find the attached these procedures definition which are raised deadlock.

Thanks for your valuable suggestion.

Hi,

Thanks to all for yours valuable points.

1. I have taken backup of that CSV_Details tables before doing delete operation

2. In First query got deleted total 676839 row(s) affected and took...

Identified that root cause issues, error log file not expanding in ssms due to SQL Native client 11.0 - client protocols - shared memory disabled, It is opened in ssms...

Error log file opened out side of ssms as below location. But not opening at SSMS and there is no error message in event viewer at application side.

2015-05-19 18:23:45.61 Server...

yes. this only just started happening then after sometime error message display.

Thank you inputs from Experts..

As per Error messages

Message

Error: 18470, Severity: 14, State: 1.

Message

Login failed for user 'sa'. Reason: The account is disabled. [CLIENT: <local machine>]

sa account has been...