Filter
Top Products
Multi Database
238
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.