|
Configuring Microsoft SQL Server 2005
In some cases, Microsoft SQL Server 2005 servers may not be displayed in the Database Servers step of
the Application Wizard in Iron Speed Designer. When you first install Microsoft 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.
|