After solving the problems with installing RIA here , I still get the following error. Not very special - I tried to create a new screen based on data sources from an existing database in a full instance of SQL 2005
An error occurred while creating a connection to an instance of SQL Server. \ SQLEXPRESS. Network-related or instance error establishing a connection to SQL Server. The server was not found or was unavailable. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL network Interfaces, error: 26 - Search error Specified server / instance)
I tried to fix the connection string in the autogen'd configuration file. Despite the fact that Visual Studio does not seem to think that the file is overwritten during the rebuild, the error continues to appear.
How can I use LightSwitch with full SQL 2005 and not SQL Express?
source
share