What is wrong with my SQL Server 2005? (SS inside)

[shpaner]

I saw in guides that i need (Local) named database , but i cant register as (Local)
Can anybody solve to me this problem



thank you!

[MentaL]

[L1mer41n]

Maybe post of SS if the error could tell more about the problem

[Damian_1993]

Everything is OK with your sql server. Probably you have read guide regarding sql server 2000. Just right click on "Databases" and then click "New Databse" and follow the wizard.

[shpaner]

I dont get any error , i press "Windows Authentication" and this log in.
When i press "SQL Server Authentication" this ask user name and password, and i dont know the user name and password... i get this error:


- - - Updated - - -

Thanks ill try this , but i dont need the "Local" thing?

[Damian_1993]

Login by default is "sa" and password is what you typed when installing sql server.

[shpaner]

cant login as "sa":

[RevolGaming]

you need to allow the login on the SA user in the security settings....

[L1mer41n]

Installed sql with mixed mode ?

[RevolGaming]

dont need to install in mixed mode, mixed mode just for add password, if he want to add password right click on the SA user in the security tab and add password... and turn on login and everything will okey.

[KarLi]

What files you will use for ur server? may u wanna go back to 2000 SQL which will make ur nerve easie on that.

[shpaner]

I get same error like in last SS when i set pass and enable login.
And SQL 2000 doesnt work for me i think i delited some Register files when i removed it from pc, and i get Warning in new installetion.

Edit: I Success login as "sa" and pass like this:


It is will work? this is still not "Local"...