Sunday, February 19, 2012

Either no components are installed, or you are not an administrator on this computer. (SQLSAC)

I get this error while trying to look at the items in my SQL Server Surface Configuration for 2005:

No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)

I of course have Admin rights onmy Win XP Pro machine. This is SQL Server Enterprise 2005

Looks like maybe it's not possible to create an instance on an XP machine with Enterprise since I see this message in the install report as a warning:

SQL Server Edition Operating System Compatibility (Warning)
Messages
SQL Server Edition Operating System Compatibility
Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.

I am not sure that is a supported configuration. SQL Server 2005 Enterprise should not install on Windows XP Professional. If you try to install, you get the following warning:

"- SQL Server Edition Operating System Compatibility (Warning)

Messages

SQL Server Edition Operating System Compatibility

Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online."

What is the version number? 9.0.1399? 9.0.2147?
Can you install a different SKU like the Developer Edition? or Express Edition?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

I have the exact same problem but in my case it's win 2k3 server and SQL express that got installed as part of the Sharepoint portal server install. I was trying to run the sqlcmd utility but got this error

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

which led me to a KB article which said to run the surface config utility.

p.s. everything is running on VMware 4.51

|||

I'm getting the same message.

However, I have standard edition running on XP SP2..

|||

See this SSPFAQ link helps.

No comments:

Post a Comment