Results 1 to 11 of 11
  1. #1
    Join Date
    Sep 2004
    Location
    NY
    Posts
    5

    Unhappy Unanswered: New sql registration

    I have a database that runs sql 7. Most of our workstations are running on a windows 98 platform, however, a few are running windows 2000. I am trying to set up a new sql registration in enterprise manager, but the connection is failing. All of the 98 machines are logging in with a sql user name, but I was told to log the 2000 machine as a NT server. If you can understand what my problem is, could you please advise me?
    thanks

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What's the error you're getting? "Server doesn't exist or access is denied" or something else?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Sep 2004
    Location
    NY
    Posts
    5
    It really isn't a error. IN the final box where you click finish, it says "SQL-unable to establish a connection, registration failed"
    thanks
    joyce

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    You trying to register a 2000 server in 7.0 EM ???
    Aint gonna happen !!!
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I THINK what they meant was that the Windoze-2000 machine should connect to your SQL 7.0 Server using NT authentication. If that is the case, In the "Connect Using" dialog you should use the NT Account instead of a SQL Login like you use on your Windoze-98 machines.

    -PatP

  6. #6
    Join Date
    Sep 2004
    Location
    NY
    Posts
    5
    Quote Originally Posted by Pat Phelan
    I THINK what they meant was that the Windoze-2000 machine should connect to your SQL 7.0 Server using NT authentication. If that is the case, In the "Connect Using" dialog you should use the NT Account instead of a SQL Login like you use on your Windoze-98 machines.

    -PatP
    Yes that is what I mean.
    I did use the NT auth, but it still won't connect, any other ideas??
    thanks
    joyce

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My first guess would be that you need to enable NT Authentication for the NT login that the user of the Windoze-2000 machine will be using.

    -PatP

  8. #8
    Join Date
    Sep 2004
    Location
    NY
    Posts
    5
    Well I thought it was enabled, is there a way to tell whether it is or not?

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Check in Enterprise Manglerto see if you can see the user's NT login in the list that is under the Server | Security | Logins.

    -PatP

  10. #10
    Join Date
    Sep 2004
    Location
    NY
    Posts
    5
    ok, yes, the NT auth. is enabled. The user says NT user under type.

  11. #11
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You should check server properties for authentication. It's also not a dynamic property, which means Configured maybe different from Running (needs service bounced)
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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