Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlferns
Starting Member
8 Posts |
 Posted - 2008-03-10 : 18:41:38
|
| hi,I have finished installing the sql server on clustered machine having 2 nodes.installation was successfull. but when connect my management studio to the vertual machine. It gives the below message. Is there anything I have to do .... in connecting the vertual machine to local system.In the surface check - i have enable the remote connection.=================================Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.===================================An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476------------------------------Error Number: 2Severity: 20State: 0 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-10 : 19:22:45
|
| Try using VirtualServerName,PortNumber in SSMS.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sqlferns
Starting Member
8 Posts |
Posted - 2008-03-11 : 11:10:21
|
| i had to change the port to 1433 - now it is working fine.Thanks a lot for the help. |
|
|
|
|
|
|
does not connect to vertual server