How to run Powershell in Windows Task Scheduler

Action : C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
Add Arguments : -noprofile -executionpolicy RemoteSigned -file E:\CopyBakPS\Powershell.ps1

SSRS - Keep header in new pages

In report design mode, click on advanced mode which is down arrow on Column Group pane.

In the RowGroups section you will find "(static)" and "(Details)". In properties,
Keep With Group = After
Repeat On New Page =True

Go back to table, right-click on the row header, and go to tablix properties

Win 2012 IP Conflict - Power Management Setting on servers (Possible resolution)

We are having Ip Conflict issues with alwaysOn SQL servers.Below is alert message from SCOM.

Alert description: The system detected an address conflict for IP address XX.XX.XXX.XX with the system
having network hardware address 08-55-56-92-3P-FC. Network operations on this system may
be disrupted as a result

Comment

There is no duplicate ip address on ARP Table. Looks like a failover event if not clearing itself up and throwing this warning.

Issues

It took Cluster Failover manager offline and caused availability group error,

Possible Solution

http://www.theemailadmin.com/2013/12/troubleshooting-dag-failovers-random-drops/

NIC have setting “Allow the computer to turn off this device to save power” is set, unless somone has a good reason we would want a server NIC to sleep I would suggest this setting be cleared.

SSRS Unattended Execution account

Reporting Services provides a special account that is used for unattended report processing and for sending connection requests across the network. The account is used in the following ways:

·         Send connection requests over the network for reports that use database authentication, or connect to external report data sources that do not require or use authentication. For more information, see Specify Credential and Connection Information for Report Data Sources in SQL Server Books Online.

·         Retrieve external image files that are used in report. If you want to use an image file and the file cannot be accessed through Anonymous access, you can configure the unattended report processing account and grant the account permission to access the file.

http://msdn.microsoft.com/en-us/library/ms156302.aspx

Credentials are encrypted in rsreport config file.

Fix SSRS 2012 Reports were viewed Blank in Chrome and Safari

function pageLoad() { var element = document.getElementById("ctl31_ctl09"); if (element) { element.style.overflow = "visible"; } }

Append the above line in ReportingService.js file under this location

E:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportManager\js

Restart Reporting service

NOTE : ctl31_ctl09 is for SQL 2012. They are different in each version of SQL server.