connection failed check sql server registration properties, SQL 2000

hello, When i login SQL Serve Enterprise Manager, try to connect one of the instance, having the error "connection failed check sql server registration properties". any idea?

we need to install a update for one of the software, we need sa password. but we forget it. also, we can not login "Use Windows Authentication"

please help, how can i retrive my sa password?

thanks
SQL2000.jpg
GoSystemsAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
well logically it seems right but I never tried it, as long as sql server 2005+ concern, you can't directly update syslogins but you may do it in SQL Server 2000. you don't have any other option so you can atleast give it a shot. moreover, if you will follow that script, you will not be able to update the table as there is no table mentioned there. I am SURE it is typo so let me give you update query for that article.

UPDATE syslogins
SET password = 0×0100583BBD63&74A1222B8
WHERE sid=0×01
AND name=sa
0
 
RiteshShahCommented:
if you don't have SA password and if you can't get login with windows authentication than I am sorry you will not be able to get it. do you have any other SQL Server authentication account with sysadmin fixed server role?
0
 
GoSystemsAuthor Commented:
no idea. we have the sa password, but the sa password not working. not sure why. is the the sa password problem or something else?
0
 
RiteshShahCommented:
you must have forgot SA password and in absence of any other powerful account, you will not be able to get it back for SURE.
0
 
GoSystemsAuthor Commented:
i did some research, here is one topic, can you see is it the correct way? "Re-setting the sa password without admin privileges"  http://nick.kavadias.org/2009/04/re-setting-the-sa-password-without-admin-privileges/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.