Viewing 15 posts - 1,981 through 1,995 (of 9,715 total)
What a wonderful day in the upgrade-hood...
Sigh.
So many SSIS packages to upgrade. So. Many. PACKAGES! :crazy:
March 11, 2016 at 6:20 am
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)...
March 11, 2016 at 6:16 am
franky.Piferoen (3/11/2016)
Hi,this returns
SomeUserSQL_LOGIN0
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?
March 11, 2016 at 5:06 am
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...
March 11, 2016 at 4:17 am
Vyper426 (3/10/2016)
The log does not show any errors on MSDB but when I try to bring SQL Agent online, it fails with the error that MSDB is read_only.
What changed right...
March 11, 2016 at 4:12 am
franky.Piferoen (3/10/2016)
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...
March 10, 2016 at 12:50 pm
Jon.Morisi (3/10/2016)
Are the linked server and the login/user security both setup for the same database?
Linked Servers don't require a database level definition. Only a server-level definition.
But if the OP has...
March 10, 2016 at 11:27 am
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...
March 10, 2016 at 11:21 am
John Mitchell-245523 (3/10/2016)
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...
March 10, 2016 at 8:30 am
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...
March 10, 2016 at 6:40 am
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...
March 10, 2016 at 6:31 am
What changed recently? Around the time that MSDB went Read Only or right before.
March 10, 2016 at 6:31 am
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...
March 10, 2016 at 6:28 am
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...
March 2, 2016 at 6:03 am
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.
March 1, 2016 at 5:59 am
Viewing 15 posts - 1,981 through 1,995 (of 9,715 total)