Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    Unhappy Unanswered: SQL Registration

    Hello all,

    I'm trying to to create a new SQL Registration using the EM but getting permison denial message. Both sql server is running SQL 2000.
    I'm doing this on my home-network,which is setup on a Workgroup model, using Win XP prof & Win 2000 prof. I can see the other SQL Server when I try to register it.
    I have no problem registering a new instance at work from one machine to another, the network is setup as a Domain model.
    I try creating a ODBC system DSN as a connection test case, but fail with permission issue message.

    My question: Is it possible to register a new sql on one machine to another using a peer-to-peer network setup? Reason behind all this is i'm trying to do replication at home. I would need to make one a Publisher and the other Subscriber, since I can not register or create a connection using ODBC as a test case. My conclusion is due to some authentication with sql server. I do have both local admin and sql server id/psw when I use to register.

    Please advise if anyone have try to do this and run into the same issue.

    Thank you all.

  2. #2
    Join Date
    May 2003

    If you can resolve the name of the server from the other machine then you should be able to set the connection.

    Set up a lmhosts/hosts file on the client PC and then ping the SQL server by name. I fit cant find the server by name, you need to fix that.



  3. #3
    Join Date
    Dec 2003



    Thanks for your reponse. I have try adding my computer name + IP address in the host file but that does not work. I don't have a problem seeing other computer on my netwrok. I can share any files / resource to any computer I have on the network. I think it has to do with some authentication that SQL require for client, since workgroup permisson is stored at the local level for each computer. Anyway, fall back on plan B and updated my Win2k pro to server. That fix the problem. Hope their a more logical answer then that. Thank you for your attention.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts