Need to repoint my PXE server to a new SQL server. On the app server I could just use bladmin show database. On the PXE server, when I run it against the _pxe deployment I get the following:
bladmin:_pxe>show database all
[15 May 2012 08:16:23,889] [main] [ERROR] com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host emda-nbp-uea26, port 1433 has failed. Error: "Connection refused. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
emda-nbp-uea26 is the old DB server. I need to change that, but can't find the string in any files.
Blasadmin –s _pxe set pxe …
The db connection is in a different section.
That did the trick! Thanks.