"Invalid authorization specification"

[Guest 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