ok i found a possible solution (also selfnote to mysefl in the future  :):

I guess you have to create a cluster and then Disable AlwaysOn feature in SQLServer Configuration Manager...

• This reply was modified 4 years, 10 months ago by  oskargunn.

Just to inform you, I have found a probable cause and resolved the issue.

I think it had to do withe the connection from SqlServer to the failover cluster. When I...

Thanks for your suggestion.

I'll try to use filter and test performance.

Do you know how much impact on performance this has on the server to audit on public and then filter the result in the server audit ?

N.B. The group that has sysadmin rights is not present in the database.

At the moment I only remove oldest partition manually, so I know which partition to delete. As test case I want to have scripts ready if there comes a problem...

Ah I am realising now that sqlspackage creates all files according to Database default locations settings in the instance properties.
I think that is sufficient. I read somewhere that sqlpackage...

I wonder if it is because I issue a select in the procedure against the view that uses the fn_get_audit_file.  I tried it again, and I always get the permission...

Hi, thanks for your reply.

I tried this walkthrough but I still get:

Msg 297, Level 16, State 1, Procedure TestSP, Line 13
The user does not have...

Hi,

Is there any solution to this?
I want to push audit data into a third-party application that handles audit logs.
I create a sqlServer login and a view...

I do read msdb for the agent jobs, I keep a copy of jobs, to send alerts to nagios. The reason of keeping a copy of the jobs is the...

The primary site is running on Windows 2008 and the Mirror site is running on Windows 2012.

Could it be that that is an issue ?

This command: GRANT CONNECT ON ENDPOINT....

results in the following error: Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

Should I use a domain...

There should be an endpoint installed.

SELECT * FROM sys.tcp_endpoints where type_desc = 'DATABASE_MIRRORING'

This query returns this set:

nameendpoint_idprincipal_idprotocolprotocol_desctypetype_descstatestate_descis_admin_endpointportis_dynamic_portip_address

Mirroring655412622TCP4DATABASE_MIRRORING0STARTED050230NULL

SQLisAwE5OmE: Yes I began using only ip address and port number. Then I tried the FQDN to see if that was the problem.