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:o:o:(
Re: No connection to SQL database
What kind of program, desktop or web?
Re: No connection to SQL database
Quote:
Originally Posted by
Darby
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"
Re: No connection to SQL database
Quote:
Originally Posted by
Shaggy Hiker
What kind of program, desktop or web?
Desktop, single private user
darby