I'm using Vb6.0
Database : SQL Server 2005.
In my vb6.0 installation file, add sql server 2005 and install automatically if not already installed.
sqlserver installation is installed properly when my software installation.No issues in Sql server 2005 installation.
Additional info: I install this exe file sql server 2005 "SQLEXPR.EXE"
here I have a question.
After install sql server 2005, how to reset or change the password for "sa"? At this stage, "sa" have no password.this is newly install sql server2005.so user have to set password.
I want to do this reset password by automatically using query.because user have no knowledge about the Sql server and settings.
How can I achieve this?
I guess explain clearly, if not please let me know.
Thanks in advance,