I'm using the Web Site Administration Tool to create users, set roles, etc, all on my development machine. When done, I'm publishing everything to the server.

On my dev machine, everything works great. But after publishing, I either get that error, or everything works without having to log in.

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)
After I published the files, I noticed the App_Data folder wasn't publishing. Which looks like it has the database. So I copied it over, but still no dice.

I Googled this and it seems the most common issue is the connection string. The connection string on the local machine is different than on the server. Which makes sense. But there are no connection strings in the web.cofig file. At least not for this anyway. I have two setup for a different server, but that's irrelevant.

Does anyone know how I'm supposed to specify the connection string, if I'm even supposed to? Or any ideas what else might be the issue?