Microsoft SQL Server Options for Database Server Selection

Field

Description

Server

Microsoft SQL Server only.  The name of the database server machine.  (Note: this is not the name of the database.)  The database server machine name can be:

  • The server name, e.g., DEMO or SQL.IRONSPEED.COM.

  • An IP address, e.g., 206.154.12.22.  Do not include the “http://” or “https://” prefix in the IP address.

In some cases, MSDE 2000 servers do not "advertise" themselves on the network, so Iron Speed Designer is not able to see them.  Instead, type in the name of the MSDE 2000 server, or its instance name, e.g.:

<Machine Name>\VSDOTNET

Authentication

Enter the database specific credentials necessary for you and Iron Speed Designer to access the database.

Use Windows Authentication
Microsoft SQL Server only.  Iron Speed Designer will use your Microsoft Windows name and password in order to log into your database server.  This generally works only for database servers local to the machine on which Iron Speed Designer is installed.

Use a specific Microsoft SQL Server user name and password
Microsoft SQL Server only.  Iron Speed Designer uses the user name and password you provide to log in to your database server.  This is generally preferred when connecting to a database server that is not attached to the machine on which Iron Speed Designer is installed.

Database user name

Microsoft SQL Server only.  The login user name required to access the selected database server machine.

Database password

Microsoft SQL Server only.  The login password required to access the selected database server machine.

See Also

Configuring Table and Record Panels