Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    46

    Unanswered: Cannot connect to Sql server - help

    Hi,
    I used to work with Sql server 7.0 and my connection string was:
    Provider=SQLOLEDB;User ID=sa;Password=;Initial Catalog=Eldat_DB;Data Source=YOSSIBA

    After clean unregister and installing Sql server 2000 Using the same connection string I get the error:
    Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

    After removing 'sa' I got the error:
    Login failed for user 'yossiba'. Reason: Not associated with a trusted SQL Server connection.

    My configuration of the server was wrong?
    How do I know Provider,Use ID,Password,Data Source parameters?
    Please advise

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    I think you need to chek the connection string with respect to the logins on the server.And the corresponding frontend too.

  3. #3
    Join Date
    Aug 2002
    Posts
    46
    Originally posted by harshal_in
    I think you need to chek the connection string with respect to the logins on the server.And the corresponding frontend too.
    Hi,
    When I entered EM..right click on the SQL Server | properties
    I have noticed that under Security Tab 'This Account' is marked and the Domain and name are correct but the Password is not the same password I enter to my computer (it is longer).
    Trying to change the password won't let me althogh I am registered as an administrator.
    In addition to that the Authentication was Windows only, changing it to Sql server and Windows with sa and my computer password raised me and error: Login failed for user 'sa'.
    Can that mess be cleared?
    Thanks

Posting Permissions

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