SQL Server 2005 Developer edition Windows XP Pro
This is a new install on this laptop. Trying to connect to the Database Engine using management studio using either TCP/IP or named pipes but getting errors regarding the server refusing connection. I've Googled these errors and as far as I can see I made all the adjustments that I need to.
TCP/IP
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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
Named Pipes
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: 2)
I've opened up both protocols in the Configuration Manager and I've opened up local and remote connections to both protocols in surface area configurator. Even tried this with the windows firewall switched off.
Any suggestions anyone?
Thanks
DaveAfter installation, did you check if the services are running?|||Yep, in fact I restarted most of them to be sure. This laptop briefly had SQL 2005 Express on it a while ago and even though that software has been removed the machine still thinks it has an instance installed.
Is it an issue to have a DHCP assigned IP address when using SQL 2005?
Dave|||
No I don't think as my laptop is with similar configuration and have no issues in connecting to the SQL instances.
Make sure SQL Browser service is up and running. Refer to http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx on Performing Configuration Changes topic.
HTH
york001 wrote:
Is it an issue to have a DHCP assigned IP address when using SQL 2005?
Dave
No comments:
Post a Comment