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.

Microsoft SQL Server

In some cases, Microsoft SQL Server servers may not be displayed.  When you install SQL Server, it disables TCP/IP for your default instance or your named instance.  Without the TCP/IP being enabled, Iron Speed Designer cannot see your database server.  Iron Speed Designer uses a Windows API function which requests the set of available database servers via TCP/IP.  To enable TCP/IP for your SQL Server default instance or named instance, follow the instructions in this Microsoft Knowledge Base article:

http://msdn2.microsoft.com/en-us/library/ms177440.aspx

You may also want to use “(local)” as the database server name for your Microsoft SQL Server installation if it’s on your local machine, in keeping with common practice in earlier versions of Microsoft SQL Server.

To do this, run the 'Microsoft SQL Server Management Studio' and connect 'Database Engine' using '(local)' in Server name.

See Also

Step 4: Connect to a Database Server

Microsoft Access Options for Database Server Selection

Microsoft SQL Server Options for Database Server Selection

MySQL Options for Database Server Selection

Oracle Options for Database Server Selection

Working with Complex Databases

Database, Table, and Field Name Restrictions