Solved

msSql Password Change

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

786 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