"Connection to the database failed" when moving to new server
Add an Answer
Your question has been submitted and is awaiting moderation.
I'm a total newby with DNN, so please excuse the (probably silly) question!
I've inherited a DNN site and am installing it on my windows 2008R2 server using SQL Server Express 2012.
I've used SQL database publishing wizard to transfer the database - it succeeded and there are plenty of tables in there with data in them. I then transferred the files, and modified the web.config file to point to the database credentials of the new server. For the time being I'm using 'sa' as the username in the web.config to ensure that permissions aren't going to create an issue (I'll modify to a more appropriate SQL user once it's working).
However, when I access the site I just get an error: "Connection To The Database Failed".
Like I said, I'm using the system administrator account and definitely the correct password in the web.config file, so I'm struggling to see what's wrong and why DNN can't connect.
Could anyone please point me in the correct direction with this? I'd be most grateful for any help :)
By the way, I don't know what version of DNN this is, the client can only tell me it's "recent" and I'm not sure how to find out for myself without being able to log in to the admin system!