Change SA Password

Dec 17, 2007

Hi All,

I am newbie at SQL server, we have sql 7.0, sql2000 and sql2005. we need to change SA password but developers claim they have hardcode the SA password.

anyone can tell me where developers hardcode this SA password? what are the files i need to look up? if they hardcode it, impossible to change?

any ideas and thoughts are welcome.

Thanks in advance

Regards

Nonie

View 3 Replies


ADVERTISEMENT

Can't Change SA Password

Apr 20, 2001

I have one server out of 6 that lets me logon as SA with the default password
of null.
If I run this command to change the password I get password changed, but it
did not change it, I still can logon as SA with the NULL password.

exec sp_password NULL, abc123, 'sa'

View 2 Replies View Related

Password Change (I Think)

May 4, 2000

The old administrator left and I am learning slowly. Since his password was changed, SQL cannot start. I get an error 1069 login failed. Maybe you have a good idead I haven't thought of?

View 1 Replies View Related

Change Sa Password

May 7, 2001

I changed the sa password now all my jobs fail, if
I change the password back to what it was they run.
Any insight is appreciated.
Thanx

View 2 Replies View Related

Change SA's Password

Sep 20, 2005

I've searched this forum and was surprised to not find this asked before - Is there any way to change SA's password (we have managed to lose it somehow)? And we do have physical access to our SQL Server of course...if that helps.

thanks in advance,
jamie

View 4 Replies View Related

How To Change Password

Jul 17, 2006

We have change administrator password. How can i change the sql server job password, so that the maintain plan work fine as before. Thanks.

View 4 Replies View Related

Where Should I Change Password

Aug 28, 2006

Dear experts,
i'm getting problem with sql server 2000. actually i changed the service from automatic to manual, right from that day,sql server is not working on my machine.when i checkd in the properties of sql server registration, it is showing some around 8 letter password. actually i will connect with sa and password sa.

where should i change the password? is there any other solution?

or is it better to uninstall and install again? if so what about my databases?


please help me in this regard

View 12 Replies View Related

Change Password

Jan 11, 2007

ikram writes "i have to changed the password of sql server and after password change it is not assassable form the network. some of my friend tell me that you will have to change some configuration form server side file. he dont know that file exactly. please tell me the soloution.

regard."

View 1 Replies View Related

CHANGE PASSWORD

Jan 9, 2008

Any way to change the password on QA without knowing the old password?



http://www.sqlserverstudy.com

View 6 Replies View Related

FTP Password Change

Apr 15, 2008

I have a SQL JOB that I inherited that uses FTP to xmit some data. When I attempt to change the password within the FTP job a window warns me that files will be deleted. My question is are these files just sytem buffers or will any important files get the axe ? Thx in advance. Lou

View 4 Replies View Related

Change Database Password

Sep 8, 2007

I have a SQL database hosted on a server. This server supports SQL Sever 2000. How do I change the password to the password?Thanks in advance, 

View 1 Replies View Related

Change Password On Sql 2000?

Apr 4, 2008

I am trying to change password, using the code below.. The code below is in a stored proc and I am passing these parameters from a web application.....
 sp_password [ [ @old = ] 'old_password' , ]     { [ @new =] 'new_password' }     [ , [ @loginame = ] 'login' ]
 
sp_password 'cust1','cust2','cust1'
Server: Msg 15210, Level 16, State 1, Procedure sp_password, Line 20Only members of the sysadmin role can use the loginame option. The password was not changed.
I made my user part of the db_securityadmin role, but that does not help...
How can I give the above mentioned permissions, so that when user cust1 logs on then he can chnage his own password from the web application as long he has given his old password correctly?
 

View 3 Replies View Related

Osql -- Change Password

Apr 3, 2001

When using osql from a command prompt the following script was run:
EXEC sp_password 'Current Password', '', 'TestLogin'

We were trying to set a password for a login to blank, but now cannot access login into the application because the application was looking a blank password for this user but the password would not work for blank.

Note ---This client only has MSDE installed, not SQL Enterprise.

If the script is run from Query Analyzer it works fine.

The script should have been this:
EXEC sp_password 'Current Password', Null, 'TestLogin'


It should have explictly stated NULL for the new password but it wasn't done.

Is there anyway to reset the password without knowing the existing password.
No other logins exist. They tried logging into the system with no password, '',"".
I am not sure what the password was set to.

View 3 Replies View Related

How Do I Change (multiple) 'sa' Password.

May 24, 2001

Howdy - I am using SQL 7.0. I have done some research using the Books On Line and I do not find any documentation on how to change the sa password using a SQL Script. Can anyone point me in the right direction?

View 1 Replies View Related

How To Change Sa Password After Installation?

May 27, 2004

I just installed MS SQL SERVER2000, but seems the password I was setting didn't look good. So I want to change it, but how? Thanks!

View 2 Replies View Related

Change Username And Password

Sep 30, 2006

Hello

I newly installed the SQL Server 2005.During installation i chose the option Mixed Mode.I aslo did nit mention any user name and password to the SQL Server.Iam able successfully create Databases using the SQL Server Management Studio.
My problem iam unable to connec to the SQL Server from my .net windows application.My application code is

Dim strCon As String
Dim sValue As String
Dim strQuery As String
Dim dsEventTransac As New DataSet
Dim daEventTransac As New SqlClient.SqlDataAdapter
Dim rowCount As New Integer
Dim oWebService As New WebReference.TkmService
'Dim nwRow As DataRow
'Dim delCmd As SqlClient.SqlCommand


strQuery = "SELECT * FROM EventTransaction"

strCon = "Data Source=localhost;integrated security=SSPI;initial catalog=KmsDb;User ID=sa;password="
objCon = New SqlClient.SqlConnection(strCon)
If objCon.State = ConnectionState.Closed Then
objCon.Open()
End If
daEventTransac = New SqlClient.SqlDataAdapter(strQuery, objCon)
Dim cmdBuilder As New SqlClient.SqlCommandBuilder(daEventTransac)
daEventTransac.Fill(dsEventTransac)

'update the DataAdapter
daEventTransac.Update(dsEventTransac)
oWebService.Url = "http://192.168.0.10/TkmService1/TkmService.asmx"

''display the table in a grid
dgEventTransac.DataSource = dsEventTransac.Tables(0)

Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub

Private Sub DataGrid1_Navigate(ByVal sender As System.Object, ByVal ne As System.Windows.Forms.NavigateEventArgs) Handles dgEventTransac.Navigate

End Sub
End Class

When i donot specify user ID and password i get connected correctly.But when i run the above code i get an error
"Unable to connect to the remote server"
Now i want to change the username and password.Please tell me how to do

View 2 Replies View Related

How To Change The User Name And Password

Sep 30, 2006

Hello

I newly installed SQL Server 2005 .I did not mention any username and password during installation.But now i want to specify one.Can you tell me how to do so .My Operating System is WindowsXp.

Thanks In Advance
Poornima

View 2 Replies View Related

Last Password Change Date

Feb 21, 2008

Theres a script that the SQL workprogram instructs someone to run which shows the last change date for a users password.
Within the results of the script theres two rows of dates and I would like to know which date indicates the "last password change date"

View 2 Replies View Related

Change 'SA' Password At Sql Server

Mar 11, 2008

Hi All,

we plan to change SA password and there are 2 servers running on replication.

what are the precautions that i have to consider?

what is the fallback plan should changing SA password causing other error/ bugs?

can somebody tell me the exact steps to change SA password for this kind of environment?

thanks in advance.

-Nonie

Nonie

View 6 Replies View Related

Password Change Problem

Jan 25, 2008

We have an application using SQLDMO tried to change password. From the trace file, it seems the application used a "SP_password" and the operation failed. However, the application returns its own message which doesn't help us at all in finding the reason. I wonder if SQL server can somehow track the operation(password change) and report a message if it failed.
Does anybody know if SQL server 2005 have such type of functionality? Or what could be the possible reasons of the operation failed. (The new passowrd fullfill the requirement of window policy.)

Thanks

View 4 Replies View Related

SQL Security :: How To Change SA Password

Apr 28, 2015

We are wanting to change the SA password on one of our Sql server 2012. My question is what are the implications? Will our agent jobs still run? SSIS packages still run under agent jobs? Is there a proper way/how to change SA password?

View 3 Replies View Related

How To Change Password To Dts Package Programmatically?

Jun 19, 2007

Hi,
 I was wondering if it is possible to change the password on a SQL Server 2000 DTS package programatically instead of justmanually using the the interface?
 I have over 150 DTS packages  used for building BI data cubes and our password policy requires a password change every 60 days.
I would like to write a windows vb.net application that loops through all the DTS packages and changes the password.
 Please advise.
 Thanks
 Chris

View 2 Replies View Related

SQL 2000 Password Change Form...?!?

Jul 23, 2007

I am looking to create an ASP w/ functionality to change user's SQL password.  Many do not have access to EM or Query Analyzer and need a website to visit.  Has any had expirience w/ this prior?

View 19 Replies View Related

Setting Up MSDE - How To Change SA Password?

Feb 13, 2004

I have installed WebMatrix and MSDE and have been able to successfully make a connection from WebMatrix to MSDE. I am used to using SQL Server with Enterprise Manager but I do not have that available to me right now so I'm using MSDE instead. I followed the setup instructions on the WebMatrix tutorial and setup MSDE with an SA password. I would now like to change the password to something else. Is there a command that I can use to do that? There is no Enterprise Manager so I'm kind of stumped. Thanks in advance for your help.

Kathleen

View 3 Replies View Related

How Can I Change Password Of SQLServer2005/Expres ?

Dec 13, 2005

ow can I change password of SQLServer2005/Expres ?

View 1 Replies View Related

Sys Admin Account Password Change

Jun 20, 2000

If someone can tell if it is wise change the SA account password after all of your databases have been set up using NT Authentication for login. Also, by using the sa password at login are you providing more security and and who should have access to that password (Your developers or your Administrators?)

Thanks

View 3 Replies View Related

Service Account Password Change - Help!

Dec 3, 1999

Ugh! Someone changed the password of our SQL Server service account. It is called syssql, and it is used by the MSSQLServer and SQL Executive services to log in at startup. After the password was changed, we noticed that replication wasn’t running, and since I know that replication uses the Executive service, I restarted that service using the new password. That worked to get replication working again, and since the boxes were production machines I didn’t restart the MSSQLServer service with the new password yet. Now, our syssql account keeps on locking up every so often, and scheduled tasks that use xp_sendmail stopped working, and alerts stopped sending. Is this happening because of the MSSQLServer service still being logged in with the old password? I suspect that the SQL Mail logs in through the MSSQLServer service, which is still using the old password, and the login failures are causing the syssql account to lock. Any other ideas???

Cindy Rutherfurd
cindy.rutherfurd@zcsterling.com

View 2 Replies View Related

SQL Authentication Error On Password Change

May 30, 2005

I have instaled SQL Server2000 in Administrator user login.My OS is Windows Adavance Server2000. It works Fine. If i change my Administrator Password and Login with the new Password then Sql Server dosn't Run.It says Authentication error if i try to run from service.
I belive DBA's in this forum can help me out.

View 2 Replies View Related

Allowing SQL Users To Change Password

Jan 26, 2004

Hi guys,

Is there anyway to allow SQL Server users to change their own passwords without giving them rights to "db_securityadmin" ?

Our M$ adviser suggested creating our own app using SQL NS and DMO to do it.

Is there any easier method, reference, download sample from the web?

View 3 Replies View Related

SQL 2012 :: Change SERVER Log On Password

Aug 14, 2014

What issues will I encounter if I change the MSSQLSERVER password?

View 2 Replies View Related

How To Change The User Account And Password

May 23, 2008

HI,

I m swagatika and working on a s/w company.I am facing some problem in MS SqlServer2005.

my problem is:-

i installed sql server2005 completely .At the install time , i set the username='xyz' and password=blank (windows authentication mode).

Now i want to change my user account to 'sa' and password to blank.

After installation,how to change the user account and password.

Please can anybody help me ?

View 3 Replies View Related

Can't Change Sql Login User's Password

Jan 13, 2006

SQL Server 2005 Express will not allow me to change the password for my login user. I tried deleting the user and re-creating the user. Another password is being put in although the password I put in was accepted. I even test to see what would happen if I left the password blank. It got accepted. But when I look at the password for my login user again, a different and much longer password was put in. I even tried this T-SQL statement:

CREATE LOGIN <loginname> WITH PASSWORD='<passwordname>', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF

I am out of ideals. Is this a bug?

View 5 Replies View Related

Jobs Fail After Sa Password Change

Feb 7, 2007

Hello,

It is our yearly procedure to change the sa password.
This time we do it for the first time in ss2005.
After changing the sa password, all jobs fail with the following error:

MessageLogin failed for user 'sa'. [CLIENT: <local machine>]
MessageError: 18456, Severity: 14, State: 8.

When i check the properties of the job i can see (in the general tab) that all jobs are running through Windows authentication.

Any newly created jobs run successfull.
What do i do wrong?

Any help is appreciated.

Best regards,

Harry

View 4 Replies View Related







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