Solved

connection failed check sql server registration properties, SQL 2000

Posted on 2009-07-16
5
653 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

734 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