Viewing 8 posts - 1 through 8 (of 8 total)
When I run the following on Server 2
USE master
GO
xp_readerrorlog 0, 1, N'Server is listening on'
GO
LogDate ...
March 4, 2016 at 4:01 am
When I tried to connect Instance 2 from Server 1 SSMS, it generates the following error
TITLE: Connect to Server
------------------------------
Cannot connect to Server 2\Instance2.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while...
March 4, 2016 at 3:07 am
Is SQL Browser running on server 2?
What are the server protocols enabled on server2?
YES SQL Browser running on server 2
protocols enabled on server2 are : TCP/IP,Named...
March 4, 2016 at 3:00 am
Is SQL Browser running on server 2?
What are the server protocols enabled on server2?
---------------------------------------------
YES SQL Browser running on server 2
Protocols enabled in Server 2 are : TCP/IP, NamedPipes and...
March 4, 2016 at 2:53 am
When I use the following Value,
LINKED SERVER : Instance2
Provider : Microsoft OLE DB Provider for SQL Server
Product Name: SQLSERVER
Data Source : Server2\Instance2
Provider String: empty / No Value is given/
Catalog:Database2 /...
March 4, 2016 at 2:47 am
I told the Network Admin to OPEN port Number 1433 and 1434 in the firewall
Using the tool, it returns the following status from Server 2
TCP port...
March 4, 2016 at 2:28 am
When I tried to connect I am getting the following error.
TITLE: Microsoft SQL Server Management Studio
------------------------------
The test connection to the linked server failed.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL...
March 4, 2016 at 12:30 am
Thank you for the reply.
For the environment above, is there any one who can tell me the following values in the linked server Intrerface.
Linked Sever:_________________
SQL SERVER:_________________
Other Data Source:____________
Provider:____________________
Product Name:_______________
Data...
March 3, 2016 at 4:49 am
Viewing 8 posts - 1 through 8 (of 8 total)