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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Missing SSAS databases

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server
I have a virtual test server which is running SQL Server 2008 R2, on it I have 2 SSAS databases which are linked to Sharepoint Dashboards I had everything was working fine then windows updates happend, in SSMS it only sees one of the databases but it has no content, no cube, no views and is no longer working on the dashboard now the really weird thing is that the other database has vanished from the SSMS entirely but is still working on the Dashboard.
When I attempt to redeploy / process the databases I get error messages about their being errors in the metadata manager. from the error message it gives pointers to the database files and it seems that all of the objects are there.

Currently I can't reprocess either database, neither can I delete the one SSMS can see. As it is a test server it wasnt being backed up by our IT guys.

Can anyone help shed some light on what's going on here?

View Complete Post

More Related Resource Links

Some functions are missing in SSAS calculation tool for my sql 2008 R2 installation (DAX functions?)

In relation to this post: http://connect.microsoft.com/SQLServer/feedback/details/569767/some-functions-e-g-timedate-are-blank-under-the-calculation-toolbar-others-are-ok  I understand that the AS functions are loaded from a XML schema, could a quick solution from Microsoft be to send an updated xml file? When I expand the "All" group under Functions the first 120 MDX (or DAX) functions are blank. I understand that this only a SQL Server 2008 R2 problem and that it's perhaps the DAX functions that shows up blank. // Bjorn

SSAS databases comparison tool


There are a lot of tools for comparing “regular” SQL databases, but I couldn’t find any tool for comparing SSAS databases or cubes. Is there one or is it just no need in such a tool among BI community?

ODBC: My Database missing in list of default databases


Hello everybody

I have the following problem:

When creating a new ODBC data source to an SQL Server 2k5 I want to change the default database from 'master' to my database 'addresses'.

However my database 'addresses' doesn't appear in the drop down list.

I'm conneting with the 'sa' account.

I've activated all protocols in the SQL Server Configuration Manager.

What shall I do?


Any help is greatly appreciated.



Copy Database Wizard: Cannot choose databases, checkboxes are missing



I try to move databases from one SQL 2008 R2 to another SQL 2008 R2 Server with the copy database wizard.
On the page where I should choose the databases to move or copy the checkboxes are missing. The databases are listed but no way to choose one of them.

I searched a lot but did not find out what the reason could be for this.
Any hints are appreciated, thank you!

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Missing 'new item templates'


 Hi all,

          I am a 'newbie' to VWD and I am slowly working through the Basic Walkthrough Help files, and learning plenty along the way.

However, when I tried to create a new database in the LINQ control walkthrough I found that the option to create a new database is missing, and further investigation has found that many other new item templates are missing.

I am using a brand new machine with Windows 7 Ultimate and have enabled IIS and .NET from Control Panel-Programs-Turn Windows Features On-Off. I used the WPI to install all basic elements eg. IIS Components, SQL Server Express.

The only 'new item templates' I have when I right-click the App_Data Folder and choose 'new item' are:-

ADO.NET Data Service

AJAX Enabled WCF Service

Dynamic Data Field

SQL Server Database

Text File

XML File

Does anyone know where I have gone wrong.


Michael J. Hill

Toolbox: Manage databases, easier FTP, and clustered caching


This month's products include DatabaseSpy, FileZilla, NCache, and more.

Scott Mitchell

MSDN Magazine October 2007

Toolbox: Analyze HTTP Traffic, Synchronize Databases, and More


Debugging Web applications can be a difficult process due to the logical, physical, and temporal differences between the mishmash of technologies that comprise such an application. For bugs that arise from the HTML and script received by the browser or in the transfer or request of a page's markup, developers often adopt archaic debugging techniques, such as using View Source and Notepad to scrutinize the contents received by the browser.

Scott Mitchell

MSDN Magazine April 2006

ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).


I Am Continiously Getting Error For Following Line Of Code, It Work  Fine In Other Database

Am I Doing Any Mistake

if (sh3itno != "" && dpsh3no != "")
                string queryy = "SELECT [CHEQNO] FROM [SH3MAST] WHERE (([CHEQDATE] = " + chqdate + ") AND ([FAVOUR] = " + favour + ") AND ([CHQTYPE] = " + ctype + ") AND ([TRSTN] = " + trstn + ") AND ([TRBANK] = " + trbank + ") AND ([SH3ITNO] = " + sh3itno + ") AND ([DPSH3NO] = " + dpsh3no + "))";
                OdbcCommand cmd3 = new OdbcCommand(queryy, connen1);
                string chqno =cmd3.ExecuteScalar().ToString(); (Here Iam Getting Error)
                tbl.Rows[i]["cheque no"] = chqno;
Stack Trace: 

[OdbcException (0x80131937): ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +39
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, Strin

All my server-controls became unrecognized!!! like there's compilation error or web.config missing!



please help - the problem is in post subject.

I have lots of warnings with following text:

"Warning 10 Element 'HyperLink' is not a known element. This can occur if there is a compilation error in the Web site, or the web.config file is missing. C:\Users\Pavel\Documents\Visual Studio 2010\WebSites\BioWebSite\ToScientist.aspx 26 18 C:\...\BioWebSite\" 

But web.confg is there! And there's no compilation error!

Site builds just fine. And If I upload it to my hoster - it works!


But with all these errors I cant add controls to pages - VS2010 adds hyperlink without ID, and intelisens stoped to work.

Strange, but in my other project (web-application) I have no such difficuty.

Apparently missing something in my understanding of session handler...


 It was doing exactly what I expected until I added more than 1 property to it.   It seems if I set the value of a property this, in turn, sets every property in the handler to the same value.  It's blatantly obvious I didn't have the understanding I thought I did on this.  :-)

Could someone point out what I'm missing?  I figured it had something to do with the "shared" but if it's not shared then I would have to declare an instance on my page which would kinda ruin the state of my variables (otherwise, I'd just put them all in my class), right??

Private Shared _strStudentName As String
Private Shared _strSchoolID As String

    Public Shared Property StudentName() As String


            If (HttpContext.Current.Session(SessionHandler._strStudentName) Is Nothing) Then
                Return String.Empty
                Return HttpContext.Current.Session(SessionHandler._strStudentName).ToString()
            End If

        End Get

        Set(ByVal value As String)
            HttpContext.Current.Session(SessionHandler._strStudentName) = value
        End Set

    End Property

    Public Shared Property SchoolID() As String


            If (HttpContext.Current.Session(SessionHandler._strSchoo

Syntax error (missing operator) in query expression

Good Day Gurus!

I have a Excel user application which has a user form (named 'Registo') that displays criteria and an image that has been entered in it's corresponding spreadsheet. This works the way it should.  There's also the ability to search the spreadsheet via a form (by clicking 'Pesquisar' button) this opens a search form. However, I having a bit of a problem with it. When I try to search for something it basically doesn't do anything at all. It just sits there. So I tried to debug it and I think I'm having a problem with either the JET db engine or somethign with teh query or maybe I don't have the correct reference.

I 'borrowed' this Excel application from another forum because it's exactly what I'm looking for! However, I suck at vb.

So I was hoping somebody could take a look at the code and see if I'm missing something?  I'm kinda' desparate to get this working because I'm been trying to figure it out for days and I'm running out of time.  Cry
Option Explicit

'constantes para auxiliar na verificação do código
Private Const Ascendente As Byte = 0

Linq with two databases (oracle and sql server)


i have a problem to bring the data from the oracle (external database) and the sql server together (with similar data). The linq entities are linked to each other. The structure is like different countries with different cities and so on. To display these "non original linq objects" i need to put them into entities (linked to each other). Now i add some of them to my sql database. But for every entity i must check the connection to the other objects i don't want to add and delete them (otherwise linq will add all the connected objects, even those I don't want to add). If this goes wrong the whole input-method crashes. Is there any other possibility, except from checking every single entity and removing unwanted connections, to handle this procedure?
Thanks a lot, preg

Search Usage Reports Missing for Site


We have Usage Analysis enabled on our employee portal farm.  The SSP in this farm crawls all local SharePoint sites and one child farm.  When we view search and query reports, one of the site collections (in a dedicated web app) is missing.  All other web apps/site collections appear in the search/query reports.  The missing site collection is using the standard search pages and web parts - no customization with the object model that might break usage logging.

Has anyone else ran into this or know the solution?

Kerberos between MOSS 2007 and SSAS 2005


I realize this is probably going to be one of those vague questions that I am not going to get much help on here, but I thought I'd give this a shot before we go the MS Incident route on monday.

We have tried to setup Kerberos between MOSS 2007 AND SSAS 2005 to no avail.  We have been through the knowledge base articles outlining the setup multiple times with all the experts on MOSS and Security here where I work.  We've used other materials we have on kerberos here.  But the end result is that the double hop is not happening.  We are trying to connect three ways: excel services, ssrs 2005 in integrated mode, and Sharepoint KPI's (using analysis services).  In every case the connection is not happening.

Other details are that the ssrs integrated mode seems to be setup right because I do get a report (albiet all it has is a connection error message).  Excel services works fine if I use the unattended service account, but when I switch the odc file to windows (should cause kerberos to kick in) it fails.  When I try to add a kpi to the kpi list it can't retrieve a list of kpi's from ssas.

In all cases I am the user trying to perform these operations, and I have total access to the cube -- I'm the developer.  I have no problems connecting to the cube directly through excel, so the security at that end passes t

missing attach button


i have a list with infopath form now i need to display the attach button when anyone try to edit items but i can't find it only in the menu i have only delete item icon and spiling icon.

anyone have any advice about this

i using moss 2007

Thanks for any help :) my blog is: http://www.waelk.com

MOSS 2007 - "next 100" link missing from permissions pages


We're running two MOSS 2007 environments that are (should be!) identical for Development and Validation.  We don't have Production set up yet to compare...

In DEV, when you go to the Site Settings > View All Site Settings > People and Groups > Groups, you see a "1 - 100 >" link at the top right to page to the next 100 groups.  In VAL, we do not see that link even though we have more than 100 Groups (the list ends on the first page with the letter "l").

Everything we have looked at between the two systems looks identical, has anyone seen something similar and has a fix?  At this point we're waiting until we get the PRD environment set up to compare because we're stumped.  Any help would be appreciated, thanks!


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