I have a database, TestDb01, which I've created using Management Studio and added a test table to.
The files TesDb01.mdf and TestDb01_log.ldf are at
C:\Program Files\Midrosoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA
With C# Express, I don't have a Server Explorer. When I rClick on Data Connections, I get a 'Choose Data Source' window, offering the options:
Microsoft Access Database File, or
Microsoft SQL Server Compact 3.5, or
Microsoft SQL Server Database File
Taking the last option, as it says, "Use this selection to attach a database file to a local Microsoft SQL Server instance (including Microsoft SQL Express", I then get to the actual 'Add Connection' box from which I can browse to the above .mdf file.
Unfortunately, 'Test Connection' fails with 'Error 26 - Error locating Server / Instance specified' (in yet another window that I can't Copy the text from, btw).
What's its problem? And h ...
Go to the complete details ...