SQL Server Security User Settings
If you use SQL Server Management Studio you can confirm the settings for database access.
The Site Manager Database is called syamdb
The Management Utilities Database is called syamutility
Security - Logins
NT AUTHORITY\SYSTEM
Server Roles
- Public
- Sysadmin
User Mapping - Datbase role membership for master - (Public checked off)
- syamdb - Empty for User / Empty for Default Schema
- syamutility - dbo for User / dbo for Default schema
Security - Logins
Administrator (Username that you installed the software as)
Server Roles
- Public
- Sysadmin
User Mapping - Datbase role membership for master - (Public checked off)
- syamdb - dbo for User / dbo for Default schema
- syamutility - Empty for User / Empty for Default Schema
**Please Note** The user syam is created during installation and uses SA password authentication, this user should not be edited.