When attempting to remote deploy at the "SQL Servers" step in Remote Deploy wizard, the server is not shown as being a SQL Server. The attempt to manually add the server returns the following error.
Error adding server. Reason: Object reference not set to an instance of an object.
Pressing "Refresh" doesn't return the server name in the dropdown.
Name resolution using nslookup completes correctly. The account used for the deployment is a local admin on the server being deployed to and has necessary permissions on the database.
Workaround:
Use Local Deployment instead of Remote Deployment.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center