| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2009-11-12 : 17:59:54
|
| I am trying to connect to another sql server from one sql server getting below errorTITLE: Connect to Server------------------------------Cannot connect to server.------------------------------ADDITIONAL INFORMATION: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) (Microsoft SQL Server, Error: 53)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476------------------------------BUTTONS:OK------------------------------ |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-11-13 : 13:56:01
|
| Tried all possibilties still throwing same errorWe have two servers production and DR server(planning to set up logshipping)In both servers sql server std edition is installed, both are in same workgroup and no firewall and all ports are openI am trying connect DR server from Prod server thru SSMS. Getting below errorDR server ip is pinging in prod server and1433 port is connectedRemote connections are allowed in DR server and network ports are enabled. In both servers SQL Server services running under local system account.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) (Microsoft SQL Server, Error: 53)trying connect thru windows authenticationtried with servername in SSMSipip,1433servername,1433I am able to connect to DRSSMS in DR server with window auth |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-11-13 : 17:41:10
|
| 1433 is listening |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-11-16 : 12:35:17
|
| I found one strange thing.....In prod server ssms i tried to connect dr sql server using DR server ip, it connected but servername is prod servername...same thing happens in DR server alsoDR IP(sql server 9.00.1399-prod servername\adminstrator)and it is not in started symbol(green) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
MuadDBA
628 Posts |
Posted - 2009-11-16 : 13:16:40
|
| Are you saying that your DR server internally has the same name as your prod server, or are you saying that that your DNS is storing the same IP for both servers? Wehn I look in SSMS the stuff in () is my Domain name and the windows account I use to connect to it. It's possible your DR server is not on the domain properly? Or maybe you do not have a domain set up?How aer you attempting to make this connection to the 2 servers...via a linked server connection, or something else? |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-11-16 : 14:08:42
|
I have two servers (server1 and server2) in same workgroup.IN both the servers SQL Server is installed and remote conn and network protocals are enabled. checked 1433 port alsoNow I want to connect to Server2 SQL Server from Server1 SSMS remotly-thru windows authenticationThrowing above error.When I tried with Server2 ip it connected but showing server1 nameServer2 IP(sql server 9.00.1399-<server1 name>\adminstrator)quote:
Originally posted by tkizer
I don't understand your last post.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
|
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-11-16 : 14:15:32
|
DR server has different nameHow to check whether DNS is storing the same IP (Only I know that both servers are in same workgroup)Servers are in same workgroup not in domainI am attempting to connect DR SQL server remotely form Prod server SSMS thru windows authentication.quote:
Originally posted by crazyjoe
Are you saying that your DR server internally has the same name as your prod server, or are you saying that that your DNS is storing the same IP for both servers? Wehn I look in SSMS the stuff in () is my Domain name and the windows account I use to connect to it. It's possible your DR server is not on the domain properly? Or maybe you do not have a domain set up?How aer you attempting to make this connection to the 2 servers...via a linked server connection, or something else?
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
connection error