SQL Server Performance Forum – Threads Archive
Error in opening SQL Server
Dear Friends, I am using sql Server 2005 standard edition…Due to some maintenance work I changed the IP Address range of DHCP.The DHCP server & Database server is on same machine. When I restarted the system…I am not able to start SQL Server using windows authentication mode or SQL server mode..Error is….. 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) Please guide me what to do.Thanks & regards,
Taher
Hi,<br />have you ensure changes are in affect in Sql Server Configuration Manager->SQL server 2005 Network Configuration-><img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />rotocols for SQL Server 2005 ????<br /><br />Hemantgiri S. Goswami<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />————————<br /<a target="_blank" href=http://hemantgirisgoswami.blogspot.com>http://hemantgirisgoswami.blogspot.com</a>
hello Mr.Hemantgiri,<br />yes, changes are affected in Sql Server Configuration Manager->SQL server 2005 Network Configuration-><img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />rotocols for SQL Server 2005.<br />All the services are stopped accept SQL Server Integration service. I tryed to star sql server service but it failed.<br />Please Guide me.<br />Thanks
ENsure NAMED PIPES protocol is enabled on this server, as it might get disable few times. Also KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 fi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Hi,
If you have privilege check if the NetBIOS over TCP/IP is enabled and NET DDE ,NET DDE DDSM service are running in Services . Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com
]]>