SQLTeam.com | Weblogs | Forums

Need to transfer SQL Agent Jobs to a new DB server


#1

I have a requirement to move the SQL Agent Jobs in SQL Server to a new SQL Server. The existing SQL Server is of the version SQL Server 2014 installed. I have installed the target or the new SQL Server with version SQL Server 2014, in order to avoid any compatibility issues. When I tried to login the new SQL Server using the credentials , I am getting the error message "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible " I have ensured that SQL Services are running. What might be the problem here?


#2

Read this. This may help you out:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-2017