About lost sa password when rebuild master database

Hi Guys,
I rebuild master database in order to change collation setting, but I lost
sa password After rebuild. I couldn't logon into database with sa. Why is it
like this, can I re-get sa password? Thanks.
Jerry MuNot sure what could have happen but ... have you tried to log in as a member
of the BUILTIN\Administrators group?
Ben Nevarez, MCDBA, OCP
Database Administrator
"Iter" wrote:
> Hi Guys,
> I rebuild master database in order to change collation setting, but I lost
> sa password After rebuild. I couldn't logon into database with sa. Why is it
> like this, can I re-get sa password? Thanks.
> Jerry Mu
>|||login with a Windows NT account that is part of sysadmin
(builtin\administrator) and reset the password.
e.g.
exec sp_password null,'new password', 'sa'
-oj
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A02122C4-8006-4D6E-99B1-A2D0DD016362@.microsoft.com...
> Hi Guys,
> I rebuild master database in order to change collation setting, but I lost
> sa password After rebuild. I couldn't logon into database with sa. Why is
> it
> like this, can I re-get sa password? Thanks.
> Jerry Mu
>

About lost sa password when rebuild master database

Hi Guys,
I rebuild master database in order to change collation setting, but I lost
sa password After rebuild. I couldn't logon into database with sa. Why is it
like this, can I re-get sa password? Thanks.
Jerry MuNot sure what could have happen but ... have you tried to log in as a member
of the BUILTIN\Administrators group?
Ben Nevarez, MCDBA, OCP
Database Administrator
"Iter" wrote:

> Hi Guys,
> I rebuild master database in order to change collation setting, but I lost
> sa password After rebuild. I couldn't logon into database with sa. Why is
it
> like this, can I re-get sa password? Thanks.
> Jerry Mu
>|||login with a Windows NT account that is part of sysadmin
(builtin\administrator) and reset the password.
e.g.
exec sp_password null,'new password', 'sa'
-oj
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A02122C4-8006-4D6E-99B1-A2D0DD016362@.microsoft.com...
> Hi Guys,
> I rebuild master database in order to change collation setting, but I lost
> sa password After rebuild. I couldn't logon into database with sa. Why is
> it
> like this, can I re-get sa password? Thanks.
> Jerry Mu
>

about connections and Login

Hey guys,

I have created dtsx packages and i have one master package which would run couple of child packages.

1. I have all on my local machine.I want others who r working with me access these.So what do i need to do?for them to access...

2.what would be the best way in executing these packages.

the way it is set now is i had 3 connections set for each package.

a.Source connection

b.Destination Connection.

c.One more connection(which is used with in the process of execution)

Can i set connections in common for all the packages in one location.

3.i also want to set some logging settings to my master package too.and i want this package to run everyday automatically at a particular time how can this be done.

How can i do that.

please let me know.

sureshv wrote:

1. I have all on my local machine.I want others who r working with me access these.So what do i need to do?for them to access...

What you mean, to edit them? just use VSS or place them in a shared location. To execute them, place them in a shared location and then set up a Job (SQl Agent) to run them.

sureshv wrote:

2.what would be the best way in executing these packages.

Via SQL Agent job would be my preferred method

sureshv wrote:

Can i set connections in common for all the packages in one location.

No, but you can use package configuration instead.

sureshv wrote:

3.i also want to set some logging settings to my master package too.and i want this package to run everyday automatically at a particular time how can this be done.

To schedule them, again, use a SQL Agent Job. For logging just enable package logging.