"Invalid authorization specification"

[Riyad Mammadov]

Hi! We have some legacy code that uses OLE DB to connect to a SQL
server. After migrating to Windows Server 2008, the code stopped
working. The error we are seeing is 80040E4D, "Invalid authorization
specification". Below is the VBScript that we use to reproduce the
error. This script runs without problems on Server 2003 and XP
computers but fails on any 2008 box.
Any help is appreciated!

dim sConnection
sConnection = "Provider=SQLOLEDB.1;Data
Source=******;Database=*****;UID=*****;PWD=*****;"

dim cnExecute
Set cnExecute = CreateObject("ADODB.Connection")
cnExecute.Open sConnection

dim rs
Set rs = CreateObject("ADODB.Recordset")
rs.ActiveConnection = cnExecute.ConnectionString