Skip to Content
0
Former Member
Jun 23, 2015 at 12:41 AM

SQLSTATE=28000 Log-on Error

518 Views

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.