Going Nuts Here...SQL SERVER 2008 is installed but not being recognized as installed by other applictations
Here is what I have installed on my Windows 2008 Server Standard:
SQL SERVER 2008 R2 which was installed first. I selected all of the options like SQL Full Text Search FOR EACH INSTALLATION which does not show up in the Add Remove Programs. See Image. I get the following showing that the system health check has detected a problem some of which are
1. A compatible version of SQL Server is not installed. NO NO NO ..... THEY ARE INSTALLED
Workaround / Remedy
SQL Server installation is a prerequisite for Visual Studio Team Foundation Server 2008. Install a supported version of SQL Server and then install any required service packs. For more information about supported versions of SQL Server, download the most recent version of the Team Foundation Installation Guide, which is available from the Microsoft Web site.
2. SQL Server is not listening for remote TCP/IP connections. I DO NOT KNOW WHAT THIS ONE IS
Workaround / Remedy
Use the SQL Server Surface Area Configuration tool to enable remote TCP/IP connections.
3. The SQL Full Text Search service is not installed. I CHECKED THIS ON BOTH INSTALLS AND IT DOES NOT SEEM TO SHOW UP IN THE LIST OF INSTALLED PROGRAMS.
Workaround / Remedy
The SQL Full Text Search service is not installed. To install this service, you must run Microsoft SQL Server setup and install this component.
SQLInstalled2008Server.png
SQL SERVER 2008 R2 which was installed first. I selected all of the options like SQL Full Text Search FOR EACH INSTALLATION which does not show up in the Add Remove Programs. See Image. I get the following showing that the system health check has detected a problem some of which are
1. A compatible version of SQL Server is not installed. NO NO NO ..... THEY ARE INSTALLED
Workaround / Remedy
SQL Server installation is a prerequisite for Visual Studio Team Foundation Server 2008. Install a supported version of SQL Server and then install any required service packs. For more information about supported versions of SQL Server, download the most recent version of the Team Foundation Installation Guide, which is available from the Microsoft Web site.
2. SQL Server is not listening for remote TCP/IP connections. I DO NOT KNOW WHAT THIS ONE IS
Workaround / Remedy
Use the SQL Server Surface Area Configuration tool to enable remote TCP/IP connections.
3. The SQL Full Text Search service is not installed. I CHECKED THIS ON BOTH INSTALLS AND IT DOES NOT SEEM TO SHOW UP IN THE LIST OF INSTALLED PROGRAMS.
Workaround / Remedy
The SQL Full Text Search service is not installed. To install this service, you must run Microsoft SQL Server setup and install this component.
SQLInstalled2008Server.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Gentlemen. I just do not know what to do? I have gone into the SQL Server Management Studio and it launches the Window showing the SQL Server 2008 R2 and I have to pick a Server.
I am confused and just do not know what to do. I get the same darn errors.
I have every service started even the SQL Server agent. See images above. I have gone in and added ports for TCP and UDP for 1433 calling them the SQL Browser Service
I have even turned the Firewall completely off. Then tried to reinstall. Nothing has worked. Do you have any more thoughts otherwise I am going to have to take this offline and get someone to help me. I am in pretty desperate situation as development is halted and one of the top experts on EE is my business partner (mlmcc) and we cannot get started. I have about $50 dollars I can spare and that is about it to resolve this. Does anyone else have any thoughts....
One thing I am confused about is why do I have different SQL Server names listed on the SQL Server Configuration Manager and not under Services..... They seem different like something is missing.
Please advise I am all in......what can I do.....?
I am confused and just do not know what to do. I get the same darn errors.
I have every service started even the SQL Server agent. See images above. I have gone in and added ports for TCP and UDP for 1433 calling them the SQL Browser Service
I have even turned the Firewall completely off. Then tried to reinstall. Nothing has worked. Do you have any more thoughts otherwise I am going to have to take this offline and get someone to help me. I am in pretty desperate situation as development is halted and one of the top experts on EE is my business partner (mlmcc) and we cannot get started. I have about $50 dollars I can spare and that is about it to resolve this. Does anyone else have any thoughts....
One thing I am confused about is why do I have different SQL Server names listed on the SQL Server Configuration Manager and not under Services..... They seem different like something is missing.
Please advise I am all in......what can I do.....?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I opened the TaskManager and took the following screenshots. See images below.
I then went in to try to install team foundation server and typed in local. I then got the following message.
Is this what you meant for me to do?
TaskManagerServices.png
TaskManagerProcesses.png
TFS-Installation.png
I then went in to try to install team foundation server and typed in local. I then got the following message.
Is this what you meant for me to do?
TaskManagerServices.png
TaskManagerProcesses.png
TFS-Installation.png
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried (local)\RPTMGRPRO
(local)\MSSQLSERVER
(local)\SQLEXPRESS
None worked.
I went back to HOSTRPTS2008\RPTMGRPRO and got these same exact errors again.
The System Health Check has detected a problem that will cause Setup to fail.
Description
A compatible version of SQL Server is not installed.
Workaround / Remedy
SQL Server installation is a prerequisite for Visual Studio Team Foundation Server 2008. Install a supported version of SQL Server and then install any required service packs. For more information about supported versions of SQL Server, download the most recent version of the Team Foundation Installation Guide, which is available from the Microsoft Web site.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that may cause Setup to fail.
Description
SQL Server Analysis Services is not installed.
Workaround / Remedy
SQL Server Analysis Services is a prerequisite for Visual Studio Team Foundation Server 2008. Install a supported version of SQL Server Analysis Services. For more information about supported versions of SQL Server and Team Foundation Server prerequisites, download the most recent version of the Team Foundation Installation Guide, which is available from the Microsoft Web site.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that may cause Setup to fail.
Description
The SQL Server Analysis Services service is stopped.
Workaround / Remedy
The SQL Server Analysis Services service is stopped. In Control Panel on the Analysis Services server, double-click Administrative Tools, double-click Services, and then look for the SQL Server Analysis Services service. If the service is not running, start it by right-clicking the service and then clicking Start.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that may cause Setup to fail.
Description
The SQL Server Analysis Services service is not set to start automatically.
Workaround / Remedy
The SQL Server Analysis Services service is not set to start automatically. In Control Panel on the Analysis Services server, double-click Administrative Tools, double-click Services, and then look for the SQL Server Analysis Services service. Double-click the service to view the service properties. In the Startup type list, click Automatic, and then click OK.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that will cause Setup to fail.
Description
The SQL Server Analysis Services instance was unavailable for querying instance information.
Workaround / Remedy
The SQL Server Analysis Services instance was unavailable for querying instance information. Please check to make sure the instance is running and available.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that may cause Setup to fail.
Description
Windows Firewall is not enabled.
Workaround / Remedy
Windows Firewall is not enabled on this computer. Team Foundation setup will not add exceptions to Windows Firewall to install and use this product. If you enable Windows Firewall at a later time, or you are using a third-party software or hardware firewall product, you must add these exceptions manually. For more information on required ports, see the Team Foundation Installation Guide.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that will cause Setup to fail.
Description
The SQL Full Text Search service is not installed.
Workaround / Remedy
The SQL Full Text Search service is not installed. To install this service, you must run Microsoft SQL Server setup and install this component.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that will cause Setup to fail.
Description
The SQL Full Text Search service is stopped.
Workaround / Remedy
The SQL Full Text Search service is in a stopped state. In Control Panel, double-click Administrative Tools, double-click Services, and then look for the service. If the service is not running, start it by right-clicking the service and then clicking Start.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that will cause Setup to fail.
Description
The SQL Full Text Search service is not configured to start automatically.
Workaround / Remedy
The SQL Full Text Search service is not configured to start automatically when the computer starts. In Control Panel, double-click Administrative Tools, double-click Services, and then look for the service. Double-click the service to view the service properties. In the Startup type list, click Automatic, and then click OK.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
Then I tried this as well HOSTRPTS2008\MSSQLSERVER and got the error below.
TFS-InstallationProblem.png
(local)\MSSQLSERVER
(local)\SQLEXPRESS
None worked.
I went back to HOSTRPTS2008\RPTMGRPRO and got these same exact errors again.
The System Health Check has detected a problem that will cause Setup to fail.
Description
A compatible version of SQL Server is not installed.
Workaround / Remedy
SQL Server installation is a prerequisite for Visual Studio Team Foundation Server 2008. Install a supported version of SQL Server and then install any required service packs. For more information about supported versions of SQL Server, download the most recent version of the Team Foundation Installation Guide, which is available from the Microsoft Web site.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that may cause Setup to fail.
Description
SQL Server Analysis Services is not installed.
Workaround / Remedy
SQL Server Analysis Services is a prerequisite for Visual Studio Team Foundation Server 2008. Install a supported version of SQL Server Analysis Services. For more information about supported versions of SQL Server and Team Foundation Server prerequisites, download the most recent version of the Team Foundation Installation Guide, which is available from the Microsoft Web site.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that may cause Setup to fail.
Description
The SQL Server Analysis Services service is stopped.
Workaround / Remedy
The SQL Server Analysis Services service is stopped. In Control Panel on the Analysis Services server, double-click Administrative Tools, double-click Services, and then look for the SQL Server Analysis Services service. If the service is not running, start it by right-clicking the service and then clicking Start.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that may cause Setup to fail.
Description
The SQL Server Analysis Services service is not set to start automatically.
Workaround / Remedy
The SQL Server Analysis Services service is not set to start automatically. In Control Panel on the Analysis Services server, double-click Administrative Tools, double-click Services, and then look for the SQL Server Analysis Services service. Double-click the service to view the service properties. In the Startup type list, click Automatic, and then click OK.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that will cause Setup to fail.
Description
The SQL Server Analysis Services instance was unavailable for querying instance information.
Workaround / Remedy
The SQL Server Analysis Services instance was unavailable for querying instance information. Please check to make sure the instance is running and available.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that may cause Setup to fail.
Description
Windows Firewall is not enabled.
Workaround / Remedy
Windows Firewall is not enabled on this computer. Team Foundation setup will not add exceptions to Windows Firewall to install and use this product. If you enable Windows Firewall at a later time, or you are using a third-party software or hardware firewall product, you must add these exceptions manually. For more information on required ports, see the Team Foundation Installation Guide.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that will cause Setup to fail.
Description
The SQL Full Text Search service is not installed.
Workaround / Remedy
The SQL Full Text Search service is not installed. To install this service, you must run Microsoft SQL Server setup and install this component.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that will cause Setup to fail.
Description
The SQL Full Text Search service is stopped.
Workaround / Remedy
The SQL Full Text Search service is in a stopped state. In Control Panel, double-click Administrative Tools, double-click Services, and then look for the service. If the service is not running, start it by right-clicking the service and then clicking Start.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
The System Health Check has detected a problem that will cause Setup to fail.
Description
The SQL Full Text Search service is not configured to start automatically.
Workaround / Remedy
The SQL Full Text Search service is not configured to start automatically when the computer starts. In Control Panel, double-click Administrative Tools, double-click Services, and then look for the service. Double-click the service to view the service properties. In the Startup type list, click Automatic, and then click OK.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
Then I tried this as well HOSTRPTS2008\MSSQLSERVER and got the error below.
TFS-InstallationProblem.png
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes I am connecting to SQL Server Management Studio to HOSTRPTS2008.
I was told that TFS 2008 would take SQL Server 2008 R2 So I installed it.
When you say " SSMS make sure you are able to connect and then run select @@version " I am not quite following you sorry...?
Should take SQL 2008 R2.
Why is it in Services it says RPTMGRPRO as the name of the database and the connection in SQL Server 2008 R2 says REPORTMANAGERPRO...? Am I on to something here....?
ConnectingToSQLServerMgrStudio.png
ConnectingToREPORTMANAGERPRO.png
I was told that TFS 2008 would take SQL Server 2008 R2 So I installed it.
When you say " SSMS make sure you are able to connect and then run select @@version " I am not quite following you sorry...?
Should take SQL 2008 R2.
Why is it in Services it says RPTMGRPRO as the name of the database and the connection in SQL Server 2008 R2 says REPORTMANAGERPRO...? Am I on to something here....?
ConnectingToSQLServerMgrStudio.png
ConnectingToREPORTMANAGERPRO.png
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am going to have to apologise for my ignorance.
When you say this:"What is the name of the instance that you installed." I thought I originally set this up to use MSSQLSERVER then I do remember Since I could not get it to work. I tried intsalling it was either RPTMGRPRO or REPORTMANAGERPRO as the database name. Now I am not so sure what it was I called it or if a previous installation kept one of the names I gave and did not erase it upon uninstallation.
I will check this tomorrow:
"Did you check the sql server configuration tool to make sure that TCP/IP is enabled on the SQL 2008 R2 instance you installed? And check the port configuration."
I thought I had done this but I am not so sure now. I created a UDP and the other ??? for 1433 and completely turned off the firewall. Where do I go to do that?
When you say this:"What is the name of the instance that you installed." I thought I originally set this up to use MSSQLSERVER then I do remember Since I could not get it to work. I tried intsalling it was either RPTMGRPRO or REPORTMANAGERPRO as the database name. Now I am not so sure what it was I called it or if a previous installation kept one of the names I gave and did not erase it upon uninstallation.
I will check this tomorrow:
"Did you check the sql server configuration tool to make sure that TCP/IP is enabled on the SQL 2008 R2 instance you installed? And check the port configuration."
I thought I had done this but I am not so sure now. I created a UDP and the other ??? for 1433 and completely turned off the firewall. Where do I go to do that?
ASKER
I am going to e working on this server and attempting to install the Team Foundation Server this weekend. I think this question was scheduled for deletion. I may still need this question open. Else I will repost. The problem is still the same and I have not been able to get it installed.
ASKER
Nothing worked. Had two different guys supposedly senior tech at Geek Squad. Neither could make it happen so that asked if I would consider reformatting ................the standard I have seen on all the machines I took to Geek Squad. So far nothing I have sent them could be fixed. 3 out of 3 machines the concluded simply had to be rebuilt..............what a disappointment............
No one could get team foundation server installed. Spent weeks on it, No one could get Windows 7 Pro SP1 to update. etc.
I will reward points on effort and leave it for you to tell me whether it should be sent to the knowledge base.......your thoughts appreciated.
No one could get team foundation server installed. Spent weeks on it, No one could get Windows 7 Pro SP1 to update. etc.
I will reward points on effort and leave it for you to tell me whether it should be sent to the knowledge base.......your thoughts appreciated.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have a brand new install of 2008 Server and I do not think that when it was installed that the guy that did it actually did what you said above. I will try that tonight and see if it helps. You are saying that the thread is above......?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Valiant effort. I still could not get the Team Foundation Server to install. Nor could the best guy they had at the Geek Squad at the National call center support or the local one I had. I do not know what stopped us but we did all we could. That much I know. Thank you for all your help.
Maybe Microsoft wants to make it a mystery to everyone too. Never seen anything so hard to setup or configure in my life. Ever
Maybe Microsoft wants to make it a mystery to everyone too. Never seen anything so hard to setup or configure in my life. Ever
ASKER
Here is what I have done. I went in to the SQL Server Configuration Manager and for some Reason even though it shows up in the Services Section. The MSSQLSERVER does not show up in the SQL Server Configuration Manager or the SQL Server Management Studio. Even thought you can plainly see it in the Administrator Tools SERVICES. This makes no sense to me. Any other thoughts.
Also I noticed some items that did not get removed for some reason like the MICROSOFT##SSEE. I removed it before from the previous installs now it is back. Any thoughts.....? Please advise. Thank you.
SQLServerConfigurationManager.png
ConnectSQLServer.png