Viewing 15 posts - 1,306 through 1,320 (of 1,583 total)
>> Sapen, Yes...it must match the credentials on the remove server (mas 90 providex database)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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???
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 23, 2011 at 12:21 pm
I didn't see the runas command in there... did you omit that on purpose?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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"
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 18, 2011 at 9:52 am
It doesn't matter. I use a program from sysinternals and in order to get that to run I had to first manually run it from the command line and...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 18, 2011 at 8:56 am
Viewing 15 posts - 1,306 through 1,320 (of 1,583 total)