dcsimg
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006
    Location
    Scotland
    Posts
    2

    Exclamation ODBC connection Timesout....then allows connection

    Hi All,

    First post on your forum, so if this is in the wrong section I apologise, haven't been able to locate any help on this so far. A colleague has 'very kindly' asked me to look into this for him.

    I'm using Access to access an SQL database. When I first try to connect ot the database i get -
    Connection failed
    SQLState: S1T00
    SQL Server Error 0
    [Microsoft][ODBC SQL Server Driver] Timeout expired
    click OK
    Then get asked for the server login, leave all info as is and hit OK and then I get to see my data

    Any help is appreciated folks

    Wasn't sure if this would be useful - Connection string
    ODBC;Description=Issues Log User Sec;DRIVER=SQL Server;SERVER=GBDAL11W3AS025;APP=Microsoft Office 2003;WSID=GBDAL11D1VRN61J;DATABASE=IssueLog;Truste d_Connection=Yes

  2. #2
    Join Date
    Dec 2006
    Location
    Scotland
    Posts
    2
    OK problem resolved, issue was tracked down to a cockup in the server set-up, it wasn't authenticating Window users properly.

    Isn't outsourcing fun.

  3. #3
    Join Date
    Nov 2015
    Posts
    1
    Hi,

    I am experiencing the same behaviour. What exactly did you do to get rid of the problem?

    SQL Server Properties I have:
    Athentication: SQL Server and Windows

    SQL Server Network Utility, Enabled protocols: Named Pipes, TCP/IP

Posting Permissions

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





×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.