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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 A network-related or instance-specific on DB mirro

Author  Topic 

imughal
Posting Yak Master

192 Posts

Posted - 2011-11-23 : 07:38:37
hi,

Working on DB mirroring for SP DR. i have configure new sharepoint with new database with alias name and its working fine.

when trying to configure DB mirroring, on principle server i am unable to connect mirror server using alias name. i am able to connect mirror server using computername\instancename its work fine and i get connected.

but when using alias name getting following error message.
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) (.Net SqlClient Data Provider)

when i try to create .udl file and test its work fine.secondly

please help how to fix it.
   

- Advertisement -