Tuesday, July 16, 2013

[MS SQL Server] resource error 0x800706B9 on installing a sql2008 r2 instance

[MS SQL Server] resource error 0x800706B9 on installing a sql2008 r2 instance

resource error 0x800706B9 on installing a sql2008 r2 instance

Posted: 16 Jul 2013 12:48 AM PDT

Afternoon All I was in the process of installing a SQL2008 R2 64-bit SE instance on a two node cluster running Windows 2003 R2 64 bit Datacenter Server , that currently hosts 3x SQl2005 SP4 CU3 SQl instances.Before the install got to the final page of the install wizard a dialogue box came up with Not enough resources are available to complete this operation. (Exception from HRESULT: 0x800706B9clicked ok and the install went away (no failure or attempt to stat the install process) Exception type: System.Runtime.InteropServices.COMException Message: Not enough resources are available to complete this operation. (Exception from HRESULT: 0x800706B9) Data: DisableWatson = true Stack: Server stack trace: at Microsoft.SqlServer.Interop.MSClusterLib.ClusResourcesClass.Refresh() at Microsoft.SqlServer.Configuration.Cluster.WindowsCluster.get_Resources() at Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterDiskPublicConfigObject.get_DiskResources() at Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterDiskPublicConfigObject.VerifyPathInClusterGroup(String path) at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.IsInvalidDrive(DirectoryInformationData did, String fullPathName, String bindingArg, String uiBindingArg) at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateDataDirectory(String directoryType, String directory, String bindingArg, String uiBindingArg, DirectoryValidationFlags validationFlags) at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateDataDirectories() at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateInstallInput() at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPublic.ValidateSettings() at Microsoft.SqlServer.Configuration.PublishedProperties.Validate() at Microsoft.SqlServer.Configuration.DatabaseEngineSecuritySettings.ValidateSettings() at Microsoft.SqlServer.Configuration.PublishedProperties.Validate() at Microsoft.SqlServer.Configuration.InstallWizardFramework.ConfigurationController.ValidateSettings() at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.CalculateValidationState() at Microsoft.SqlServer.Configuration.WizardFramework.PageHost.<>c__DisplayClass1.<PageLeaving>b__0() at Microsoft.SqlServer.Configuration.WizardFramework.BlockingWorker.ThreadCallBack(MethodInvoker method) at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase) at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData) at Microsoft.SqlServer.Configuration.WizardFramework.BlockingWorker.WorkerCallback.EndInvoke(IAsyncResult result) at Microsoft.SqlServer.Configuration.WizardFramework.BlockingWorker.PerformWork(MethodInvoker method) at Microsoft.SqlServer.Configuration.WizardFramework.PageHost.PageLeaving(PageChangeReason reason) at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.PageLeaving(PageChangeReason reason) at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardTabbedPageHost.PageLeaving(PageChangeReason reason) at Microsoft.SqlServer.Configuration.WizardFramework.UIHost.set_SelectedPageIndex(Int32 value) at Microsoft.SqlServer.Configuration.WizardFramework.NavigationButtons.nextButton_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m) at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)I've done mixed installs like this before but without incident - rather than try again I though I might request some suggestions as to what might have been the cause .Thanks

Transaction Log Backup fails Exclusive access could not be obtained because the database is in use

Posted: 15 Jul 2013 06:42 AM PDT

I have an AM and a PM TransactionLog Backup.The AM runs fine the PM failsI get the following error.Date 07/15/2013 03:00:00 PMLog Job History (Backup_DataWarehouse_TransactionLog_PM_Test.Subplan_1)Step ID 1Server MyServerJob Name Backup_DataWarehouse_TransactionLog_PM_Test.Subplan_1Step Name Subplan_1Duration 00:00:22Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: MyDomain\SQLServerAgent. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 03:00:00 PM Progress: 2013-07-15 15:00:00.77 Source: {247A3977-1976-4E4B-8B35-B14F86B49B5F} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2013-07-15 15:00:21.01 Code: 0xC002F210 Source: Back Up Database (Transaction Log) Execute SQL Task Description: Executing the query "BACKUP LOG [DataWarehouse] TO DISK = N'D:\Backup\Tran..." failed with the following error: "Exclusive access could not be obtained because the database is in use. BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 03:00:00 PM Finished: 03:00:21 PM Elapsed: 20.811 seconds. The package execution failed. The step failed.Any ideas?

SQL Server Crash Dump

Posted: 15 Jul 2013 09:39 PM PDT

Hi All,I have strange problem with my live cluster environment. I have a dev environment in which a procedure completes in approx 4mins. In my live environment, the same procedure if executed it runs for 1st time = 18 sec2nd time = 18-20 sec3rd time it hangs the servers. At this point, I cannot open new window from management studio. I cannot run any query in any other window in that server. This keeps on for several hours or more than 1 day and then server crashes.We have disabled the hypthreading and have made the default max worker threads.My SQL Version:-0Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) Thanks in advance.Harsha

dear all,

Posted: 15 Jul 2013 04:08 PM PDT

can anyone please le tme know, in sql 2012 high avalability solution REPLICATION is deprecated or what? i got this doubt whe i try to surf high avalibility solutions in sql 2012, nowhere i get to see REPLICATION in 2012.can anyone please let me know.Thanks in advance.

Removing article from existing Peer to Peer replication

Posted: 15 Jul 2013 11:32 AM PDT

Hi Everyone,We have a Peer to Peer replication in sql server 2008 R2.We want to remove an article from the replication.What is the safest way to that(through TSQL),Will that cause any problem for the replication operation?Thanks

List of when commands were introduced

Posted: 15 Jul 2013 08:34 AM PDT

Has anyone compliles a list of SQL Commands and which version of MSSQL introduced them?We're wroking on some maintanance & admin scripts that will be used on multiple instances of difference versions and I'm not certain of which commands will work on SQL 2005 or 2000.Dan

SQL bACKUP FILE SIZE

Posted: 15 Jul 2013 05:57 AM PDT

Hello All,I need to monitor size of most recent SQL .BAK file in each folder (each database has it's folder) and insert the name and size to a SQL table. This can be a job which would run everyday.Can someone please suggest me the bets way to achieve these results?Thanks,

SQL Server 2008 R2 to SQL Server 2008 R2 Linked Server Issues

Posted: 15 Jul 2013 06:33 AM PDT

Greetings,I'm trying to establish a linked-server connection from our Regional SQL Server 2008 R2 (R1) to the Division SQL Server 2008 R2 (D1).Both our server (R1) and the Division server (D1) reside on the same NT domain. All users who would be accessing the linked server (D1) have permissions to do so - this has been verified by connecting directly to D1 via SSMS. At this point, we're certain it's not a permissions issue, per se.That said, we're having some issues, and I'm hoping someone here has solved these before and can help me out - Googling and searching the forums hasn't turned up precisely what we're dealing with, so that's why I'm posting here.Scenario One:I connect to R1 via SSMS on my laptop. I then execute a simple SELECT statement against D1 using the linked server connection:[code="sql"]SELECT * FROM [D1].[USERS].[DATA].[USER_DATA][/code]At which point, I get the following error message:[code="other"]Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.[/code]After reading up on linked server connections and permissions, I execute the following, though technically I shouldn't have had to:[code="sql"]EXEC sp_addlinkedsrvlogin 'D1', 'true';[/code]Again, I try the simple SELECT statement above, and get the same error message.Scenario Two:I use Microsoft's Remote Desktop (RDP) program to connect to R1. I then open SSMS on the R1's remote desktop, and attempt the simple SELECT:[code="sql"]SELECT * FROM [D1].[USERS].[DATA].[USER_DATA][/code]And I get valid data from D1The question is this: Why is R1 not passing the NT credentials - despite being configured to do so in the D1 linked server definition - when a user connects to R1 via SSMS, and yet does pass the NT credentials of the RDP user when the query is executed through a RDP session with SSMS?Fundamentally: is there a way to change this behavior? We need to be able to execute queries against the linked server within our local SSMS sessions on our local workstations without having to RDP every time; furthermore we need to replicate data from this linked server.

Find all users mapped to a credential

Posted: 15 Jul 2013 05:57 AM PDT

I just stumbled upon a credential in SSMS under Security-Credentials. I can see the credential in sys.credentials. I can examine the properties of an individual login to see if they are mapped to this credential. Is there any way to see all logins this credential is mapped to?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog