Wednesday, March 28, 2012
Migrating beta 2 AS to beta 3 AS?
Is there any suggestion to migrate beta 2 AS db to beta 3 AS db?
I tried to use backup and restore, and it did not work.
I have lots of MDX. I do not want to recreate AS in beta 3. U know, it is
lots of work from scratch.
Thanks,
Guangming
Strictly speaking there is no Beta 3.
I suspect you are out of luck but you might be better asking your
question on the microsoft.private.sqlserver2005.analysisservices.o lap
newsgroup.
Login information is located at
http://communities.microsoft.com/new...lcomePage.htm.
Andrew Watt
MVP - InfoPath
On Thu, 6 Oct 2005 10:42:01 -0700, Word 2003 memory Leakage
<Word2003memoryLeakage@.discussions.microsoft.com > wrote:
>Hi,
>Is there any suggestion to migrate beta 2 AS db to beta 3 AS db?
>I tried to use backup and restore, and it did not work.
>I have lots of MDX. I do not want to recreate AS in beta 3. U know, it is
>lots of work from scratch.
>Thanks,
>Guangming
|||I solved this problem by generating AS script in beta 2 and rerun it in beta 3.
THere is a beta 3. Not sure what you mean.
"Andrew Watt [MVP - InfoPath]" wrote:
> Strictly speaking there is no Beta 3.
> I suspect you are out of luck but you might be better asking your
> question on the microsoft.private.sqlserver2005.analysisservices.o lap
> newsgroup.
> Login information is located at
> http://communities.microsoft.com/new...lcomePage.htm.
> Andrew Watt
> MVP - InfoPath
> On Thu, 6 Oct 2005 10:42:01 -0700, Word 2003 memory Leakage
> <Word2003memoryLeakage@.discussions.microsoft.com > wrote:
>
>
Migrating beta 2 AS to beta 3 AS?
Is there any suggestion to migrate beta 2 AS db to beta 3 AS db?
I tried to use backup and restore, and it did not work.
I have lots of MDX. I do not want to recreate AS in beta 3. U know, it is
lots of work from scratch.
Thanks,
GuangmingStrictly speaking there is no Beta 3.
I suspect you are out of luck but you might be better asking your
question on the microsoft.private.sqlserver2005.analysisservices.olap
newsgroup.
Login information is located at
[url]http://communities.microsoft.com/newsgroups/ICP/sqlserver2005/us/welcomePage.htm.[
/url]
Andrew Watt
MVP - InfoPath
On Thu, 6 Oct 2005 10:42:01 -0700, Word 2003 memory Leakage
<Word2003memoryLeakage@.discussions.microsoft.com> wrote:
>Hi,
>Is there any suggestion to migrate beta 2 AS db to beta 3 AS db?
>I tried to use backup and restore, and it did not work.
>I have lots of MDX. I do not want to recreate AS in beta 3. U know, it is
>lots of work from scratch.
>Thanks,
>Guangming|||I solved this problem by generating AS script in beta 2 and rerun it in beta
3.
THere is a beta 3. Not sure what you mean.
"Andrew Watt [MVP - InfoPath]" wrote:
> Strictly speaking there is no Beta 3.
> I suspect you are out of luck but you might be better asking your
> question on the microsoft.private.sqlserver2005.analysisservices.olap
> newsgroup.
> Login information is located at
> http://communities.microsoft.com/ne...ge.htm
.
> Andrew Watt
> MVP - InfoPath
> On Thu, 6 Oct 2005 10:42:01 -0700, Word 2003 memory Leakage
> <Word2003memoryLeakage@.discussions.microsoft.com> wrote:
>
>sql
Monday, March 12, 2012
Migrate Database from SQL Server 2005 beta 3 to Sql Server 2005 Release
Procedores backup/restore can't help becouse of unsuported version database.
Any ideas?What about generate a schema script? Then run an install of your schema in a new query. You could at least get the db schema but not the data.|||but I have many datas
Monday, February 20, 2012
Microsoft SQL Server Setup Support Files (English) -- Installation failed
I'm trying in vain to upgrade sql server 2000 to 2005 with great headache and pain.
I (finally) have removed all Beta, and other incompatible version of .NET, Visual Studio and any other offending components, and made it to the first page of the install shield.
The .NET 2.0 components installed fine - but I get a fatal error trying to install the SQL Server Set Support Files.
I do have a log file - and have tired searching on the various error codes in it, but am coming up blank. Please advise - this is taking forever!
sample of error msgs in log file:
MSI (s) (B0:E0) [12:33:06:613]: Note: 1: 1935 2: 3: 0x8002802F 4: 5: CreateAssemblyNameObject 6: Microsoft.NetEnterpriseServers.ExceptionMessageBox,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"
MSI (s) (B0:E0) [12:33:06:613]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 2908. The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
MSI (s) (B0:E0) [12:33:06:613]: Executing op: ComponentRegister(ComponentId={52723CBD-3400-458C-988A-4D012E6CAEDB},KeyPath=<\Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0",State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
Error 2908. The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
MSI (s) (B0:E0) [12:33:06:629]: MSCOREE not loaded loading copy from system32
MSI (s) (B0:E0) [12:33:06:629]: Assembly Error:Function not defined in specified DLL.
MSI (s) (B0:E0) [12:33:06:629]: Note: 1: 1935 2: {52723CBD-3400-458C-988A-4D012E6CAEDB} 3: 0x8002802F 4: 5: CreateAssemblyNameObject 6: Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"
MSI (s) (B0:E0) [12:33:06:629]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 1935. An error occurred during the installation of assembly 'Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Please refer to Help and Support for more information. HRESULT: 0x8002802F. assembly interface: , function: CreateAssemblyNameObject, component: {52723CBD-3400-458C-988A-4D012E6CAEDB}
Error 1935. An error occurred during the installation of assembly 'Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Please refer to Help and Support for more information. HRESULT: 0x8002802F. assembly interface: , function: CreateAssemblyNameObject, component: {52723CBD-3400-458C-988A-4D012E6CAEDB}
MSI (s) (B0:E0) [12:33:06:629]: User policy value 'DisableRollback' is 0
MSI (s) (B0:E0) [12:33:06:629]: Machine policy value 'DisableRollback' is 0
Action ended 12:33:06: InstallFinalize. Return value 3.
mandpenny
Please read this blog and see if it helps with the problem.
http://blogs/jdbaker/archive/2006/04/20/10684.aspx
|||Thanks for the reply Raja, but I can't get to that URL - pg. cannot be displayed error...
Mandy
|||I had a similar problem - removing the beta version of SQL Native Client (which came with the 2005 CTP) fixed it
Dave
Microsoft SQL Server Setup Support Files (English) -- Installation failed
I'm trying in vain to upgrade sql server 2000 to 2005 with great headache and pain.
I (finally) have removed all Beta, and other incompatible version of .NET, Visual Studio and any other offending components, and made it to the first page of the install shield.
The .NET 2.0 components installed fine - but I get a fatal error trying to install the SQL Server Set Support Files.
I do have a log file - and have tired searching on the various error codes in it, but am coming up blank. Please advise - this is taking forever!
sample of error msgs in log file:
MSI (s) (B0:E0) [12:33:06:613]: Note: 1: 1935 2: 3: 0x8002802F 4: 5: CreateAssemblyNameObject 6: Microsoft.NetEnterpriseServers.ExceptionMessageBox,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"
MSI (s) (B0:E0) [12:33:06:613]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 2908. The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
MSI (s) (B0:E0) [12:33:06:613]: Executing op: ComponentRegister(ComponentId={52723CBD-3400-458C-988A-4D012E6CAEDB},KeyPath=<\Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0",State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
Error 2908. The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
MSI (s) (B0:E0) [12:33:06:629]: MSCOREE not loaded loading copy from system32
MSI (s) (B0:E0) [12:33:06:629]: Assembly Error:Function not defined in specified DLL.
MSI (s) (B0:E0) [12:33:06:629]: Note: 1: 1935 2: {52723CBD-3400-458C-988A-4D012E6CAEDB} 3: 0x8002802F 4: 5: CreateAssemblyNameObject 6: Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"
MSI (s) (B0:E0) [12:33:06:629]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 1935. An error occurred during the installation of assembly 'Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Please refer to Help and Support for more information. HRESULT: 0x8002802F. assembly interface: , function: CreateAssemblyNameObject, component: {52723CBD-3400-458C-988A-4D012E6CAEDB}
Error 1935. An error occurred during the installation of assembly 'Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Please refer to Help and Support for more information. HRESULT: 0x8002802F. assembly interface: , function: CreateAssemblyNameObject, component: {52723CBD-3400-458C-988A-4D012E6CAEDB}
MSI (s) (B0:E0) [12:33:06:629]: User policy value 'DisableRollback' is 0
MSI (s) (B0:E0) [12:33:06:629]: Machine policy value 'DisableRollback' is 0
Action ended 12:33:06: InstallFinalize. Return value 3.
mandpenny
Please read this blog and see if it helps with the problem.
http://blogs/jdbaker/archive/2006/04/20/10684.aspx
|||Thanks for the reply Raja, but I can't get to that URL - pg. cannot be displayed error...
Mandy
|||I had a similar problem - removing the beta version of SQL Native Client (which came with the 2005 CTP) fixed it
Dave
Microsoft SQL Server Reporting Services
I have downloaded the new realese of SQL Server Reporting Services
(the real release, not the Beta 2) and gets the following error
whenever I try to build, deploy or preview a report. I even got it
when I try to shut down the Microsoft .Net IDE. Does anyone have a
clue?
I have used the beta 2 for a while now, without problem and I have
tried both to upgrade the beta 2 to this release and to uninstall the
beta 2 and install the new release from scratch with the same result.
Here is the error message I've got:
"Method not found: Void
Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])"
Because I didn't find any group dedicated to Reporting Services I post
this message in a couple of more or less closely related groups. I
hope nobody minds.
Regards,
/Mattias TorngrenMat,
Please let me know if you get a resolution to this. I am getting the same er
ror.
Bob
-- Mat wrote: --
Hi all!
I have downloaded the new realese of SQL Server Reporting Services
(the real release, not the Beta 2) and gets the following error
whenever I try to build, deploy or preview a report. I even got it
when I try to shut down the Microsoft .Net IDE. Does anyone have a
clue?
I have used the beta 2 for a while now, without problem and I have
tried both to upgrade the beta 2 to this release and to uninstall the
beta 2 and install the new release from scratch with the same result.
Here is the error message I've got:
"Method not found: Void
Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])"
Because I didn't find any group dedicated to Reporting Services I post
this message in a couple of more or less closely related groups. I
hope nobody minds.
Regards,
/Mattias Torngren|||The reporting services newsgroup went up early Tues 27 morning. It's
microsoft.public.sqlserver.reportingsvcs. Post there as it is being actively
monitored.
"Mat" <mattias_torngren@.hotmail.com> wrote in message
news:c7333b1a.0401280231.5843bba3@.posting.google.com...
quote:
> Hi all!
> I have downloaded the new realese of SQL Server Reporting Services
> (the real release, not the Beta 2) and gets the following error
> whenever I try to build, deploy or preview a report. I even got it
> when I try to shut down the Microsoft .Net IDE. Does anyone have a
> clue?
> I have used the beta 2 for a while now, without problem and I have
> tried both to upgrade the beta 2 to this release and to uninstall the
> beta 2 and install the new release from scratch with the same result.
> Here is the error message I've got:
> "Method not found: Void
>
Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])"
quote:|||I cannot find this microsoft.public.sqlserver.reportingsvcs newsgroup anywhe
> Because I didn't find any group dedicated to Reporting Services I post
> this message in a couple of more or less closely related groups. I
> hope nobody minds.
> Regards,
> /Mattias Torngren
re on the MSDN Newsgroup on the left nav bar for all the MSDN newsgroups
Venky|||Since it's a public newsgroup, it's hosted on the msnews.microsoft.com nntp
server .
I don't think there is a MSDN "managed" newsgroup as of yet.
"Venky" <anonymous@.discussions.microsoft.com> wrote in message
news:4785D4CD-E34F-48C3-BC6B-99FF6E32176A@.microsoft.com...
quote:
> I cannot find this microsoft.public.sqlserver.reportingsvcs newsgroup
anywhere on the MSDN Newsgroup on the left nav bar for all the MSDN
newsgroups
quote:|||You should be able to fix the problem by putting
> Venky
Microsoft.DataWarehouse.Interfaces.DLL in the gac. (Try the gacutil
command line tool).
HTH,
Scott
http://www.OdeToCode.com
On 28 Jan 2004 02:31:39 -0800, mattias_torngren@.hotmail.com (Mat)
wrote:
quote:|||I cannot find this reporting services newsgroup either !!|||and I don't know if it will become a "managed" newsgroup. I've asked the
>Hi all!
>I have downloaded the new realese of SQL Server Reporting Services
>(the real release, not the Beta 2) and gets the following error
>whenever I try to build, deploy or preview a report. I even got it
>when I try to shut down the Microsoft .Net IDE. Does anyone have a
>clue?
>I have used the beta 2 for a while now, without problem and I have
>tried both to upgrade the beta 2 to this release and to uninstall the
>beta 2 and install the new release from scratch with the same result.
>Here is the error message I've got:
>"Method not found: Void
>Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])
"
>Because I didn't find any group dedicated to Reporting Services I post
>this message in a couple of more or less closely related groups. I
>hope nobody minds.
>Regards,
>/Mattias Torngren
microsoft.com site folks to get it listed out on
http://communities2.microsoft.com/c...s/default.aspx,
English/United States/Servers/SQL Server as that apparently got overlooked.
I've also started the conversation with technet and MSDN to see if we can
get it listed out on their sites.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Keith Hay" <demungkeith.hay@.attglobalperiodnet> wrote in message
news:Oy0uo%23b5DHA.2656@.TK2MSFTNGP11.phx.gbl...
quote:
> Since it's a public newsgroup, it's hosted on the msnews.microsoft.com
nntp
quote:|||Scott,
> server .
> I don't think there is a MSDN "managed" newsgroup as of yet.
>
> "Venky" <anonymous@.discussions.microsoft.com> wrote in message
> news:4785D4CD-E34F-48C3-BC6B-99FF6E32176A@.microsoft.com...
> anywhere on the MSDN Newsgroup on the left nav bar for all the MSDN
> newsgroups
>
I have this same problem as Mat and the dll was already in the gac.
Bob
-- Scott Allen wrote: --
You should be able to fix the problem by putting
Microsoft.DataWarehouse.Interfaces.DLL in the gac. (Try the gacutil
command line tool).
HTH,
Scott
http://www.OdeToCode.com
On 28 Jan 2004 02:31:39 -0800, mattias_torngren@.hotmail.com (Mat)
wrote:
quote:|||I've got an answer from another newsgroup that helped me. If you have
>Hi all!
>(the real release, not the Beta 2) and gets the following error
>whenever I try to build, deploy or preview a report. I even got it
>when I try to shut down the Microsoft .Net IDE. Does anyone have a
>clue?
>tried both to upgrade the beta 2 to this release and to uninstall the
>beta 2 and install the new release from scratch with the same result.
>Here is the error message I've got:
>Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])
"
>this message in a couple of more or less closely related groups. I
>hope nobody minds.
>/Mattias Torngren
a beta installed than it's important to delete everything that has
with the reporting services to do before installing the new release,
otherwise you can get this problem.
The solution is to add an assembly to the gac like this:
"Add the file "C:\Program Files\Microsoft SQL
Server\80\Tools\ReportDesigner\Microsoft
.DataWarehouse.Interfaces.DLL"
to the GAC"
"You can do this from Start>Programs>Administrative Tools>Microsoft
.Net Framework 1.1 Configuration. Click on Assembly Cache and choose
Add an Assembly to the Cache"
You find the whole thread here:
http://www.sql-server-performance.c...p?TOPIC_ID=2963
Thank you again Jasper Smith
/Mattias Torngren
mattias_torngren@.hotmail.com (Mat) wrote in message news:<c7333b1a.0401280231.5843bba3@.posting.goo
gle.com>...
quote:
> Hi all!
> I have downloaded the new realese of SQL Server Reporting Services
> (the real release, not the Beta 2) and gets the following error
> whenever I try to build, deploy or preview a report. I even got it
> when I try to shut down the Microsoft .Net IDE. Does anyone have a
> clue?
> I have used the beta 2 for a while now, without problem and I have
> tried both to upgrade the beta 2 to this release and to uninstall the
> beta 2 and install the new release from scratch with the same result.
> Here is the error message I've got:
> "Method not found: Void
> Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[]
)"
> Because I didn't find any group dedicated to Reporting Services I post
> this message in a couple of more or less closely related groups. I
> hope nobody minds.
> Regards,
> /Mattias Torngren