ContributionsMost RecentMost LikesSolutionsRe: SQL Server does not exist or access denied after server change Yes, I'm able to connect and query using the credentials from the TC machine SQL Server does not exist or access denied after server change We retired our old test server for a new one and I'm now getting this error "[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied." despite updating the connection string to match the new server. This was working before we switched servers so I have no clue what's causing the problem. Using connection string formatDRIVER={SQL Server};SERVER=[server name];UID=[valid SQL Server login];PWD=[valid SQL Server pwd for server];DATABASE=[initial DB to connect to]. I've confirmed the user and password work through SSMS and I've got no clue what the problem could be. Using VBScript. Re: Get return value from a stored procedure I'm not the one who made the stored procedure and I don't have enough experience with them to be sure how it was setup. How would I access the second dataset to get the value I'm looking for? Editing the sproc is not an option. Get return value from a stored procedure I followed thedocumentation on stored procedureshere and I'm able to get my stored procedure to run, but my return value is always 0. I've searched high and low for my problem but no one else seems to be having it. Set sproc = ADO.CreateADOStoredProc sproc.ConnectionString = Project.Variables.ConnStringDB02 sproc.ProcedureName = WMSLib.useDB & ".dbo.get_TestLabel" Call sproc.Parameters.AddParameter() sproc.Parameters.Items(0).Name = "RETURN_VALUE" sproc.Parameters.Items(0).DataType = adInteger sproc.Parameters.Items(0).Direction = adParamReturnValue sproc.Parameters.Items(0).Value = Null Call sproc.ExecProc() 'this always ends up being zero labelNum = sproc.Parameters.Items(0).Value Solved