Multi Database

5.Type this code, including the commas: sp_attach_db 'Multi', 'C:\MSSQL7\Data\Multi.mdf', 'C:\MSSQL7\Data\Multi.ldf'

6.Execute the code by pressing F5, or using the “Execute” command.

Using Admin to Create a SQL-compatible Multi Database

1.Before using Admin to connect to a SQL-Server server, your SQL database administrator provides you with:

A SQL account and password. The SQL Administrator logon is “sa” by default, but it and its password may have been changed.

The SQL-Server server name

Share name of the folder that will hold the Multi db.

2.Ensure that a SQL-Server client is installed on the PC used to connect to a SQL-Server server.

3.Start Admin. The Admin Logon window appears.

4.In the Admin Logon window, leave or type “Administrator” in the User ID box.

5.Leave the Password box empty. An empty database lists only one user: “Administrator”. By default, this account has no password. See the information about the default user in Administrator Password on p.176.

6.Click “Microsoft SQL”. Your next step depends on which Windows operating system is running your PC.

Users of Microsoft Windows 2000 or XP. You have the option of clicking Scan, to locate SQL-Server servers in your network neighborhood. The scan takes some time to perform on shared drives. If the scan is ineffective at locating the server you need, you can try the next option, even if it is designed for other versions of Windows.

-or -

Users of Win98se; or if a scan was ineffective. Type the name of a SQL server in the Server name box. Your organization’s database administrator can help you find this name.

7.Click the arrow in the Database Name box to see the database names that are in use. To create a database type a name that is not in use in Database Name.

8.Click OK.

If the name was typed in, a scan is performed, regardless of the Windows operating system on your PC.

If SQL-Server security has been changed, a SQL log on window appears, as discussed in section SQL-Server Option on p. 165. Type in a Login and Password obtained from your database administrator; then click OK. The Create Database window appears (see fig. 14–4). Note that Create empty database is selected.

9.Click OK. In the Admin window, a site is listed on the Sites tab; an “Administrator” user listed on the User tab.

238

Page 238
Image 238
Honeywell K14392V1 manual Using Admin to Create a SQL-compatible Multi Database