In the Logshipping wizard, on the 'Subscribers' step, can't establish connection to the SQL Server selected under 'Specify Subscribers' (4257379)

Chatta subito con l'assistenza

Restituisci

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Titolo

In the Logshipping wizard, on the 'Subscribers' step, can't establish connection to the SQL Server selected under 'Specify Subscribers'
Descrizione

We register a SQL instance using a server name and port number. In the Log Shipping Wizard, we use the SQL instance a subscriber in a log shipping plan. However, we get an error on “Subscribers” page when "next" is clicked. Note that the port number is not part of the SQL instance name in the “Specify Subscribers” field on the "Subscribers" page.
The full error is "SQL Server: xxxx Domain user: xxxx Authentication type: Negotiate A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. We should be able to have the ability to use a port number with the SQL name in the log shipping wizard."
Causa

Software Defect. This issue is being tracked as LS-897: "Log shipping wizard does not use the port number of a registered SQL instance"
What the wizard is doing is its querying the Server for its name and using that without the port number. The server is registered with just an IP address and port number. But the wizard shows the SQL instance name instead with no port number
Risoluzione

WORKAROUND 1
Turn SQL browser service on. That will just make it so it can look up whatever port it needs
WORKAROUND 2

Create an alias with port number in the name.

STATUS

Waiting for fix in a future release of LiteSpeed.
ID difetto

LS-897

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Contenuti consigliati

Cronologia articoli:: Data di creazione: 4/1/2018
Ultimo aggiornamento: 5/7/2023

Titolo