Using version control subversion. Packages are deployed to...

What is it?

Yes, that is the article I read too.

By the way what is the best reporting script utility for DBAs?

Thanks

Also I am migrating a SQL 2005 reportserver to a SQL 2008R2 server.

Each server above has database engine and reporting service installed.

After install SQL erver 2008R2, can I do a...

Thank you for the information, it is very helpful

Perry Whittle (3/3/2012)

---

sqlfriends (3/1/2012)

---

I 'm migrating a sql server 2005 reportServer and reportServertempdb to a SQl server 2008R2 box.

What is the beter route for me?

1. On the new box, install...

SQLKnowItAll (3/8/2012)

---

sqlfriends (3/8/2012)

---

SQLKnowItAll (3/8/2012)

---

So, when you tell SSIS to use SQL Server Agent Account it is not using the domain account that you assigned to authenticate the service, it is...

SQLKnowItAll (3/8/2012)

---

So, when you tell SSIS to use SQL Server Agent Account it is not using the domain account that you assigned to authenticate the service, it is using the...

Perry Whittle (3/8/2012)

---

yes there is impersonation so that when the agent service needs to carry out an admin task it can. However, there is no inheritance, logging into SSMS as...

The other reason I ask this is because recently while I investigate a ssis packge schedueled as a sql job that runs using sql service agent account.

It is...

No, it is a member of the NT SERVICE\SQLSERVERAGENT virtual account and is granted minimum permissions needed to be that service account. If YOU set up your domain account...

Sorry, I wonder why it is so hard to explain.

When you install SQL server using the setup wizard, and at the step to choose account for SQl server and sql...

No, it is not my windows account , it is a domain account created in AD.

For each of our SQL server, we asked our network engineer created a domain...

Separate, it is not a windows group. It is actually what they call a Virtual Account. As far as I know, you cannot see which domain users are assigned...

windows 2008