Sql Edition Selection: items

Showing posts with label items. Show all posts

Wednesday, March 7, 2012

EM showing (No Items)

Having made no changes to the database server we are now getting no
database list when connecting via EM from client machines, as well as
locally on the database server. I've researched the problem to no
success. The database list shows up fine in QA, however. I used the
following script in QA:
use master
go
select * from sysdatabases
go
And this is the error message I received:
(36 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 51805.
I saw a similar message when trying to delete an outdated Login
account.
Anyone have any ideas? Thanks in advance!
Jon Brookins
Paragon New Media, Inc.What version? Have you run DBCC CHECKDB recently?
"Jon Brookins" <jonathan@.pnmi.com> wrote in message
news:fa11c6b4.0310101200.58233742@.posting.google.com...
> Having made no changes to the database server we are now getting no
> database list when connecting via EM from client machines, as well as
> locally on the database server. I've researched the problem to no
> success. The database list shows up fine in QA, however. I used the
> following script in QA:
> use master
> go
> select * from sysdatabases
> go
> And this is the error message I received:
>
> (36 row(s) affected)
> Server: Msg 220, Level 16, State 1, Line 1
> Arithmetic overflow error for data type smallint, value = 51805.
> I saw a similar message when trying to delete an outdated Login
> account.
> Anyone have any ideas? Thanks in advance!
> Jon Brookins
> Paragon New Media, Inc.|||CHECKDB sounds like a good suggestion. Also, you might want to prepare yourself for restoring a
clean backup of the master database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Jon Brookins" <jonathan@.pnmi.com> wrote in message
news:fa11c6b4.0310101200.58233742@.posting.google.com...
> Having made no changes to the database server we are now getting no
> database list when connecting via EM from client machines, as well as
> locally on the database server. I've researched the problem to no
> success. The database list shows up fine in QA, however. I used the
> following script in QA:
> use master
> go
> select * from sysdatabases
> go
> And this is the error message I received:
>
> (36 row(s) affected)
> Server: Msg 220, Level 16, State 1, Line 1
> Arithmetic overflow error for data type smallint, value = 51805.
> I saw a similar message when trying to delete an outdated Login
> account.
> Anyone have any ideas? Thanks in advance!
> Jon Brookins
> Paragon New Media, Inc.

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.

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