problem to connect sql server 2000 from other domain RRS feed

  • Question

  • hi

    first sorry for my english


    i have windows server 2003 it is not a domain it is in workgroup

    i was setup sql server 2000 in this server and setup sp4

    i can't  connect to this sql server by sa account from other computer whitch in other domin

    what can i do in this problem ?



    Saturday, November 8, 2008 9:04 PM

All replies

  • have you tried connecting using the IP instead of the name?


    Sunday, November 9, 2008 6:07 PM

    yes have  tried it


    i ask if i must open port in the computer or router ?? 

    Monday, November 10, 2008 12:10 AM

    What exactly does "I cannnot conenct" mean, which error message do you get ?


    Jens K Suessmeyer

    Monday, November 10, 2008 3:13 PM
  • Did you already verified your firewall?

    Did you checked if SQL Server and windows authentication is selected on instance properties? If it's "only windows" you can have problem due this box isn't in domain.

    From other box try to create an alias to target box you have been problem, and then try to connect.

    Tuesday, November 11, 2008 10:52 AM