Big Problem in sql server 2000
-
Hi All, first I installed SQL SERVER 2005 dev edition in my machine and after that I have uninstall it. so I have installed sql server 2000 enterprice in my machine. BUT when I am going to connect to sql server 2000 through my application, I have received following error message:- "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)" This error message is belong to sql server 2005 and NOT FOR sql server 2000 !!!. but there is no sql server 2005 in my machine at the moment.so how can i get sql server 2005 error message for sql server 2000 ? please help . Thanks in advance..
-
Hi All, first I installed SQL SERVER 2005 dev edition in my machine and after that I have uninstall it. so I have installed sql server 2000 enterprice in my machine. BUT when I am going to connect to sql server 2000 through my application, I have received following error message:- "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)" This error message is belong to sql server 2005 and NOT FOR sql server 2000 !!!. but there is no sql server 2005 in my machine at the moment.so how can i get sql server 2005 error message for sql server 2000 ? please help . Thanks in advance..
firstly what is your machine OS? Is it Windows XP or VISTA? You can install sql server enterprise edition on Server OS . none of above OSs allow you to install enterprise. secondly you can see your sql server services and find that if you have sql server 2000/2005 instances. you must go to Control panel-> administrative tools->services then find all MSSQL services or something like this.
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php