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 2005
In some cases, Microsoft SQL Server 2005
servers may not be displayed. When you
install SQL Server 2005, it disables TCP/IP for your default instance or your
named instance. This behavior is
different than with SQL Server 2000 and was done presumably for security reasons. 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 2005 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
Configuring
Table and Record Panels