LeighM


Hi,

I'm attempting to install Proclarity 6 on a Win2003 Virtual PC, using SQL Server 2005 as my DB platform.

The installation continually fails with the error: "The SQL Serve Selected is not in Mixed Mode...". This occurs even if i specify the 'sa' account during the installation.

My SQL Sever is definitely set to Mixed Mode authentication!

Has anyone come accross this before and is there a fix

Thanks in advance,

Leigh.





Re: Proclarity Installation using SQL Server 2005

Madhu K Nair


just run this statement and see whether its returning 0 or not

select SERVERPROPERTY('IsIntegratedSecurityOnly')

Madhu







Re: Proclarity Installation using SQL Server 2005

LeighM

Hi Madhu,

I ran that statement and got 0 back from the server suggesting that i am indeed running in "Mixed Mode".

Cheers,

Leigh







Re: Proclarity Installation using SQL Server 2005

LeighM

Well, i'm not sure why, but i've applied SQL 2005 SP2 and created a new user which i specified to run the ProClarity installation and hey-presto, suddenly everything works!

Cheers,
Leigh