September 22, 2005 at 3:45 pm
I am trying to install McAfee Entercept on my 2003 server and when I do I am getting an error that states "No running instances of MS SQL 2000 Server SP2 or higher were detected. Please make sure there is a running instance of MS SQL 2000 SP2 or higher."
I checked the Microsoft SQL SERVER\Installed instances and I did have an instance specified.
I then installed a new instance named Entercept using the sql 2000 cd rom and verified the same key above to see if it was actually listed. It was. I checked my mssql server service and it was up and running. I have no idea why it is not seeing the instance. How can I tell if my instance was created correctly. I didn't receive an error when creating it with the sql 2000 cd.
Thanks in Advance.
Hector.
September 22, 2005 at 3:53 pm
If you can see the service running and can connect to the instance via Query Analyzer, the odds are that the instance was created without error (whether it is configured correctly is another matter).
Did you apply SP2 or later? I'm not familiar with Entercept. Does it require any special configuration to work properly?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
September 22, 2005 at 4:02 pm
I am in the process of uninstalling both products and reinstalling them. When installing Entercept it just asks you if you want to install using sql so I select that option. When I click next is when I get that error. So it then looks for an instance but it states that there is not one running. Don't know. I will reinstall and see what happens.
September 22, 2005 at 4:06 pm
Some applications (those written by really dumb programmers) can't deal with named instances.
It doesn't ask you to point it at a SQL Server? So, it HAS to be installed on the same hardware? I'd be tempted to dump Entercept right then and there if that's the case.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
September 22, 2005 at 4:14 pm
You do have to have it installed locally. So I did that but it will not see the instance. Who knows. I just began the instalation of sql again. I will install entercept in a bit.
Thanks for your help.
September 22, 2005 at 5:05 pm
Well I reinstalled SQL sp3 and I am still getting the same error when installing about no running instance of sql 2000 server sp2 or higher. How can I tell if the named instance that I installed is running and has sp2 or higher installed? It is showing as the default mssql in the installed instance registry key.
ERROR:
"No running instances of MS SQL 2000 Server SP2 or higher were detected. Please make sure there is a running instance of MS SQL 2000 SP2 or higher."
I am pulling my hair out on this one. UGGGGGGGGGG!!!!!!
HEctor
September 23, 2005 at 6:47 am
You can tell by running select @@version in query analyzer from the master database in the instance in question. If the output is 2000.80.760 or higher, then you SP3 applied.
September 23, 2005 at 6:49 am
Thanks for your help. I came across this yesterday evening. I guess I was on the right track. Everything is now installed.
Thanks.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply