SQL Server Performance Forum – Threads Archive

SQL Server and DC

Hi I have got SQL Server 6.0 running as DC.I want to copy the objects and data to SQL server 2000 which is not part of the domain.
when i try to connect to sql server 6.0 it says "server not found or access denied". What is the procedure for conneting two sql servers which are not on the same domain. Thanks Harry

Have you tried just using the IP address of the SQL Server instead of using its name?

Hi, is these domain having same network segment ? are you able to ping each domain from one to another ? <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

hi Thanks for the reply.
I did try with ip address still cannot find the db.
Both the machines are in the same segment.
But still only can ping from dc to client on the other way around. Regards Harry

Have you worked with the network guys on this? If not, you will need to do so probably. Sounds like you might actually have some guys over there that know what they’re doing. You will need the ports open up between the two boxes that SQL Server is running on. You will also need to have either: 1. NetBIOS enabled and UDP 1434 open between the boxes, or
2. An entry in the lmhosts or hosts file to allow connection between the boxes AND discovery of the SQL Server service. Once that’s completed, you can connect with a SQL Server account. You could also connect with a local machine account if: 1. You have the local account with same name and password setup on both machines.
2. You have the local account enabled for shadowing or impersonation.
3. You have the appropriate ports open to allow the authentication token through. What do you mean the other machine is on the "same segment"? Are you sure about that? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

I doubt SQL version 6.0 capability in connecting from the DC to SQL 2000 (check Derrick’s references).
Have you ever tried this before connecting both the SQL servers?
If this is the first time and a one=off job then transfer data to flat files and use DTS from SQL 2000 to import the data. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi Thanks for replies.
I have two tasks to do in this setup.
Need to transfer data from sql 6.0 to sql 2000 .
This i have done using DTS making sql 6.0 as ODBC source.
But still can i get the data relations along with tables and datas? Second part is to setup sql replication from 6.0 to 2000.
From msdn it looks like sql 6.0 can be made as subscriber and sql 2000 as publisher.
CAn any body list out the steps to achieve this? thanks Harry

In order to get the relations and schema, it is better to script SQL 6.0 table & objects and then apply them to SQL 2k. Again use the DTS to transfer the data itself, as it will deal with schema changes or any indexes refurbishment. With regard to replication refer:
http://www.sql-server-performance.com/tp_replication.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replimpl_4joy.asp HTH Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for reply.
I will try out the data transfer as you mentioned.
Regarding replication sql 6.0 cannot act as publisher which is my requirement.
The link you have given for sql 6.5 to sql 2000. Am i correct in this?
Is there any other way to do data transfer on daily basis? Thanks Harry

I dont’ see much difference between SQL 6 & 6.5, so try it out.
If you are getting the data without any issues then continue with DTS. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>