dear all, y'day one of my new colleague has changed the login/password of SQL server and he is forgotten that login/password. Thus, Our website is not connecting to Databbase server. We are overwheling with the calls from website users. Can anyone guide me how to find out the loginname or to disable the login/password Pl. expedite in providing answers its very urgent Rajendar ok
If the user has changed the password yesterday then u can run the query in master to find the who are all users changed passwords select * from syslogins order by updatedate DESC use where clause in the query for finding the users changed password on the given date Thanks Rushendra
Thank u for ur prompt reply. My SQL Server has got only one login/password. Now we are not able to connect to SQL Server Rajendar ok
Are you talking about the sa account? If so, and if you registered this server in EM, you can change the password from there. Bambola.
For this u can use Sql Enterprise manager and change the Password for the user because u were telling that only one user is there in sql server. If ur enterprisemanger allows Windows authentication. Thanks. Rushendra
When I'm trying to open myserver from Server group in Enterprise Manager, its asking login/password. Rajendar ok
In the Enterprise manager right click on the server and choose edit sql server registration then remove the option allways prompt for login name and password and then try to connect the the server by changing the windows authentication mode If it succeeds then change the user password in the enterprise manager. Thanks. quote:Originally posted by erajendar When I'm trying to open myserver from Server group in Enterprise Manager, its asking login/password. Rajendar ok Rushendra
I found this: To reset the sa password, you can make the following: 1. Login to the SQL Server box as the Administrator. 2. Run SQL Server Enterprise Manager. 3. Right-click the server name and choose 'Edit SQL Server Registration properties'. 4. Choose 'Use Windows authentication' and click OK button. 5. Expand a server, expand a Security and click Logins. 6. Double-click the sa login and specify new password on the General tab. and this: http://www.softstack.com/security/server-what-can.html Bambola.
Dear Rushendra, bambola, Thanks for ur continuous reply. When I'm doing like ur suggestion it is giving following message box:: SQL Server registration failed because of the connection failure displayed below. Do you wish to modify any way? Login failed for user'RAJENDARAdministrator'. Rajendar ok
Is 'RAJENDAR' the box you have SQL Server on? You need to logon as Administrator to the system that has the SQL Server service on it. Assuming 'RAJENDAR' is the box, bring up the Services list in Computer Management. Check the 'Log On' properties of the MSSQLSERVER service. Perhaps you can change it to a valid log in on that computer. Once you've completed that I would try to modify you connection in Enterprise Manager and fix the problem from there.
1. Try starting the Service with the limited 'Local System Account' and then logon to the system to restore your connection settings. 2. If you never modified the 'sa' account (and I hope not) try using SQL Server Authentication Mode with the 'sa' account. Nathan H.O.
This old article on logins may raise your eyebrows (For staunch supporters of WIndows Authentication) http://www.sqlservercentral.com/columnists/awarren/thecaseforsqlloginspart1_printversion.asp] Nathan H.O.
