Tag Info

New answers tagged

1

Why is SQL Server on the same box? "Perform Volume Maintenance Tasks" should certainly be granted to the service account used to run SQL Server since that will allow SQL Server to not spend time unnecessarily zero-ing files during expansion of existing files and creation of new files. "Lock Pages in Memory" would be a good consideration if you want to ...


4

There are 2 ways you can go about this. You can either create a service account for the sql agent service and give that account permissions on the olap server, or you can create a sql agent proxy account. Personally I think the proxy account is the cleanest solution. To create a proxy account refer to this msdn article: Create a SQL Server Agent Proxy. ...


1

this was really nonsense. I right click on ssms and run as administrator, and added the permission there without a problem.


2

The settings that you are looking for are stored in msmdsrv.ini \Program Files\Microsoft SQL Server\MSAS12.MSSQLSERVER\OLAP\Config\msmdsrv.ini or <your Analysis service custom path>\OLAP\Config\msmdsrv.ini Note: Above path applies for Default installation. Its a good practice to create a backup of that file, if you are changing any config value.


1

Late yesterday (7/8/2015), the Microsoft SQL Server Engineering Team confirmed that the Analysis Services hotfixes were indeed missing from the release of this CU. They intend to fix this in CU2 for SQL Server 2014 SP1. More information in the update message on the bottom of their blog post: link to SQL Release Services blog entry


1

1.How they talk each other(the two Servers)? From the database engine perspective, both SSRS and SSAS are clients like any other application. These query data from SQL Server using SQL queries. Microsoft just chose to include these components with SQL Server licensing and media. 2.Where the cube for SSAS stored? On the server with SSAS installed ...



Top 50 recent answers are included