Invalid authorization specification

Hi,

We are testing our product on Windows Vista with SQL Server 2005 SP2 and are encountering an "invalid authorization specification". We make the connection through a Windows service using a standard ADO connection. I have tried changing the provider in the connection string to SQLNCLI without any success. The application is written in Delphi 5 and has worked on previous versions of Windows running SQL Server 2005.

Thanks.

Steven
Can you post the connection string ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Hi,

My connection string is: Provider=SQLNCLI;Database=TESTDB;Server=STEVENV;UID=sa;PWD=test

Steven

|||

What's the exect error msg?

Can you check this page http://msdn2.microsoft.com/en-us/library/ms188670.aspx to ensure that SQL Authentication is turned on? (although I noticed that the title mentioned authorization) Thanks,

|||

We actually managed to get this issue resolved.

What was happening is that we were setting the previously posted connection string on our ADO connection object and when we requested the connection string off that object for a different connection object, for some reason it was adding a whole lot of other connection string parameters that obviously don't work on Windows Vista but do work on Windows XP. This must just be some strange behaviour in the ADO connection object that we're using, a pretty legacy ADO object in Delphi 5. We resolved the issue by always using the original connection string instead of the one off the first ADO connection.

Thanks for the help.

Steven