Professional Web Applications Themes

Trusted connection from FoxPro 5.0 - Microsoft SQL / MS SQL Server

I am trying to create a trusted connection from a FoxPro 5.0 program to a SQL Server 6.5 via a VPN. I need to run an automated process, and of course, without the trusted connection it will always ask for a password. However, on matter what I do, the ODBC driver keeps telling me it is not associated with a trusted connection. Is there something I have to do on the SQL Server end to make this specific login "trusted"? -- Geoff Callaghan IT Manager TRAK Engineering [email]gcallaghantrakeng.com[/email]...

  1. #1

    Default Trusted connection from FoxPro 5.0

    I am trying to create a trusted connection from a FoxPro 5.0 program to a
    SQL Server 6.5 via a VPN. I need to run an automated process, and of course,
    without the trusted connection it will always ask for a password. However,
    on matter what I do, the ODBC driver keeps telling me it is not associated
    with a trusted connection. Is there something I have to do on the SQL Server
    end to make this specific login "trusted"?


    --
    Geoff Callaghan
    IT Manager
    TRAK Engineering
    [email]gcallaghantrakeng.com[/email]


    Geoff Callaghan Guest

  2. #2

    Default Re: Trusted connection from FoxPro 5.0

    Whatever login your Foxpro application is using, should have been granted
    access to connect to your SQL Server. See sp_grantlogin in SQL Server Books
    Online. Since you are on SQL Server 6.5, you'd probably need xp_grantlogin.
    Once the login is granted, you should also map this login to the desired
    database, with appropriate permissions.

    Also make sure your SQL Server 6.5 server is configured to accept Windows
    authenticated (trusted) connections.

    --
    HTH,
    Vyas, MVP (SQL Server)
    [url]http://vyaskn.tripod.com/[/url]
    What hardware is your SQL Server running on?
    [url]http://vyaskn.tripod.com/poll.htm[/url]




    "Geoff Callaghan" <gcallaghantrakeng.com> wrote in message
    news:#UwhbyxPDHA.2832TK2MSFTNGP10.phx.gbl...
    I am trying to create a trusted connection from a FoxPro 5.0 program to a
    SQL Server 6.5 via a VPN. I need to run an automated process, and of course,
    without the trusted connection it will always ask for a password. However,
    on matter what I do, the ODBC driver keeps telling me it is not associated
    with a trusted connection. Is there something I have to do on the SQL Server
    end to make this specific login "trusted"?


    --
    Geoff Callaghan
    IT Manager
    TRAK Engineering
    [email]gcallaghantrakeng.com[/email]




    Narayana Vyas Kondreddi Guest

Similar Threads

  1. Trusted sql connection failure
    By Arie in forum ASP.NET Security
    Replies: 1
    Last Post: February 14th, 03:34 AM
  2. Replies: 1
    Last Post: January 4th, 03:44 AM
  3. Trusted connection question
    By Peter in forum ASP.NET Security
    Replies: 1
    Last Post: May 4th, 02:12 AM
  4. ending a trusted connection
    By Alexander Stojakovic in forum ASP.NET Security
    Replies: 0
    Last Post: October 31st, 01:53 PM
  5. Not associated with a trusted SQL Server connection
    By vlad in forum ASP.NET Security
    Replies: 2
    Last Post: August 20th, 07:30 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139