Viewing 15 posts - 7,966 through 7,980 (of 9,720 total)
Is the user there or the login there?
There's a difference. If the login isn't mapped to the database or mapped improperly to the database, then you'll encounter this error.
"Improperly" is...
May 7, 2010 at 7:00 am
2cams (5/7/2010)
This is my 1st Tempdb issue so I'm grabbing whatever I can implement easily to help with this issue
Please don't take this the wrong way...
Beware the easy out....
May 7, 2010 at 6:41 am
This code hits one of my major pet peeves, which probably doesn't contribute much to your problem but certainly doesn't help it either.
Allow me to point out a few...
May 7, 2010 at 6:33 am
gvaldridge (4/30/2010)
However, if this is working as designed, I guess I'm not sure what the point is in allowing the user to manually enter a Connection String within DTEXEC(UI).
Elliot is...
May 7, 2010 at 6:02 am
Edit: Misread original post. Deleting this comment and looking for a better solution.
May 7, 2010 at 5:56 am
Paul_Harvey (5/7/2010)
It seems add that simply setting the RetainSameConnection to True would cause a permissions error.
I've never actually seen that error before, and I've used the RetainSameConnection property. But never...
May 7, 2010 at 5:50 am
The number of times a query runs doesn't mean anything. What matters is the number of reads, writes, and recompiles. Also the length of time a query runs.
I'll take a...
May 7, 2010 at 4:56 am
Are you running a clustered server environment? Does your network use a foundary for passing up connections to the cluster?
We've had issues with our foundary where it would keep routing...
May 6, 2010 at 5:57 am
nana.asare (5/5/2010)
i have attached a screen shot of the error i got to my reply
Read the error carefully. See where it says "or Remote connections are not allowed?"
Brandie Tarvin (4/29/2010)
May 6, 2010 at 4:27 am
emily-1119612 (5/5/2010)
>>Most of the actual SQL code is generated & issued by a 3rd party applicationSo does this 3rd party support 2008?
That's actually a huge issue with using third party...
May 6, 2010 at 4:17 am
wodom (5/5/2010)
It sounds like you're saying DTS has been replaced by SSIS in the newer versions.
That's exactly what he's saying. DTS was completely taken apart and rebuilt from the ground...
May 6, 2010 at 4:15 am
Kwisatz78 (5/5/2010)
Sorry I am not even getting to execute code, this error happens when trying to connect to the database engine remotely.
Walk us through the steps you're using to...
May 5, 2010 at 11:34 am
How are you running through SSMS? Are you right-clicking an object in the Object Explorer and choosing execute or are you running the code directly in a query window?
We ran...
May 5, 2010 at 4:13 am
Viewing 15 posts - 7,966 through 7,980 (of 9,720 total)