Skip to content

Commit 38ab7ed

Browse files
v-thepetv-thepet
committed
move db-engine 1
1 parent ff6cd88 commit 38ab7ed

658 files changed

Lines changed: 7088 additions & 7088 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎docs/2014/analysis-services/instances/configure-analysis-services-for-kerberos-constrained-delegation.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -82,7 +82,7 @@ manager: "mblythe"
8282

8383
4. On the Select Users or Computer page, enter the account used to run the SQL Server instance providing data to Analysis Services tabular model databases. Click **OK** to accept the service account.
8484

85-
If you cannot select the account you want, verify that SQL Server is running and has an SPN registered for that account. For more information about SPNs for the database engine, see [Register a Service Principal Name for Kerberos Connections](../../database-engine/register-a-service-principal-name-for-kerberos-connections.md).
85+
If you cannot select the account you want, verify that SQL Server is running and has an SPN registered for that account. For more information about SPNs for the database engine, see [Register a Service Principal Name for Kerberos Connections](../../database-engine/configure-windows/register-a-service-principal-name-for-kerberos-connections.md).
8686

8787
![SSAS_Kerberos_3_SelectUsers](../media/ssas-kerberos-3-selectusers.gif "SSAS_Kerberos_3_SelectUsers")
8888

‎docs/2014/analysis-services/instances/configure-service-accounts-analysis-services.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -21,7 +21,7 @@ ms.author: "owend"
2121
manager: "mblythe"
2222
---
2323
# Configure Service Accounts (Analysis Services)
24-
Product-wide account provisioning is documented in [Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows-service-accounts-and-permissions.md), a topic that provides comprehensive service account information for all [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] services, including [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)]. Refer to it to learn about valid account types, Windows privileges assigned by setup, file system permissions, registry permissions, and more.
24+
Product-wide account provisioning is documented in [Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows/configure-windows-service-accounts-and-permissions.md), a topic that provides comprehensive service account information for all [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] services, including [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)]. Refer to it to learn about valid account types, Windows privileges assigned by setup, file system permissions, registry permissions, and more.
2525

2626
This topic provides supplemental information for [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)], including additional permissions necessary for tabular and clustered installations. It also covers permissions needed to support server operations. For example, you can configure processing and query operations to execute under the service account ─ in which case you will need to grant additional permissions to get this to work.
2727

@@ -94,7 +94,7 @@ manager: "mblythe"
9494
## <a name="bkmk_FilePermissions"></a> File System Permissions assigned to the Analysis Services service account
9595

9696
> [!NOTE]
97-
> See [Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows-service-accounts-and-permissions.md) for a list of permissions associated with each program folder.
97+
> See [Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows/configure-windows-service-accounts-and-permissions.md) for a list of permissions associated with each program folder.
9898
>
9999
> See [Configure HTTP Access to Analysis Services on Internet Information Services &#40;IIS&#41; 8.0](configure-http-access-to-analysis-services-on-iis-8-0.md) for file permission information related to IIS configuration and [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)].
100100
@@ -147,7 +147,7 @@ manager: "mblythe"
147147
|Write to a query log table in a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] relational database|Create a database login for the service account and assign write permissions on the query log table|You can enable query logging to collect usage data in a database table for subsequent analysis. The [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] service account must have write permissions to the query log table in the designated [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] database. If this table does not already exist and needs to be created, the [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] logon account must also have create table permissions within the designated [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] database. For more information, see [Improve SQL Server Analysis Services Performance with the Usage Based Optimization Wizard (Blog)](http://www.mssqltips.com/sqlservertip/2876/improve-sql-server-analysis-services-performance-with-the-usage-based-optimization-wizard/) and [Query Logging in Analysis Services (Blog)](http://weblogs.asp.net/miked/archive/2013/07/31/query-logging-in-analysis-services.aspx).|
148148

149149
## See Also
150-
[Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows-service-accounts-and-permissions.md)
150+
[Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows/configure-windows-service-accounts-and-permissions.md)
151151
[SQL Server Service Account and Per-Service SID (Blog)](http://www.travisgan.com/2013/06/sql-server-service-account-and-per.html)
152152
[SQL Server uses a service SID to provide service isolation (KB Article)](http://support.microsoft.com/kb/2620201)
153153
[Access Token (MSDN)](http://msdn.microsoft.com/library/windows/desktop/aa374909\(v=vs.85\).aspx)

‎docs/2014/analysis-services/instances/configure-the-windows-firewall-to-allow-analysis-services-access.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -230,8 +230,8 @@ manager: "mblythe"
230230
If you are using SharePoint 2010, you do not need to open ports in Windows Firewall. SharePoint opens the ports that it requires, and add-ins such as PowerPivot for SharePoint operate within the SharePoint environment. In a PowerPivot for SharePoint 2010 installation, the PowerPivot System Service has exclusive use of the local SQL Server Analysis Services (PowerPivot) service instance that is installed with it on the same computer. It uses local connections, not network connections, to access the local Analysis Services engine service that loads, queries, and processes PowerPivot data on the SharePoint server. To request PowerPivot data from client applications, requests are routed through ports that are opened by SharePoint Setup (specifically, inbound rules are defined to allow access to SharePoint – 80, SharePoint Central Administration v4, SharePoint Web Services, and SPUserCodeV4). Because PowerPivot web services run within a SharePoint farm, the SharePoint firewall rules are sufficient for remote access to PowerPivot data in a SharePoint farm.
231231
232232
## See Also
233-
[SQL Server Browser Service &#40;Database Engine and SSAS&#41;](../../database-engine/sql-server-browser-service-database-engine-and-ssas.md)
234-
[Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service](../../database-engine/start-stop-pause-resume-restart-sql-server-services.md)
235-
[Configure a Windows Firewall for Database Engine Access](../../database-engine/configure-a-windows-firewall-for-database-engine-access.md)
233+
[SQL Server Browser Service &#40;Database Engine and SSAS&#41;](../../database-engine/configure-windows/sql-server-browser-service-database-engine-and-ssas.md)
234+
[Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service](../../database-engine/configure-windows/start-stop-pause-resume-restart-sql-server-services.md)
235+
[Configure a Windows Firewall for Database Engine Access](../../database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access.md)
236236
237237

‎docs/2014/analysis-services/instances/spn-registration-for-an-analysis-services-instance.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -171,7 +171,7 @@ Setspn –s msolapsvc.3/<virtualname.FQDN > <domain user account>
171171
[What SPN do I use and how does it get there?](http://social.technet.microsoft.com/wiki/contents/articles/717.service-principal-names-spns-setspn-syntax-setspn-exe.aspx)
172172
[SetSPN](http://technet.microsoft.com/library/cc731241\(WS.10\).aspx)
173173
[Service Accounts Step-by-Step Guide](http://technet.microsoft.com/library/dd548356\(WS.10\).aspx)
174-
[Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows-service-accounts-and-permissions.md)
174+
[Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows/configure-windows-service-accounts-and-permissions.md)
175175
[How to use SPNs when you configure Web applications that are hosted on Internet Information Services](http://support.microsoft.com/kb/929650)
176176
[what’s new in service accounts](http://technet.microsoft.com/library/dd367859\(WS.10\).aspx)
177177
[Configure Kerberos authentication for SharePoint 2010 Products (white paper)](http://technet.microsoft.com/library/ff829837.aspx)

‎docs/2014/analysis-services/multidimensional-models/creating-multidimensional-models-using-sql-server-data-tools-ssdt.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -48,7 +48,7 @@ manager: "mblythe"
4848
|-------------|-----------------|
4949
|[!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] Scripts|Contains DMX, MDX, and XMLA scripts for [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)], as well as connections to [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] instances against which these scripts can be executed. For more information, see [Analysis Services Scripts Project in SQL Server Management Studio](../instances/analysis-services-scripts-project-in-sql-server-management-studio.md).|
5050
|SQL Server Compact Scripts|Contains SQL scripts for SQL Server Compact, as well as connections to SQL Server Compact instances against which these scripts can be executed.|
51-
|SQL Server Scripts|Contains [!INCLUDE[tsql](../../includes/tsql-md.md)] and XQuery scripts for a [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] instance, as well as connections to [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] instances against which these scripts can be executed. For more information, see [SQL Server Database Engine](../../database-engine/sql-server-database-engine.md).|
51+
|SQL Server Scripts|Contains [!INCLUDE[tsql](../../includes/tsql-md.md)] and XQuery scripts for a [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] instance, as well as connections to [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] instances against which these scripts can be executed. For more information, see [SQL Server Database Engine](../../database-engine/sql-server-database-engine-overview.md).|
5252

5353
For more information about solutions and projects, see "Managing Solutions, Projects, and Files," either in the [!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[vsprvs](../../includes/vsprvs-md.md)] .NET documentation or in the MSDN Library.
5454

‎docs/2014/analysis-services/multidimensional-models/set-impersonation-options-ssas-multidimensional.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -60,7 +60,7 @@ manager: "mblythe"
6060
**Use the service account**
6161
Select this option to have the [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] object use the security credentials associated with the [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] service that manages the object. This is the default option. In previous releases, this was the only option you could use. You might prefer this option to monitor data access at the service level rather than individual user accounts.
6262

63-
In [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)], depending on the operating system you are using, the service account might be NetworkService or a built-in virtual account created for a specific [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] instance. If you choose the service account for a connection that uses Windows authentication, remember to create a database login for this account and grant read permissions, as it will be used to retrieve data during processing. For more information about the service account, see [Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows-service-accounts-and-permissions.md).
63+
In [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)], depending on the operating system you are using, the service account might be NetworkService or a built-in virtual account created for a specific [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] instance. If you choose the service account for a connection that uses Windows authentication, remember to create a database login for this account and grant read permissions, as it will be used to retrieve data during processing. For more information about the service account, see [Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows/configure-windows-service-accounts-and-permissions.md).
6464

6565
> [!NOTE]
6666
> When using database authentication, you should choose the **Use the service account** impersonation option if the service is running under the dedicated virtual account for Analysis Services. This account will have permissions to access local files. If the service runs as NetworkService, a better alternative is to use a least privilege Windows user account that has **Allow log on locally** permissions. Depending on the account you provide, you might also need to grant file access permissions on the Analysis Services program folder.

‎docs/2014/books-online-for-sql-server-2014.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -33,7 +33,7 @@ manager: "jhubbard"
3333

3434
|||
3535
|-|-|
36-
|![Database Engine icon](../2014/media/database-engine.gif "Database Engine icon")|[Database Engine](../2014/database-engine/sql-server-database-engine.md)<br /><br /> The Database Engine is the core service for storing, processing and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise. The Database Engine also provides rich support for sustaining high availability.|
36+
|![Database Engine icon](../2014/media/database-engine.gif "Database Engine icon")|[Database Engine](database-engine/sql-server-database-engine-overview.md)<br /><br /> The Database Engine is the core service for storing, processing and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise. The Database Engine also provides rich support for sustaining high availability.|
3737
|![DQS Logo for BOL home topic](../2014/media/dqs-logo.jpg "DQS Logo for BOL home topic")|[Data Quality Services](../2014/data-quality-services/data-quality-services.md)<br /><br /> SQL Server Data Quality Services (DQS) provides you with a knowledge-driven data cleansing solution. DQS enables you to build a knowledge base, and then use that knowledge base to perform data correction and deduplication on your data, using both computer-assisted and interactive means. You can use cloud-based reference data services, and you can build a data management solution that integrates DQS with SQL Server Integration Services and Master Data Services.|
3838
|![Analysis Services icon](../2014/media/analysisserver.gif "Analysis Services icon")|[Analysis Services](../2014/analysis-services/analysis-services.md)<br /><br /> [!INCLUDE[ssASnoversion](includes/ssasnoversion-md.md)] is an analytical data platform and toolset for personal, team, and corporate business intelligence. Servers and client designers support traditional OLAP solutions, new tabular modeling solutions, as well as self-service analytics and collaboration using PowerPivot, Excel, and a SharePoint Server environment. [!INCLUDE[ssASnoversion](includes/ssasnoversion-md.md)] also includes Data Mining so that you can uncover the patterns and relationships hidden inside large volumes of data.|
3939
|![Integration Services icon](../2014/media/dts.gif "Integration Services icon")|[Integration Services](../2014/integration-services/sql-server-integration-services.md)<br /><br /> [!INCLUDE[ssISnoversion](includes/ssisnoversion-md.md)] is a platform for building high performance data integration solutions, including packages that provide extract, transform, and load (ETL) processing for data warehousing.|

‎docs/2014/data-quality-services/install-windows/install-data-quality-services.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -45,7 +45,7 @@ manager: "jhubbard"
4545

4646
|DQS Component|Minimum System Requirements|
4747
|-------------------|---------------------------------|
48-
|[!INCLUDE[ssDQSServer](../../includes/ssdqsserver-md.md)]|Memory (RAM):<br />-Minimum: 2 GB<br />-Recommended: 4 GB or more<br /><br /> [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] Database Engine. For more information, see [About the SQL Server Database Engine](../../database-engine/install-windows/install-sql-server-database-engine.md).|
48+
|[!INCLUDE[ssDQSServer](../../includes/ssdqsserver-md.md)]|Memory (RAM):<br />-Minimum: 2 GB<br />-Recommended: 4 GB or more<br /><br /> [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] Database Engine. For more information, see [About the SQL Server Database Engine](../../database-engine/sql-server-database-engine-overview.md).|
4949
|[!INCLUDE[ssDQSClient](../../includes/ssdqsclient-md.md)]|.NET Framework 4.0 (installed during the [!INCLUDE[ssDQSClient](../../includes/ssdqsclient-md.md)] installation, if not already installed)<br /><br /> Internet Explorer 6.0 SP1 or later|
5050

5151
> [!IMPORTANT]

0 commit comments

Comments
 (0)