😛

Still not sure if I like Data Tools or not....

Windows 10 or Windows 2010?

I don't know of any Windows 2010 release.

What version of Windows was the user upgraded from? And was SQL 2012 32bit also or 64bit?

As an added note, I worked for Iron Mountain Records Management when 9/11 happened. I remember well the tales of the New York office getting people up and running right...

Vyper426 (3/11/2016)

---

No. about 800GB available on that drive.

Just before this, MSDB had been corrupted. We took the backup from the backup system and replaced it. The backup system does not...

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...