BaseNow

 

  Search
   

  Help

Screen shots

Compare editions

Online help

Quick-start videos

System requirements

License agreement

Known issues

  Support

 Forums

Technical support

Feedback

 About the author

 Company

Contact

Privacy policy

  Features

BaseNow architecture

Database tools

BaseNow Agent

Tables and views

SQL Query Builder

Import/export data

  Subscribe

Stay informed about any major changes. Click here to subscribe

 

Creating a new database

Create Database Wizard helps you to create a new database in a few simple steps. It supports the Microsoft Access and Microsoft SQL Server database formats. First, you need to enter file locations, select the database format, and in case of SQL Server database, enter connection information.

Database Format

Allows you to choose a database format. The following formats are supported:

 Microsoft SQL Server 7.0

 Microsoft SQL Server 2000

 Microsoft Access 97

 Microsoft Access 2000

Database File Location

Allows you to enter the location of the database file. This file contains the startup information for the database and is used to store data. Microsoft Access files have mdb file extension, while the SQL Server files use mdf files. The wizard automatically attaches appropriate file extension.

Transaction Log File Location

Specifies the name for the transaction log file. Log files hold the log information used to recover the database. The transaction log is a serial record of all modifications that have occurred in the database. There must be at least one log file for each database.

Connection Properties

This dialog box enables you to configure the connection to the SQL Server. The wizard automatically generates a connection string that will be used to open a connection to the database server.

Server name

Specifies the name of the server. If the server is located on a LAN, you will enter a local IP address or computer name in that text box. If the server is located on the internet, you will use its domain name, or Internet IP address.

Windows NT integrated security

SQL Server achieves login security integration with Windows NT 4.0 or Windows 2000 by using the security attributes of a network user to control login access. A user's network security attributes are established at network login time and are validated by a Windows domain controller. When a network user tries to connect, SQL Server uses Windows-based facilities to determine the validated network user name.

Specific user name and password

When a user connects with a specified login name and password from a nontrusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. If SQL Server does not have a login account set, authentication fails and the user receives an error message.


Related Topics:

How to create a database

About designing a database

Normalization

Database performance

About Create Database Wizard

Database file details

Transaction log file details

Create a new table

Completing the wizard

[Home] [Download] [Screen Shots] [Details] [Support] [Purchase]

Copyright © 1997-2005 Gate Comm Software. All Rights Reserved.