When installing a new GoldMine system, where do you define the desired name of the GoldMine database?

Version 1


    - When installing a new GoldMine system, where do you define the desired name of the GoldMine database?
    - Why is your GoldMine database called GoldMine when you may wish to have a more company related database name?


    - During the installation  process in the MS SQL Administrator dialog the Database details can be  defined and modified, for example the GoldMine database


    MS SQL Server Name: This is fixed and is the server name and if applicable instance name of the existing Microsoft SQL Server, for example
    W08R2  (when the SQL Server is a default instance without an instance name) or  W12R2\SQLExpress when certain Microsoft SQL Editions are used or  specific instance name was applied during the installation of Microsoft  SQL Server

    MS SQL Database Name:
    This is by default GoldMine but can be changed to any appropriate Microsoft SQL database name (for example OurCompanyGMDB

    See  further information on Microsoft Web pages and documentation, for  example from an extract from the document Guide to Migrating from MySQL  to SQL Server 2012.
    In SQL Server 2012, an object name can be up to 128 characters long.

    Nonquoted identifier names must follow these rules:

    - The first character must be alphanumeric, an underscore (_), an at sign (@), or a number sign (#).
    - Subsequent characters can include alphanumeric characters, an underscore, an at (@) sign, a number sign, or a dollar sign.
    - The identifier must not be a Transact-SQL reserved word.
    - Embedded spaces or special characters are not allowed.
    -  Identifiers that start with @ or a number sign have special meanings.  Identifiers starting with @ are local variable names. Those that start  with a number sign are temporary table names.

    To quote an identifier name in Transact-SQL, you must use square brackets ([]).

    MS SQL Administrator Username: By  default this is set to the Microsoft SQL user sa (systemadministrator)  and is recommended to use at least for the initial installation as  extended rights are necessary in order to create the database, the  tables etc. After the initial installation and making sure to have a  Microsoft SQL user setup with appropriate rights (absolutely recommended  at least to set as db_owner in the User Mapping for the the GoldMine  database) the login name can be changed in the Alias Manager to the  desired SQL Login

    MS SQL Administrator Password:
    Matching SQL Login password for the used MS SQL Administrator Username

    MSSQL Database Owner: dbo this value should never be changed! - This is not the real owner of the database but instead the used schema