When creating a SmartConnect map, when going to select a company destination, it is showing a different SQL instance, and any maps created are being sent to the wrong SQL server instance.
This typically happens if you restore a SQL database from one SQL instance to another.
To determine the SQL server name type the following into SQL Query analyzer:
select @@SERVERNAME
If the name is incorrect, you need to change it by running the following commands in SQL server query analyzer:
sp_dropserver 'old_name' go sp_addserver 'new_name','local' go
You will need to stop and start the SQL server in order for the change to take effect.
