Viewing 15 posts - 1,306 through 1,320 (of 1,584 total)
Really? I have linked servers set up with users that do not exist on the source server. Isn't the source simply passing whatever credentials you tell it to?
I didn't phrase...
November 30, 2011 at 12:55 pm
>> Sapen, Yes...it must match the credentials on the remove server (mas 90 providex database)
November 30, 2011 at 11:38 am
I just noticed you said you're having this issue only when connecting from a remote location. I assume you're on a VPN connection of some sort? In any...
November 30, 2011 at 10:31 am
In the security part of the linked server setup, for kicks and giggles specify the credentials under "Be made using this security context" and see if you get the same...
November 30, 2011 at 10:22 am
Cool! Glad you got it wokring. Wouldn't it be GREAT it this site had a Resolved button for posts???
November 30, 2011 at 10:07 am
You could try using an Execute SQL Task, setting the Result Set to a Single Row/Full Result Set, then setting that to a variable. This way it would either...
November 30, 2011 at 9:44 am
Jared, that's just sample code 😉 To prove the concept of testing something against a linked server - would never do that in working code!
November 30, 2011 at 9:32 am
Sounds like your DBA has allocated 59GB of memory for the SQL server. If it's allocated it will eat it up (not necessarily using all of it, but SQL...
November 25, 2011 at 10:43 am
Glad to hear that 🙂 In either case, any one here is willing to help knowing that you've already gave it your best shot...so if you would please post...
November 23, 2011 at 12:37 pm
Please post what SQL you have come up with so far, so we can better assist...
Um - This isn't a homework assignment is it?
November 23, 2011 at 12:21 pm
I didn't see the runas command in there... did you omit that on purpose?
November 21, 2011 at 10:14 am
With regards to the RUNAS, I'm not happy with specifying username/password in clear text anywhere. The SQL Agent proxy I set up should take care of that anyway.
No need to...
November 21, 2011 at 9:46 am
Regarding the default "server setting for compression"...if it's set up to compress backups in your SQL Server configuration, and you attempt to back it up on a sever that has...
November 18, 2011 at 1:35 pm
Is there any chance there's a backup compression software application running on the server i.e. (HyperBac, Litespeed, etc?). This will give you the same error when you attempt to...
November 18, 2011 at 1:31 pm
Try something like this from the command line:
C:\Program Files\robocopy>Runas /user:YOURDOMAIN\YourUser "YourCommand"
Example:
C:\Program Files\7-Zip>Runas /user:mycompany\mydoggiejessie "7z.exe a c:\test71.zip c:\ziptest\* -mx9 -r"
November 18, 2011 at 9:52 am
Viewing 15 posts - 1,306 through 1,320 (of 1,584 total)