So I just installed DNN on my local machine, and I'm having trouble with connecting to external databases.
When I configured my DNN site, I foolishly chose to take the default or local option. Now that I can see the DNN site, I can't switch the database over to remote SQL server. Does anyone see where I configured it incorrectly?
1.located the database at /app_data/Database.mdf
2. turned off my IIS for that website, and transferred the file over to the SQL data folder.
3. Attached the database to the SQL server
4. Created a new user dnn_user as a login, for the SQL server and for the database. Gave the dnn_user permissions and marked it as "db owner"
5. Checked the database, it seems to be working fine, has tables, has security set up.
6. changed web.config file for my site. Under connection strings:
<add name="SiteSqlServer" connectionstring="Server=dbServer1;Database=Web_DNN9;uid=dnn_user;pwd=##;" providername="System.Data.SqlClient">
7. Added this to appsettings:
<add key="SiteSqlServer" value="Server=dbServer1;Database=Web_DNN9;uid=dnn_user;pwd=##;">
With these two modified/added to the web.config, all I get is a cannot connect to the database error...
Does anyone see what I missed doing?