I try to connect through: Microsoft SQL Server Database File (SqlClient), but I recieve error:
The attempt to attach to the database failed with the following information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)
So, i click Connect to Database in Server Explorer
This window show up. In which i choose: Microsoft SQL Server Database File (SqlClient) and then browse my .mdf database file.
Clicking ok gives error mentioned before:
Server is running, I use windows authentication in database. Any sugestions?
You need the SQL Server Express LocalDB add-on, you can get it from here in both x86 & amd64 versions.
I had faced same issue when I deployed my software on test machine.
Solution:
SELECT @@VERSION
. If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With