Q
Problem solve Get help with specific problems with your technologies, process and projects.

How can I switch my default master time server for my domain?

I have a multi-site Windows 2000 domain which was recently upgraded from a Windows NT 4.0 domain. For the upgrade to Active Directory, we promoted another computer to the PDC role, leaving the old PDC as a BDC. We then took the BDC offline and ran the upgrade to Windows 2000 and Active Directory on the new PDC. We'll call this SERVER1 and the old PDC SERVER2. There are several other servers in the domain, some member servers and some domain controllers, depending on their location.

My problem is this: my default master time server for the entire domain is SERVER1. I want it to be SERVER2. If I run a NET TIME command on any file server (without parameters), it lists SERVER1 as the primary where is gets its time. This server is going to be shipped out to a branch office and shouldn't be the default time server for the domain.

I have since transferred the GC back to SERVER2 (the old PDC), as well as the 5 FSMO roles (although I'm going to split the roles up a bit with another DC on the local LAN after this issue is resolved). I checked all of the roles out with DUMPFSMO, and none of them are assigned to SERVER1. I have rebooted all of the servers, and still the master time server is listed as SERVER1. When I down SERVER1 and attempt to move it out of the local LAN, some things seem to get hung-up and I can't find another server to get time from automatically. I'm afraid synchronization won't work between my domain controllers listed in Active Directory. How can I solve this problem? What did I miss?

Thanks ahead for any help you can give me!
I think you just need to set the time server on each server system by following the instructions in the following Microsoft documents:  http://support.microsoft.com/default.aspx?scid=kb;en-us;216734
If that document fails to resolve the issue, try searching with "time server" at Microsoft.com/technet.

Dig Deeper on Windows Server troubleshooting

Why does our DTS package fail when executed from a separate server under different permissions? Our DTS package fails to execute when executed from a separate server under different permissions. Here are the specs:
  • Both Server1 and Server2 are on the same domain. Server1 is the SQL Server instance (Enterprise Edition) with SP4.

  • Server2 has a batch script on it that opens DTSrun and executes a DTS package on Server1 to bulkload some XML into a database on Server1 using a trusted connection.

  • Server2 has no instance of SQL Server on it; instead it has the SQL tools installed.

  • The owner executing the batch script (BBB) has appropriate rights in the database as a DBO and is a member of the bulkadmin fixed server role.

  • The permissions (BBB) executing the script are not the DTS package owner (AAA), nor are they members of the SA group.

  • Additionally, Server2 has the necessary files (XBLKLD3.dll) to create the XMLBulkLoad object, with the latest SQLXML and .NET 1.1 installed. However, the execution of the batch script on Server2 fails with the error message that permissions are denied on the createobject SQLXMLBulkLoad when BBB executes the batch script.

  • The executing account (BBB) has permissions to where the files being loaded are kept.

  • When the batch script is executed off a local XP Pro machine in the same domain with BBB logged on, the script executes successfully. The machine only has the SQL tools installed with no running instances.

  • Server2 is a Windows 2000 server.

  • Batch script executes successfully under the DTS package owner (AAA) off of a local XP Pro machine in the same domain. The machine only has the SQL tools installed with no running instances.
Is this a potential case of
cross-database ownership chaining (CDOC). However, the MS literature does not make specific mention that this would affect DTS package execution from another server. Specifically the documentation mentions that CDOC is between databases instances that access objects in another database, and in my case there is only one instance on Server1.

Thanks,
Frustrated with DTS

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchSQLServer

SearchEnterpriseDesktop

SearchVirtualDesktop

Close