Results 1 to 15 of 15
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: URgent pls help!!!!!!!!

    Hi:

    We are currently in the process of testing our Webserver migration to Win 2000 and came across a problem while setting up a ODBC dataserver connection to the SQL database on USAWDB1. When I try to setup the connection on WWWBOXSTER2 its giving the error message "Login failed reason: Not associated with a trusted SQL server connection" . Please advise

    Pls help its very urgent

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    You are trying to set up a dsn ???
    Get yourself a copy of the The Holy Book

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

  3. #3
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    reply

    yeah we r trying to set up an dsn

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    One of two things is going on. Either SQL 2000 was installed to accept only Windows Authenticated connections (default), or the ODBC is trying to use a Trusted connection to the database (also default).

    The first can be fixed by going to the properties of the sql server in enterprise manager. The second can be fixed by selecting the right radio button on the login screen.

  5. #5
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    reply

    thnx alot crawley for replying back.

    can u be more specific it would be very helpful


    thanks a lot again

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Are you using windows authentification or sql server authentification in your odbc connection ? Check to see if you sql server is using windows only or mixed authentification ... In enterprise manager, right click the server and select properties -> security ...

  7. #7
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    reply

    we are using sql server authentication.
    thnx for ur reply
    waiting for ur reply again.

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    OK -but what is your sql server setup to handle - Did you check out the security settings in enterprise manager ?

  9. #9
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115
    to be true we are not able to login to the clients machine and have to suggest them the solution th'gh their conversation. which i have already mentioned.

    thnx for reply.
    waiting for ur reply.

  10. #10
    Join Date
    Feb 2002
    Posts
    2,232
    Do you mean that sql server is installed on the client machine ?

  11. #11
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Just re-read the post. Let's get a few facts straight, then.

    1) The Database server has not been upgraded/reconfigured in any way?

    2) The WebServer has been upgraded to Windows 2000. Is it a different physical machine?

    3) If it is a different physical machine, is the old one available (for reference)?

    If the answer to three is yes, then the client should be able to copy the ODBC DSN exactly. I do not believe the screens have changed very much from NT4 to Win2K.

  12. #12
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    from www.Dictionary.com

    As meant by Aadil
    cli·ent
    The party for which professional services are rendered, as by an attorney.

    As meant by rnealejr
    A computer or program that can download files for manipulation, run applications, or request application-based services from a server.
    Get yourself a copy of the The Holy Book

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

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Fact 4) "Crowley", not "crawley"

  14. #14
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Dictionary.com mentions us? We certainly have given them enough free plugs ;-).

  15. #15
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    And to Blindman: I know I creep out a lot of people, but that typo back there did go a touch far ;-).

Posting Permissions

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