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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

VS 2010 One-Click Deploy uses different SQL Server user from packaged deploy?

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

I'm working on an ASP.NET MVC 3 project which uses One-Click Deploy, with Web Deploy running on the development server I'm deploying to.  The project includes a SQL Server database.  I have it set up in the project properties, completely with a deployment-only connection string (in Connection string for destination database) with a SQL Server login (call it BuildGuy) that has dbcreator rights.

I'm also using a build server (Jenkins).  I have it set up to use the command line to build my project, run tests, create a deployment package, and then deploy to our shared development server.

All of this works from the build server except the SQL Server deployment piece.  I'm using ScriptDropsFirst in Presource in my project to drop the tables, then re-create them.  When I do the one-click deployment from Visual Studio 2010, it works fine.  When the build server deploys from the package, the SQL Server piece fails with this message: "The user does not have permission to perform this action."  The SQL Server deploy only succeeds from the build server if the login, BuildGuy, has the sysadmin role.

Meanwhile, I tried removing both sysadmin and dbcreator from BuildGuy and found that the deploy still works when I do it from Visual Studio 2010.  It appears that Visual Studio 2010 is using *my* creden


View Complete Post


More Related Resource Links

Failing while trying to deploy Sharepoint Server 2010

  
Hi, I am installing Sharepoint Server 2010 in [ Windows Server 2008 SP2 win SQL Server 2008 R2 installed]. Installation  fails  with message Configuration failed . The following error in the error log 23:09:10  9  INF                    Creating connection string for config db SharePoint_Config server sharepointalias 08/21/2010 23:09:10  9  INF                    Creating connection string for admin content db SharePoint_AdminContent_b6892e2d-f9c1-4c75-aac5-c7ebefb032ca server sharepointalias 08/21/2010 23:09:10  9  INF                    Using NTLM for sql connection string 08/21/2010 23:09:10  9  INF                    Creating a new farm with config db SharePoint_Config content db SharePoint_AdminContent_b6892e2d-f9c1-4c75-aac5-c7ebefb032ca server sharepointalias for farm mode 08/21/2010 23:09:10  1  INF                    Not running in high contr

Visual Studio 2010 Lab Environment for Student to deploy to a IIS 7.5 web server with SQL 2008

  
Currently the environment I am trying to create is a teaching lab for Visual Studio 2010 and ASP.NET website development. The intent is to setup an environment where students can create a website with an attached database written with the assistance of Visual Studio 2010. When the website is completed they need to use one of the Visual Studio deploy technologies to upload the website to a locally run server (Windows 2008 R2 with IIS 7.5 running and SQL Server 2008.) I am responsible for setting up the correct deploy technology in Visual Studio as well as setting up the IIS 7.5 deployment server that is running the right version of SQL Server. I have already started this process and figured out how to configure a deployment package in visual studio and have it published on our local server. I am trying to get a very streamlined environment that does not require students have to configure a lot of SQL strings and IIS settings because this is not really what the teaching lab is all about. Just to let you know, we have had  this exact setup using Visual Studio 2008, Server 2003 with front page server extensions on IIS 6.0 and SQL Server Compact edition running on the server. My issue is that since it is now time to update everything there does not seem to be something comparable. Any help would be greatly appreciated. If someone has an idea of the 

how to deploy to server farm from visual studio 2010?

  

Server farm config is 4 servers: 2 wfe,1 app, 1 db.  NLB on WFE's. 

Deploy from VS 2010 to http://myspapp or http://myspsite I get this error in visual studio.

Error 2 Error occurred in deployment step 'Recycle IIS Application Pool': Cannot connect to the SharePoint site: http://myspapp/. Make sure that this is a valid URL and the SharePoint site is running on the local computer. If you moved this project to a new computer or if the URL of the SharePoint site has changed since you created the project, update the Site URL property of the project.

On my dev machine deploy works fine.  Is it possible to deploy to a server farm from visual studio 2010 or do I have to use powershell commands?


Deploy xslt with wsp file to sharepoint 2010 server

  

I have a xslt file, which i need to place in the layout section, I have created the path in the web part project, I am not able to deploy the wsp file through VS2010 as i do not have local sharepoint server, sO i am copying the file from biin\debug\wsp file to sharepoint server then add the solution install the soution,, but i also have an xslt file, which i need to place it in layouts folder, I have added as resource file during building the web part, file exists in the package, but i am not sure in wsp file

I have a layout folder in my vs 2010 project and xslt file is there in the folder , built the solution, when i use it on the sharepoint page it says that c:\pro.. files\..\..\..\bin\14\templates\layout\xyz.xslt file not found.

Hope some has a view or suggestion or an answer

thank you

Neel

 


Can a user with SQL express deploy a SSIS to a remote SQL server (how)

  

sql express does not have integration services.

dtutil does not work without integration services.  This is therefore not an option.

The deployment manifest needs dtutil to execute.  This is also not an option.

The documentation on microsoft states that a person can connect to remote integration services by editing the ini file and then connecting locally. http://msdn.microsoft.com/en-us/library/ms137789.aspx.  Without integration service, one can not connect locally to integration services so using the transfer package of sql server is also not an option.

Also connecting remotely to an integration without editing the ini seems to require local admin rights on the target server.  This is a bit too much to ask.  (this is what I experimented let me know if you know the exact requirements)

Is there a possibility for a person with sql express, without local admin rights to the target server, to push his ssis to his sql server test instance?


How to deploy on a windows web 2008 dedicated server the VS 2010 ASP.NET simplest template ?

  

I have installed SQL Server 2008 Express Advance Services Edition on server.


I have copied the standard asp.net VS 2O10 from simplest template (the one with login link and 2 tabs home and about) under the root directory of the server. The website works until I try to login then I get:

Failed to generate a user instance of SQL Server

I cannot find a single article that just explains step by step how to deploy this simple example used by Microsoft or can I ? Then can you point me to this tutorial thanks.


Deploy and update script file with custom ribbon tab to Sharepoint Server 2010

  

Hey everyone,

currently I'm building a custom tab for Sharepoint Server 2010 and at the moment I'm stuck on the following issue,
with the first debug deployment Visual Studio sends the .js file that provides some functions for the ribbon elements from Scripts folder in the VS project
to Sharepoint Server.
However, it won't apply any changes I did on the script afterwards to the file on the server.
So the effect is, that as soon as I do the next debug, the previous script is being used by Sharepoint and the new version, containing the new code, is left aside.

It seems to me as if Visual Studio would only deploy the .js file just once and then rely to this copy, maybe there are some configuration settings to make, but after hours of research, I still can't figure out where things do go wrong or what configuration to apply to update the script on the server.
I couldn't locate the file on hdd either, even searched the whole fs but the results showed only the new script file.

Any help on this would be very much appreciated, this issue drives me nuts and consumes plenty of time ;)

Workaround at the moment: each time the script is changed, set up new project... :D

Greets, Norman

P.S: Yes, I did flush

Deploy and update script file with custom ribbon tab to Sharepoint Server 2010

  

Hey everyone,

currently I'm building a custom tab for Sharepoint Server 2010 and at the moment I'm stuck on the following issue,
with the first debug deployment Visual Studio sends the .js file that provides some functions for the ribbon elements from Scripts folder in the VS project
to Sharepoint Server.
However, it won't apply any changes I did on the script afterwards to the file on the server.
So the effect is, that as soon as I do the next debug, the previous script is being used by Sharepoint and the new version, containing the new code, is left aside.

It seems to me as if Visual Studio would only deploy the .js file just once and then rely to this copy, maybe there are some configuration settings to make, but after hours of research, I still can't figure out where things do go wrong or what configuration to apply to update the script on the server.
I couldn't locate the file on hdd either, even searched the whole fs but the results showed only the new script file.

Any help on this would be very much appreciated, this issue drives me nuts and consumes plenty of time ;)

Workaround at the moment: each time the script is changed, set up new project... :D

Greets, Norman

P.S: Yes, I did flush

I cannot get visual studio 2010, SQL Server 2008, and .NET Framework 3.5 or 4.0 to deploy a very sim

  

Creating [SqlClassLibrary]...

C:\Projects\SqlClassLibrary\bin\Debug\SqlClassLibrary.sql(39-39): Deploy error SQL01268: .Net SqlClient Data Provider: Msg 6218, Level 16, State 3, Line 1 CREATE ASSEMBLY for assembly 'SqlClassLibrary' failed because assembly 'SqlClassLibrary' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message

An error occurred while the batch was being executed.

Build FAILED.

Time Elapsed 00:00:06.23

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

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


Search Server 2010 Express - To Deploy Or Not To Deploy

  

We want to deploy (brand new deployment) on Search Server 2010 Express but I need to determine if SSE will be supported in the same manner as SPF?  In other words, will CU's and Service Packs be available for SSE as required? 

Currently I see CU's (KB 2475880 and KB 2459125) for SharePoint Foundation 2010 and a CU (KB 983319) for Search Server 2010 but nothing specifically for Search Server 2010 Express.  Is this product being maintained?

Can SharePoint Foundation CU's and Service Packs be applied to SSE installations to keep SSE up-to-date?

Any insight into this would be greatly appreciated,

Thanks,

Grant. 


Configuring User Profiles in SharePoint Server 2010

  
Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

ClickOnce: Deploy and Update Your Smart Client Projects Using a Central Server

  

ClickOnce is a new deployment technology that allows users to download and execute Windows-based client applications over the Web, a network share, or from a local disk. Users get the rich interactive and stateful experience of Windows Forms, but still have the ease of deployment and updates available to Web applications. ClickOnce applications can be run offline and support a variety of automatic and manual update scenarios.Learn all about it here.

Brian Noyes

MSDN Magazine May 2004


SharePoint 2010 Server: Cannot manage all user profiles from upgraded MOSS SSP database

  
I have upgraded an SSP database to SharePoint 2010 and successfully performed User Profile Synchronization with Active Directory, however I cannot manage ALL of the user profiles in the database. I go to "Manage User Profiles" in Central Administration and perform a filtered search (i.e. I want all DOMAIN accounts beginning with "j" so I search for "DOMAIN\j" in Manage User Profiles), but I don't receive ALL the user profiles back. I receive about 8 in return when I know there are about 20 starting with "j". If I create a new AD account beginning with "j" it is successfully synched with SharePoint 2010 and I see it in the Manage User Profiles. I ran an stsadm -o sync to clear any old synchronization information, and the Forefront Synchronization Service appeared to pull in many changes to existing accounts (including ones I can't currently manage), but I still cannot manage them using "Manage User Profiles". I really need to be able to manage all the profiles so I can manually edit some fields. Can anyone please help? Thanks in advance.

Target a Specific Site/Web using Deploy in VS 2010 IDE

  
If using a SharePoint Project's context menu option of "Deploy", is there a way to specify a target (given the scope of the Feature, etc.)? Thanks.

Can you install SharePoint 2010 and User PerformancePoint in a single server enviroment?

  
Hi I Installed SharePoint 2010 in a single server farm and I configured a Performance Point service aplication. Whenever I run dashboard designer it seems to work but it eventually crashes. I don´t know if I have any configuration errors. I read this Run the Secure Store Service on a separate application server that is not used for any other service. Create the secure store database on a separate application server running SQL Server. Do not use the same SQL Server installation that contains content databases. Here http://technet.microsoft.com/en-us/library/ee806889.aspx I believe this service is necesary to run connect to data sources does this mean it all cannot be run in the same server.

Issues with updating Lists with Manager Names and User Profile Imports in SharePoint 2010 Server

  
I am having a curious problem with SharePoint 2010 Server. I have imported all the user profiles of our organization into SharePoint User Profile Service Application from our Active Directory. When the Manager name imports it comes in as domain/login. The organizational browser seems to work for MOST people, but not all. I believe this is contributing to my second problem, which is, I have setup a very simple workflow in SharePoint Designer that simply looks up the persons Manager, then places that information into a field called "Approval 1". After that it looks at Approval 1 and get the Manager name and populated "Approval 2" with that information, and so on. I have used an Impersonation Step as the Farm Administrator in the workflow and I have done it without the impersonation step. Both results in the same problem. When I enter my name into the list and run the workflow it runs beautifully give every manager up the chain to the top. However, if I put any other person's name in there it gives me the error "Workflow failed to get user profile for user: ____". I went to my supervisor's office and asked him to run the workflow. Using his login he had the exact same result--if my name was in there it worked great, otherwise, it gave an error. Any help with this strange error would be greatly appreciated.  Thanks

Cannot Deploy Reports to Report server - Times Out

  
I have SQL Server 2008 Developer SP1 on XP Pro SP3 to become familiar with its capabilities.  I installed the AdventureWorks sample database and was able to generate a cube, but I have not had the same success with reports.  I am trying to publish the sample reports to Report Server, but every report fails.  The errors says that the operation timed out.  However, the data sourse appears to publish correctly.  When I go to Report Manager, the data source is in the Data Sources folder and I see the AdventureWorks 2008 Sample Reports folder, but it's empty.  I tried loading the rdl file from within Report Manager, but it also fails.  Eventually, it gives me an empty dialog box for a username and password, but I configured Report Services to use a built-in account so I do not have a username or password to provide.  I have been searching forums for the past week, but cannot find anyone with a similar issue. Here is the portion of the log dealing with the deployment error: library!ReportServer_0-2!a44!06/06/2010-04:16:24:: Call to GetItemTypeAction(/AdventureWorks 2008 Sample Reports). library!ReportServer_0-2!a44!06/06/2010-04:16:24:: Call to GetItemTypeAction(/Data Sources). library!ReportServer_0-2!a44!06/06/2010-04:16:24:: Call to GetItemTypeAction(/Data Sources/AdventureWorks2008). library!ReportServer_0-2!a44
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