July 23, 2004 at 4:02 pm
I have had a Local version of SQL Server but now have 2 SQL Servers that need to communicate / share data / Run Jobs between themselves.
We have a very small network currently without a Domain, how do I set up a simple Domain so I can use a Domain Login for Server communication (currently using local logins).
THis is a very 101 question but if anyone could steer me in the right direction I would be very thankful!
Regards
July 25, 2004 at 6:26 pm
You're going to need to configure at least one of the servers as a domain controller. The command dcpromo allows you to do this if you're using Windows 2000 or 2003. You'll then need to move the other SQL Server into the same domain. If you're still in the Windows NT 4.0 world, you'll either need another computer or you'll need to rebuild an existing server.
However, if you have 2 SQL Servers that need to communicate, can you not use SQL Server logins? Or worse case scenario, you create local accounts on both computers that have the same username/password. That would be preferable if you aren't familiar with Active Directory administration.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply