Results 1 to 4 of 4
  1. #1
    RayMilhon is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,067

    SQL Server Security issue

    Msg 18456, Level 14, State 1, Line 1
    Login failed for user 'RMILHON'.



    I get this error on 1 View in my Database. However, I'm logged in as HPN\RMILHON the system Administrator. I only get this when trying to open 1 View all of the other views, tables, stored procedures everything else works just fine. This is an old login when the system was first set up in 2012. I don't believe it's used anymore but there could be some older MS Access front ends that use this login in the ODBC Driver for those DB's.
    Any body have an idea why I would get this on 1 and only 1 view especially when I'm not logged in under that user code?

  2. #2
    RayMilhon is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,067
    ok, I finally figured it out. That particular View uses a link to another SQL Server Database and the login for RMILHON on that Database has been changed. It's working now.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Thanks for posting the solution...

    Ready to mark this solved?

  4. #4
    RayMilhon is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,067
    Thanks forgot to do that.

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

Similar Threads

  1. SQL Server Security Issue
    By RayMilhon in forum SQL Server
    Replies: 3
    Last Post: 01-06-2014, 11:44 AM
  2. Security with SQL Server 2005
    By Datech in forum SQL Server
    Replies: 2
    Last Post: 07-08-2012, 03:57 PM
  3. Access security ODBC to SQL Server
    By Mark@CHP in forum Security
    Replies: 3
    Last Post: 03-27-2012, 08:31 AM
  4. access on server security
    By bigmac in forum Security
    Replies: 1
    Last Post: 03-11-2012, 06:02 AM
  5. Replies: 1
    Last Post: 01-29-2011, 10:52 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