Unanswered: i locked myself out of SQL Server engine
I went into the <username> with Management Studio
it had Login on Disabled in Security, i put it on Enabled i remember, after a while i moved it back to Disabled as i didn't notice any improvement with my problem. But to my surprise it said account disabled. Furthermore i can't login with anything else or the users i make from SQL configuration management. How do i reset this so i can log in to management studio and databases again please?
1. Is that SQL server running under local system account or any other other ,
- If its running under local system account , create an id and add it to administrator group then you will be able to connect
2.If SQL server is running under any other account , check whether u know the password and its having logon locally privilege at Os level , Try connecting SQL using that id , since if its running SQL server it must be having privilege at SQL server
I can't test anymroe i reinstalled. Anything i tried back then gave me user is disabled, cannot log in. My new problem is that my site won't access the database with SQL Server 2008, only with 2005 Express... and i can't make large inserts with 2005 Express that i know of so i'm stuck between a rock and a hard place.