Export (0) Print
Expand All
Expand Minimize

Set-SPProjectDatabaseSQLCredentials

Project Server 2013
 

Applies to: Project Server 2013

Topic Last Modified: 2013-12-18

Sets the credentials to be used by the Project Server service application to connect to a Project Web App database.

Set-SPProjectDatabaseSQLCredentials [-Name] <String> [-WebApplication] <SPWebApplicationPipeBind> -ReadWriteCredentials <PSCredential> -ReportingSchemaCredentials <PSCredential> -SQLLogon <PSCredential> [-AssignmentCollection <SPAssignmentCollection>] [-DatabaseServer <String>]
Set-SPProjectDatabaseSQLCredentials [-Name] <String> [-WebApplication] <SPWebApplicationPipeBind> -ClearCredentials <SwitchParameter> [-AssignmentCollection <SPAssignmentCollection>] [-DatabaseServer <String>]
Set-SPProjectDatabaseSQLCredentials [-Name] <String> [-ServiceApplication] <PsiServiceApplicationPipeBind> -ReadWriteCredentials <PSCredential> -ReportingSchemaCredentials <PSCredential> -SQLLogon <PSCredential> [-AssignmentCollection <SPAssignmentCollection>] [-DatabaseServer <String>]
Set-SPProjectDatabaseSQLCredentials [-Name] <String> [-ServiceApplication] <PsiServiceApplicationPipeBind> -ClearCredentials <SwitchParameter> [-AssignmentCollection <SPAssignmentCollection>] [-DatabaseServer <String>]

The Set-SPProjectDatabaseSQLCredentials cmdlet allows administrators to set appropriate credentials for the Project Server service application to connect to a Project Web App database in a least-privileges configuration. Two sets of credentials are configured to connect to the Project Web App database and are used depending on the action that is being taken. The ReadWriteCredentials credentials are used to execute on all scalar functions, stored procedures, table types, select on all functions, and select, update, insert, and delete on all tables. The ReportingSchemaCredentials credentials are used to create a table, create a view, and alter a table in the DBO schema for the Project Web App database.

 

Parameter Required Type Description

Name

Required

System.String

The name of the Project Web App database to set SQL credentials on.

ServiceApplication

Required

Microsoft.Office.Project.Server.Cmdlet.PsiServiceApplicationPipeBind

Specifies the Project Server service application which the Project Web App database is connected to.

WebApplication

Required

Microsoft.SharePoint.PowerShell.SPWebApplicationPipeBind

Specifies the web application which the Project Web App database is mounted to.

ClearCredentials

Required

System.Management.Automation.SwitchParameter

Clears the ReadWriteCredentials and ReportingSchemaCredentials and reverts to using SQL Login credentials.

ReadWriteCredentials

Required

System.Management.Automation.PSCredential

Database credentials to be used to read and write data to the Project Web App database. The credentials will be granted execute on all scalar functions, stored procedures, tables types, select on all functions and select, update, insert and delete on all tables.

ReportingSchemaCredentials

Required

System.Management.Automation.PSCredential

Database credentials to be used to update the schema. The credentials will be granted create table, create view and alter table in the DBO schema for the Project Web App database.

SQLLogon

Required

System.Management.Automation.PSCredential

The SQL admin credentials to be used to setup the ReadWriteCredentials and ReportingSchemaCredentials credentials.

AssignmentCollection

Optional

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

NoteNote:
When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

DatabaseServer

Optional

System.String

The database server that hosts the Project Web App database.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft