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?

If you logged in as an administrator on the machine, you should be able to log into SQL Server.

In windows auth mode it sais cannot connect to user: ".
exactly like that: ".
Because is not related to any trusted connections.

And in SQL Auth mode it sais login failed for user: <myuser> and <my password> that i set for it from sql configuration manager.

I don't know any default logins. I tried u:sa p:sa it didn't work.

Know any others? If i repair or uninstall/install SQL Server will it be fixed? Any other way to reset this?

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.