Solved

msSql Password Change

Posted on 2006-07-23
2
427 Views
Last Modified: 2010-04-05
hi experts
How i can Change or set MSSQl database Password?
0
Comment
Question by:mahdiparak
2 Comments
 
LVL 4

Accepted Solution

by:
LMuadDIb earned 500 total points
ID: 17163636
how are you connecting to the database? ADO connection?

bascailly all you have do is:

' Connect to the database
' Create the SQL string to change the database password.
 strAlterPassword := "ALTER DATABASE PASSWORD [NewPassword] [OldPassword];";

'  Execute the SQL statement now...


here is an example:
http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/Q_21900292.html
0
 
LVL 12

Expert Comment

by:Ivanov_G
ID: 17170021
In MS SQL Server you don't have password in the same way as Access. You can change user password. It that what you want?
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now