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

Top 5 Contributors of the Month
Post New Web Links

DAC Deployment Issue

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :


       I am unable to deploy my database through DAC Package. I am using SQL Express 2008 R2 (on Windows 7 & XP machoines)for Deployment. When ever I try to deploy my database it gives me following exception of coud not create a database. I have removed the database and try but same exception occurs.

------ Build started: Project: TIS.Mahidharpura.Database.Security, Configuration: Debug Any CPU ------

Loading project files...

Building the project model and resolving object interdependencies...

Validating the project model...

TIS.Mahidharpura.Database.Security -> D:\TIS.Mahidharpura.Database\TIS.Mahidharpura.Database\TIS.Mahidharpura.Database.Security\sql\debug\TIS.Mahidharpura.Database.Security.dacpac

------ Deploy started: Project: TIS.Mahidharpura.Database.Security, Configuration: Debug Any CPU ------


Pre-Deploy: Starting script execution…


Pre-Deploy: Finished script execution.


Preparing DAC metadata in the SQL Server instance 'MVPC\SQLEXPRESS'


Preparing deployment script


Creating database 'TIS.Mahidharpura.Database.Security_af16a3b7-bb57-4f7c-80fb-d497c72f16

View Complete Post

More Related Resource Links

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?



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 !

MOSS 2007 Content Deployment Issue Could not find Feature UsageReportingTemplateList



I am trying to deploy a site collection from our development enviroment into our live enviroment all our other sites site collections deploy fne apart from this one which we dont seem to have chnaged anything.

The deployment job is failing due to the below error

Could not find Feature UsageReportingTemplateList


Please help

Error 1 Cannot publish because a project failed to build ? Click Once Deployment issue while publis


H! friends

Error  1 Cannot publish because a project failed to build ? Click Once Deployment issue while publishing the application ?

Can anyone tell me how to fix this problem? gone trhough many posts on net but didnt get the right solution for this ? If yu know how to fix this problem tell me plz? or any resource which can guide me to sucessful publishing


Pleas reply




Vijay Gaur


ssis deployment issue - Unable to load custom dll - due to change in Sql server installation


Hello all

I had a strange issue in testing my package, after it was deployed to a Test server.

The details of the server

Sql 2005 is installed, in the D:\ drive

I have used a package, where i use a custom DLL to read values. Hence, i added that DLL to the GAC. I was in the assumption that this should complete my proceess of deploying this package.


However once i executed the package, i got an error - Could not load the Helper object.

Unable to CAST "system.object"  to namaspace.class.Helper.


I reviewed the setting on my macihine, since as part of development inorder to reference the dll i added this to the C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies location so that i can reference this from BIDS. I checked that location in my test server, i was not present. This location was present in the D: drive ( i assume this was present since i installed my complete SQL Server in the D:\ ). I copied the dLL in that location and added it to GAC from that location. My package still failed with the same error.


To resolve this issue, i created the same path in the C:\ folder as C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

assemblies was newly created in C: and i added the dll to GAC from there. Now my package worked.


Deployment Issue


I am having hard time in deploying a webpart in production envirionment.I did create wsp,Got it added to Solution store and now when I deplyed it its taling a long time.

After Stsadm -o deploysolution I followed it with  stsadm -o execadmsvcjobs also


Sharepoint 2010 and SSRS 2008 R2 deployment issue and Globals!ReportName issue


1. Does Sharepoint 2010 in integrated mode Support =Globals!ReportName

Or is there any equivalent of the above expression to work in sharepoint


2. I tried to Deploy Reports from BIDS 2008 to Sharepoint 2010. No matter what settings i choose for OverWriteDatsources, it always redeploys the Datasources.




~~ Mark it as Answer if you find it correct~~

SSC 3.5 SP2 Private Deployment issue on Windows Mobile with SSC 3.5 (3.5.5386) installed


I want to deploy applications that use Private Deployment for SQL Server Compact 3.5 SP2 for Windows Mobile.
I made test sample according to SQL Server Compact 3.5 Service Pack 2 Books Online instructions.

I tested with WM 6.5 device and emulator.

I deploy to application folder on WM the following files:
C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\System.Data.SqlServerCe.dll
C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\armv4i\sqlceme35.dll
C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\armv4i\sqlceqp35.dll
C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\armv4i\sqlcese35.dll

The code is simple:
using (SqlCeConnection sqlCeConnection = new SqlCeConnection())
   button1.Text = sqlCeConnection.ServerVersion;

When I run my test on clean WM 6.5(with SSCE 3.1 in ROM), it's ok. Server version is 3.5.8080.0.

When I run my test on WM 6.5 with SSC 3.5 SP1 installed, test fails with the error:
The application is trying to load native components of version 5386 that are incompatible with ADO.NET provider of version 8080.
Incompatible versions can lead to application instability and hence loading of SQL Server Compact has been aborted.

CLR Deployment issue sql server 2008 r2 visual studio 2010



 i am getting the following error while deploying the clr project converted frm vs2008 to vs2010. Please help me


Compile complete -- 0 errors, 24 warnings

Bloomberg_WSDL -> D:\Projects\STP\Development\BBG-WSDL\SS-BBG-WSDL\bin\Release\Bloomberg_WSDL.dll

------ Deploy started: Project: Bloomberg_WSDL, Configuration: Release Any CPU ------

Build started 11/22/2010 7:07:50 PM.


Beginning deployment of assembly Bloomberg_WSDL.dll to server : stpQA01

C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.SqlClr.targets(96,5): error : Could not connect to server stpQA01 : Login failed for user 'stpuser'.


Time Elapsed 00:00:00.07

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========


Content Deployment and related content issue


Hi People,

we've got a website with various subsites that have items that relate to items in other subsites. Standard related content type stuff.

This is then deployed from the staging environment into production using Content Deployment.

However the relationships between content don't always stick.

I can kind of understand this, because you're potentially establishing a relationship between two bits of content, where one doesn't exist yet.
But what we're seeing is that even after multiple Content Deployments the relationships still aren't being updated (unless you update one of the items in the relationship and then kick off a content deployment).
And it gets even more interesting, during the the import phase of the Content Deployment, we see the relationships being successfully set up, but then when the Content Deployment job finishes, the relationships are torn down again.

So the only sucessful relationships we ever get are the ones where both items exist when Content Deployment pushes them out for the first time.

Has anyone else seen this? Has anyone found a way around it?

Our current potential solution is to "touch" (checkout/checkin) every item, one list at a time, with a content deployment between each list. But this will muck up our Last Modified dates. The Last Mod date isn't too big a deal,

Deployment issue - HomeController isn't being instantiated


I have a MVC 2 project I'm trying to deploy to a QA server, and I'm having fits. I get a YSOD with the error starting as:

[InvalidOperationException: An error occurred when trying to create a controller of type 'DSC.Web.Controllers.HomeController'. Make sure that the controller has a parameterless public constructor.]

I've installed Visual Studio on the server, and the application runs without issue from Visual Studio. I've also checked the HomeController and it does have a parameterless public constructor. What could be causing this issue?

The server specs:

Windows 7 Enterprise 64-bit

IIS Version 7.5.7600.16385

Site Deployment Issue


Does anyone know if it's possible to prevent a website folder from being deployed?  There was a way in FrontPage to tag a folder with "do not publish" and can't find anything similar in VS'05.  The reason is that I'm trying to avoid a folder overwrite and prevent the contents from getting deleted.

Any advice or suggestions is greatly appreciated.

Thanks in advance.

Deployment Issue - A Complete Newbie Question


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 '

Deployment issue using SQL CLR, visual studio TFS GDR 2, SQL Server 2005.


I have a solution project that consists of database project, CLR database project, C# projects. The database project references the CLR database project. Thus, by clicking deploy on the database project will auto-deploy all projects under the solution. It is successfully depolyed locally to either SQL Server 2005/2008 wihtout TFS GDR 2.

However, in addition to those compoments, on the staging server, there are TFS GDR 2 and the Windows Server running on virtual machine. The deployment failed. The reason is that my custom SQL CLR assembly that is loaded into database requires other additonal assemblies. Those assemblies have a dependent hierarchy, which requires deletion in a certain sequence (e.g. assemblyA depends on assemblyB, thus, assemblyB must be deleted from database first before deleting assemblyA.). When the deployment happens on the staging server, the generated database tsql script try to delete those assemblies, but in a wrong way/sequence. That is the reason it failed. As I said, it is working locally. But local deployment has no TFS GDR2 and virtual machine server, which might or might not be the cause. Because the auto-generated database script is done via visual studio.

I have tried using the pre/post deployment script, but it still failed on staging server.  We want to auto-deploy the solution for staging and production server.

Issue with BCS Model deployment in VS2010


I'm seeing an issue with deploying a BCS model project created using VS2010

I updated the model and added additional properties to LOB System Instance and redeployed and the new properties added are not showing in application definition file deployed to BCS, I exported the model file from BCS directly and confirmed this, none of the new properties I added in VS2010 were there. Anyone else seen this? I also looked at the model file that was packaged into wsp and I was able to see the new properties that I added, definitely looks like some bug during deployment

I had to go into manage service applications->Business Connectivity Service and cleanup all references and redeploy bdcmodel from VS2010



Microsoft Certified Master | SharePoint 2007

IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"


MVC2 issue - Stuck. Trying to create a cms with nested partials


I am currently trying to display multiple items on a single page. I am not sure as to how to tackle this. What I have is a database table that has all the page data in. I have this run as a PagesController and this works fine. However what I would like to do is, if say the Products page is selected via the menu, I want to pull back not only the Products page html but also get all the products, and even be able to pull them through via category. I was trying to use a partial view, but I can't get it to work. The same would be for other pages, having partial views to display the other content, ie if Gallery is selected, the page html for Gallery shows and it then can push to a partial view that pulls all the gallery images from the gallery db table and so on. 

Maybe I am tackling this the wrong way. I have the pages stored in the db to allow for a CMS system I have setup. Maybe I need to use models for all the other items(Products, Gallery, Videos and such) and use the partial for the page html?

Any help would be greatly appreciated as I am confused.

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