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


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

.NET 4.0 deploy to sql server 200 8R2

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

Hi,

I have a Windows 7 platform with SQL Server 2008 R2, VS2010, .NET4.0.

When I deploy my stored procedure to SQL, i get the error:

Deploy error SQL01268: .Net SqlClient Data Provider: Msg 6257, Level 16, State 1, Line 1 CREATE ASSEMBLY for assembly 'vciPointDataWriteCS' failed because the assembly is built for an unsupported version of the Common Language Runtime.

 

Simple solution is to regress the build to .NET 3.5, but what do I need to do to have SQL 2008 recognize a 4.0 assembly?

 

Boyd


BDM


View Complete Post


More Related Resource Links

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


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 

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

How to deploy and configure ssis packages using sql server table in testing server and production en

  
Hi We have three environments (development, testing and production ) I have to configure and deploy the ssis packages using sqlserver table in different environments(development, testing and production).   Three environments database structures  are same But database names are different like (DEVSERVER,SITSERVER,UATSERVER) We have 14 packages and one master package. In master package we called all 14 packages question1 First time i will deploy all (master and 14 packages). If i modify one package we need to deploy all the packages or single package deployment is enough    Please help me thanks in advance          

how to deploy a workflow design in SharePoint Designer 2007 in a list from development server to pro

  

how to deploy a workflow design in SharePoint Designer 2007 in a list from development server to production server. 

 i create a workflow in a list with SPD 2007 . I want to deploy it to production server who i can do this.


Thanks and Regards Er.Pradipta Nayak

Create and Deploy Charts using SQL Server Business Intelligence Development Studio 2005

  

Hi All,

Does any one have good blogs for creating different types of charts using SQL Server Business Intelligence Development Studio 2005 which pulls data from the sharepoint list and display in graphical format. iam new to SSRS.

Thanks in advance


Deploy web part to production server

  

I develop my visual web part on a development machine running windows 7, SharePoint foundation server 2010 and visual studio 2010,  

I have SharePoint 2010 production server, and I deploy the web part as the instructions using the following line

 

stsadm -o addsolution -filename <yourfilename>.wsp

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

 


what should be changed to web.config file if i deploy my application to actual server ?

  

Hi,

I have developed a web site application with vb.net code behind.Debugging mode was on.

I have deployed my web site in actual server machine ,but when i open my home page some error is coming related to web.config file.I directly deployed my application to actual server without any change to web.config file.

So, is there any settings required if i deploy my application ? 


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

Cannot deploy assembly from VS.NET into SQL server 2005

  

Hi,
when deploying assembly from VS into SQL Server 2005, deployment fails with these error messages:

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.

I'm deploying assembly with UNSAFE permission setting.
What's wrong, please?

Thanx, Fipil

 


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

How can deploy a cube from production server to local server?

  

Hi,

How can deploy a cube from production server to local server?

I tried to do it from BIDS, I have opened production server database from BIDS but nothing happened when I click project file.

I couldnt change default deployment

Also I have tried Wizard but couldnt find product server asdatabase

Any help will be appreciated

thanks,

Gok


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