Solved

msSql Password Change

Posted on 2006-07-23
2
432 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

749 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