What a wonderful day in the upgrade-hood...

Sigh.

So many SSIS packages to upgrade. So. Many. PACKAGES! :crazy:

Honestly, the only time I've ever seen the error is if:

1) The login doesn't exist on the server

2) The login exists on the server but doesn't have database level permissions

3)...

Are you sure, absolutely positive, that the user name is spelled exactly the same way on the server as it is in the linked server?

I think it would make an excellent presentation. Make sure to include the ability of people to reach that documentation during DR. After all, if the only copy is in...

What changed right...

franky.Piferoen (3/10/2016)

---

Hi,

The remote user is a sql login which has then necessary rights on the database.

I can login with that user on the server and query the tables.

I use...

Linked Servers don't require a database level definition. Only a server-level definition.

But if the OP has...

Grr. Having this issue with another login.

This login does NOT have sysadmin and can't create endpoints. In fact, when I run all the code, I can't find anything that...

John Mitchell-245523 (3/10/2016)

---

Brandie

I'm guessing you've set up mirroring on the server?

SELECT

l.name AS LoginName

,e.name AS EndpointName

FROM sys.server_permissions p

JOIN sys.server_principals l ON p.grantor_principal_id = l.principal_id

JOIN sys.endpoints e ON p.major_id = e.endpoint_id

WHERE p.class_desc...

Allow me to say, actually, sort of. Depending on how hard you want to work.

You can use Linked Servers to run the query against multiple server connections, but you'll have...

The login is defined and set up with permissions on both servers (local and remote)?

And it uses the same password on both servers?

EDIT: On the General tab, what is the...

What changed recently? Around the time that MSDB went Read Only or right before.

While you might be able to upgrade the packages directly to 2012, I wouldn't recommend it. Enough changed with SSIS between 2005 and 2008 that your incremental step approach is...

Thanks, all, for the reviews of the presentation.

While my class is now officially over, I'm debating on the possibility of redoing the presentation for a more real-world push of the...

As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of you mind.