Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

connection failed check sql server registration properties, SQL 2000

Posted on 2009-07-16
5
Medium Priority
?
658 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

604 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