March 22, 2011 at 2:42 am
Hi I'm getting an error message that
DataBase Connect fail
An error has occurred while establishing a connection to the server. When connecting to SQL Server, 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.)
Operating system is XP and sql server is 2000 I'm trying to connect Hanvon software server to sql for database but its giving this error. I was successful only 1 time but unfortunately I uninstall SQL due to some reason after reinstalling I'm getting this error even on other machines I don't know why this is happening Kindly help.
Sorry for my poor English.
March 23, 2011 at 4:54 am
Have a look at
http://www.issociate.de/board/goto/766405/installing_msde2000_for_remote_connection.html
Is sql2000 the msde version?
From SP3 on there is some extra configuration work for remote connections.
March 24, 2011 at 6:50 am
Sorry I'm quite unaware of its msde version but I can access the following data
Microsoft SQL Enterprise Manager
Microsoft Corporation
Version: 8.0
I already checked remote settings it enable but still giving this error
March 25, 2011 at 6:04 am
Are you using fixed or dynamic ports?
Either way, try adding the port to your connection string. However if you are using dynamic ports the port will probably change on each restart of the sql server.
myserver/instance,port
If the dns name doesn't work trying IP and port.
IP,port
March 25, 2011 at 11:07 am
also check out the firewall settings
http://msdn.microsoft.com/nl-nl/library/cc646023(SQL.100).aspx
March 26, 2011 at 5:42 am
my windows firewall is off
I also try this on other machine but giving same error
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply