I'm trying to use the default membership provider for my .NET app. I don't have many users, so I thought I'd just go with the ASPNETDB.MDF.
It works great in development, but I this error on my production server.
"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)"
Any ideas why? My web.config has no reference to LocalSqlServer at all. Do I need it to? I thought that if I put nothing at all, it will default to in and look in App_Data/ASPNETDB.MDF. Am in wrong in that assumption?