Search results for query: *

Thank you for your response. We're going down the route of upgrading/replacing the VPN appliance - it's nearing end of life anyway. We'll keep the 2003 DCs as is without DNS for now until we get the VPN sorted - it's a shame because we really want to retire the 2000 DCs a.s.a.p. I've checked...

Sorry for the delay in coming back to you - our internet access broke for most of yesterday. I tried setting the Primary DNS of the 2003 DCs after DNS was installed (before they were pointing at existing DNS servers). Unfortunately remote access stopped again. I uninstalled DNS and AD from one...

OK, I will try option 2 tomorrow morning. Thanks for the info.

Thanks for your reply. I believe I've tried adding DNS when the DCs Primary DNS was set to itself and to one of the other existing DCs too. The outcome was the same. However, just to be sure I will give this another try. What's your recommendation? 1) Set Primary DNS to itself, then install...

Dear theravager, Thanks for your reply. I've already tried this - I can promote the 2 new DCs and they operate happily alongside the existing 2000 DCs. Remote logons are unaffected (same as the internal ones). Once DNS is added we find that initially things are OK for about 24 hours and then...

Does anyone have any further suggestions? This problem's been bustin' my ass for 4 weeks now so any help is appreciated.

Dear TheLad, Thanks for your reply. I did run adprep /forestprep and adprep /domainprep before running dcpromo on the 2003 members. I did find initially that dcpromo was complaining that AD wasn't ready to receive a 2003 DC but that was resolved by running adprep /forestprep and adprep...

Dear Lemon13, Sorry but that did not work. As soon as the Forest/DomainDNSZones objects are added to AD, remote access stops - adding users to Remote Desktop Users makes no difference - I even waited for the group user addition to replicate to all DCs (2000 and 2003) before trying a remote logon...

Dear Lemon13, Thank you for prompt reply. I've checked this group and it currently has no members whatsoever. When I next promote the DCs and add DNS I'll add a couple of test users to the group and come back to you with the results. Regards, Ray.

Attempting to move from 2 x 2000 DCs with AD integrated DNS to 2 x 2003 R2 DCs. Have managed to create 2 x 2003 R2 member servers and can DCPROMO them to DCs and back to members at will while leaving 2000 DCs unchanged and connected to network. When adding DNS to both new DCs (or members and...

Thanks gmmastros! I used the collation value SQL_Latin1_General_Cp437_BIN for both columns in the join and that error message has now gone. Only to be replaced by the following message when I try to save the SP: Error 7405: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options...

Thanks for your reply gmmastros - I tried what you said and then got: Error 7753: Cannot specify an index or locking hint for a remote data source. So I took out (readuncommited) and then got: Error 446: Cannot resolve collation conflict for equal to operation. The plot thickens ...

Thanks for your response - I've digged deeper and found that this seems to be the wrong error message! I got this from Reporting Services but when I run the SP from within Query Analyzer I get this instead: Server: Msg 208, Level 16, State 1, Procedure Zusp_ReportCOAcknowledgement, Line 72...

I'm trying to modify an existing SP to add another table from a different database from another SQL Server. Original procedure runs without error but when I change this: from FS_COHeader ch (readuncommitted) left join @tbl tbl on ch.COHeaderKey = tbl.COHeaderKey to: from FS_COHeader ch...

Another RS newbie here, so please excuse me if this one's obvious! I'm modifying an existing report with several datasets and I've added a new one (Territory). I want to filter this dataset to a single row using a field from another dataset - when I try this is get: The filter value expression...