Results 1 to 3 of 3
  1. #1
    mcode is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Mar 2016
    Posts
    2

    Access to SSL sql server

    Hi All,


    I am facing issue with access database to connect to SQL server in different domain. I am using
    connetionString = "Provider=sqloledb;Network Library=DBMSSOCN;Data Source=xxx.xx.xx.xxx;Initial Catalog=people;User ID=user;Password=pass;Encrypt=True;"

    Error : [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    Also, we have recently implemented ssl on the sql server. And installed the cert in my local machine. But all the time getting error to connect from access to sql.
    I have also tried new data source widget in access but same error.
    Any suggestions?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    did you try using the ODBC app to see if you can build a DSN with your connection?
    Test to see if it connects, if not, you may need a newer ODBC driver for it.

  3. #3
    mcode is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Mar 2016
    Posts
    2
    Tried user DSN with Microsoft SQL Server and Microsoft SQL Server Native Client Version 11.00.5058

    Running connectivity tests...


    Attempting connection
    [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
    [Microsoft][SQL Server Native Client 11.0]Login timeout expired
    [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.


    TESTS FAILED!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. ACCESS as a GUI for SQL SERVER
    By elico in forum SQL Server
    Replies: 2
    Last Post: 03-06-2016, 05:01 AM
  2. ACCESS and SQL SERVER
    By elico in forum SQL Server
    Replies: 1
    Last Post: 01-31-2016, 04:34 PM
  3. Replies: 1
    Last Post: 02-23-2015, 07:06 AM
  4. Replies: 2
    Last Post: 11-21-2012, 09:57 AM
  5. access - FTP Server
    By mtownend in forum Access
    Replies: 2
    Last Post: 04-07-2011, 03:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums