In today's blog post we will be covering how to setup a Microsoft SQL Server repository for IDERA ER/Studio Data Architect Professional / Enterprise Team Edition.
Team Server and Repository databases may run on any of the following database platforms:
- Microsoft Azure SQL Database
- Microsoft SQL Server 2012 to 2019
- Microsoft SQL Server Express Edition 2012 to 2019 is supported, but presents performance limitations that may be unsuitable for your production environment.
Microsoft SQL Server Characteristics
- 64-bit client libraries are already installed on Windows machines.
- Ensure that the server and database are set to case-insensitive, as case-sensitive is not supported. Also set the SQL Server Configuration Properties to allow SQL Server authentication. Team Server only supports SQL Server Authentication.
- The database and server collation must be set to SQL_Latin1_General_CP1_CI_AS
- When using SQL Server, ensure the SQL Server Agent is running.
- Team Server on SQL Server only supports the following communication protocols:
- Shared Memory
- Named Pipes
- The option ANSI_NULLS (Server Properties > Connections) needs to be set as On.
- The default schema for Team Server database needs to be dbo. If you were using a different schema please move the tables to dbo schema previous to install or upgrade Team Server.
Note: After configuring a new installation against a SQL Server 2014 or later database, it is recommended that you go into the properties of the new database and change the compatibility settings to 2012 or 2008. This step helps prevent significant performance degradation in many environments. For more information about this feature, see an IDERA forum post about this subject.
For more details.. Stick around on how to setup an AzureSQL DB for the repository tomorrow!