Support Center Email Support Knowledge Base Videos
Geoscience > Main Launcher > File Menu > SQL Server Admin Tool

SQL Server Admin Tool

Use the SQL Server Admin tool to help configure SQL permissions for specific logins or for all users. Note: You will need to be an administrator to run this configuration tool. It is the final step in the SQL setup/installation for using SQL with the software.

ClosedHow do I configure an installation of SQL Server?

  1. Select the SQL Server that needs to be configures. Use the drop down to select the server, or select "Browse for more" if you don't see the server that you need. 

  2. Turn on Allow Remote Access to indicate that you want to allow users to connect to this server across the network. 

  3. Turn on Allow all logins or select specific users that you want to grant permission to access the SQL Server.
    • If Allow all logins is turned on, anyone trying to access the server should be granted permission.
    • If only specific users need access click . Enter the user name (in the format: Domain\User). 

  4. Click  when finished.

General Information

SQLServerTool.png

Server Name

Server: The name of the SQL Server that the permissions are currently going to be set for. Note: You must have administrator privileges to make changes to any permissions. Typically the name would be "Server\SQLExpress" for SQL Express installs, or "Server\SQL" for full SQL Server installs.

Server Permissions

Allow remote access: This configures the SQL Surface Area Configuration to allow users to connect to the SQL installation across the network.

Allow all logins: This configures the permissions so that any user can connect to the SQL Server.

Specify Users

Allowed Users: This lists all of the currently added uses that have permission to use the SQL Server.

Add...: Use this to add additional users to the Allowed Users list. The names are in the format "Domain\User".

Delete: Highlight a user's name from the Allowed Users list and click on delete to remove the user from the Allowed Users List.

— MORE INFORMATION

Copyright © 2020 | SeisWare International Inc. | All rights reserved