Bonehead move..

I disabled standard authentication login and implemented OPENID login as the only login authentication routine.

DNN has no reference of an OpenID account ... the host (standard) login certainly doesn't work.

I have access to MSSQL on the server but unable to see or access the tables to manually alter the login authentication mode.

Help

Hey Oliver

Yeah...took my eye off the ball.

DNN version 4.08.01

MSSQL Server Management Studio Express

I am perplexed over the permissions in SQL server management ... I can't see any tables in the DNN database..  I can't even write a simple UPDATE query to set the values in IsEnabled back to true and/or the PackageID column to -1, 1, 2 (DNN, LiveID, OpenID respectively)  which I believe will get back the standard DNN login prompt.

Need to work permissions to enable Table view/access et al.

I have console (server) access.

Thanks for the prompt reply earlier

Oliver

All that is good .. I am using the same login as in script (web.config) ..database IS attached and reading from the mdf file located in 'Program Files\MS SQL Server\MSSQL.1\MSSQL\Data\....'

Can't view Tables...Tried writing a query through one of my modules to reset the authentication modes as an inside approach but getting an 'invalid object name "Authentication"

I'm guessing it is a security thing ... DNN requires front door authentication to write to certain tables??

I just need access to the table from SQL Manager ... My last good is 5 days old .. I guess I may have to restore from that ..

I obviously not up to adequate speed with regard to SQL permissions..

b