Hello Ragezoner , i need help i don't have my id and pass my sql ...
I know we can lauch without id and pass , but i need for change info in server.txt ...
My question : How found my id and pass Sql ?
Hello Ragezoner , i need help i don't have my id and pass my sql ...
I know we can lauch without id and pass , but i need for change info in server.txt ...
My question : How found my id and pass Sql ?
Id = "sa" w/o ""
to get pass, just login via windows auth. and follow these steps
Security > Logins > Right click "sa" > type in new password and then re-type to confirm then hit ok
Once doing this, new user/pass = sa/whateveryoutyped
Where is security ? XD
i am french sorry ...
security is located on the left hand side right under database
Can u make screen ? plz
Here is a s/s of where to find user 'sa', all you need to do is follow the other instructions I posted
Ty but i can't change my pass ..
just right click on sa and click properties
fill in passwords and should be it
this shut do it
Code:USE [master] GO ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON GO USE [master] GO ALTER LOGIN [sa] WITH PASSWORD=N'blah' MUST_CHANGE GO
the query wont work because my computer has windows 2002 lol
SQL Manger
you mean manager? and how can i change the password with my version of windows. or give me the download for the updated system >.<