I'm facing some challenges after migrating to a new server running Windows Server 2022 for our webapp. Our old servers relied on the main server's database for essential data, including user credentials. However, when we set everything up on the new server, it couldn't access the main database, yet we confirmed that hosting the database locally worked fine. Now, I'd like to ask: 1) Why can't the new server read from our main server's database when all the other servers can? Could it be a firewall or configuration issue? 2) Given the situation, is it wise to make this new server the main one? I have my reservations about this possibly causing more complications. 3) I need to transfer .bak backup files from the old server to the new one. While I have scripts for backing up and restoring, I'm not sure how to physically transfer the backup files since the servers aren't on the same LAN. Any guidance would be appreciated!
3 Answers
It's possible that the new server isn’t correctly configured to connect with the old one. Double-check your network settings and SQL Server configurations. For the .bak files, I suggest using a USB drive or setting up a simple FTP connection, even if the servers aren't on the same LAN. Getting a USB external drive can also be a quick fix; they’re relatively cheap and easy to use for transferring files.
It sounds like your new server might be facing some network configuration issues. If it's a 'couldn't read from it' problem, I'd definitely look into the Windows Firewall settings first. There shouldn't be significant changes in SQL compatibility with Windows Server versions. As for transferring your .bak files, you might need to use an external USB drive or set up an intermediate storage solution, like a shared cloud drive, since transferring directly through the internet might require some additional setup.
There’s a lot to unpack here, and I think several things could be causing your issues. First, make sure the SQL Server TCP/IP listener is functioning correctly and check your firewall rules; they might be blocking access. The method to transfer your backups depends on your exact situation, but using an FTP/SFTP service could work if you're trying to do this over the internet. If the problem persists, hiring a qualified sysadmin to help with the migration could save you a lot of headaches.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures