Hi Justin, Thanks for reply.

I checked hash password on both the nodes, Both are same hash values. somewhere application not accepting connection in database server with listener name.

The same connection...

Please find the remarks

Does it happen with all connections?

1. it happens only web server applications (apache web server) , other interface and thick client continuously connecting.

Does SSMS connect ok.

2. Yes,...

In Error logs- there were multiple errors like for login filed messages and frequently recorded in error logs.

Error: 18456, Severity: 14, State: 8. -

Message

Login failed for user 'Login_name'. Reason: Password...

Hello Johan Thanks for reply .

Yes, I am using listener name for connecting applications.

Thank you for sharing reference link for monitoring failed login. I will try to capture it. My...

Thanks for your reply..

By mistakenly posted commends like  5 hours earlier. it seems  5 hours back time from server current time.

I think, database audit logs stored in audit file date...

Hi.

I understood your commends.

Database audit logs captured but I can see that event_time does not show the correct time. Actually it shows 5 hours earlier than time. is it logs...

Thank you..

CREATE DATABASE AUDIT SPECIFICATION [Audit1]

FOR SERVER AUDIT [audit_Logs]

ADD (DELETE ON DATABASE::[DBNAME] BY [public]),

ADD (EXECUTE ON DATABASE::[DBNAME] BY [public]),

ADD (INSERT ON DATABASE::[DBNAME] BY [public]),

ADD (DATABASE_OBJECT_CHANGE_GROUP),

ADD (SCHEMA_OBJECT_CHANGE_GROUP),

ADD (UPDATE ON DATABASE::[DBNAME] BY...

Thank you for you reply.

Reason behind is every night whole VM backup taken and backup completion time 2.5 Hours ,

during backup time AG got failover automatically to node2 due to...

Modified and mentioned my SQL Instance name where target database get inserted from values as below line,, but

Import-DbaCsv -path $targetFile -SqlInstance "DB_servername" -Database DB_Name -Table InventorySQLVersion -AutoCreateTable

below line not working.

$ActiveSQLInstances...

Hi Johan,

Thank you for sharing

I am new to PowerShell scripting , just copied executed in PowerShell ISE but nothing display the results. Please suggest me if something mention (input parameter...

Hi.

Thanks for posting PS script for fetching SQL version.

Invoke-Sqlcmd -ServerInstance "Servername" -Query "Select @@version as SQLVERSION"

I want to store output in sql server table like servername, version...

• This reply was modified 1 year, 8 months ago by  SQL Galaxy.

Thanks for sharing.

In Existing ALWAYSON AG setup, will it possible to configure Publisher role and Distributor role on same existing ALWAYSON AG ? or Does it require distributor role another separate ...

Fixed that issues after removed that subscriber hostname in publisher and maintained only AOAG listener only. tested failover AG setup and standalone publisher connected to subscriber through listener.

Thanks

Hi.

My requirement is don't want use SQL native replication method instead of using application s/w tool and GUI based for SQL server to SQL server data replication from different sites....

hi.

TB002 is Publisher and distributor role.

TB003 is subscriber role. and TBSQLT02 is AOAG listener name.

so AOAG in primary role in TB003 then replication publisher successfully connected to subscriber, if failover...