Microsoft KB Archive/323191

= BUG: Chat DTS Packages Use Windows Authentication for OLE DB Instead of SQL Server Authentication =

Article ID: 323191

Article Last Modified on 6/18/2003

-

APPLIES TO


 * Microsoft TV Server 2.0 Service Pack 1

-



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.
 * 1) Right-click the task in either package, and then click Properties.

Additional query words: DTS packages Chat authentication

Keywords: kbprb KB323191

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.