Tuesday, June 11, 2013

[SQL 2012] SQL Server 2012 cluster install error

[SQL 2012] SQL Server 2012 cluster install error

SQL Server 2012 cluster install error

Posted: 11 Jun 2013 02:11 AM PDT

I am installing SQL Server 2012 Enterprise (x64) with SP1 on a Windows 2012 SP1 3 node cluster utilizing mount points. I get the following error during the initial install on the first node:While updating permission setting for Folder 'z:\SQLDATA\System Volume Information' the permission setting update failed for file 'z:\SQLDATA\System Volume Information\ResumeFilterKey.Store' The folder were supposed to be set to 'D:P(A;OICI;FA;;;BA)(A;OICI;FA;;;SY)(A;OICI;FA;;;CO)(A;OICI;FA;;;S-1-5-80-617070787-1164103636-1191419902-1692725703-799689240)The 3 workarounds I found all referenced SQL Server 2008 R2. I tried all 3 suggestions and none have worked.I am thinking this relates to the mount somehow, but I am stuck. And, no, the mount points are NOT in the root of the drive.Any ideas???

How to change IntelliSense timeOut in SSMS 2012?

Posted: 11 Jun 2013 01:11 AM PDT

Hi everyone(my english is not very strong)I was wondering if anybody know how to "manually" change de time out of the intellisense in SQL server Management Studio 2012.I have a local instance and the SSMS works very well with it. But when I connect to the remote instance, intellisense doesn't work.I read that this value (timeout) is "hardcoded", but I'll try to change it. :-DThanks in advance

Data Cube / SQL Server 2012 / BI

Posted: 10 Jun 2013 10:02 PM PDT

Hi Folks,I am a newbie to this forum and relatively new to SQL especially SQL Server.My first query in this area:I have got 2 tables with one common field on which i can make a join.A/ I have been asked to convert this data into a cube.All i know is that a cube is more then 2 dimensional data. Would love your input on where i can learn about cubes and how do i achieve this in sql server 2012 as i already have a license for it.B/ The objective of this exercise i believe, is to keep ready as many reports in as many permutation combinations as possible so that when a user asks for this data, its readily available and very fast to execute.Wouldn't a view just work for this or is that too simple and time consuming to modify every time there is a different request?C/ We also would like to use the BI part of SQL Server 2012. End result is for users to use Excel to interact and play with the data/reports.Can users directly through excel leverage the BI tools of SQL Server 2012Thanks in advance..Regds, Ross

Oracle Data Guard Functionality

Posted: 10 Jun 2013 09:47 AM PDT

Hello all,Does anyone know if the functionality of Oracle Data Guard (Separation of Duties) is available under SQL Server 2012?

Where to find the Sql Server Integration Services 2012 components' componentClassIDs (CLSID)

Posted: 10 Jun 2013 09:41 AM PDT

Hi,I need to find the list of all the component CLSIDs for sql server integration services 2012. Can anyone let me know where I can find them?Thanks!
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog