SQLSTATE=28000 Log-on Error

[Former Member]

I'm getting the following error message when attempting to run an application from the development mode:

Error Code: 999

Error Message:  SQLSTATE=28000

Microsoft SQL Server Native client 11.0

Invalid authorization specification.

(I've searched prior posts but I can't find one that fits my situation)

I've just migrated a PB12.5 development application on a laptop to PB 16.  The laptop has Windows 8 (administrator) and the DB is MS SQLServer (Express) 2012.  The 'Connect' entry for SQL Server is 'Windows Authentication'.  PB 16 connects ok to the DB.  The PB database profile is:

SQLCA.DBMS = "SNC SQL Native Client (OLE DB)"

SQLCA.ServerName = "TABLET\SQLExpress"

SQLCA.AutoCommit = True

SQLCA.DBParm = "TrustedConnection=1,Database='callrunner_sqlserver',Provider='SQLNCL11''

The relevant registry setting (HKEY LOCAL MACHINE and mirrored in WOW2364) are:

DBParm "TrustedConnection=1,Database='callrunner_sqlserver',Provider='SQLNCL11'"

DBMS           SNC SQL Native Client (OLE DB)

ServerName  TABLET\SQLEXPRESS

There is no entry of relevance in the SQL Server log file.  All variables load from the registry when running/debugging the application.

[Former Member · Accepted solution]

Thanks for everyone's help.

I solved the problem by assigning 'sa' to SQLCA.LogID  and 'password' to SQLCA.LogPass - values not required in my MS SQL Server 2008 configuration. 

2008 accepted '' values for these variables with the Windows trusted connection. 

(Ricardo, the 2012 DB and PB12.6  were both on a laptop)