• Home   /  
  • Archive by category "1"

Sql Server Instance Name Format For Essay

4/23/2012

Use the SQL Server Instance Name page of the Windows Embedded Standard installation wizard to choose the SQL Server instance that will be used during setup.

A SQL Server instance can be either a default instance or a named instance. A default instance is an installation of SQL Server that uses the same name as the computer name on which it is installed, also referred to as <MachineName>. A software client need only specify the computer name when connecting to a default instance. SQL Server 2000 and higher support multiple SQL Server instances on a single computer or processor, but only one instance can be the default instance; all others must be named instances. A named instance is an installation of SQL Server that is given a name to differentiate it from other named instances and from the default instance on the same computer. A named instance is identified by the computer name on which it is installed and its instance name, also referred to as <InstanceName>. A software client must specify both the computer name and the instance name when connecting to a named instance.

On the SQL Server Instance Name page of the Windows Embedded Standard installation wizard you will utilize the Server Name list to choose the SQL Server instance that will be used by setup. The following scenarios will help you determine how to specify the SQL Server instance.

  1. Install a new component database or migrate from an existing component database.
    Note: To install a new component database or to migrate an existing component database you must specify a local SQL Server Instance. The component database cannot be installed to or migrated on a remote SQL Server Instance.
    • Choosing a default instance: Select/enter either (local) or <MachineName>.
    • Choosing a named instance: Select/enter either (local)\<InstanceName> or <MachineName>\<InstanceName>.
    Example
    If the component database will be created on a SQL Server 2005 Express instance named SQLEXPRESS and the name of the computer running that SQL Server is PC-COMPDB, you can enter either (local)\SQLEXPRESS or PC-COMPDB\SQLEXPRESS as the SQL server instance.
  2. Install tools and connect to a local SQL Server Instance
    • Choosing a default instance: Select/enter either (local) or <MachineName>.
    • Choosing a named instance: Select/enter either (local)\<InstanceName> or <MachineName>\<InstanceName>.
  3. Install tools and connect to a remote SQL Server Instance
    • Choosing a default instance: Select/enter <MachineName>.
    • Choosing a named instance: Select/enter <MachineName>\<InstanceName>.
    Example
    If the component database exists on a remote SQL Server 2005 instance named REMSQLSERVER and the name of the computer running that SQL Server is PC-COMPDB, you can enter PC-COMPDB\REMSQLSERVER.
Note:
For Windows Embedded Standard installer to detect a remote SQL Server instance, you must start the SQL Server browser service on the remote server running that instance.

3.3 Advanced-Mode Database Server Installation

Install and configure Microsoft SQL Server to suit your environment. Be sure to keep a few things in mind:

  1. For installations using a single host for the Web Server and Database Server, Shared Memory will be used to connect the Web App to the database.
  2. For installations using separate hosts, Microsoft SQL Server will have to be configured to listen on TCP/IP using port 1433. On Express editions this usually needs to be manually enabled.
  3. You'll be running SQL Scripts manually to implement the report42 database schema, so be sure you have access on the server or an administration workstation from a client such as the Microsoft SQL Server Management Studio.
  4. The SQL Scripts will create an ID that connects the report42 web app with the report42 logical database, so you don't need to give out system administrator IDs.

3.3.1 Installing Microsoft SQL Server Express

If you are not integrating into an existing Microsoft SQL Server infrastructure, download and install Microsoft SQL Server 2008/2012/2014 Express.

Click Images to Enlarge

The recommended configuration options are:

  • Feature Selection: Add the Connectivity Components
  • Authentication Mode: Use Mixed Mode and set a password for the sa login ID
  • Configuration Options: Disable User Instances, Add the current user to the Administrator Role

3.3.2 Configuring SQL Server for TCP/IP

Important: this step is only required for installations where the Web Server and Database Server are installed on separate hosts on the network.

Launch the SQL Server Configuration Manager from the Start Menu. You need to make changes in the TCP/IP properties under:

  • SQL Server Configuration Manager
    • SQL Server Network Configuration
      • Protocols for SQLEXPRESS (or other instance name, such as MSSQLSERVER)

Click Images to Enlarge

Set the following in the TCP/IP Properties:

  • Protocol Enable: Yes
  • External Interface IP Address: Activate and Enable, clear TCP Dynamic Ports, set TCP Port to 1433.
  • IPAll TCP Dynamic Ports: clear the field (even if the value is 0, delete it)
  • IPAll TCP Port: Set to 1433

Save your changes and procede to:

  • SQL Server Configuration Manager

Select the SQL Server service and restart it using the toolbar button or from the right-click menu.

3.3.3 Installing SQL Server Management Studio

If you are using Microsoft SQL Server Express, you may want to download and install the SQL Server Management Studio separately as an alternative to the command-line tools. The default install options are acceptable.

Note: as of the 2012 version, SQL Server Management Studio is a 1GB+ download and typically requires 30-60 minutes to install. If you are using Microsoft SQL Server 2012 or greater, you may wish to consider using the built-in command-line tools instead.

3.3.4 Creating the report42 Database

The report42 Web App installer configuration wizard creates several scripts for creating and backing up its database. Periodically, a Web App update will include an Update script to add back-end features to the system.

If necessary, copy these scripts to the database server from the web server's report42 scripts program directory. Run them using the SQL Server Management Studio or the sqlcmd command-line utility in this order:

  1. CreateDB.sql: Creates the report42 logical database. By default, it is named REPORT42DB.
  2. CreateClientDBLogin.sql: Creates a local Microsoft SQL Server ID with access rights to the report42 database.
  3. CreateDefaultAdmin.sql: Creates the report42radmin login ID with administrative rights in the web app. You are strongly advised to change the default password after logging into report42 for the first time.

For example, using the command line (including a complete log file):

C:\> cd C:\report42\scripts
C:\report42\scripts> sqlcmd -S YOURDBHOSTNAME\SQLEXPRESS -i CreateDB.sql CreateClientDBLogin.sql CreateDefaultAdmin.sql -e -u -o sqlcmdlog.txt

One thought on “Sql Server Instance Name Format For Essay

Leave a comment

L'indirizzo email non verrĂ  pubblicato. I campi obbligatori sono contrassegnati *