Get values from database query

I have written the following lines

myConnection =New MySqlConnection("server=" + dbServer +"; user id=" + dbUserID +"; password=" + dbPassword +"; database=" + dbName +"; pooling=false;")strSQL ="SELECT * FROM user where type=1;"

user table has name, tel, addr, id, type fields

I would like to know how to use a string array to store the name in the result of strSQL?

Thank you

Hi thtang

You can use fllowing code:

SqlCommand cmd = new SqlCommand(myConnection ,strSQL );

SqlDataReader dr = cmd.ExecuteReader();

while(dr.Read())

{

stringList.Add(dr.GetString(0));

}

Get Value to Return to VB.Net

I have the following stored procedure:
ALTER Procedure spInsert
@.UserName char(50),
@.Password char(15),
@.EmailAddress char(60),
@.TCoName char(50),
@.TCoAddress char(50),
etc.
@.UserID int OUTPUT,
@.TCoID int OUTPUT
AS
INSERT INTO tblLogin
VALUES
(
@.UserName,
@.Password,
@.EmailAddress
)
Declare @.Ident int
Select @.UserID = @.@.IDENTITY
Select @.Ident = @.UserID
INSERT INTO tblTCompany
VALUES
(
@.Ident,
@.TCoName,
@.TCoAddress,
etc.....
)
Declare @.Ident2 int
Select @.TCoID = @.@.IDENTITY
Select @.Ident2 = @.TCoID
I need to grab the @.Ident2 value into VB.Net (for a Web App). How do I get
the two applications to "talk" to each other?
Any suggestions will be greatly appreciated!
Sandy> I need to grab the @.Ident2 value into VB.Net (for a Web App).
You have a couple of options. One method is to return the value as a result
set:
SELECT @.Ident2
Another technique is to return the value as an OUTPUT parameter:
ALTER Procedure spInsert
@.UserName char(50),
@.Password char(15),
@.EmailAddress char(60),
etc.,
@.Ident2 OUT
AS
...
GO
Hope this helps.
Dan Guzman
SQL Server MVP
"Sandy" <Sandy@.discussions.microsoft.com> wrote in message
news:F826D886-345C-48DF-BE65-3725BA80E920@.microsoft.com...
>I have the following stored procedure:
> ALTER Procedure spInsert
> @.UserName char(50),
> @.Password char(15),
> @.EmailAddress char(60),
> @.TCoName char(50),
> @.TCoAddress char(50),
> etc.
> @.UserID int OUTPUT,
> @.TCoID int OUTPUT
> AS
> INSERT INTO tblLogin
> VALUES
> (
> @.UserName,
> @.Password,
> @.EmailAddress
> )
> Declare @.Ident int
> Select @.UserID = @.@.IDENTITY
> Select @.Ident = @.UserID
> INSERT INTO tblTCompany
> VALUES
> (
> @.Ident,
> @.TCoName,
> @.TCoAddress,
> etc.....
> )
> Declare @.Ident2 int
> Select @.TCoID = @.@.IDENTITY
> Select @.Ident2 = @.TCoID
> I need to grab the @.Ident2 value into VB.Net (for a Web App). How do I
> get
> the two applications to "talk" to each other?
> Any suggestions will be greatly appreciated!
> Sandy|||Hi Dan -
Thanks for your reply. How do you refer to the value in VB.Net, though?
What's the VB code you would write?
Sandy
"Dan Guzman" wrote:

> You have a couple of options. One method is to return the value as a resu
lt
> set:
> SELECT @.Ident2
> Another technique is to return the value as an OUTPUT parameter:
> ALTER Procedure spInsert
> @.UserName char(50),
> @.Password char(15),
> @.EmailAddress char(60),
> etc.,
> @.Ident2 OUT
> AS
> ...
> GO
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Sandy" <Sandy@.discussions.microsoft.com> wrote in message
> news:F826D886-345C-48DF-BE65-3725BA80E920@.microsoft.com...
>
>|||Sandy,
Here's my table definition
CREATE TABLE dbo.Report (
ReportID int IDENTITY (1, 1) NOT NULL ,
Descr varchar (50) NOT NULL ,
ReportName varchar (50) NOT NULL
)
And the associated SP. Notice the @.ReportID as OUTPUT
and the SET @.ReportID as the last statement. That
returns the identity value in the OUTPUT parameter.
---
CREATE PROCEDURE dbo.usp_Report_Ins
@.Descr varchar(50),
@.ReportName varchar(50),
@.ReportID int OUTPUT
AS
INSERT INTO dbo.Report (
Descr,
ReportName
)
VALUES (
@.Descr,
@.ReportName
)
SET @.ReportID = SCOPE_IDENTITY()
This is a snippet of the Insert code. I use the the
Microsoft Data Access Application Block to do the
SQL stuff (SqlHelper statements) to update the DB.
Use whatever code works there. The last statement
retrieves the value of the identity field.
---
Dim params() As SqlParameter = New SqlParameter(2) {}
params(0) = New SqlParameter("@.Descr", Reports.Descr)
params(1) = New SqlParameter("@.ReportName", Reports.ReportName)
params(2) = New SqlParameter("@.ReportID", Reports.ReportID)
params(2).Direction = ParameterDirection.Output
SqlHelperParameterCache.CacheParameterSet(ConnectionSettings.cnString,
_
"usp_Report_Ins", params)
Dim result As Integer =
SqlHelper.ExecuteNonQuery(ConnectionSettings.cnString, _
CommandType.StoredProcedure, "usp_Report_Ins",
params)
dim PrimaryKey as Integer = CInt(params(2).Value)
On Thu, 10 Feb 2005 07:09:02 -0800, "Sandy"
<Sandy@.discussions.microsoft.com> wrote:
>Hi Dan -
>Thanks for your reply. How do you refer to the value in VB.Net, though?
>What's the VB code you would write?
>Sandy
>
>"Dan Guzman" wrote:
>|||larzeb's example shows how you can get a parameter output value. To
retrieve a value returned as a single-row single-column result, you can use
a number of methods, such as SqlCommand.ExecuteScalar,
SqlCommandExecuteReader or SqlDataAdapter.Fill.
Hope this helps.
Dan Guzman
SQL Server MVP
"Sandy" <Sandy@.discussions.microsoft.com> wrote in message
news:EBDC9678-1001-4809-A0C5-A524115190B0@.microsoft.com...
> Hi Dan -
> Thanks for your reply. How do you refer to the value in VB.Net, though?
> What's the VB code you would write?
> Sandy
>
> "Dan Guzman" wrote:
>

Get the sa password possible?

Hello,
Is it possible to get or change the existing sa password for microsoft
sql server 2000 as i've forgotten it?
I'm able to use Enterprise Manager by via Windows Authentication, but
i need to connect to a database with SQL Authentication.
Thanks,
jack.Hello,
YOu can not see the password, but you can change the password. All you have
to do is:-
1. Login into the query analyzer using windows authentication
2. Execute the below query to change the SA password
sp_password NULL,'Newpassword','sa'
This will change the password of SA to a new password. THis will work well
if you r windows user is part od Admin group.
Thanks
Hari
"Jack" <bradnerdhss@.hotmail.com> wrote in message
news:1171849045.996306.258230@.s48g2000cws.googlegroups.com...
> Hello,
> Is it possible to get or change the existing sa password for microsoft
> sql server 2000 as i've forgotten it?
> I'm able to use Enterprise Manager by via Windows Authentication, but
> i need to connect to a database with SQL Authentication.
> Thanks,
> jack.
>|||On Feb 19, 11:19 am, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> YOu can not see the password, but you can change the password. All you hav
e
> to do is:-
> 1. Login into the query analyzer using windows authentication
> 2. Execute the below query to change the SA password
> sp_password NULL,'Newpassword','sa'
> This will change the password of SA to a new password. THis will work well
> if you r windows user is part od Admin group.
> Thanks
> Hari
> "Jack" <bradnerd...@.hotmail.com> wrote in message
> news:1171849045.996306.258230@.s48g2000cws.googlegroups.com...
>
>
>
>
> - Show quoted text -
Yes thanks. That worked perfectly.
Jack.

Get the sa password possible?

Hello,
Is it possible to get or change the existing sa password for microsoft
sql server 2000 as i've forgotten it?
I'm able to use Enterprise Manager by via Windows Authentication, but
i need to connect to a database with SQL Authentication.
Thanks,
jack.
Hello,
YOu can not see the password, but you can change the password. All you have
to do is:-
1. Login into the query analyzer using windows authentication
2. Execute the below query to change the SA password
sp_password NULL,'Newpassword','sa'
This will change the password of SA to a new password. THis will work well
if you r windows user is part od Admin group.
Thanks
Hari
"Jack" <bradnerdhss@.hotmail.com> wrote in message
news:1171849045.996306.258230@.s48g2000cws.googlegr oups.com...
> Hello,
> Is it possible to get or change the existing sa password for microsoft
> sql server 2000 as i've forgotten it?
> I'm able to use Enterprise Manager by via Windows Authentication, but
> i need to connect to a database with SQL Authentication.
> Thanks,
> jack.
>
|||On Feb 19, 11:19 am, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> YOu can not see the password, but you can change the password. All you have
> to do is:-
> 1. Login into the query analyzer using windows authentication
> 2. Execute the below query to change the SA password
> sp_password NULL,'Newpassword','sa'
> This will change the password of SA to a new password. THis will work well
> if you r windows user is part od Admin group.
> Thanks
> Hari
> "Jack" <bradnerd...@.hotmail.com> wrote in message
> news:1171849045.996306.258230@.s48g2000cws.googlegr oups.com...
>
>
>
> - Show quoted text -
Yes thanks. That worked perfectly.
Jack.

Get the sa password possible?

Hello,
Is it possible to get or change the existing sa password for microsoft
sql server 2000 as i've forgotten it?
I'm able to use Enterprise Manager by via Windows Authentication, but
i need to connect to a database with SQL Authentication.
Thanks,
jack.Hello,
YOu can not see the password, but you can change the password. All you have
to do is:-
1. Login into the query analyzer using windows authentication
2. Execute the below query to change the SA password
sp_password NULL,'Newpassword','sa'
This will change the password of SA to a new password. THis will work well
if you r windows user is part od Admin group.
Thanks
Hari
"Jack" <bradnerdhss@.hotmail.com> wrote in message
news:1171849045.996306.258230@.s48g2000cws.googlegroups.com...
> Hello,
> Is it possible to get or change the existing sa password for microsoft
> sql server 2000 as i've forgotten it?
> I'm able to use Enterprise Manager by via Windows Authentication, but
> i need to connect to a database with SQL Authentication.
> Thanks,
> jack.
>|||On Feb 19, 11:19 am, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> YOu can not see the password, but you can change the password. All you have
> to do is:-
> 1. Login into the query analyzer using windows authentication
> 2. Execute the below query to change the SA password
> sp_password NULL,'Newpassword','sa'
> This will change the password of SA to a new password. THis will work well
> if you r windows user is part od Admin group.
> Thanks
> Hari
> "Jack" <bradnerd...@.hotmail.com> wrote in message
> news:1171849045.996306.258230@.s48g2000cws.googlegroups.com...
>
> > Hello,
> > Is it possible to get or change the existing sa password for microsoft
> > sql server 2000 as i've forgotten it?
> > I'm able to use Enterprise Manager by via Windows Authentication, but
> > i need to connect to a database with SQL Authentication.
> > Thanks,
> > jack.- Hide quoted text -
> - Show quoted text -
Yes thanks. That worked perfectly.
Jack.

Get sa password

Hey,
I admin an company with MS SQL-Server. They forget the sa-password. Is there
any way to get the password from an running sql-server? I need it for
SQL-Backup!
Thanks for answere
Frank
Are you using mixed mode that has an NT account with sysadmin rights? if so,
log that account then change the sa password.
What version are you running?
Thomas
"Frank Moskopp" wrote:

> Hey,
> I admin an company with MS SQL-Server. They forget the sa-password. Is there
> any way to get the password from an running sql-server? I need it for
> SQL-Backup!
> Thanks for answere
> Frank
>
>
|||I have no access with my NT accounts. The company run SQL-Server 2000.
Thanks for more information
Frank
"Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...[vbcol=seagreen]
> Are you using mixed mode that has an NT account with sysadmin rights? if
> so,
> log that account then change the sa password.
> What version are you running?
>
> --
> Thomas
>
> "Frank Moskopp" wrote:
|||What service account is SQL running under ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
news:djrccf$qtb$1@.newsreader3.netcologne.de...
>I have no access with my NT accounts. The company run SQL-Server 2000.
> Thanks for more information
> Frank
>
> "Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
>
|||If you have NT authentication enabled you should be able to logon as a local
administrator and then change the sa password (this assumes that builtin
admins has not been removed from SQL)
http://vyaskn.tripod.com/administration_faq.htm#q9
Thomas
"Frank Moskopp" wrote:

> I have no access with my NT accounts. The company run SQL-Server 2000.
> Thanks for more information
> Frank
>
> "Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
>
>
|||Hi,
Talk to you system admin about this. Using his windows admin login login to
server and connect to SQL Server using Windows authentication.
After that change your SA password using (SP_Password null,newpassword,sa).
After this you could login using new password and do necessary Admin tasks.
Thanks
Hari
SQL Server MVP
"Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
news:djr6ja$f3q$1@.newsreader3.netcologne.de...
> Hey,
> I admin an company with MS SQL-Server. They forget the sa-password. Is
> there any way to get the password from an running sql-server? I need it
> for SQL-Backup!
> Thanks for answere
> Frank
>
|||I have 3 mssql-services. It's run on an SBS 2003 Standard-Server. The
application 'Act!' install the SQL-Server. I coundn't set an sa password.
The application manage the service of MSSQL$ACT7. The service of
'Sharepoint' run with the NT admin account.
I need the sa password for my Veritas SQL-Backup and maybe for maintenance.
Services:
MSSQL$ACT7
MSSQL$Sharepoint
MSSQL$xxxx
Frank
"Jasper Smith" <jasper_smith9@.hotmail.com> schrieb im Newsbeitrag
news:u31L0az2FHA.1980@.TK2MSFTNGP15.phx.gbl...
> What service account is SQL running under ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
> news:djrccf$qtb$1@.newsreader3.netcologne.de...
>
|||Hey Thomas,
The progamm 'act' manage the MSSQL-service. I need the actually password and
not any new password.
Frank
"Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
news:A17984F0-5540-4BC1-9A2E-C69AB3647256@.microsoft.com...[vbcol=seagreen]
> If you have NT authentication enabled you should be able to logon as a
> local
> administrator and then change the sa password (this assumes that builtin
> admins has not been removed from SQL)
> http://vyaskn.tripod.com/administration_faq.htm#q9
>
> --
> Thomas
>
> "Frank Moskopp" wrote:
|||Hey Hari,
The progamm 'act' manage the MSSQL-service. I need the actually password and
not any new password.
Thanks
Frank
"Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:e%23o60642FHA.3276@.TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Talk to you system admin about this. Using his windows admin login login
> to server and connect to SQL Server using Windows authentication.
> After that change your SA password using (SP_Password
> null,newpassword,sa).
> After this you could login using new password and do necessary Admin
> tasks.
> Thanks
> Hari
> SQL Server MVP
>
> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
> news:djr6ja$f3q$1@.newsreader3.netcologne.de...
>
|||Frank Moskopp wrote:
> Hey Hari,
> The progamm 'act' manage the MSSQL-service. I need the actually password and
> not any new password.
> Thanks
> Frank
> "Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:e%23o60642FHA.3276@.TK2MSFTNGP10.phx.gbl...
>
You can't get the actual password for sa- you'll have to enter a new
one. You might be able to contact the application vendor and ask them
for the sa password since it sounds like the program is assigning a sa
password during installation. Maybe it's a standard password (God forbid
it...) and then they can tell you what it is.
Regards
Steen

Get sa password

Hey,
I admin an company with MS SQL-Server. They forget the sa-password. Is there
any way to get the password from an running sql-server? I need it for
SQL-Backup!
Thanks for answere
FrankAre you using mixed mode that has an NT account with sysadmin rights? if so,
log that account then change the sa password.
What version are you running?
Thomas
"Frank Moskopp" wrote:
> Hey,
> I admin an company with MS SQL-Server. They forget the sa-password. Is there
> any way to get the password from an running sql-server? I need it for
> SQL-Backup!
> Thanks for answere
> Frank
>
>|||I have no access with my NT accounts. The company run SQL-Server 2000.
Thanks for more information
Frank
"Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
> Are you using mixed mode that has an NT account with sysadmin rights? if
> so,
> log that account then change the sa password.
> What version are you running?
>
> --
> Thomas
>
> "Frank Moskopp" wrote:
>> Hey,
>> I admin an company with MS SQL-Server. They forget the sa-password. Is
>> there
>> any way to get the password from an running sql-server? I need it for
>> SQL-Backup!
>> Thanks for answere
>> Frank
>>|||What service account is SQL running under ?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
news:djrccf$qtb$1@.newsreader3.netcologne.de...
>I have no access with my NT accounts. The company run SQL-Server 2000.
> Thanks for more information
> Frank
>
> "Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
>> Are you using mixed mode that has an NT account with sysadmin rights? if
>> so,
>> log that account then change the sa password.
>> What version are you running?
>>
>> --
>> Thomas
>>
>> "Frank Moskopp" wrote:
>> Hey,
>> I admin an company with MS SQL-Server. They forget the sa-password. Is
>> there
>> any way to get the password from an running sql-server? I need it for
>> SQL-Backup!
>> Thanks for answere
>> Frank
>>
>|||If you have NT authentication enabled you should be able to logon as a local
administrator and then change the sa password (this assumes that builtin
admins has not been removed from SQL)
http://vyaskn.tripod.com/administration_faq.htm#q9
Thomas
"Frank Moskopp" wrote:
> I have no access with my NT accounts. The company run SQL-Server 2000.
> Thanks for more information
> Frank
>
> "Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
> > Are you using mixed mode that has an NT account with sysadmin rights? if
> > so,
> > log that account then change the sa password.
> >
> > What version are you running?
> >
> >
> > --
> > Thomas
> >
> >
> > "Frank Moskopp" wrote:
> >
> >> Hey,
> >>
> >> I admin an company with MS SQL-Server. They forget the sa-password. Is
> >> there
> >> any way to get the password from an running sql-server? I need it for
> >> SQL-Backup!
> >>
> >> Thanks for answere
> >>
> >> Frank
> >>
> >>
> >>
>
>|||Hi,
Talk to you system admin about this. Using his windows admin login login to
server and connect to SQL Server using Windows authentication.
After that change your SA password using (SP_Password null,newpassword,sa).
After this you could login using new password and do necessary Admin tasks.
Thanks
Hari
SQL Server MVP
"Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
news:djr6ja$f3q$1@.newsreader3.netcologne.de...
> Hey,
> I admin an company with MS SQL-Server. They forget the sa-password. Is
> there any way to get the password from an running sql-server? I need it
> for SQL-Backup!
> Thanks for answere
> Frank
>|||I have 3 mssql-services. It's run on an SBS 2003 Standard-Server. The
application 'Act!' install the SQL-Server. I coundn't set an sa password.
The application manage the service of MSSQL$ACT7. The service of
'Sharepoint' run with the NT admin account.
I need the sa password for my Veritas SQL-Backup and maybe for maintenance.
Services:
MSSQL$ACT7
MSSQL$Sharepoint
MSSQL$xxxx
Frank
"Jasper Smith" <jasper_smith9@.hotmail.com> schrieb im Newsbeitrag
news:u31L0az2FHA.1980@.TK2MSFTNGP15.phx.gbl...
> What service account is SQL running under ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
> news:djrccf$qtb$1@.newsreader3.netcologne.de...
>>I have no access with my NT accounts. The company run SQL-Server 2000.
>> Thanks for more information
>> Frank
>>
>> "Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
>> news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
>> Are you using mixed mode that has an NT account with sysadmin rights? if
>> so,
>> log that account then change the sa password.
>> What version are you running?
>>
>> --
>> Thomas
>>
>> "Frank Moskopp" wrote:
>> Hey,
>> I admin an company with MS SQL-Server. They forget the sa-password. Is
>> there
>> any way to get the password from an running sql-server? I need it for
>> SQL-Backup!
>> Thanks for answere
>> Frank
>>
>>
>|||Hey Thomas,
The progamm 'act' manage the MSSQL-service. I need the actually password and
not any new password.
Frank
"Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
news:A17984F0-5540-4BC1-9A2E-C69AB3647256@.microsoft.com...
> If you have NT authentication enabled you should be able to logon as a
> local
> administrator and then change the sa password (this assumes that builtin
> admins has not been removed from SQL)
> http://vyaskn.tripod.com/administration_faq.htm#q9
>
> --
> Thomas
>
> "Frank Moskopp" wrote:
>> I have no access with my NT accounts. The company run SQL-Server 2000.
>> Thanks for more information
>> Frank
>>
>> "Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
>> news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
>> > Are you using mixed mode that has an NT account with sysadmin rights?
>> > if
>> > so,
>> > log that account then change the sa password.
>> >
>> > What version are you running?
>> >
>> >
>> > --
>> > Thomas
>> >
>> >
>> > "Frank Moskopp" wrote:
>> >
>> >> Hey,
>> >>
>> >> I admin an company with MS SQL-Server. They forget the sa-password. Is
>> >> there
>> >> any way to get the password from an running sql-server? I need it for
>> >> SQL-Backup!
>> >>
>> >> Thanks for answere
>> >>
>> >> Frank
>> >>
>> >>
>> >>
>>|||Hey Hari,
The progamm 'act' manage the MSSQL-service. I need the actually password and
not any new password.
Thanks
Frank
"Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:e%23o60642FHA.3276@.TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Talk to you system admin about this. Using his windows admin login login
> to server and connect to SQL Server using Windows authentication.
> After that change your SA password using (SP_Password
> null,newpassword,sa).
> After this you could login using new password and do necessary Admin
> tasks.
> Thanks
> Hari
> SQL Server MVP
>
> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
> news:djr6ja$f3q$1@.newsreader3.netcologne.de...
>> Hey,
>> I admin an company with MS SQL-Server. They forget the sa-password. Is
>> there any way to get the password from an running sql-server? I need it
>> for SQL-Backup!
>> Thanks for answere
>> Frank
>|||Frank Moskopp wrote:
> Hey Hari,
> The progamm 'act' manage the MSSQL-service. I need the actually password and
> not any new password.
> Thanks
> Frank
> "Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:e%23o60642FHA.3276@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>>
>> Talk to you system admin about this. Using his windows admin login login
>> to server and connect to SQL Server using Windows authentication.
>> After that change your SA password using (SP_Password
>> null,newpassword,sa).
>> After this you could login using new password and do necessary Admin
>> tasks.
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
>> news:djr6ja$f3q$1@.newsreader3.netcologne.de...
>> Hey,
>> I admin an company with MS SQL-Server. They forget the sa-password. Is
>> there any way to get the password from an running sql-server? I need it
>> for SQL-Backup!
>> Thanks for answere
>> Frank
>>
>
You can't get the actual password for sa- you'll have to enter a new
one. You might be able to contact the application vendor and ask them
for the sa password since it sounds like the program is assigning a sa
password during installation. Maybe it's a standard password (God forbid
it...) and then they can tell you what it is.
Regards
Steen|||Hey Steen
I contakt the app. venndor and they told me the install-routine create an
random password and its possible to get the password (for money). By
ordering the act-program we get the SQL-server. But these is not an
Standard-SQL-Server. If I have the sa-password I could use this trimmed
Server with managed tools full. I doesn't want open the SQL-Server. Only for
Backup
Frank
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> schrieb im Newsbeitrag
news:Om59K752FHA.3732@.TK2MSFTNGP15.phx.gbl...
> Frank Moskopp wrote:
>> Hey Hari,
>> The progamm 'act' manage the MSSQL-service. I need the actually password
>> and
>> not any new password.
>> Thanks
>> Frank
>> "Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
>> news:e%23o60642FHA.3276@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>>
>> Talk to you system admin about this. Using his windows admin login login
>> to server and connect to SQL Server using Windows authentication.
>> After that change your SA password using (SP_Password
>> null,newpassword,sa).
>> After this you could login using new password and do necessary Admin
>> tasks.
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
>> news:djr6ja$f3q$1@.newsreader3.netcologne.de...
>> Hey,
>> I admin an company with MS SQL-Server. They forget the sa-password. Is
>> there any way to get the password from an running sql-server? I need it
>> for SQL-Backup!
>> Thanks for answere
>> Frank
>>
>>
> You can't get the actual password for sa- you'll have to enter a new one.
> You might be able to contact the application vendor and ask them for the
> sa password since it sounds like the program is assigning a sa password
> during installation. Maybe it's a standard password (God forbid it...) and
> then they can tell you what it is.
> Regards
> Steen|||Frank Moskopp wrote:
> Hey Steen
> I contakt the app. venndor and they told me the install-routine create an
> random password and its possible to get the password (for money). By
> ordering the act-program we get the SQL-server. But these is not an
> Standard-SQL-Server. If I have the sa-password I could use this trimmed
> Server with managed tools full. I doesn't want open the SQL-Server. Only for
> Backup
>
> Frank
> "Steen Persson (DK)" <spe@.REMOVEdatea.dk> schrieb im Newsbeitrag
> news:Om59K752FHA.3732@.TK2MSFTNGP15.phx.gbl...
>> Frank Moskopp wrote:
>> Hey Hari,
>> The progamm 'act' manage the MSSQL-service. I need the actually password
>> and
>> not any new password.
>> Thanks
>> Frank
>> "Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
>> news:e%23o60642FHA.3276@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>>
>> Talk to you system admin about this. Using his windows admin login login
>> to server and connect to SQL Server using Windows authentication.
>> After that change your SA password using (SP_Password
>> null,newpassword,sa).
>> After this you could login using new password and do necessary Admin
>> tasks.
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
>> news:djr6ja$f3q$1@.newsreader3.netcologne.de...
>> Hey,
>> I admin an company with MS SQL-Server. They forget the sa-password. Is
>> there any way to get the password from an running sql-server? I need it
>> for SQL-Backup!
>> Thanks for answere
>> Frank
>>
>> You can't get the actual password for sa- you'll have to enter a new one.
>> You might be able to contact the application vendor and ask them for the
>> sa password since it sounds like the program is assigning a sa password
>> during installation. Maybe it's a standard password (God forbid it...) and
>> then they can tell you what it is.
>> Regards
>> Steen
>
Hi Frank
I'm sorry, but I don't quite understand you last post. If you really
need the SA password and the vendor can supply you with this password
for a fee, I think this is the route you have to go. Otherwise you'll
have to follow the other peoples advices to log on to the server with an
Admin account and then either reset SA password or create an account for
you, that can do what you need to do.
None of the administration you need to do have to be done with the SA
account. Instead I'd suggest that you gets an admin account created that
can perform the tasks you need and where you can control password
yourself. Best of all this should be a windows account, but that require
SQL server to be running in Mixed Mode.
Regards
Steen

Get sa password

Hey,
I admin an company with MS SQL-Server. They forget the sa-password. Is there
any way to get the password from an running sql-server? I need it for
SQL-Backup!
Thanks for answere
FrankAre you using mixed mode that has an NT account with sysadmin rights? if so,
log that account then change the sa password.
What version are you running?
Thomas
"Frank Moskopp" wrote:

> Hey,
> I admin an company with MS SQL-Server. They forget the sa-password. Is the
re
> any way to get the password from an running sql-server? I need it for
> SQL-Backup!
> Thanks for answere
> Frank
>
>|||I have no access with my NT accounts. The company run SQL-Server 2000.
Thanks for more information
Frank
"Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...[vbcol=seagreen]
> Are you using mixed mode that has an NT account with sysadmin rights? if
> so,
> log that account then change the sa password.
> What version are you running?
>
> --
> Thomas
>
> "Frank Moskopp" wrote:
>|||What service account is SQL running under ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
news:djrccf$qtb$1@.newsreader3.netcologne.de...
>I have no access with my NT accounts. The company run SQL-Server 2000.
> Thanks for more information
> Frank
>
> "Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
>|||If you have NT authentication enabled you should be able to logon as a local
administrator and then change the sa password (this assumes that builtin
admins has not been removed from SQL)
http://vyaskn.tripod.com/administration_faq.htm#q9
Thomas
"Frank Moskopp" wrote:

> I have no access with my NT accounts. The company run SQL-Server 2000.
> Thanks for more information
> Frank
>
> "Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
>
>|||Hi,
Talk to you system admin about this. Using his windows admin login login to
server and connect to SQL Server using Windows authentication.
After that change your SA password using (SP_Password null,newpassword,sa).
After this you could login using new password and do necessary Admin tasks.
Thanks
Hari
SQL Server MVP
"Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
news:djr6ja$f3q$1@.newsreader3.netcologne.de...
> Hey,
> I admin an company with MS SQL-Server. They forget the sa-password. Is
> there any way to get the password from an running sql-server? I need it
> for SQL-Backup!
> Thanks for answere
> Frank
>|||I have 3 mssql-services. It's run on an SBS 2003 Standard-Server. The
application 'Act!' install the SQL-Server. I coundn't set an sa password.
The application manage the service of MSSQL$ACT7. The service of
'Sharepoint' run with the NT admin account.
I need the sa password for my Veritas SQL-Backup and maybe for maintenance.
Services:
MSSQL$ACT7
MSSQL$Sharepoint
MSSQL$xxxx
Frank
"Jasper Smith" <jasper_smith9@.hotmail.com> schrieb im Newsbeitrag
news:u31L0az2FHA.1980@.TK2MSFTNGP15.phx.gbl...
> What service account is SQL running under ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
> news:djrccf$qtb$1@.newsreader3.netcologne.de...
>|||Hey Thomas,
The progamm 'act' manage the MSSQL-service. I need the actually password and
not any new password.
Frank
"Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
news:A17984F0-5540-4BC1-9A2E-C69AB3647256@.microsoft.com...[vbcol=seagreen]
> If you have NT authentication enabled you should be able to logon as a
> local
> administrator and then change the sa password (this assumes that builtin
> admins has not been removed from SQL)
> http://vyaskn.tripod.com/administration_faq.htm#q9
>
> --
> Thomas
>
> "Frank Moskopp" wrote:
>|||Hey Hari,
The progamm 'act' manage the MSSQL-service. I need the actually password and
not any new password.
Thanks
Frank
"Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:e%23o60642FHA.3276@.TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Talk to you system admin about this. Using his windows admin login login
> to server and connect to SQL Server using Windows authentication.
> After that change your SA password using (SP_Password
> null,newpassword,sa).
> After this you could login using new password and do necessary Admin
> tasks.
> Thanks
> Hari
> SQL Server MVP
>
> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
> news:djr6ja$f3q$1@.newsreader3.netcologne.de...
>|||Frank Moskopp wrote:
> Hey Hari,
> The progamm 'act' manage the MSSQL-service. I need the actually password a
nd
> not any new password.
> Thanks
> Frank
> "Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:e%23o60642FHA.3276@.TK2MSFTNGP10.phx.gbl...
>
You can't get the actual password for sa- you'll have to enter a new
one. You might be able to contact the application vendor and ask them
for the sa password since it sounds like the program is assigning a sa
password during installation. Maybe it's a standard password (God forbid
it...) and then they can tell you what it is.
Regards
Steen