Question

  Asked: Jun 9 2008   3:22 PM GMT
  Asked by: SQL Server Ask the Experts


Using DTS objects for scripts to alter SQL Server password


SQL Server, DTS, Scripts, Scripting

Is it possible to use DTS objects to create scripts to alter the SQL Server password I assigned when I installed the server?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



You can change the password for the sa account using the sp_password procedure provided that you have sysadmin rights to the SQL Server. The syntax is:

exec sp_password @new='Your New Password', @loginame='sa'


DTS is not normally used for user management.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server, Development and Microsoft Windows.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Jun 9 2008  10:39PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.