Results 1 to 4 of 4

Thread: No connection to SQL database

  1. Jan 28th, 2025, 04:44 PM #1
    Darby
    Darby is offline

    Thread Starter
    Junior Member
    Join Date
    Aug 2021
    Posts
    26

    No connection to SQL database

    I received a notification that there was an update to MS SQL so I ran the update. I have an application that I had been running for many years but not lately. When I started it recently it wouldn't connect to the SQL database, When I run the app, it throws the following message:

    System.Data.SqlClient.SqlException
    HResult=0x80131904
    Message=Cannot open database "D:\DATA FILES 092015\DVD_LIST.MDF" requested by the login. The login failed.
    Login failed for user 'DESKTOP-H7RL6S9\Darby'.
    Source=.Net SqlClient Data Provider


    When I go into SQL Server the database comes up and I can run queries and everything runs great. Something changed to affect my application, and I don't know how to fix it. I can't find in the application where it attaches to the database so I can't make any changes to the connection string if necessary.

    Let the smarter minds prevail

    darby
    Reply With Quote Reply With Quote
  2. Jan 28th, 2025, 05:22 PM #2
    Shaggy Hiker
    Shaggy Hiker is offline
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    40,102

    Re: No connection to SQL database

    What kind of program, desktop or web?
    My usual boring signature: Nothing
    Reply With Quote Reply With Quote
  3. Jan 29th, 2025, 02:00 AM #3
    Zvoni
    Zvoni is offline
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    5,261

    Re: No connection to SQL database

    Quote Originally Posted by Darby View Post
    I can't find in the application where it attaches to the database so I can't make any changes to the connection string if necessary.
    Search the whole project for "DVD_LIST.MDF"
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad
    Reply With Quote Reply With Quote
  4. Jan 30th, 2025, 12:08 PM #4
    Darby
    Darby is offline

    Thread Starter
    Junior Member
    Join Date
    Aug 2021
    Posts
    26

    Re: No connection to SQL database

    Quote Originally Posted by Shaggy Hiker View Post
    What kind of program, desktop or web?
    Desktop, single private user

    darby
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width