I am using Visual Studio 2005 withSQL Server 2000. I'm having an issue where I can build my website just fine for long periods of time, and then for what appears to be no reason, my site errors out when trying to connect to the database with the message below -- the thing is I don't want to use a SQL Server 2005 database, nor do I have Server 2005 or Server Express loaded. How can I unhook this and make it use SQL 2000?
"An error has occurred while establishing a connection to theserver. 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.) "
This is the standard message for failing to connect to the server, even if it is SQL Server 2000.
The message talks about 2005, but if you're using 2000, you may ignore this addition.
The important sentence here is: "No connection could be made because the target machine actively refused it".
One thing you could try is just refresh the page and try again.
Jos
|||Hi i gues u need to restart ur services including SQL services as well n yes it a common error so dont worry about it may it helps u
|||I've tried restarting my SQL services and rebooting repeatedly but it doesn't help.
|||Hi tjherman,
Did you made any modifications to your connection string before? Check it.
Besides, I also tend to believe that the problem is related to your database engine.Make sure you sql sever service is started(Since you said that you have restared your sql server2000, i would suggest you to also check if the database service is started), you can first connect to your database using Management Studio and see what happened
Hope my suggestion helps
|||ya Bo Chen is rite u should first try it using Enterprise Manager n see ur DB is working fi9 or
No comments:
Post a Comment