August 24, 2011 at 12:26 am
I have tried to change SA password using login who was having sa rights...
I tried through SSMS.
by using OSQL.
but still its not getting changed... is there any other way to change sa password...
Sagar Sonawane
** Every DBA has his day!!:cool:
August 24, 2011 at 12:34 am
Whats the error message you are getting?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
August 24, 2011 at 12:51 am
Logn Failed for user 'sa' Error No 18456
Sagar Sonawane
** Every DBA has his day!!:cool:
August 24, 2011 at 1:48 am
In order to resolve the issue, please refer to the following steps:
1. Login to the MSSQL Server Management Studio with Windows Authentication.
2. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
3. Under the Server Properties, select a page of “Security”.
4. Select the Server authentication as “SQL Server and Windows Authentication mode” and click Ok.
5. Restart the SQL Services and then try to login with ‘sa’ details.
August 24, 2011 at 3:02 am
Ohh.. it was just near to eyes.... Thanks its done 🙂
Sagar Sonawane
** Every DBA has his day!!:cool:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply