How to determine which Analysis Services edition is installed

Hi,

How can I determine what edition (standard or enterprise) of Analysis Services is installed on a server?

thanks

Lyn

I guess that the version of AS will be the same as the version of SQL Server, which you can determine by executing the following SQL-query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Source: http://support.microsoft.com/kb/321185

|||

No, since only AS was installed on the server.

|||

Then you have to connect to the AS server using SQL Management Studio, highlight the server and then click Report in the Summary tab.

You'll see a reporting services report with the info:

Server: COMPUTERNAME(\INSTANCE) 4/19/2007 15:19 Edition: Developer Version: 9.00.2047.00

|||

The Analysis server is version 2000 though.

Thanks

|||

Look at this registry key value:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup\Edition

|||

On a named instance this value is at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<INSTANCE NAME>\Setup

Else, here is a feature comparison: http://msdn2.microsoft.com/en-us/library/aa175266(SQL.80).aspx

Enterprise Edition has support for linked cubes, user-defined partitions etc.

How to determine which Analysis Services edition is installed

Hi,

How can I determine what edition (standard or enterprise) of Analysis Services is installed on a server?

thanks

Lyn

I guess that the version of AS will be the same as the version of SQL Server, which you can determine by executing the following SQL-query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Source: http://support.microsoft.com/kb/321185

|||

No, since only AS was installed on the server.

|||

Then you have to connect to the AS server using SQL Management Studio, highlight the server and then click Report in the Summary tab.

You'll see a reporting services report with the info:

Server: COMPUTERNAME(\INSTANCE) 4/19/2007 15:19 Edition: Developer Version: 9.00.2047.00

|||

The Analysis server is version 2000 though.

Thanks

|||

Look at this registry key value:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup\Edition

|||

On a named instance this value is at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<INSTANCE NAME>\Setup

Else, here is a feature comparison: http://msdn2.microsoft.com/en-us/library/aa175266(SQL.80).aspx

Enterprise Edition has support for linked cubes, user-defined partitions etc.

How to Design a report in Web Developer Express

Hey All,
The title pretty much says it all, how do I design a report using Visual Studio Web Developer 2005 Express edition? I thought it would be pretty strait forward.

I have downloaded the add-in for it, called SQLServer2005_ReportAddin.msi and installed it. I know this provides me with a report viewer for my web apps, but I want to design a report, maybe deploy it to a reporting server. But thats all.

How do I do that?

I see no File -> New Report or anything.

Thanks for the help

Mark

Hi.

Ok, I believe that the programa that you downloaded install a new IDE... or something like that, Find out in your programs menu for "Microsoft SQL Server 2005" and then "SQL Server Business Intelligence Development Studio" and let me know.

|||Hi, thanks for the reply, I went to Start -> Programs -> SQL Server 2005 but there is nothing like "SQL Server Business Intelligence Development Studio" at all.

You are correct in saying that I installed a new IDE, I was under the assumption that when I installed Web Developer Express 2005, and the Sql Server Add-in I could create reports. But I cant find where to do it, or for that matter documentation for the add-in to help me.

Thanks for the help so far.

mark

How to deliver a report dynamically based on the dataset with standard edition?

Hi All,

I am working on a report which displays profit and loss discrepancy between two systems. So if there is discrepancy, in other words, the dataset returns value, then I want reporting serive to deliever the report to intended users. I am currently using standard edition with no data-driven subscription support.

I do not know what is the workaround for this implementation. Tks for advise in advance.

Alex

Sounds like you need a custom application to check the condition. You can use the RS FireEvent API to trigger the subscribed delivery.|||

Tks for your reply. Can we also render report inside SSIS, then send out to users? Not sure if that is possible.

Alex

|||I don't see a reason why this shouldn't work. You can write a script task to call down to the SSRS web service and request the report by invoking the Render method.|||

Great, thanks for your answer.

Also, I have another issue with ReportingService2005.FireEvent API, whenever it gets called, the system threw an exception said "insufficient permission for performing this operation". No idea how to fix it. Thanks in advance.

Sample Code:

rs.FireEvent("TimedSubscription", SubID);

Alex

|||

I don't know why it won't work if you are executing the call as a local admin on your local machine where SSRS is installed. If not, does it work if you add the the Windows identity the call is going under to the local Administrators group? If so, you need grant that user System Admin rights in the Report Manager.

|||

Hi,

I found the answer that by default "Generate event" permission is not granted to anyone. You have to go to report manager, security section to check this item. Tks.

Alex

how to delete text file

hi...
how to delete text files from c drive (ex: c:\sale\300407.txt) using ms sql express edition 2005 ?
plz help me...

enable xp_cmdshell from start-- programs -- SQL Server 2005-- SQL Sserver surface Area Configuration tool -- Surface area confiugration for feature --

enable XP_Cmdshell

then run

exec xp_cmdshell 'del c:\yourfilename.txt'

Madhu

|||Be aware that if you are using Windows Authentication, the User who is accessing th e procedure will need the appropiate rights to delete the file. If you are using SQL Server authentication, it has to be the SQL Server Service account, if you don′t won′t either one, you will have to create a proxy account for the XP_CMDSHELL.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||i'm using windows authentication. the command given still error. here the error :

c:\010407_S13103.txt
Access is denied

how about delete multiple text file from folder (exale) in drive c using ms sql express edition 2005. is using the same command?|||

its a permission problem. this user do not have permission in the folder. Jens's post already mention how to handle it. Basically, what xp_cmdshell used for is to run a shell command from SQL Platform. Delete multiple files use

xp_cmdshell del *.txt

Madhu

|||the user is admin. there should be no permission problem. but i still get the same error after i run the command above for multiple files. please be remind that i'm using ms sql express edition 2005.|||Are you using WIndows authentication for connecting to the database ?

|||yes i'm using windows authentication|||Then you either have a proxy account configured which is not able to access the file, or the user you are currently using for the connection is not allowed, or the usage of the directory (if you using Vista) is required elevation.

|||i try this command in ms sql 2005 express edition but still get the same error. here the command :

declare @.del varchar(1000)
select @.del = 'del c:\Transfer\*.TXT'
exec xp_cmdshell @.del

here the error:
c:\Transfer\010407SALE.131.TXT
Access is denied

i'm using windows authentication and using admin account. so there should be no permission problem. i already enable xp_cmdshell in SQL Server Surface Area Configuration. why this error still occur? plz help me. i'm using ms windows xp.|||Is the folder encrypted ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||no

How to de-install SQL Server 7.0

I am unable to de-install 120 days evaluation version of
SQL Server from my desktop running Windows XP Home
edition. While attempting to un-install, I get the
following message:
" unInstallShield has detected that 'C:\MSSQL7
\BINN\sqlmangr.exe' is in use. Please close the
application using this file and unInstallShield again."
Please advise.SQLMANGR.exe is the manager program in the task tray at the bottom of your
screen that allows you to stop and start SQL processes. Right click on the
icon that looks like a little server with a red or green arrow and close
it... or you can kill the sqlmangr.exe process from Task Manager...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"TJ" <tajammalw@.msn.com> wrote in message
news:075401c399c6$eab57240$a101280a@.phx.gbl...
> I am unable to de-install 120 days evaluation version of
> SQL Server from my desktop running Windows XP Home
> edition. While attempting to un-install, I get the
> following message:
> " unInstallShield has detected that 'C:\MSSQL7
> \BINN\sqlmangr.exe' is in use. Please close the
> application using this file and unInstallShield again."
> Please advise.