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


Post New Web Links

Possible problems with this 2005/2008 configuration?

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server
 

Hi -- My company is in the process of upgrading their SQL Server 2000 data warehouse to SQL Server 2008.  Note that my company currently uses the BI toolset from SQL Server 2005.  However, my company has no plans to upgrade the 2005 BI services that we currently use.  Will this configuration work? 

Back-end Database Engine: SQL Server 2008, SP-2
Back-end BI Services: SQL Server 2005, SP-3 (SSAS, SSIS, SSRS - each on their own server)
Front-end Client Tools: SQL Server 2008, SP-2 (SSMS, BIDS)

My concern is that I would, for example, develop an SSIS package on my laptop with the 2008 client toolset and it would work just fine.  But when the package is run in production on the SSIS box (that contains only the 2005 SSIS service), it might complain because it doesn't understand the 2008 package structure.  Or is the SSIS service smart enough to detect the version of the package and work as if nothing was wrong? 

Thanks in advance for your help.

 




View Complete Post


More Related Resource Links

Problems installing SQL Server 2005 Integration Services for Server 2008 R2

  
I am trying to install Microsoft Forefont and i have got a tick on every requirement bar 1. I can't install SWL Server 2005 Integration Services Component. I am running windows Server 2008 R2. I have tried numerous steps such as going into to control panel and adding component but the Integration services is not appearing on the options. Is it actually possible to install 2005 integration services on server 2008 and if so how? Thanks

Package Configuration Problems SQL 2008 R2

  
I have an SSIS package that is using a SQL Server configuration to store connection strings for the other connection managers used by the package.  The connection string for the connection manager used to get the SQL Server configuration data is passed to DTExec when the package is executed.  The SQL configuration sets the values of variables that hold the connection strings and the connection managers use the variables in an expression to set the connection string.  I'm doing this so that I can move the packages from dev to qa then to production.  I also need to have the child packages use the same connection strings as the parent package so each child package has a parent package variable configuration containing the connection strings.  It uses these to set the values of child package variables which are then used to set the connection string property of the connection managers using an expression. I tested my packages by connecting to the development SSIS server, clicking on the package and selecting run package.  I select the connection managers tab so that I can change the connection string of the connection manager that points to the SSIS Configurations table which contains the development connection strings.  This works great. I deployed my packages to the production server and again tested the packages by running them from the pr

Upgrade from SQL 2005 to SQL 2008 cause problems with MSDTC

  
We have recently upgraded our server from SQL Server 2005 to SQL Server 2008.  Previously we were running our asp.net application using MSDTC with no problems. Since we upgraded, we are encountering problems that seem to relate to Multiple Active Result Sets (MARS).  The error we receive is: "There is already an open DataReader associated with this Command which must be closed first" when we try and perform a save process.  To fix this problem we added MultipleActiveResultSets=True to the connection string.  We now get the error: "The transaction operation cannot be performed because there are pending requests working on this transaction." Within the transaction scope we save to a table and then load from the same table.  Our stack trace indicates this is where the first error occurs.  Again, this transaction worked using SQL Server 2005. If we do not use MSDTC by putting Enlist=false in the connection string, the request works. We are really stumped as to what to do.  We would prefer not to have to role back to SQL Server 2005 and would also prefer not to have to have sweeping code changes in our application.  We have test MSDTC by using DTC ping on our servers and it works. Your help is greatly needed and would be greatly appreciated. Regards, Steve and Nilesh

Upgrade from SQL 2005 to SQL 2008 cause problems with MSDTC

  
We have recently upgraded our server from SQL Server 2005 to SQL Server 2008.  Previously we were running our asp.net application using MSDTC with no problems. Since we upgraded, we are encountering problems that seem to relate to Multiple Active Result Sets (MARS).  The error we receive is: "There is already an open DataReader associated with this Command which must be closed first" when we try and perform a save process.  To fix this problem we added MultipleActiveResultSets=True to the connection string.  We now get the error: "The transaction operation cannot be performed because there are pending requests working on this transaction." Within the transaction scope we save to a table and then load from the same table.  Our stack trace indicates this is where the first error occurs.  Again, this transaction worked using SQL Server 2005. If we do not use MSDTC by putting Enlist=false in the connection string, the request works. We are really stumped as to what to do.  We would prefer not to have to role back to SQL Server 2005 and would also prefer not to have to have sweeping code changes in our application.  We have test MSDTC by using DTC ping on our servers and it works. Your help is greatly needed and would be greatly appreciated. Regards, Steve and Nilesh

Generate insert unicode script in sql 2005 to 2008 has problems

  

Dear

I have generated insert unicode script in sql 2005 the run insert script sql 2008 database has problems show ???????????? >

What should I do ?

Best regards






Visual Studio 2008 Memory problems

  

My memory in task manager reaches about 900,000K  and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.


Problems converting VS 2003 project to VS 2008

  

Hi!

I'm having problems converting a VS 2003 project to VS 2008 (tried 2005 as well, same problem). There are several problems;
a) I don't have VS 2003 installed.
b) The project is a web service, however I'm not sure what type of VS project it was created as.
c) The general knowledge about the project setup is..slim.

I get a error message using the conversion wizard, however, I'm not familiar with the tool and I cannot quite find any good information on Google for it, so I am left with a error message I do not understand.

Conversion Issues - myProject.csproj:
Unable to open the Web site 'C:\local\path\to\project\myProject.csproj'. The Web site 'C:\local\path\to\project\myProject.csproj' does not exist.

The web service is not intended to run on the dev machine, it is copied to a test or a prod server. However, I do not know how this was done previously. I'm thinking that in order to convert, it has to access the server on which it should run (which is set somehow in a config maybe). But that doesn't actually make any sence..

If anyone could shed light on this, I would really appreciate it.

Thank you.


Converting Crystal Report 2005 to 2008 - Please Tell Me I'm Stupid :)

  

Hello peeps,

  I have a series of Crystal Reports that I can view/edit using Visual Studio 2005 with no issues.  The method I'm using is to simply click on the *.rpt file and it opens in the VS crystal editor with no issues.  The problem I'm having is that we are upgrading to Visual Studio 2008, and when I open the *.rpt file in 2008 it opens as a binary file.  I guess I'm used to everything else in Visual Studio prompting me to convert the older version to the newer version, so I'm not sure what to do in this case.

  Is this normal?  Is there an easy conversion method that I'm simply overlooking?  Am I screwed?  Who invented liquid soap, and why?

Answers to any of these questions would be greatly appreciated...


Convert 2005 RDLC to 2008 using VS2010

  

Hi and thanks.

 

I'm getting an error on serveral reports that I built  in VWD2005 (express) using the reportviewer control.  Trying to edit the rdlc file in VS2010, VS2010 asks if i want to convert the file to RDLC 2008 format and I click ok.  When I build the site, I get this error (and of course also when the report is ran):

 

Error 1 The report definition is not valid.  Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. C:\inetpub\wwwroot\mastercardlcm\Reports\WorkLists\OpenSRStatus.rdlc 1 

 

Here is my web.config concerning the RDLC assemblies, etc.

		<httpHandlers>
			<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
		</httpHandlers>
		<compilation debug="true">
			<assemblies>
				<add assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
				<add assembly="Microsof

SSRS 2008 R2 and sharepoint 2007 report builder problems

  

I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu


VS 2005 to 2008

  

Hi folks

Am in the process learning C#, My instructor uses Visual C# 2005 Express and on my side I have Visual Studio 2008 Pro.

Do you think it will affect me in my Coding practice due to the different IDE Versions? Wha do I have to heed when coding?

Thanks

William


SQL server 2005 2008

  

i cant install sql server 2005 nor 2008 on my windows 7 os

i read about somthing like adding new account when installing sql 2008 to provision the server or so, but didnt know how,,,

can you plz help me??

 


SQLServer 2008 Tools and SQL 2005 Cluster

  
I recently built a SQL Server 2005 cluster on the o/s Windows Server 2008 R2.  I have been attempting to connect to the cluster from my Windows 7 dekstop with my SQL Server 2008 Tool set.  I have been unable to attach to this cluster since its creation. The firewall is temp off, remote connections in the surface area configuration is set to pipes and tcp/ip and the Browser surface is up and running. I ran Wireshark against the cluster and I could see that there was UDP conversations for ms-sql-m (SQL Port) but that was as far as it would get.  I am using a named instance so not using 1433, but I do see the cluster offering up high RPC ports but the client never responds after the initial UDP response. When I noticed that there was a two way conversation taking place, I went to a seperate machine and fired up SQL Server 2005 Tools and I was easily able to attach to the cluster.  So my question is - Are there any known incompatibilities between SQL Server 2005 cluster services and SQL Server 2008 Tool set?  I can use my 2008 tools to attach to a non-clustered SQL Server 2005 w/o issue.   Error when attempting to connect: A network-related or instance-specific error occured while establishing a connection to sql server.  The server was not found or was not accessible.  Verify that the instance name is correct and the SQL Server is con

Steps by Step document for configuration Merge Replication in 2005

  
Hi , Can anyone provide link to configure Merge Replication in 2005 with print screen.Also let me know the difference between Transcation level and Merge Replication. regards Vijay  

Having problems installing/setting up SQL Server 2008 Express/R2 for ASP.NET user management on deve

  
I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me. I'm currently building a couple of ASP.NET MVC 2 sites.  I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool.  The problem is that ASP.NET can't 'see' the database. I have SQL Server 2008 installed on my laptop.  It's the version which is available on the Web Platform Installer (I believe it's Express).  When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that I'm running any version of SQL Server at all.  I get an exception about 'named pipes', and some other things I don't understand at the moment. Obviously, this is all a bit over my head.  Is there an idiot proof guide or tutorial available that describes, step-by-step, how to: 1. Install SQL Server 2008 on a development PC 2. How to configure it to be used by Visual Studio 2010 Professional 3. How to properly upload/modify the db on the production server with what's on the development PC Essentially, all the things that the ASP.NET tutorials gloss over.  Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.

migration and upgarde from 2005 to 2008

  
we need to migrate the data from Houston to Seattle. plus, we need to upgrade 2005 server to 2008 at the same time, with the minimal downtime. The plan is to build the brand new 2008 server in Seattle, restore all databases (500 on the same server!) from full backup. when ready, shutdown applications in Houston, run diff backup and restore Seattle from diff. My question is about initial restore of master database in Seattle. is it a problem to restore 2005 master db on 2008 server?JulieShop
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