The "Data Source" field is a text box, the Refresh button does not appear, and you cannot attach a database file as a database name when you try to create a Microsoft Data Link file by using the SQL Native Client provider in SQL Server 2005 (904799)

SYMPTOMS

Consider the following scenario. You try to create a Microsoft Data Link (.udl) file by using the SQL Native Client (SQLNCLI) provider together with the Data Links wizard. You may notice the following symptoms:

The Data Source field on the Connection tab is a text box instead of a drop-down list, as expected.
The Refresh button does not appear next to the Data Source field.
On the Connection tab, no option exists to attach a database file as a database name. This option exists when you use the Microsoft OLE DB Provider for SQL Server (SQLOLEDB).

WORKAROUND

To work around this problem, use the following methods:

To specify the data source, directly input the server name in the Data Source field.
To attach a database, click the All tab on the Data Link Properties dialog box. Then, set the Initial File Name property to the database file name.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.