Migrating from CSLA 2.1.4 to 4.0.0.100723. Using the same Project Tracker database as 2.1.4 I am not able to connection to the database in the 4.0 project tracker. Receiving the following error:
DataPortal.Fetch failed (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: 26 - Error Locating Server/Instance Specified))
I'm using identical connect strings in both the 2.1.4 and 4.0.0.x project config. Are there other changes that need to be made in the app.config to allow connections (see attached 4.0.0 app.config)? The CslaDataPortalProxy key does not exist in the 2.1.4 app.conif file and I don't know enough yet how this is used.
Thanks in advance.
CslaDataPortalProxy is used to configure the data portal to use a remote server. If that key is setting the value to something other than "Local" then the connection string you care about is in the remote server's web.config file. Odds are good that you need the WcfHost or WcfPortal project (whatever I called it), as that's the process that is really talking to the database.
Copyright (c) Marimer LLC