We added a SQL new server , works fine. But..when I attempt to change a procedure on my reporting server to point to the new server I get :
OLE DB provider "SQLNCLI" for linked server "VSMIADBGP01\GREATPLAINS" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "VSMIADBGP01\GREATPLAINS" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
The checkbox for 'allow remote connections' is checked. My network guy can see when I try and change the proc that Im allowed in. So I'm not sure what to check.