Changing Lost SA Password

Jul 23, 2005

I just started a new job and no one seems to know the SA password.
Here's my plan to change it:

1. I've run a trace for a couple of days to verify that there are no
jobs or processes that are connecting as SA and that would break if I
changed the password.

2. Before the changing the password I am going to bulk copy out the
sysxlogins row for SA so that if things go wrong I can reinset the old
data with the old unknown password (will that work?).

3. Log on to the console as Windows administrator and changing the SA
password.

Does that make sense? Anyone have any other suggestions?

Thanks.

View 1 Replies

LOST SA PASSWORD HELP!!

May 8, 2001

Hello all,

My company took over a project that another company was building. The other company switched all the passwords for the system and the database right before they left. No one has the passwords to the system or the database. Is there a way I can dump the data, or re-mount the drives into a different machine and get the data? Or am I just screwed? I have physical access to the machine and I can do anything needed I just need this data asap!!

TIA

Sean Silvius

View 3 Replies View Related

SA Password Lost

Jul 14, 1998

Hi All,

I have lost the system administrator password for my test server which contains
inf. which I cannot afford to loose. The SQL server documents state that if
the password is lost , then a SQL re-installation will have to be done.

Is anyone aware of a way to reset the password for SA without reinstalling the
SQL server.

Matter is most URGENT.

Regards

Vedanth

View 5 Replies View Related

Lost PASSWORd

Jun 28, 2004

Hie,
do you know how can i find a lost user password with the sa connection.
What is the difference between the connection and the user ?

View 2 Replies View Related

Lost The Sa Password

Oct 7, 2004

thanks a lot

View 2 Replies View Related

Password Lost

Aug 2, 2006

Hello,

I import a package into Integration Services (it containt 3 ole db connections to SQL Server), then I schedule this into a job.

When I run the job, it failed !

For the connections, I use a sql user and, in the step that run package, I notice that the password isn't store

I add password in the connection string ("Password=password;") and when I rerun the job, it terminate with success.

My question is: Is it possible to store the password directly into the package and so avoid password encoding several times ?

Regards

Arnaud

View 1 Replies View Related

SA Password Lost In MS SQL 2005

Oct 3, 2007

I need to retrieve the SA Password through MS SQL 2005. The reason why is I am trying to connect a number of computers in the same building for an Address Book to be shared by everyone. I will be using the program, Addressinator! to do this. But I need to have the SA password in order to connect the computers.
I am running Windows XP. I have read a few instructions on how to retrieve or make a new password on the net, but most of it doesn't make sense to me.

For Example, this is one that I found:
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. (I don't have the Enterprise Manager)
3. Right-click the server name and choose 'Edit SQL Server Registration properties'. (I can't find the 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.

I hope someone can help me out with this.
Thanks!

View 1 Replies View Related

I Need URGENT Help About Lost DTS Password

Oct 25, 2005

I forget my dts password for an dts on Sql 2000 SP3 .How can i reset or find my password for edit my DTS .I have db admin and sys admin user rights on this database.

View 1 Replies View Related

Package Configuration Xml And Lost Password

Mar 22, 2007

Hi to all!.

I tell you my problem...

I have an DB2 source and SQL destination. I have 2 ConnectionManager. One for DB2 (IBM DB2) and other for SQL. Both are of the OleDB type.

Well. I setup my connections and it work fine. Now i want to change my ConnectionManager for others sources or destinations. And I don't want to have to change the connection in more than forty packages.

For this, i have 2 XML configuration file in package configurations. One for connection. In this XML i have the connectionstring, user and password. These files are obtained in all the packages.

Well. If i change the connectionstring in this XML file configuration, only work fine the OLEDB for SQL. The conection for DB2 return the fail: "The AcquireConnection method call to the connection manager "_packagename_" failed with error code 0xC0202009."

I have proven to modify protectionLevel of the package to DontSaveSensitive. SQL work fine. DB2 fails. I have changed to EncryptSensitiveWithPassword. The same.

Why the packages obtain the data of connection of the configuration file for SQL and it does not work or with the configuration file for DB2.

This is bug?

Thanks to all!.

View 3 Replies View Related

Lost Sql Mail When Changing NT Domain

Oct 26, 2000

hi, I am not sure what happen. but I have lost the sql mail when I changed the from one user domain to another, any sugguestions on how to solve this issue

thanks for your help

Ahmed

View 1 Replies View Related

Lost Sa Password... 2005-&>2000 Conversion?

Mar 15, 2007

Hello, I'm running an MS SQL 2005 database which supports our entire website and it's fairly huge. I seem to have lost the sa password for the database.

I COULD get it back if there was a way to convert the SQL 2005 DB to an SQL 2000 DB, seeing as how I found a password cracker for that version. Is there anyway to convert a 2005 DB back to a 2000 DB?

Does anyone have any other ideas they might want to lay on me?

I'm kind of sick about this... I'm usually a really good note-taker; In fact, I do have the sa password recorded in an IT database that I keep. Unfortunately the password just doesn't work. I've tried the caps lock and other variations, but the password just eludes me.

Thanks for your help,
Chris

View 4 Replies View Related

Lost Sa Password... 2005-&&>2000 Conversion?

Mar 15, 2007

View 10 Replies View Related

Lost Server Registrations When Change Domain Password

Aug 4, 2006

I am using the Management Sudio Express and after I changed my domain password, I lost all of my SQL Server registrations.

I remember this was an old problem with SQL 2000 until a SP fixed it.

Any ideas?

-- VPDJ

View 1 Replies View Related

Slowly Changing Dimension - Lost Configuration On Package Open

Feb 28, 2008

Often when I open an SCD component that was previously configured I find that the configurations are lost. The "Input Columns" and the "Key Type" columns on the first screen ("Select a Dimension Table and Keys") are blank. The "Dimension Columns" column is still populated.

If I run the package, the SCD component appears to function the way it was configurated to function. However, the settings cannot be viewed.

Has anyone experienced anything similar? Any ideas why this happens?

Thank you.

View 2 Replies View Related

SSIS - Data Source Password Lost When Imported Into Integration Services

Apr 17, 2007

After designing a SSIS package in Visual Studio 2005 that had two connection manager defined to keep the password. After I deployed the package to a file system. I then Imported the .dtsx file after making a Integration Services connection in Sql Server Management Studio. When I tried to run the package it failed when it tried to make the connection. When I edited the connection manager connection string and added the password and the package ran fine but it does not retain the password!. I need to have this package scheduled to run daily so I need to know how to have the package keep the password in the connection string. I have seen other posts on this issue but not seen a good solution. Could someone point me to the proper MSDN article that would explain how to implement this ? Is it a SQL Server configuration issue or a property in Visual Studio SSIS design time ?

thanks.

View 4 Replies View Related

Changing The Sa Password

Aug 6, 1998

I`m running SQL 6.5 with standard security. We`re running NT 4.0. I am a member of the NT Admin group - which, of course, has sa privileges in SQL Server. I changed the sa password (via Enterpise Manager on my client machine); and it worked. I tested the password change by connecting to ISQL/w - both on my client machine and at the server machine.

However, when I attempted to connect to the server via Enterprise Manager (SEM) - on my client machine - my login attempt failed. But at the server machine, I connected just fine.

Somehow, even though we`re using standard security, I`m getting locked out of SEM because of the new password. Changing the sa password back to what it had been resolved the problem; but the old password was only meant to be temporary.

Any suggestions or explanations?

View 3 Replies View Related

Changing SA Password

Mar 27, 2007

Is there a thread that says what should we be looking for if I change password for SA?

I am new to the org here and have to clamp down on the SA logins.

This is what comes to my mind:

1.Client apps:
====================
a.Hard coded into VB apps
b.File DSNs
c.System DSNs

2.Web app:
================
a.Hard coded into .asp and .aspx
b..inc files that have collective connection strings.
c.Possible use of file DSNs
d.Possibly use of system DSNs

3.Ad-hoc Queries by Users
===============================

4.Maintenance Plans and Jobs etc.
=======================================
a. DTS packages
b. Replication

Is there anything else that you can add to this list will be helpful.
Regards
Paresh

Regards
Paresh Motiwala
Boston, USA

View 4 Replies View Related

Changing SA Password

Jun 9, 2007

Is there any strategy I should follow in order to change the SA password.Experts answers only. Thanks

=============================
http://www.sqlserverstudy.com

View 20 Replies View Related

Changing SA Password

Oct 5, 2007

After I have changed the SA password and attempt to login I get the following error.

A connection was successfully established with the server, but then an error occurred during the login process. (provider:Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error:233)

If I change the password back I can login without any problems. I need to change the SA password.

Thanks for any suggestions.

View 6 Replies View Related

Changing Sa Password On SQL Breaks SMS

May 31, 2002

Hello all,

When I changed the SQL sa account password (it was blank) and then tried to connect to SMS remotely via SMS Administrator Console, I get Connection Failed. It seemed to work for a about 20 minutes and then I get "Connection Failed" when I try to run the console remotely. I used the SQL Enterprise Manager to change the sa password and then I used the SMS Administrator Console to set its SQL Server account to sa with the new password under Site Properties. When I switched it to a blank password in SQL and SMS, it started working again.

From the Application Event Log I seem to be getting a lot of these messages (even now - and it's working):
"The description for Event ID ( 1001 ) in Source ( SQLCTR70 ) could not be found. It contains the following insertion string(s): SQL Server not running."

I have also gotten: "The Open Procedure for service "NM" in DLL "nmperf.dll" failed. Performance data for this service will not be available. Status code returned is DWORD 0. "

I don't see any messages from SMS in Event Viewer.

What am I doing wrong?

TIA for you assistance.

View 1 Replies View Related

User Changing Password

Jul 7, 2000

Can the user change their password in Enterprise Manager? When they follow the documentation, this does not seem to work
unless they are sa: (I know about sp_password....we are trying to find a GUI method for typical user.)

Expand a server group; then expand a server.
Expand Security; then click Logins.
In the details pane, right-click the login to modify, and then click Properties.
In Password, on the General tab, enter a new password.
Confirm the password.

View 2 Replies View Related

Cannot Start After Changing Password

Aug 4, 1999

Hi all,

I am using Administrator to log in the WinNT and I have just changed the password
of the Administrator. After that, I discover that I cannot use all function in the sql server.
Althougt the server is still running, I cannot open the database, login the security manager.

I have checked that the SQL Executive in NT service is assigned to local system account.
As you know, there is no place for inputting password. Where can I change the password
in order to let the function of sql server run again?

Thanks

View 1 Replies View Related

Changing The Mssql Password

Jul 10, 2004

I have SQL Server 2000 the Microsoft SQL Enterprise Mangaer version 8.0 and I don't know the password of sa account and I found this page where it shows how to change it and I tried it but it didnt work for me. Password didnt change
So what to do? Is there any way to see the current pw?

View 3 Replies View Related

Sa Password Keep Changing Automatically

Aug 17, 2004

I am working with MSDE, but some how the password for sa keep changing by itself. I can reset it by logging in windows authentication mode using osql, but the next day the password does not work again.
Please give me some suggestions

Mik

View 6 Replies View Related

Can't Connect Via EM After Changing Sa Password?

Jan 6, 2005

A client of mine changed his SA password "because it hadn't been changed in a while". :mad: Now nobody can get into Enterprise Manager - opening EM or trying to right-click > Connect on the server yields an error:

A connection could not be established to SERVER1.

Reason: login failed for user 'sa'.

Please verify SQL Server is running and check your SQL Server Registration
properties (by right-clicking on the SERVER1 node) and try again.

Of course, if I right-click on the SERVER1 node, I get the same message.

My client remembers the password he set; I managed to use it to get into Query Analyzer, which I thouhght was weird. But no luck with Enterprise Manager. It's just trying to log in as sa without prompting for a pw.

I already tried running sp_Password in Query Analyzer to change the pw back to what it was. Still can't connect to the SQL Server via Enterprise Manager.

What can I do?

View 3 Replies View Related

Changing Guest Password?!!!

Oct 18, 2005

Hi,
I know this seems odd but is there any way to change the guest's password?
I know this is paradoxical regarding the nature of guest user but if there is any way please clarify me!
-Thanks

View 3 Replies View Related

Cannot Access Database After Changing Password

Dec 11, 2006

that sounds obvious but I'm stuck...
I have an ASP.net application which someone else started and I continue.
on the SQL server there was a user X which was used to access the database from the ASP website.
I accidently changed the password in the SQL server and now I cant restore the prior settings
(trying to reset password to blank or embedding the username and password in the connection string didnt work).
it stops on "connection.open" with - "SQLException Login failed for user 'X'"
any ideas why that happens and how I can fix it?

thanks

View 1 Replies View Related

Changing SA Password In SQL Server 2005

Dec 14, 2005

How do you change the SA password in SQL Server 2005?

Thanks.
Doug

View 1 Replies View Related

Prevent User From Changing Password

Apr 17, 2011

Is there a way to prevent a particular user with SQL login from changing their password?

We have an application where we only want to prevent a certain user from changing their password but do not want to use windows authentication?

View 14 Replies View Related

Changing The Domain User Password

Apr 8, 2004

Is there an automatic way of changing the Domain user password getting used for running the SQL Server as a Domain user account? I'm taking about EM---Security----Domain User name and the password getting used for running the SQL Server?

View 1 Replies View Related

Changing 'sa' Password Breaks Replication

Apr 17, 2008

We are currently using continuous transactional replication from an OLTP type database to a Reporting database. We recently changed the 'sa' password for the first time since replication was introduced and now the Replication Log Reader job fails to start.

This is the error from the Job Log:

Message
2008-04-14 15:18:24.894 Copyright (c) 2005 Microsoft Corporation
2008-04-14 15:18:24.894 Microsoft SQL Server Replication Agent: logread
2008-04-14 15:18:24.894
2008-04-14 15:18:24.894 The timestamps prepended to the output lines are expressed in terms of UTC time.
2008-04-14 15:18:24.894 User-specified agent parameter values:
-Publisher OASV-SQL1
-PublisherDB georgiaoas
-Distributor OASV-SQL1
-DistributorSecurityMode 1
-Continuous
-XJOBID 0xCE146F975BC43043AB1ECBF42F801C43
-XJOBNAME OASV-SQL1-georgiaoas-1
-XSTEPID 2
-XSUBSYSTEM LogReader
-XSERVER OASV-SQL1
-XCMDLINE 0
-XCancelEventHandle 00000730
-XParentProcessHandle 0000075C
2008-04-14 15:18:25.034 Status: 0, code: 20015, text: 'Login failed for user 'sa'.'.
2008-04-14 15:18:25.034 Login failed for user 'sa'.

When we change the 'sa' password back to the previous value, we can start the Log Reader without issue.

We have tried restarting the SQL Server Agent process without success. We have not restarted the SQL Server process due to the server hosting production databases.

Any ideas?

View 1 Replies View Related

Changing Windows/SqlServer2005 Password

Jun 3, 2008

I have changed my windows password on my workstation, and the result is that I cannot now access the local databases and services resident on my workstation. I can still access all remote servers, but all attempts to access the local machine have failed. I even changed the password back to the original password, but this has had no effect.

Has anyone had any experience similar to this one? I am at a loss for things to try at this point.

View 12 Replies View Related

Changing XP Password Affects SQL Server?

Apr 27, 2006

hi folks,

has anyone experienced this issue?

When one changes the login password for XP, all the SQL Server groups are removed the next time you log into SQL Server 2000.

Is this a bug or a security feature, is there any way around it?

thanks for any help!

View 11 Replies View Related