Info |
---|
|
...
Microsoft SQL resources
...
Configuration requirements
Server Authentication
SQL Server uses three ways to authenticate user access:
...
Crows Nest requires Mixed Mode Authentication.
...
Windows Account Permission
To use the Crows Nest DB Utility application to create or update databases, you must be logged into the server using a Windows account that has been granted 'sysadmin' permissions to the SQL Server instance.
...
For administrators familiar with SQL Server with specific security configuration needs, it is possible to configure permissions separately through the SQL Server Management Studio (SSMS) application.
...
SQL Server Management Studio (SSMS)
SSMS is an interface to the database server. Use it to troubleshoot connectivity issues, and to manage your database (advanced users).
...
If using an Express version of SQL Server, download the option titled "... with Advanced Services" which includes SSMS. Download SQL Server Management Studio (SSMS)
...