BUG: Chat DTS Packages Use Windows Authentication for OLE DB Instead of SQL Server Authentication (323191)


The information in this article applies to:

  • Microsoft TV Server
This article was previously published under Q323191

SYMPTOMS

Chat DTS packages do not use SQL Authentication information that is provided in MSN Communications Applications for Microsoft TV Server configuration files.

CAUSE

This behavior occurs because Chat DTS packages use Windows Authentication by default.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

When a Chat DTS package uses SQL Authentication, the package reads the user name and password from the MSN Communications Applications for Microsoft TV Server configuration file, maintains this information in the DTS Global variables, and then uses this information to populate the fields in the Connection Properties dialog box. The expected behavior is that in Connection Properties for the Chat DTS packages, the Use SQL Authentication option is selected, username text box contains the text wtv_service, and the password text box contains the text wtv. By default, however, the Use Windows Authentication option is selected and the username and password text boxes are empty.

Steps to Reproduce the Behavior

  1. In SQL Enterprise Manager, click Data Transformation Services, and then click Local Packages.
    There are two Chat DTS packages. A task named Microsoft OLE DB Provider for SQL Server appears in each of these packages.
  2. Right-click the task in either package, and then click Properties.
Modification Type:MinorLast Reviewed:6/18/2003
Keywords:kbprb KB323191
©2003 Microsoft Corporation. All rights reserved.