Re: SQL2005 Configuration Tools can not detect SQL components

I just tried to run the SAC utility on this server and specified the -DE
option and it said instance not found. What is stopping this from running?

Thanks

Chris

"Chris Wood" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eZOzU6YjHHA.1216@xxxxxxxxxxxxxxxxxxxxxxx
Henry,

I am having a similar problem in not being able to see all the SQL
Services. In our case the latest hotfix was applied using Microsoft Update
using a different account than our normal SQL admin account. Now I only
see reporting services and SSIS.

Chris

"HenryT" <HenryT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:34CFF9C9-3A01-447A-A55C-B5A913E27137@xxxxxxxxxxxxxxxx
I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv
Server,
SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could
see
and configured all services via SQL Configuration Manager and SQL Server
Surface Area Configuration tools. This worked for a couple of days and
now
both configuration tools no longer detect SQL2005 components. SQL Server
Surface Area Configuration issued an error that said "No SQL Server 2005
components were found on specified computer. Either no components are
installed, or you are not an administrator on this computer. (SQLAC)".
SQL
Configuration Manager did not list any installed services. I don't know
what
caused this. Anyone has any idea? Please help! Below is the
Installation
Report which shows installed components.

=====================================================
G1DSQL20
The following components are installed on this server

DEV
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level:
9.2.3054
Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level:
9.2.3054
Language: English (United States)]
Reporting Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level:
9.2.3054
Language: English (United States)]

QA
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level:
9.2.3054
Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level:
9.2.3054
Language: English (United States)]

Common components
Integration Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level:
9.2.3054
Language: English (United States)]
Notification Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level:
9.2.3054
Language: English (United States)]
Workstation Components
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level:
9.2.3054
Language: English (United States)]
=====================================================

Thanks in advance!





.

Relevant Pages

  • Re: Can I specify location of noise file?
    ... About Language Resources ... As for integrating the fictional "language" into SQL Server FTS in a real ... production environment that uses "English" as the actual text language, ... >> therefore different noise word files for each table. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Changing localization version
    ... An additional problem occurs if administrators use different language versions of the operating system. ... English .adm files typically have a later timestamp than the U.S. English versions. ... So i guess the only option is to install second server in english ...
    (microsoft.public.windows.server.general)
  • Re: If you were developing a database in Forth...
    ... instances of SQL server. ... relational database well is a difficult task. ... free to come up with your own query language philosophy/design. ...
    (comp.lang.forth)
  • Re: mdf Files?
    ... SQL Express, a variant of SQL Server is a windows service that allows ... Environment may consist of multiple databases, ... in fact, when SQL server is up and running, you cannot access the files. ... The framework, the CLR, the desired language, and a compiler. ...
    (microsoft.public.dotnet.general)
  • Re: SQL2005 Configuration Tools can not detect SQL components
    ... I am having a similar problem in not being able to see all the SQL Services. ... and configured all services via SQL Configuration Manager and SQL Server ... Language: English ] ...
    (microsoft.public.sqlserver.setup)