gtrapp
asked on
How to make a SQL Server 2008 instance visible
I am on Windows Server 2008 R2 Standard server. On this server there is SQL Server 2008 R2 with a databases installed. I like to see this instance from other servers, but it is not visible. On this server I am in SQL Server Configuration Manager and looking at the protocols for the instance I want to see, I have Named Pipes and TCP/IP enabled. "Allow remote connections to this server" is checked. However, I still can not see the instance. Can you help?
ASKER
When I am on another server with SQL Server 2008 R2, I can not connect to the database engine on the other server. The other server with SQL Server 2008 is up and running. I see this error:
TITLE: Connect to Server
-------------------------- ----
Cannot connect to pls-sea.
-------------------------- ----
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
TITLE: Connect to Server
--------------------------
Cannot connect to pls-sea.
--------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
Step 1) Make sure SQL SERVER is up and the instance you try to connect is running.
Step 2) Your system Firewall should not block SQL Server port.
Step 3) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration
Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.
Step 4) Now follow this KB Article of MSDN depending on your server : http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
Step 2) Your system Firewall should not block SQL Server port.
Step 3) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration
Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.
Step 4) Now follow this KB Article of MSDN depending on your server : http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what do you mean you cannot see?
you cannot conenct or you get an error?
can you ping the server remotely?