dcsimg
Page 1 of 2 12 LastLast
Results 1 to 15 of 24

Thread: SQL Server 2000 - absolute beginner! Please help me

  1. #1
    Join Date
    Nov 2002
    Posts
    7

    Angry SQL Server 2000 - absolute beginner! Please help me

    Hello there...
    Pending receiving the full version from the higher powers at my work, I have downloaded the Evaluation version of SQL 2000, and set up an instance on my desktop machine. This was set up on an administrator account, and works fine.
    My main aim with SQL 2000 is to upsize all the companies piddling little Access 97 databases into an SQL backend and keep the 97 frontends. I have migrated some of the tablesets into SQL, and linked to them in Access 97 and they work fine.
    However, the problems are when I try and set up ODBC. When I enter ODBC as a different user on the server itself, the ODBC list of available SQL Servers shows me the correct server information - my PC ID no, followed by the server name. However, when I try and connect with another machine on the network, it only displays the PC ID no of the server, and not the server name. When I attempt to add the server with just the PC name, it doesnt find the server - same when I add the name of the database to the end of the PC ID no.
    I'm sure there is something really basic I have not done, but I'm totally stumped now. I am using Windows Auth, and have set up the login of the other PC I am trying to connect, as an authorised user.
    Please help me - I am just a doofus, please feel free to laugh at me...

  2. #2
    Join Date
    Sep 2002
    Posts
    23
    Not laughing - we all started somewhere!

    First thing to check.

    Are the machines members of a domain or not. Windows auth across machines requires a domain.

  3. #3
    Join Date
    Nov 2002
    Posts
    7
    Yes they are all part of the same NT domain.
    Cheers for not laughing, I have training for this booked for Jan, but a project to complete prior to them - IT eh.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Did you install sql server on those pcs with problem? What's error message?

  5. #5
    Join Date
    Nov 2002
    Posts
    7
    No I'm not going to be installing SQL server on those machines, only using ODBC to connect Access 97 databases to them - they are extremely tight for user licences in this company, and they refuse...
    Hope I have understood/explained correctly.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Do you have odbc driver for ms sql on those pcs?

  7. #7
    Join Date
    Nov 2002
    Posts
    3
    try using system ODBC DSN ....

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    Go to drivers tab to see if sql server driver is there.

  9. #9
    Join Date
    Nov 2002
    Posts
    7
    Hi there,
    I do have SQL drivers on the other PCs. I'm not sure what you are suggesting when you say "Use ODBC DSN"... please could you elaborate.

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    Then create system dsn that points to your sql server.

  11. #11
    Join Date
    Nov 2002
    Posts
    7
    Hi... I have tried to create a System DSN on the client machines, and have one set up on my server that works. However, I still am unable to "see" the instance on a remote machine - only the server name.

  12. #12
    Join Date
    Sep 2002
    Posts
    5,938
    Have to type it.

  13. #13
    Join Date
    Nov 2002
    Posts
    7
    Hi... I'm afraid I have tried that too... and it doesn't work when you type it either.
    I have tried it from a machine with SQL Server Client software on it, and the Client network utility picks it up on TCP/IP - server name and instance. However, it still won't set it up in ODBC.

  14. #14
    Join Date
    Sep 2002
    Posts
    5,938
    Choose tcp/ip netlib in odbc.

  15. #15
    Join Date
    Nov 2002
    Posts
    7
    When I am configuring the Client configuration on ODBC, it is set to TCP/IP already, and to dynamically determine the port - the same as the one working connection I have set up. It still doesn't work.

Posting Permissions

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