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


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

IO queuing issue after migration from 2005 to 2008

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :Sql Server
 
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.    


View Complete Post


More Related Resource Links

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


Xp_runwebtask issue after migration to sql 2008

  
Msg 2812, Level 16, State 62, Procedure sp_runwebtask, Line 16 Could not find stored procedure 'master..xp_runwebtask'. The statement has been terminated. This is wt i am getting after i upgraded from sql 200 to 2008 while i am inserting sth. help me

SQL 2005 migration issue

  
Hey everyone, I do not know anything about SQL, so hopefully someone can help me out. Installed SQL 2005 on a new server.  Restored a database from SQL7. The database I restored is called "train" for example and in that database is a user called "train_user" I cannot connect to the obdc data source using this "train_user".  I do not know if the password didn't carry over during the migration and don't even know how to check or change this password.  I don't know if this user needs certain privileges to be able to access the SQL server?  They are the db owner of the database that I restored.  The application I am trying to launch gives me the odbc error.  This info is stored in an ini file.  If I change this info to sa, then I can access the application. If I need to provide more info, I can do that, but hopefully someone understands what is going on or what I need to do to fix it. Here is the error code:  Error: 18456, Severity: 14, State: 5.

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

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

  
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

SQLSERVER 2008 to SQL SERVER 2008 R2 REPORTS MIGRATION ISSUE?

  
Hi All, Yesterday we installed SQLSERVER 2008 R2 in our development mechine , and already it have Microsoft TFS 2008. When i open my report project it came up with the upgrade messagebox i clicked on Yes.And i try to run the reports locally its giving me exception like "An attempt has been made to  use the data extention 'custom datasource extention 1.2' that is eaither not registered for this report server or is not supported in this edition of reporting services'.So i did the changes like adding the dlls into the reportserver bin and added the data block which i have configured for SSRS 2008 i have applied the same setting for the SSRS 2008 R2 but still i am gettign the same exception do we need to do any changes in SSRS 2008 R2. because i am able to run the reports sucessuflly in SSRS 2008 but not SSRS 2008 R2? Any body have ideas on this. Thanks, Veeren.

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

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)

SSRS 2005 to 2008R2 custom code migration issue

  

We have an SSRS 2005 report that we upgraded to 2008R2 with custom code in the report properties code tab that no longer works.  We checked permission setting in the report server config files, checked if the data set was passig nulls and it is not, looked to see if we ignored the error if the report would render the correct value anyway despite the error and it did not, tried different code variations and referencing different system libraries without luck....we are truly baffled.  The only thing that does work is setting the total to 0 and removing the loop through the jsColl to compute the total.  Here is the code that used to work on 2005.  Any ideas why it does not work on 2008R2?  We call it in an expression =Code.getTotal()

Public

 

jsColl As Microsoft.VisualBasic.Collection

 

Issue with SAN Drive Migration in master database in clustered SQL Server 2005 SP1

  

All,

 

In our SQL Server 2005 SP1 cluster, I have to retire the existing SAN and move all my databases to new SAN drive. I have successfully moved all datafiles (user,system databases, resource) except master database.

 

Even when I change the parameters in start-up from configuration manager, I am getting error when starting up from cluster administrator / configuration manager.

 

But I am able to start the SQL Server successfully from command line (without any flags).

 

When I start the SQL Server from cluster administrator / configuration manager (after changing the parameters), I see that the start-up parameters are changing back to originalpath (old SAN) .

 

Please let me know incase you need any more information.


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?

Column Alias in ORDER BY Clause -- not supported in SQL Server 2005/2008 -- Causes enter migration

  

Hi

We are migrating from SQL Server 2000 to SQL Server 2008 R2 and our web application having thousands of SQL Statement with "Column Alias in ORDER BY Clause ".It is very difficulty to change all statements.

One of article says that SQL Server 2005/SQL Server 2008 not support "Column Alias in ORDER BY Clause and we have to replace with column name" because of this issue If we change Alias name to column name, we have do enter application/integrity testing. it is going to be big deal.

our client Decided to stop migration, Please some help is there any other alternative.

 


SNIVAS

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


Migration of Analysis Services 2005 Cluster (Windows 2003) to Analysis Services 2005 (Windows 2008)

  

Hello,

I need to migrate my SQL Server and Analysis Services cluster from Windows Server 2003 to Windows Server 2008, I have found an article for SQL ID (953200), but I cannot find anything for Analysis Services, does such a guide exist?

Regards

 

Paul


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

datatype tranformation issue in oracle to sql 2008 migration using SSIS

  

Hello friends

I am doing oracle to SQL2008 R2 migration and i want to use SSIS.

Oracle has mainly three datatypes DATE, VARCHAR2 and number. 

I tried without using the transformation it worked but the datatypes like date did not changed to datetime in sql server, even the number datatype remain same.

secondly while doing very first time i got very weired name of the table on sql side. 

Instead of going to dbo schema it shows the name like tom\myname.A_RETURNS.

So how can i resolve both the datatype and naming issue?

Thanks in advance..


dimrd_SQL
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