Solved

connection failed check sql server registration properties, SQL 2000

Posted on 2009-07-16
5
652 Views
Last Modified: 2012-05-07
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
0
Comment
Question by:GoSystems
  • 3
  • 2
5 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24867175
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
 

Author Comment

by:GoSystems
ID: 24867264
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
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24867274
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
 

Author Comment

by:GoSystems
ID: 24867459
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
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24867487
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

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Insert to Begin if data exists 2 33
Nested Case statement 4 39
SQL Server Configuration Manager WMI Error 11 21
MSSQL - Lock Row from reading by other programs 9 40
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question