.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

SSAS Deployment Server Version 9.0 - Revisited

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :Sql Server
 

Does anyone knows the answer to this question?

After a SSAS project created in BIDS 2008 (VS2008), if you choose deployment to Server Version 9.0 (SQL 2005), everything seems to be working fine.   Except for the DDS layout contains an invalid control progid error when you try to open the DSV, cubes or dimensions using BIDS 2005.

I used to fix that by searching and replacing DdsShapes.DdsObjectManagedBridge.2 with DdsShapes.DdsObjectManagedBridge.1.   This no longer works.

Does anybody knows what else changed?

Regards,

DT




View Complete Post


More Related Resource Links

Web Deployment with IIS settings of remote server

  

Im trying to deploy a web application project (VS 2010) via team build (TFS 2010), i got to use IIS settings of development server for deployment. So from the project properties I configured the web projects to use Custom web server, (enabled radio button), once i do this the Option in the tab Package/Publish Web "Include all IIS Settings as configured in IIS manager" gets disabled and as a result the deployed web project does not have this IIS settings.

What am I missing here, Im not using the option "Use local IIS Web Server" because the build happens in a build server and would try to take local IIS settings for packaging which is not present.

If this is not possible, suggest me any workaround. Any help on this is greatly appreciated.


Team System: Team Foundation Server Version Control

  

In this new column, Brian Randell begins his long look at how to extend and enhance Visual Studio Team System.

Brian A. Randell

MSDN Magazine January 2007


SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices

  

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.

Paul Yao and David Durant

MSDN Magazine June 2001


Active Server Pages+: ASP+ Improves Web App Deployment, Scalability, Security, and Reliability

  

ASP has been rebuilt from the ground up. The result? Active Server Pages+. ASP+, with a host of new features, provides for easier to write, cleaner code that's simple to reuse and share. ASP+ boosts performance and scalability by offering access to complied languages; development is more intuitive thanks to Web Forms; and an object-oriented foundation facilitates reuse. Other important features include page events, Web Controls, and caching. Server Controls and improvements in data binding are also new with ASP+. Libraries for use with ASP+, and the Microsoft .NET Framework which allows custom business functions to be exposed over the Web, provide more new development opportunities.

Dave Sussman

MSDN Magazine September 2000


Uninstall SQL Server 2008 trial version

  
I would like to know how to properly uninstall SQL Server 2008 trial version altogether.

SQL server compact deployment help

  
I have a very simple windows desktop app I am trying to deploy using windows installer. I also have a SQL Server compact database file or (Local Database). When I deploy the app and try installing it on my test computer, I get an error saying the database was not found and then it displays the connection string that was set originally in Visual Studio. The application runs but all the database in not there. I don't understand why there is even a connection string there if the database in embedded in the application. Which is one of the benefits of SQL Server  Compact. What should change the connection string to?? Anyone have experience using SQl Server Compact for Win Forms?

SQL Server 2005: Install reporting services - which version?

  
Hello - I installed SQL Server 2005 as part of an SBS2008 install. I need to install reporting services, but now I'm having trouble identifying which version (X64 or X86) I'm running. Is there an easy way of figuring out which installation disk I need to insert for SQL Server 2005? Thanks, Nick.

Does MOSS 2007 Support SQL Server 2008 R2 RTM version?

  
Hi, We have MOSS 2007 SP1 databases in SQL Server 2005 EE x64 with SP3. Now, we want to upgrade the SQL Server 2005 to SQL server 2008 R2 EE x64 RTM version. Does MOSS 2007 Support SQL Server 2008 R2 RTM version? If yes, please take me to the MS link where I can find this information. Thanks

SSIS Deployment Reads local Environment Variable and not Server

  
Hi All, I have an SSIS package that uses an Environment variable to hold the connection string for the local SSISConfiguration table.  This works properly on my local machine.  However, when I import the package to Integration Services(through SSMS) it reads the environment variable from the local machine and not the server it is deployed to.  If I log on to the server remotely and do the same process it uses the the correct environment varible... (SQL Server 2005) Is there a way to deploy the package to the server and get it to use the correct Env variable without having to log-in to the server and import it?  Let me know if anyone is looking for additional information.   Thanks!

Cube Writeback SQL Server 2008 R2 (SSAS, write back)

  
CUBE WRITE BACK in SQL SERVER 2008 R2 Did anybody get the SSAS write back functionality to work against a decent sized datawarehouse? I'm not asking about a little demo but a significant sized footprint e.g. 14M Rows measures, 6-8 wired Dimensions with 8-10 attributes each. I setup a test server using a Dell XEON ( 2x4core) with 48 GB RAM hardware and the latest Sql Server 2008 R2 release. I used the What-If scenario in Excel 2010 and modified a higher level, hoping SSAS would push the values down. After about 15 minutes and after having used 48 GB memory (on average 5% CPU) Excel throw an error - short on memory - and stopped the action. I found the same behavior in Sql server 2005 and 2008 and was hoping this would work now but apparently not so. Here are my questions: Is anybody using this at all? how can one calculated (roughtly) how much memory is requiered? is there any paper that describes best practise? Thanks for any help in advance, Dirk  

Solution deployment requires executing execadmsvcjobs command on search server to complete deploymen

  
We have multiple Sharepoint 2007 farms and deploy custom code weekly to the farms. On one o the farms it is required to run stsadm -o execadmsvcjobs on the Search server in the farm in order for solution deployments to complete deploying. These are solution recycles that we are running. This is the only farm this happens on and all farms are identical. In central admin it shows the solution state as deploying. Farm Config Sharepoint 2007 SP2 w Dec Cumulative updates 1 WFE 1 Search server 1 SQL server

Problem facing in Deployment on Windows Server 2003

  
Hi All I have deployed my MVC 2 apllication on Windows server 2003 under iis 6.0. I am using Nhibernate for data access. I could deployed it but when i browse the application it is redirecting to Error.aspx Page. It is not showing any stack trace. Can anyone guide me why it is happening. Thanks sskulkarni.

Can SSAS 2005 run with Sql Server 2008 database engine?

  
Are there any known issues of running SSAS 2005 with SQL Server 2008 database engine?

Windows 7 (64x), Visual Basic Xpress V10, Sql Server Xpress V8R2 -Deployment results in Attempt to a

  
Hi all, I'm at my wits trying to figure this out.  It's a new 64x computer running Windows 7.  I've installed Sql Server Express V8 R2. The connection string is user instance = true.  And the database is located in a directory off the main directory to which the connection string points to. The error I get when starting up my VB Express 10 app is "An attempt to attach an auto-named database for file ‘C:\datadirectory\data.mdf’ failed. A database with the same name exists, or specified file cannot be opened, or it is located in UNC share. I've attached the database using sql server manager v10, and can see the data. Googling his error, there seems to be a lot of web-aps seeing this as well. I did have a problem after I installed sql server version 8 r2, just trying to create a database.  That was resolved by going through the IIS -configuration. If I can provide any other information, please let me know.  Cheers        

sql server doesn't support version

  
The database DATABASE.MDF cannot be opened because it is version 655. This server supports version 611 and earlier.  A downgrade path is not supported.Could not open new database 'DATABASE.MDF'. CREATE DATABASE is aborted. 

Windows 7 (64x), Visual Basic Xpress V10, Sql Server Xpress V8R2 -Deployment results in Attempt to a

  
Hi all, I'm at my wits trying to figure this out.  It's a new 64x computer running Windows 7.  I've installed Sql Server Express V8 R2. The connection string is user instance = true.  And the database is located in a directory off the main directory to which the connection string points to. The error I get when starting up my VB Express 10 app is "An attempt to attach an auto-named database for file ‘C:\datadirectory\data.mdf’ failed. A database with the same name exists, or specified file cannot be opened, or it is located in UNC share. I've attached the database using sql server manager v10, and can see the data. Googling his error, there seems to be a lot of web-aps seeing this as well. I did have a problem after I installed sql server version 8 r2, just trying to create a database.  That was resolved by going through the IIS -configuration. If I can provide any other information, please let me know.  Cheers        
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend