Viewing 15 posts - 2,971 through 2,985 (of 6,105 total)
Are you connecting to the local server using Windows authentication? If so, it'll attempt a Windows authentication connection to the other server. In that case, port 135 (and some others)...
July 7, 2005 at 11:45 am
What does the error log for SQL Server indicate? Anything in the system or application event logs? Usually if they're boucing there'd be something in the Windows logs as to...
July 7, 2005 at 11:41 am
It may be. How are you connecting to the SQL Server, Windows authentication or SQL Server login? How is the linked server connection specified to connect?
July 7, 2005 at 9:28 am
This is the one I usually refer to since it also lists version changes due to hotfixes:
July 7, 2005 at 9:26 am
This depends... if you are capturing the new values, you want inserted. If you are capturing the old values, you use deleted.
July 7, 2005 at 9:18 am
There are a few causes to this but the most likely is MS DTC isn't running on one of the two SQL Servers. Can you verify that they are? Also,...
July 7, 2005 at 8:55 am
Where you have FOR INSERT change to FOR UPDATE. The inserted table is present with UPDATE triggers. It represents the new values for the rows changing. The deleted table is...
July 7, 2005 at 8:52 am
It sounds like the SQL Server is set up to only allow Windows authentication. In order to be able to use a SQL Server login, the SQL Server will need...
July 7, 2005 at 8:49 am
I know we implemented an earlier version of the tool (pre-OLAP support) and it was inexpensive and works well for us. We also use their reporting piece. Last I remembered,...
July 7, 2005 at 8:48 am
No, it does support the OLAP connections. An example walkthrough that demonstrates this with an MDX query is here:
July 7, 2005 at 8:36 am
The issues with DTC on XP/2003 was because MS changed how DTC worked. The network DTC access/COM+ Rollup package addresses those issues. If it's a DTC issue between two Windows...
July 7, 2005 at 8:32 am
Availability of Windows XP COM+ Hotfix Rollup Package 10
This looks to be the latest, although you might have to check with MS to find out. We...
July 7, 2005 at 8:10 am
The one I know about that is similar is Data Dynamics' DynamiCube. We looked at it once upon a time. It's $599, but unfortunately it is an ActiveX control. Still...
July 7, 2005 at 8:05 am
Yes. If that one server has bad memory or a bad motherboard, it would have the issue you described while the others would be fine. We have seen occasions where...
July 7, 2005 at 8:00 am
To piggy-back on Chris, we've seen this with several different issues:
a) bad motherboard
b) bad memory
c) bad driver for a piece of hardware
July 7, 2005 at 7:26 am
Viewing 15 posts - 2,971 through 2,985 (of 6,105 total)