To delete a primary database connection, use sp_dropprimaryconn:
sp_dropprimaryconn "conn_name"
where conn_name is the connection name in the form ds.db.
