Error on using VB in calculated members AFTER stepping up to Enterprise version ?

I have "succesfully upgraded" (?) our SQL2005 from standard to Enterprise version.
Before, following set worked like a charm:

CREATE SET CURRENTCUBE.[Now CY]
AS strtomember("[00 - Time].[00 - H - Calendar].[Day Name].&[" + format(now(),"yyyyMMdd") + "]");

But when I process the cube now, I get this error:

Error 1 MdxScript(Sales) (58, 74) The '[now]' function does not exist. 0 0

It seems like the reference to Visual Basic has been lost somehow
Curiously following calculated member works, even it also uses now() ?

CREATE MEMBER CURRENTCUBE.[MEASURES].[Now]
AS now(),
FORMAT_STRING = "yyyyMMdd",
VISIBLE = 1;

Any suggestions ?
please ;-)

/ geert larsen

denmark

Can you reproduce this problem in Adventure Works Enterprise Edition? Another thing to try is the qualified name: VBA![Now]()|||

Hello Deepak
Thanks for your reply
unfortunately the VBA![Now]() did not work
(And I have not installed the AdventureWorks )

BUT I have investigated a little further in the Assemblies and found that ie. the VBAMDX
is registred in C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdvbanet.dll
But this directory is empty ?
Now the file(s) are situated in C:\Program Files\Microsoft SQL Server\MSSQL.6\OLAP\bin\

I have tried to copy the files and re-register (regsvr32 msmdvbanet.dll)
but I get this error:
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdvbanet.dll was loaded, but the DllRegisterServer entry point was not found.
This file can not be registered.

I hope this may give you (and then me) a hint

tia
/ geert larsen
denmark

|||Well, msmdvbanet.dll is not a COM server, therefore you cannot register it with regsvr32. There is something that went wrong during setup or upgrade, and the problem with VBA might not be the only one. I recommend reinstalling from scratch.|||

Complete un- and reinstall solved the problems *NOT FUNNY*

Thanks for advice

/ geert larsen

denmark

error number 1612

I'm doing a reinstall of SQL 2005 Standard Edition but I get this cryptic error message in the installation log file when it tries to install Integration Services or Notification Services. How do I resolve this? I've spent countless hours un-installing and re-installing the product.I looked at the log file and the message says 'The installation source for this product is not available. Verify that the source exists and that you can access it.' It seems to be a problem with the Windows Installer. How do I fix this?|||

Someone else posted a similar problem in the past day. If you're not using the original media to do the reinstall, please try that. If you are, please post again and I'll find a Setup developer and get specific advice from him about this problem.

Paul

|||Thanks for replying, Paul. I am using the original media for the reinstall and I have submitted a more detailed post of this problem in this section under the subject heading 'Cannot install SSIS or Notification services'.

Error message trying to log into Report Manager

I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
Standard or whatever comes with SBS Premium.
I installed SQL as a named instance (SERVER\MSGPSBM) and also installed
Reporting Services in this instance using the default config during the
installation.
When I try to connect to Reporting Services with SSMS on the local
machine using Windows Authentication logged in as Administrator I get
the following error:
Cannot connect to SERVER\MSGPSBM
Additional Information:
Unable to connect to the remote server (System)
No connection could be made because the target machine actively refused
it (System)
When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
Error Unable to connect to the remote server. message
I can log into the database engine just fine.
What am I doing wrong?
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/20/2007 10:45:44 AMHello,
When you use SQL Server Reporting Services Configuration Manager can you log
to SSRS service?
If so check which of the points are marked on red. All of them should be
green or blue (if no active).
This is the first step to recognize where is the problem.
I suppose it could be a problem with accounts (Windows Services Account or
IIS Application Pool Account)
Best Regards,
Radoslaw Lebkowski
Uzytkownik "Japheth Nolt" <japheth.remove@.landiscomputer.com> napisal w
wiadomosci news:xn0ff611k1lg3ln001@.msnews.microsoft.com...
>I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
> Standard or whatever comes with SBS Premium.
> I installed SQL as a named instance (SERVER\MSGPSBM) and also installed
> Reporting Services in this instance using the default config during the
> installation.
> When I try to connect to Reporting Services with SSMS on the local
> machine using Windows Authentication logged in as Administrator I get
> the following error:
> Cannot connect to SERVER\MSGPSBM
> Additional Information:
> Unable to connect to the remote server (System)
> No connection could be made because the target machine actively refused
> it (System)
> When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
> Error Unable to connect to the remote server. message
> I can log into the database engine just fine.
> What am I doing wrong?
> --
> Japheth Nolt
> Microsoft SBF Specialist
> Landis Computer
> www.landiscomputer.com
> 12/20/2007 10:45:44 AM|||All are green except:
Encryption Keys - Blue
Initialization - gray
Email Settings - yellow
Execution Account - yellow
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/24/2007 8:37:59 AM
Radoslaw Lebkowski wrote:
> Hello,
> When you use SQL Server Reporting Services Configuration Manager can
> you log to SSRS service?
> If so check which of the points are marked on red. All of them should
> be green or blue (if no active).
> This is the first step to recognize where is the problem.
> I suppose it could be a problem with accounts (Windows Services
> Account or IIS Application Pool Account)
> Best Regards,
> Radoslaw Lebkowski
>
>
> Uzytkownik "Japheth Nolt" <japheth.remove@.landiscomputer.com> napisal
> w wiadomosci news:xn0ff611k1lg3ln001@.msnews.microsoft.com...
> > I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
> > Standard or whatever comes with SBS Premium.
> >
> > I installed SQL as a named instance (SERVER\MSGPSBM) and also
> > installed Reporting Services in this instance using the default
> > config during the installation.
> >
> > When I try to connect to Reporting Services with SSMS on the local
> > machine using Windows Authentication logged in as Administrator I
> > get the following error:
> >
> > Cannot connect to SERVER\MSGPSBM
> > Additional Information:
> > Unable to connect to the remote server (System)
> > No connection could be made because the target machine actively
> > refused it (System)
> >
> > When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
> > Error Unable to connect to the remote server. message
> >
> > I can log into the database engine just fine.
> >
> > What am I doing wrong?
> > -- Japheth Nolt
> > Microsoft SBF Specialist
> > Landis Computer
> > www.landiscomputer.com
> > 12/20/2007 10:45:44 AM|||I'm still learning.
My Report Server had been configured to use SSL. I turned that off and
now it works.
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/24/2007 9:17:34 AM
Japheth Nolt wrote:
> All are green except:
> Encryption Keys - Blue
> Initialization - gray
> Email Settings - yellow
> Execution Account - yellow