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

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

Deployment Issue - A Complete Newbie Question

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

I'm attempting to create my first Analysis Server database.  This is being done in SQL Server 2008.  Please don't assume anything, I'm really learning as I go along and am thinking I'm doing something "obvious" wrong...

So far I've created a Data Warehouse DB that contains my dimension and fact tables - this was created on an OLTP/Database Engine Server (Server name e275rd4).  Using VS 2008, I created an Analysis Services Project and was able to successfully build out my dimensions and cube DB.  The problem I'm having is in trying to deploy this to my Analysis Server DB (server e275bidev02).  When I first tried to deploy, my impersonation properties were incorrect, it was asking for a user name/password.  I changed this property to inherit, and now I'm getting an error on the very first dimension it's trying to create.  The error message is:

Error 4 OLE DB error: OLE DB or ODBC error: Invalid column name 'dimLocationID'.; 42S22.  0 0 
Error 5 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Location', Name of 'Dim Location' was being processed.  0 0 
Error 6 Errors in the OLAP storage engine: An error occurred while the 'Dim Location ID' attribute of the '

View Complete Post

More Related Resource Links

connection string question from a newbie


when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"

Total newbie question: Calling jQuery in an UpdatePanel?



Please forgive this ignorant question - I've used ASP.NET AJAX a good deal but I'm new to jQuery.  Specifically, is it possible to call or create jQuery events on the fly via an UpdatePanel?  For example, calling a jQuery modal or animating a Label (or <div> contained Literal), etc.

If anyone has any advice or could point me to some easy tutorials on mixing ASP.NET AJAX and jQuery, I'd greatly appreciate it. 



Web Part Namespace & Deployment Question



I have a web part deployment and development question. Probably newbie questions..

For web parts which will only be used in certain web applications, I can definitely see creating custom CAS policies etc.. and deploying the dll only to the Bin of the Web Application, but what is the best practice for deploying a Farm wide web part that everyone will use?

I assume it goes in the GAC, and additionally, are there any best practices as far as the namespaces for web parts when they are going into the GAC?

For example, if I go into the Assembly folder and look at all the assemblies in the GAC, is it "okay" to have various globally deployed web part assemblies in there? Like, "MyCustomWebPart" sitting in there with the other sharepoint assemblies? Seems messy to me, but if these are "one-off" web parts that won't have a bunch of classes within a single namespace, it seems like what needs to be done.

Hopefully that was clear enough!

SSAS newbie question

Hi Guys, I come from a SAP BW background, and i was wondering if i need to learn SSIS and SSRS together with SSAS in order to get a job? A insight into the current job market would also be helpfful. Thanks!

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

Dynamically adding User Controls -- newbie question!

I am new to ASP.NET (coming from ColdFusion, thank goodness I'm away from that!).  And I am have THE hardest time understanding how to work with forms in ASP.NET.  Here's what I am doing:Dynamically add User Controls to a PlaceHolder based on some int value (which currently is passed in a HiddenField).Fire an event if the WebControls inside of the User Control change, then handle that event in the Main Page (i.e. save the input to DB)When the user clicks the "Next/Continue" button, the next controls for the next page are loaded.And I guess maybe I just can't seem to get how things work in ASP.NET, because I am really struggling with the general idea of how ASP.NET flows.  Should I be dynamically loading the controls in Page_Init, or Page_Load?  Or should I load the controls when the buttonclick event is fired?Do I have to add the axCtrl.OnDataChange += new EventHandler(HandleAxControlDataChange); line on Page_Load?  Or should I put this in When I first load the UserControl, I need to initialize some WebControls within the UserContorl.  Is there a way to know if I have loaded new user controls into my placeholder?  I can't use Page.IsPostback, because after the first page, every page is a postback from the buttonclick.Any help for this confused newbie would be GREATLY appreciated!!Here's what I have: pu

Newbie question about embedding videos, etc.

I know how to use the web part to insert a video which works just fine. What I don't know is how I can configure/design a page which I can display several videos with explanatory texts next to them, much like this page:  http://sharepoint.microsoft.com/en-us/Pages/Videos.aspx I know it's a total newbie question, but I guess I gotta start somewhere!

Newbie question...

Hi Guys i  need to ask a question about dimensions and cubes: Does the cube only consist of the fact table, or does it consist of the dimensions and the fact table? Thanks in advance

Newbie question about adventureworks database


Hi Guys,

I downloaded the Adventurworks2008 database and the AdventureworksDW2008 database for practice with SSIS.  I was wondering what the difference between the two databases is, because in the exercises im following it is stating that i will need to extract data from  the Adventureworks2008 database to the AdventureworksDW2008 database.

Is the the AdventureworksDW2008 an empty database and we are just extracting OLTP data to it? Please any help in clarifying this will be highly appreciated. Thanks!

newbie question: change login name of dbo user


My database has a user "dbo" which is dbo of all database objects. The login name for this user is e.g. "Login1". Now I need to change the login name for user "dbo" from "Login1" to a new login name "Login2".

It is not possible to change the related login name of the user "dbo" in the user's properties dialog. And it is also not possible to change or remove the dbo relation in the login name's properties dialog (because a dbo user can not be removed).

Is there any possibility to change the login name of an dbo user? How can I do it?

Service deployment issue



I have a WCF service that is hosted in Windows service and has been tested on the local box. Now I want to deploy it on the dev box (Windows Server 2003 SP2) and test it remotely with mutiple clients accessing it simulateously. Our dev box doesn't have Visual Studio on it and I couldn't find installutil.

The WCF Service and Windows Service were both developed on the guidelines found in this forum and on the SMDN.

1. Where do I look for installutil on the dev box? Or, can I just copy it from my local machine to somewhere on the dev box?

2. What files do I need to copy to dev box in order to install the service there?

2. Do I need to make any changes to the config before moving to dev box?



Newbie User Import Question re: One way external trust & Security



There is a business initiative to install a Dev Sharepoint 2007 server in our Trusting Domain. My internal corp network will be Corp.COM. The 3rd party network will be 3rd.COM.  Currently 3rd.COM has a Oneway External Trust pointing inward to Corp.com.  Corp.COM Domain and Forest levels are WIndows 2003. 3rd.com Domain level is Windows 2000 Mixed and the Forest is Windows 2000.

The Dev sharepoint server is located in 3rd.Com domain and the consultant is trying to import Corp.com users by pointing the user profile connection to Corp.com active directory. Needless to say this will fail because there is a one way trust in place so 3rd.com users are allowed to read Corp.Com active directory. Not to mention there are no firewall ports open for this anyway. My questions are...

How can we securely allow this sharepoint server to import in 3rd.com to import users from Corp.com?

Ideally we would like to use a service account from Corp.com to import the accounts. We would also like to either

(A) encrypt the sharepoint servers communication to our Corp.com active directory. because there are Two firewalls between the trust ports would be specifically opened from Sharepoint server <-> Corp.com DC

(b) some how use the existing trust to facilitate this procedures. no additional ports opened on the firewalls.

Any ass

Newbie question re: asp.net textbox + jquery change event


Hello guys,

I thought I was coding a change event correctly, yet somehow i'm not getting any result

I made the simplest of examples to accomplish what i want

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script type="text/javascript" src="jquery-1.4.2.js"></script>
<script type="text/javascript">
    $(document).ready(function() {
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <form id="form1" runat="server">
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

Newbie question: Relationship between an ASP.NET app and WF 4



I'm really interested in implementing WF that will work in/with my ASP.NET/C# Web Forms 4 app to define workflows for a lot of corporate activities -- ranging from user registration to submitting an expense report. I'm trying to understand how the interaction will work.

Am I correct to assume that:


  1. I create an WCF Workflow Service Application project in Visual Studio and define a set of activities and workflows.
  2. In my ASP.NET application logic, I make calls to this WCF Workflow Service app to determine the next step in my corporate activities e.g. once the user registration is completed, send user notification to fill out his/her user profile, etc. In effect, I'm using the ASP.NET app as an UI piece to my WCF logic.
I'd appreciate your feedback in helping me understand how the two will work together.


Thanks, Sam

newbie question on MVC



I have the following code snippet from MvcMusicStore tutorial:

    public class StoreController : Controller
        // GET: /Store/

        public string Index()
            return "Hello from Store.Index()";
        // GET: /Store/Browse
        public string Browse()
            return "Hello from Store.Browse()";
        // GET: /Store/Details
        public string Details()
            return "Hello from Store.Details()";

        public string Details(int id)
            string message = "Store.Details, ID = " + id;
            return Server.HtmlEncode(message);

When I called the action : /store/details/2

I got:

The current request for action 'details' on controller type 'StoreController' is ambiguous between the following action methods:
System.String Details() on type MvcMusicStore.Controllers.StoreController
System.String Details(Int32) on type MvcMusicStore.Controllers.StoreController 

According to tutorial, this should work. I am using MVC2.


Application deployment - database connection issue


Hi, I finished an intranet application using webconfig to store my connection string to an Access database which has linked tables to SQL Server 2005.

Everything works perfectly, but when I publish the application on a IIS server service, it seems like all connections fail... :(


I looked up on internet but found nothing on this. I think my webconfig file is correct :


    <add key="dbconnect" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=//192.168.xxx.x/Websites/xxx/xxx.accdb;Persist Security Info=True"/>


Any idea why it happens?


thanks alot !

Newbie question about SQl code and SSIS


Hi Guys,

Im coming from a SAP Datawarehouse background and i don't know much about sql queries or statements. I was wondering if i need this knowledge to learn SSIS, and if so in what situations?

Thanks in advance

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