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


ADVERTISEMENT

Problems Changing An Expired Password In SQL Server 2005

Oct 10, 2007

Hi All,

My application supports both SQL Server 2005 and Oracle. Now, while chaging the password for the user WHOSE PASSWORD IS ALREADY EXPIRED .... the following code works fine for Oracle , but I dont know how to handle the same thing in SQL Server 2005.Please reply at your earliest.I am posting the code below which is creating the problem.


public static boolean changeExpiredPassword(User user, User newUser) throws SQLException, Exception
{
if (_logger.isDebugEnabled())
{
_logger.debug("changeExpiredPassword(User user=" + user + ", User newUser=" + newUser + ") - start");
}

boolean passwordChanged = false;
String url = null;
Properties dalProps = null;
Connection conn = null;
String sysIdentifier = null;

try
{
dalProps = DALManager.getInstance().getProperties();
url = dalProps.getProperty(DALConfigurator.URL);
if (url != null && url.indexOf("thin") > -1 && url.lastIndexOf(":") > -1)
{
int index = url.lastIndexOf(":");
sysIdentifier = url.substring(index+1, url.length());
url = "jdbcracleci" + sysIdentifier;
}

Properties props = new Properties();
props.put("user", user.getUsername());
props.put("password", user.getDecryptedPassword());
props.put("OCINewPassword", newUser.getDecryptedPassword());

if (DALManager.getInstance().isOracle() &&
url != null)
{
conn = DriverManager.getConnection(url, props);

if(conn != null && !conn.isClosed())
{
passwordChanged = true;
conn.close();
}
}
if (DALManager.getInstance().isSqlServer() &&
url != null) // This condition becomes true if we are connected to SQL Server 2005
{
/// Over here , the connection object is Returning the NULL value since the I have loaded the Properties ( props.put ) with Oracle specifice syntax it ( i.e. OCINewPassword ) . I dont know what to code if its connected to the SQL Server 2005 itstead of Oracle.
conn = DriverManager.getConnection(url,props); // This part fails

if(conn != null && !conn.isClosed())
{
UsersQueryModule.changePassword(user.getUsername(), user.getDecryptedPassword(), newUser.getDecryptedPassword(), false);
passwordChanged = true;
conn.close();
}
}
}
catch (SQLException e)
{
_logger.error("changeExpiredPassword(user=" + user + ", newUser=" + newUser + ")", e);
throw new AxisFault("Expired password cannot be changed. Possible cause may be TNS Name does not match with Oracle SID. Please consult the System Administrator.");
}
catch (Exception e)
{
_logger.error("changeExpiredPassword(user=" + user + ", newUser=" + newUser + ")", e);
throw e;
}
finally
{
if (conn != null && !conn.isClosed())
conn.close();
}

if (_logger.isDebugEnabled())
{
_logger.debug("changeExpiredPassword(User, User) - end - return value=" + passwordChanged);
}
return passwordChanged;
}

View 3 Replies View Related

Changing SQL 2005 Password Policy Not Working

Feb 19, 2007

I have modified the Security Settings>Account Policies>Password Policy on my PC as follows:

Minimum password length: 10 characters

Password must meet complexity requirements: Enabled

However, when creating a login within SQL Server 2005, which does not adhere to the amended policy, this does not seem to be taken into account:

CREATE LOGIN testlogin WITH PASSWORD='a',

DEFAULT_DATABASE=[master],

DEFAULT_LANGUAGE=[us_english],

CHECK_EXPIRATION=ON, CHECK_POLICY=ON

have tried restarting the SQL Server and rebooting the PC, but this does not solve the problem.

View 7 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

Unable To Restart MSSQL Server After Changing My NT Password

Nov 22, 2000

I have recently changed my NT password and since then one of my machines has not been able to start MSSQL server. When I re-boot the machine it lets me know that it was unable to start MSSQL server. If I right click on the SQL server group in EM and try to manually start the service, it tells me that I have a login failure. I don't understand how changing my NT password would affect one machine and not the others. When I right click on the "edit SQL service registration properties" tab, all of the machines are using the NT password selection as opposed to the SQL server authentication password. Any ideas would be greatly appreciated

View 1 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

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 nojobs or processes that are connecting as SA and that would break if Ichanged the password.2. Before the changing the password I am going to bulk copy out thesysxlogins row for SA so that if things go wrong I can reinset the olddata with the old unknown password (will that work?).3. Log on to the console as Windows administrator and changing the SApassword.Does that make sense? Anyone have any other suggestions?Thanks.

View 1 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

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 The Password For SQL Service Account

Apr 16, 2008

We are running SQL Server 2000 on two servers and when they were built, the same domain account was used for all installations, and the MSSQLSERVER and SQLServerAgent services run logged in as that same account. That account is also the dbo of all the SQL databases. We now need to change the password and possibly disable that domain account.

What do we need to do to make sure the SQL Servers and databases continue to run without problems after making the password change and/or disabling the account?

I appreciate any advice!

View 6 Replies View Related

Specified Module Could Not Be Found By Changing Password

Dec 20, 2007

Hi,

I tried to change / add password in SQL Server Compact Edition 2005 (in Mobile 5.0) via SQL Server Management Studio. As a result I got an error: "The specified module could not be found." I wonder why and how can I change the (blank) password to a new one?

Regards and thanks in advance,
Mixxo

View 4 Replies View Related

Problem In Changing Account Name, Password

Jun 29, 2006

Hi

I installed SQL Server 2005 Express Edition. When I try changing the account name, password in the SQL Server Configuration Manager, i.e. by clicking on Apply, the SQLEXPRESS restarts and the password gets replaced by a longer password. Also the user name gets prefixed with "./". Any help on this will be highly appreciated.

Another query: Do we have the query analyser (gui or command line) kind of thing in Express Edition? Also where can I get a proper documentation of doing elementary things in setting up a database, like creating a database, adding a user, etc)

Thanks and Regards
Roopesh

View 4 Replies View Related

Changing User Accound And Password

Oct 15, 2007



I tried to cahnge this account option to built in account option in SQL ( MSSQLSERVER) properties box. Then SQL Server was log on as Local system. But then I can not view my reports which i created. Now I changed it again to this account option. but I dont exaclty remember the password. Is there anyway I can get to know the password I created.

Thanks

View 1 Replies View Related

Application Roles - Changing Password

Mar 13, 2007

Hello,

 

in SQL Server 2005 I have an application role that is being used to limit access to my server data from third party applications. Everything is working well, except changing the Application role password.

I set up a small form that allows an administrator to change the App Role password through the front end app. I cannot, however, seem to get the Password field in my approle to accept a parameter.

For example:

declare @newpassword varchar(128)

set @newpassword = 'foo'

ALTER APPLICATION ROLE MyApplicationRole

with PASSWORD = @newpassword

This procedure gives me a syntax error in the last line. It will accept a string in quotes but not a varchar parameter.

 

Ideas?

View 3 Replies View Related

Changing Sa Password Causes Scheduled Tasks To Fail.

Feb 8, 2000

I recently changed the SA password on my SQL Server 6.5 installation and discovered that this had caused the Scheduled CmdExec Tasks (defined in SQL Executive) to fail with:

"Process Exit Code 1. Microsoft (R) SQLMaint Utility, Version 6.50.240 Copyright (C) Microsoft Corporation, 1995 - 1996 [Microsoft SQL-DMO] Error 4002: [SQL Server] Login failed"

Changing the password back to the original resolves the problem, but is a less than satisfactory solution.

Any advice on how I can change the SA password and allow CmdExec tasks to continue running would be gratefully appreciated.

View 1 Replies View Related

Replication :: Changing Password For Remote Distributor

Jul 22, 2015

We have inherited a remote distribution db where the password has been lost.  I would like to confirm that if you change the password in the distributor properties-->publishers--> administrative link password that the password will be changed on all publishers without having to resnap the publications?

View 3 Replies View Related

Changing The Administrator Password MURDERED My Reports!

Nov 18, 2007

Hi. I changed the Administrators Login password on my web & data base servers, both of which are hosted on Windows Server 2003 and run iis6. This caused the reports (I'm using 2005 Reporting services) to stop running. Rather I get the error: "The request failed with HTTP status 401: Unauthorized"



I made the necessary adjustments to the web.config and the reports just won't run. I have been struggling over this all day. Can anyone offer me some advice?

Thanks

HP

View 1 Replies View Related

SQL 2005 SP2 - Windows 2003 Ent SP1 - Password Does Not Meet The Password Policy DLL

Jun 18, 2007

I am receiving the following error message when attempting to create a new SQL Authenticated login id.



Password validation failed. The password does not meet the requirements of the password filter DLL. (Microsoft SQL Server, Error: 15119)



I have four servers all running SQL Server 2005 SP2 on Windows 2003 Ent. SP1. Of the four servers, only one received the above error message using the same TSQL below.



CREATE LOGIN TEST_LOGIN WITH PASSWORD = 'pvif9dal' MUST_CHANGE, CHECK_EXPIRATION = ON



All four servers are in the same domain, which if I understand correctly, the password policies are therefore inherited at the OS level by the domain. The password being used is within the password policies of the domain.



Any ideas as to a root cause?

View 5 Replies View Related

Integration Services :: Package Failed After Changing Password In Shared Data Source

Jun 19, 2015

I'm using a shared data source to connect an Oracle server in my packages.  After changing the database user password in the shared data source, I noticed the package concerned would fail with the following description.

Source: "OraOLEDB"  Hresult: 0x80004005  Description: "ORA-01017: invalid username/password; logon denied".

Is there a way to ensure the packages will use the latest information in the shared data source?  I did do a Rebuild before executing the packages.

View 5 Replies View Related

Do We Have Password Type In Sql Server 2005?

Mar 12, 2007

Hi guys,anybudy know the thing as title?And does sql server has the func. to transfer plain txt to encryt. text? Cheers, Elton 

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved