.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

Issue in SMO DB transfer from SQL 2005 EE to SQL 2008 EE SP1

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :Sql Server
 
Hi All, I am transferring DB from SQL Server 2005 EE to SQL 2008 EE SP1 using SQL Server SMO. I am using the TransferData method of Transfer object. I am facing a problem where it creates the DB on 2008 instance but does not create any table, view and procedures. This is not getting reproduced every time. The error that caught in code reads below:   ERROR : errorCode=-1073548784 description=Executing the query "CREATE TABLE [dbo].[table1]( [ParamKe..." failed with the following error: "The log for database 'sadb20052008' is not available. Check the event log for related error messages. Resolve any errors and restart the database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C} For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   I checked the SQL Server logs and it is reading as below. I enabled the deadlock logging by setting the SQL Server service startup parameters to -T1204, -T1205, -T3605 and found the log as given below. How can I debug it to find the root cause and resolve it?   2010-04-06 16:50:28.31 spid7s Deadlock encountered .... Printing deadlock information 201


View Complete Post


More Related Resource Links

upgrade sql 2005 to 2008 issue

  
i am trying to upgrade sql server 2005 Enterprise edition sp2 to Sql server 2008 R2 Data center Edition on a windows 2003 Enterprise edition SP2. Up gradation fails to give 'FeatureUpgradeMatrixCheck' error. any ideas ? i don't find much online. I would like to upgrade ::: [Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)     Enterprise Edition on Windows NT 5.2  ] to [Microsoft SQL Server 2008 R2 (RTM)   Data Center Edition ] possible ? thx, jason

IO queuing issue after migration from 2005 to 2008

  
Hi,   Are there any functional changes to the number of outstanding IOs to a LUN from 2005 to SQL 2008? 2008 seems to have a limit of 128 outstanding IOs to a DB volume where SQL 2005 does not. I am struggling to find any SQL tuning parameters that would impact how the db can read/write to disk? Help/comments appreciated.    

SSRS in place upgrade from 2005 to 2008 issue

  

I did an inplace upgrade of SSRS 2005 to 2008 and now the reports are throwing the following error. The reports were all working fine and there is a datasource with the name 'Data Source Name' without the '_'.  Please help.

  • An error has occurred during report processing. (rsProcessingAborted)
    • The data source 'Data_Source_Name' cannot be found. (rsDataSourceNotFound)

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

3) Also one more point about the s

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

Migration Issue to 2005 & 2008

  

Hello:

Back in 2002, I wrote a program which utilized SQL-DMO to build "If Exists/Drop" and "Create" Scripts for me, and it's worked great until I migrated to 2005 then immediately to 2008.  I've briefly read up on switching to SMO and I'm going have to learn SMO unless someone knows of a tool that can create these scripts for me.  Does anyone know if SQL has a new tool for this or maybe a third party software.  I'm so busy with our flagship product, that it would really be terrible if I had to learn SMO right now and rewrite a script creator.

Thanks so much in advance.

Frank


Upgrade issue from SQL 2005 x64 to SQL 2008 x64

  

Hi,

I am facing an issue while upgrade from SQL server 2005 x64 to SQL server 2008 x64. After upgrade all the componets are not showing on Start menu program Files and while upgrade I am getting only 2 features to upgrade. Please see the attached images.

http://lh3.ggpht.com/_sXjLsZULhuI/TLQxA35TjfI/AAAAAAAAABA/lXdbTi6_doc/1.JPG

http://lh3.ggpht.com/_sXjLsZULhuI/TLQxBmzo5YI/AAAAAAAAABI/hHnwTa0nE2c/2.JPG

 I tried to upgrade SQL 9.00.1399.06 standard to 10.0.3798.0 standard version. Is there any known issue in upgrading 2005 to 2008 on 64 bit platform?

Any help will be greatly appreciated...

 

Regards,

Bineesh


Linked server issue on test box, post upgrade 2005 to 2008 R2

  

In an effort to do some testing prior to upgrading our environment to 2008 R2, I made a test instance on our Dev box.  2005 instance, copied as many things as I could think of from various other instances.  Made a basic linked server to our main cluster, had a repeating job to email me results of a query across that link every few hours.

 

Everything was working fine until the upgrade finished.  It completed at ~7pm.  The email at 6PM came through fine (while the upgrade was in progress), the email at 8pm didn't come through.  Checked various things (DB mail was still working, tested fine).  It couldn't access the data across the linked server.  I tried deleting that link and remaking it.  Errors out.  Tried running the same scripts we use to create our standard linked servers, error out.  The only ones that I can set up and function are links to other instances on the same box.

I've looked around at other fixes for this error message and none seem to make any difference.  Log in with Domain cred's, log in with the sa account, no difference.  I can connect from other instances & servers back to this one, just not outbound from this one.  And it worked prior to the upgrade I applied to it.  All other instances on the box are 2005 as well.

Here is the message I ge

Issue with linked server 2008 (and R2) not an issue in 2005

  

Hi,

I have been using SQL 2005 successfully to connect to tables in a 10g Oracle data warehouse. I have been using the 11g client.

I have tried several times to get this working in SQL Server 2008 (and R2) and have tried the 10g and 11g clients...

I do a query like Select top 100 * from DWD..DW.IC_TRAN_PND and I get the error: 

"Invalid data for type "numeric".

 

I have read about the reasons for this but is there a way to make it work like it does in SQL server 2005?


Issue while migrating reports from SSRS 2005 to SSRS 2008

  

We developed reports for SSRS 2005 using SQL Server Business Intelligence Development Studio (Visual Studio 2005).

 

We migrated these reports for SSRS 2008 using SQL Server Business Intelligence Development Studio (Visual Studio 2008) by opening the Reports project folder in SSRS 2008.

 

After migration when the report is ran without any changes made in the design mode we get the correct output.

 

The issue arises when we try to edit the report in the Design mode. In design mode, it shows only 1 'Tablix Filter' Value and loses the rest of the 'Tablix Filter' values. Specifically, If we try and edit the Tablix properties (In Design mode) all the values in the 'Filters' property disappear.

Using Conditional Split data Transfer in SSIS 2008

  
This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Word Automation Issue in Windows Server 2008 Hosting

  

Hi,

The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.


With Regards,

Ashok



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

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
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