InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:42:08 GMT20http://www.sqlservercentral.com/Forums/Topic1306009-2799-1.aspxHere is the command line:[quote]Setup.exe /ConfigurationFile="C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20120524_123258\ConfigurationFile.ini"[/quote]And here is the output:[quote]Microsoft (R) SQL Server 2012 11.00.2100.60Copyright (c) Microsoft Corporation. All rights reserved.The following error occurred:'<null or empty string>' is not a valid value for setting 'ACTION'. Refer to Help for more information.[/quote]Has anyone seen this?Thu, 24 May 2012 10:55:55 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic1304568-2799-1.aspxHI,Is there a free version/edition available of SQL 2012 that we can use to develop (like Developer edition for 2008)? Is where where I can get it?ThanksTue, 22 May 2012 15:13:32 GMTRem70Remhttp://www.sqlservercentral.com/Forums/Topic1305688-2799-1.aspxI have a requirement in reports that the No. of rows in reports should be constant for each page generated by reporting service. Suppose there is a description column for products, which vary from product to product, some products has 1 line description and some has 10 lines or more lines. But the requirement is that each page should have 10 products. How do i achieve this. I need solution for both version of reports 2005 and 2008.Shamshad Ali.Thu, 24 May 2012 04:48:14 GMTshamshad.alihttp://www.sqlservercentral.com/Forums/Topic1305582-2799-1.aspxHi,I have a required in SQL Reports that the columns in report should not scroll, they should be freezed or its up to client, if he want to feez the columns. Like we do in Excel. Is there any such feature available ?Shamshad Ali.Thu, 24 May 2012 02:13:06 GMTshamshad.alihttp://www.sqlservercentral.com/Forums/Topic1305605-2799-1.aspxWe have losts of reports build in SSRS 2005, with complex/conditional formatting. When I simply open those reports in SSRS 2008 version, they all messup and when i run reports they does not contain all the conditional formattings etc. Is there any way to migrate as it is in SSRS 2008 to same time and efforts?Shamshad AliThu, 24 May 2012 02:44:53 GMTshamshad.alihttp://www.sqlservercentral.com/Forums/Topic1305270-2799-1.aspxIf I run select RECIP as recipno, DIAGNOSIS_CODE as diag_1, /*icd 9 codes must be 5 in length without decimal code*/ CASE WHEN dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE IS NOT NULL THEN CASE WHEN SUBSTRING(LTRIM(RTRIM(dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE)), CHARINDEX('.', LTRIM(RTRIM(dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE))), 1) = RIGHT(LTRIM(RTRIM(dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE)), 1) THEN CAST(LEFT(LTRIM(RTRIM(dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE)), CHARINDEX('.', LTRIM(RTRIM(dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE))) - 1) AS varchar(5)) WHEN LEN(SUBSTRING(LTRIM(RTRIM(dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE)), CHARINDEX('.', LTRIM(RTRIM(dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE))), CHARINDEX('.', LTRIM(RTRIM(dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE))) + 1)) > 1 THEN CAST(PARSENAME(LTRIM(RTRIM(dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE)), 2) + PARSENAME(LTRIM(RTRIM(dbo.p_DMAS_MEDICAL_TRANSITION.DIAGNOSIS_CODE)), 1) AS varchar(5)) END ELSE NULL END AS diag_1 from dbo.p_DMAS_MEDICAL_TRANSITION inner join dbo.m_Enrollment_months on dbo.m_Enrollment_months.MED_ID= dbo.p_DMAS_MEDICAL_TRANSITION.recip where dbo.m_Enrollment_months.DOS_DATE between '10/1/2011' and '10/31/2011' I get recipno and diag_1 as I expect but also a second diag_1 var which I did not expect and is all null ...if I take outthe last end as diag_1 it will just keep that second var without a name. What code do I omit to just get the recipno and fisrt diag_1?ThxWed, 23 May 2012 12:35:28 GMTdiva_di_datihttp://www.sqlservercentral.com/Forums/Topic1304267-2799-1.aspxQuick question -I'm looking to find the exact send rate when alwayson (AVG) isconfigured.For instance - when sql 2008 mirroring is configured, you can launch the mirroring monitor from w/in SSMS and the application will provide the send rate and restore rate for both the principal and mirror node.I have AlwaysOn configured with servers in NYC and LA and I'm trying to find if the send rate is readily available in the SSMS GUI (don't see it in the AVG dashboard). I have the data from perfmon - but i'm hoping it's avaiable in SSMS.Thank.Tue, 22 May 2012 09:53:37 GMTcheshirefoxhttp://www.sqlservercentral.com/Forums/Topic1303982-2799-1.aspxIf you haven't already got a copy of this, download it using this link, its a 450 ish page PDF ouch[url]http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf[/url]Tue, 22 May 2012 02:58:18 GMTSQLDBA360http://www.sqlservercentral.com/Forums/Topic1300571-2799-1.aspxI have not been able to get brace matching to work in SSMS 2012. I did try this setting: Tools / Options / Environment / Fonts and Colors, then under 'Display items:', I played with both 'Brace Matching (Highlight)' and 'Brace Matching (Rectangle)', but neither seems to work. What I want it to do is what it does in SSMS 2008: highlight the opening bracket when I type the closing bracket, or highlight both when I bring the cursor adjacent to the bracket or parenthesis. If somebody knows how to get this to work, would appreciate your sharing the fix.Thanks much.Tue, 15 May 2012 13:54:07 GMThakim.alihttp://www.sqlservercentral.com/Forums/Topic1303143-2799-1.aspxI experienced this issue when I tested the installation of SQL 2012 Developer Edition on Windows 7 Enterprise x64.After the installation completed, I checked on MSDB database. I found that all tables, stored procedures, and functions related with DTA were missing, or not installed. When I started on Database Engine Tuning Advisor, I got connection error message.Does anyone get similar situation?Sun, 20 May 2012 20:28:15 GMTHaininghttp://www.sqlservercentral.com/Forums/Topic1296327-2799-1.aspxHi AllA question regarding the SQL 2012 High Availibility FeaturesI understand that in order to use the High Availibility Features that comes with SQL 2012, the Servers need to be clustered.1. Does this mean the SQL needs to be installed as a clustered instance or does the server just need to be clistered2. If I want to set up SQL 2012 High Availibility between 2 Servers, do they need need to be part of the same Cluster?ThanksDerekTue, 08 May 2012 03:48:24 GMTderekr 43208http://www.sqlservercentral.com/Forums/Topic1302858-2799-1.aspxDear friends,I need to install sql2012 on my web server. but my webserver (windows2008) have plesk control panel on it. And Plesk uses MSDE (sql2000). I experimented to install sql2012 on a machine which msde installed and only way I could find is to uninstall MSDE, install sql2012 and re-install MSDE. But I cannot do this procedure because web server is in use. Also I really afraid of corrupting plesk panel because I don't have any chance to stop it. I cannot afford to loose my web server nor panel operation for couple of hours.So, can anybody found a way to install sql2012 as a new instance while MSDE (sql2000) installed on a computer ? I don't want plesk panel to control it (of course it won't as it does not support sql2012). Plesk will continue to use MSDE. sql2012 will be new instance and wont have any connection with plesk.best regards.Fri, 18 May 2012 15:17:19 GMTaykut canturkhttp://www.sqlservercentral.com/Forums/Topic1301043-2799-1.aspxI am configuring my Availability Group Listener and running into an issue during testing. The configuration of my AG is 3 SQL Servers (replicas). I can ping between all of them by name (SQL1, SQL2, SQL3) without issue. I can connect via SSMS as well. All is well until I start testing my AG Listener. AG Listener was created when the Primary was SQL1. I could connect to the app (separate machine altogether) via the AG Listener and connect to it via SSMS on SQL1. I cannot ping and/or connect to it via SSMS on SQL2 or SQL3.When I failover the AG, I am then able to ping and/or connect to theAG Listener on the server that now hosts the Primary (i.e. SQL2). However, I am unable to connect to the AG Listener anymore through the app. The other 2 SQL Servers hosting the secondaries are still unable to connect to the AG Listener.I deleted my AG Listener and recreated it to insure all was well. I am experiencing the same behavior. Any insight would be greatly appreciated!Thanks,DaveWed, 16 May 2012 07:50:01 GMTDavid Kothhttp://www.sqlservercentral.com/Forums/Topic1301800-2799-1.aspxArgh! This is driving me nuts! Does anyone know how to turn off all of this Corod nonsense and reset the keyboard mapping in SSMS back to 2008 or anything sane?Thu, 17 May 2012 08:16:12 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic1301609-2799-1.aspxHi All,Currently, one of our New DB Server installed with SQLServer 2008 R2(X64) Enterprise Evaluation (Trail) Edition.Can we apply SQLServer 2012(X64) Standard Edition licence on this.Please advise...it's bit urgent.Thanks and Regards,RavichandraThu, 17 May 2012 04:09:11 GMTravisamigohttp://www.sqlservercentral.com/Forums/Topic1300875-2799-1.aspxI have received this error when starting a Service Broker (through SQLDependency.Start() in .net). All was fine in 2008 R2, but 2012 is just hanging up. The error:SELECT permission denied on object 'services', database 'mssqlsystemresource', schema 'sys'. Permission for the user - just public rights to the database, then:ALTER USER [WebUser]WITH DEFAULT_SCHEMA = [web]GO-- Deny all common rightsDENY SELECT TO [WebUser]DENY INSERT TO [WebUser]DENY UPDATE TO [WebUser]DENY DELETE TO [WebUser]-- Permission for starting SqlDependencyGRANT CREATE PROCEDURE TO [WebUser]GRANT CREATE QUEUE TO [WebUser]GRANT CREATE SERVICE TO [WebUser]GRANT REFERENCES ON CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] TO [WebUser]GRANT VIEW DEFINITION TO [WebUser]-- Permission for receiving SqlDependencyGRANT SUBSCRIBE QUERY NOTIFICATIONS TO [WebUser]GRANT RECEIVE ON QueryNotificationErrorsQueue TO [WebUser]GOFrankly, I am lost.Wed, 16 May 2012 03:20:01 GMTJakub.Jandahttp://www.sqlservercentral.com/Forums/Topic1301097-2799-1.aspxI have a client with a Point of Sale system that the vendor of the PoS has left on a woefully undersized server. The vendor's recommendation was to go to the next undersized server considering the client is growing and adding locations. This has shaken the client's confidence in the vendor, and they have turned to us to help them out. The previous hardware was non-brand/home built server. The current environment has the server with SBS 2003 R2 - Dual Core Xeon - 4 GB of RAM- 500 GB HD (On on board RAID). They also use it as their DC and File Server. No wonder it runs at 6.5 GB of RAM and crashes every day. The other locations are have PoS systems that are connecting back to this as the main server, but from what I can tell, they have local databases that are replicating back to the SBS server. One "Server" is an XP Workstation - the other two are Server 2003 R2 and Server 2008 R2. The database is running on SQL Server 2005 Workgroup edition.** BANGS HEAD SOME MORE - I will get to the question in a moment - sorry.Ok - so we will be putting them on a real HP Proliant with RAID 10 (4 1 TB Drives) - 6 core - 24 GB of RAM. That is the current plan at least. I will use volume licensing for Server 2008 R2, CALS, and SQL 2012, etc. The server will be database only. They are planning on adding 3 more locations right away and looking to grow after that. I would like to rebuild the old server with Server 2008 R2 (add RAM) and have it be DC, FS, etc. So I have several concerns about this database. 1) The manufacturer does not indicate that they have tested with SQL Server 2012. I have an email in to them. The quote from the PoS vendor did have SQL Server 2008 listed in the specs on Server 2008 R2. So I am expecting that we should be able to transition the database to SQL Server 2008. So the question is here - what issues would we have with 2012? Everything I have read indicates that there is a transition tool for 2005 to 2012. I don't have a machine local to the SQL 2005 server to run the transition tool at the moment, but I will have my local guy go onsite to do testing before the final decision. I do plan to have the vendor do the PoS transition work. I just need to be able to call BS on them if they say something can't be done.2) I was trying to recalculate the database size after the 32-bit to 64-bit transition. From what I have read, increasing the estimated size by about 1/3-1/2 more should be safe when calculating disk size. From first hand experiences, do you feel this is accurate? I might be able to drop down to (4) 500 GB drives and save them some money if it is.3) Looking through the server is a mess. Looking through folders used for deploying software I see SQL Server 2005 Express, SQL Server 2005, SQL Server 2008. In the Programs menu, I see Visual Studio Tools 2005 - they were never run until I loaded the first time. SBS Came with SQL Server 2005 Worgroup - which is what their app needs. Looking in the programs menu, I see tools for configuring SQL 500, 2008, and 2008 R2. Then I looked in the Services and Applications - I see two instances of SQL 2005 services. When I check the actual version running, it is 9.0.3080. So I am guessing they attempted to upgrade and ran into a problem. The database appears to be under 4 GB. I am wondering if the best thing to do is to just take a copy of the database and try to migrate it on a test box. Any thoughts on this? (Other than run away - lol)4) What am I not thinking of? I figure worst case I should be able to exercise the downgrade right for SQL Server 2012 to 2008. But I keep thinking this should not be this big of an issue.THANKS!Wed, 16 May 2012 08:45:21 GMTBrian Souderhttp://www.sqlservercentral.com/Forums/Topic1300120-2799-1.aspxHi to all, I'm migrating an old SSIS 2005 version to a SSIS 2012 structure (on a new machine Windows 2008 R2 64 bit).I've converted DTS package using SQL Data Tools and all seems to be ok.To run the package I use a .bat file with the following syntaxdtexec.exe /FILE "D:\SSIS\MySSIS.dtsx" /CONFIGFILE "D:\SSIS\MySSISConf.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI > Log_DTEXEC.txtWe're planning to move our environment from Windows 2003 32 bit to Windows 2008 R2 64 bitIf I run the .bat file I get the following errors:The requested OLE DB provider SQLNCLI.1 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000.An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".Consider changing the PROVIDER in the connection string to SQLNCLI11 or visit http://www.microsoft.com/downloads to find and install support for SQLNCLI.1.I've change in MySSISConf.dtsConfig from SQLNCLI.1 to SQLNCLI11.1but the error still the same.I've searched on web for a solution and tried to execute 32 bit version of dtexec.To be sure I've copied my dtsx and dtsconfig file in C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn and ALL IS WORK FINE ????Can someone suggest me a way to investigate the problem?Thank you in advance for your help.Best regardsFabrizioTue, 15 May 2012 03:53:17 GMTfabriziocrespihttp://www.sqlservercentral.com/Forums/Topic1300021-2799-1.aspxI installed Sql Server 2012 Express. Everything went without a hitch until I attempted to create a new database and place it on a second drive (E:). The location window displays C: and an external drive (Z:), but not the E: drive where I wish to place the database. Permissions show full control, but Sql Server won't display it.Mon, 14 May 2012 21:33:36 GMTml 66943http://www.sqlservercentral.com/Forums/Topic1293226-2799-1.aspxWe have a variety of database related projects and tasks in the pipeline and I'm trying to put together a system to rank and prioritize them so we can tackle the items in a logical order and the ones that don't make sense (perhaps someone's pet project) fall behind ones that impact the business more. Here are some of the criteria I've thought of: - Financial benefit (direct result of more profit or less loss) - Security (tighter control, more auditing) - Performance (faster, fewer executions, less resource usage) - Scalability (ability to handle greater future load) - Integrity (Data integrity, consistency) - Iterations (Man hours to complete)I thought I'd rank each project 1-5 in each area, then multiply the value by an "importance" factor (i.e. if security is paramount, a "5" there is twice as influential in the score than a "5" in Performance) and sum them up. Since Performance and scalability are frequently related, they would probably receive smaller importance factors than the other items.Do you have a different methodology that works for you, or other criteria I should add?Thanks,Chad*Edit: Added Iterations to the listTue, 01 May 2012 09:20:53 GMT Chad Crawfordhttp://www.sqlservercentral.com/Forums/Topic1299132-2799-1.aspxIn 2008, code blocks in a query window that are currently folded are by default ignored by the text search, and the functionality could be toggled on / off using the "Search hidden text" option. However, now in SSMS 2012, when I call up the "Find and Replace" dialog, it appears that the "Search hidden text" option has been removed.I'm currently working on a 12,000 line stored procedure and need to retrofit and unit test one block at a time. It would be very useful to have the "Search hidden text" option back in SSMS 2012.Does anyone know the back story on this or how to toggle "Search hidden text" on / off in 2012? I would really love to get that functionality back.Sat, 12 May 2012 10:47:31 GMTEric M Russellhttp://www.sqlservercentral.com/Forums/Topic1298433-2799-1.aspxHi ,I have a chance to look into [url]http://blogs.technet.com/b/dataplatforminsider/archive/2012/04/09/the-coming-in-memory-database-tipping-point.aspx[/url] site where it states about in-memory,whether it is really equal to Oracle's TimesTen database [url]http://download.oracle.com/otn_hosted_doc/timesten/603/TimesTen-Documentation/arch.pdf[/url]The project which i am working is new to me at present the data load is happened in memory and read/writes are also happen in memory only.Only aim for us is what ever we are writing in memory we need to write to database with same speed at present which it works,so our aim is not to have any performance degrade when we choose a database.Our records are less than micro second level ,thousands of records will be written at a stretch to memory in a second and process takes place from memory so when we need to implement database it should not effect our process. Which is better Oracle's TimesTen or SQL server 2012 (which is having in-memory option).Thanks for your help!Fri, 11 May 2012 03:46:58 GMTyuvipoyhttp://www.sqlservercentral.com/Forums/Topic1297996-2799-1.aspxHi,I have purchased an Open License for four cores of SQL 2012 Standard Edition (2 x 7NQ-00219). According to the downgrade rights chart on the Microsoft website I should be able to install 2008 R2 instead, but in the VLSC I do not have access to the 2008 R2 Standard Edition download, only the SQL Server Standard Core 2012.Has anybody used downgrade rights from 2012? Where did you get the install and/or keys?ThanksThu, 10 May 2012 09:51:07 GMT688119http://www.sqlservercentral.com/Forums/Topic1296525-2799-1.aspxI have a SSIS package that I am try to execute via the stored procedures found in SSISDB.Here is my T-SQL:[code="plain"]DECLARE @execution_id BIGINTEXEC [SSISDB].[catalog].[create_execution] @package_name = N'PackageName.dtsx' , @execution_id = @execution_id OUTPUT , @folder_name = N'FolderName' , @project_name = N'ProjectName' , @use32bitruntime = False , @reference_id = NULLSELECT @execution_idDECLARE @var0 SMALLINT = 1EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id , @object_type = 50 , @parameter_name = N'LOGGING_LEVEL' , @parameter_value = @var0EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id , @object_type = 50 , @parameter_name = N'SYNCHRONIZED' , @parameter_value = 1EXEC [SSISDB].[catalog].[start_execution] @execution_idGO[/code]It says that it executes successfully, but when we check the tables where we are expecting the new records to be there is nothing. Although, if we just run the package via SSDT, all the records are there.Am I missing something stupid? We have tried calling this code from within our web app, and via SSMS, but niether "work".I am running SQL 2012 (obviously), I have granted the test user (that is calling the package) Read, Modify, Execute, and Manage Permissions on the Project, as well as Read, Execute Objects, and Read Objects on the Folder. These didn't help, the user continually got this message:[quote]Msg 27146, Level 16, State 1, Procedure create_execution, Line 167Cannot access the package or the package does not exist. Verify that the package exists and that the user has permissions to it.[/quote]Not until I added the user to the SSIS_Admin role was he able to execute the code, which as stated just returned that it was successful.Thanks in advance for you help.Tue, 08 May 2012 08:50:29 GMTsqlNinjahttp://www.sqlservercentral.com/Forums/Topic1283357-2799-1.aspxJust curious to see if this is something that's possible to do. I'd imagine that there should not be any problems, since you can do the same with 2005 to 2008, perhaps I've overlooked something? This will be for transactional replication.Fri, 13 Apr 2012 12:41:20 GMTDVSQLhttp://www.sqlservercentral.com/Forums/Topic1296198-2799-1.aspxHi helpfuls,I am a SQL developer with 5 years+ experience and recently my role has morphed to become >50% DBA, and my employer would like me to gain a certification along those lines.Given SQL 2012 has only just come out, and the exams are only going live in June, and there is currently no listed study publications by Microsoft, should I be going for a MCSA SQL Server 2012, or an older SQL 2008 certification do you think?Thanks for any help,signal_runnerMon, 07 May 2012 21:10:15 GMTsignal runnerhttp://www.sqlservercentral.com/Forums/Topic1296110-2799-1.aspxHi - Planning on upgrading from SQL 2008 R2 to SQL 2012...Has anyone performed one way SQL Mirroring for the upgrade process?Simple example - add SQL 2012 as a mirror node to a SQL 2008 R2 principal.. Then simply failover the database...Should be pretty basic - just want to see if anyone has actually done it yet.Thanks.Mon, 07 May 2012 14:36:18 GMTcheshirefoxhttp://www.sqlservercentral.com/Forums/Topic1293814-2799-1.aspxHi All,I'd like to learn how to build business intelligence solutions. I've been doing database development for years but know little about Analysis Services. I've been approved to expense local training. I'm in Dallas, TX. I'd appreciate some advice.I would like to take the Microsoft-designed course "Implementing a Data Warehouse in Microsoft SQL Server 2012 (10777)". However, the partners providing the training in Dallas, like Global Knowledge and Dynamics Edge, have been canceling classes due to lack of enrollment. I'm guessing it is because the class is still new and the correlating exam isn't even out yet. While I eventually want to take the exam, I'm more concerned now with learning the fundamentals, especially of dimensional modeling, so I have a way to orient myself when digging through the details and nuances. I'm reading on my own but want to take the opportunity given to attend instructor-led training. I'm not sure how long the offer will be extended. Would it be beneficial to go ahead and take course based on 2008? Is there a non-Microsoft course I could benefit from? Should I try to hold out? It seems like a lot of 2012 improves BI so I'm hesitant to take a 2008 course. But what do I know? Thanks in advance for any advice.RobWed, 02 May 2012 07:17:59 GMTrwm972http://www.sqlservercentral.com/Forums/Topic1294918-2799-1.aspxHi,When installing SQLEXPR_x86_ENU.exe the installation just dies out after showing a command prompt box. The SQLSetup.log found in %tmp% shows:05/03/2012 14:49:29.586 ======================================================================05/03/2012 14:49:29.586 Setup launched05/03/2012 14:49:29.586 Attempting to determine media source05/03/2012 14:49:29.586 Media source value not specified on command line argument.05/03/2012 14:49:29.586 Setup is launched from media directly so default the value to the current folder.05/03/2012 14:49:29.586 Media source: c:\8b13bdbe95039358f45308af\05/03/2012 14:49:29.586 Attempt to determine media layout based on file 'c:\8b13bdbe95039358f45308af\mediainfo.xml'.05/03/2012 14:49:29.743 Media layout is detected as: Core05/03/2012 14:49:29.743 Not a slip stream media, so continuing to run setup.exe from media.05/03/2012 14:49:29.758 SQM key not found05/03/2012 14:49:29.758 /? or /HELP or /ACTION=HELP specified: false05/03/2012 14:49:29.774 Help display: false05/03/2012 14:49:29.774 .Net version 3.5 is installed05/03/2012 14:49:29.774 .Net version 2.0 is installed05/03/2012 14:49:29.774 Local setup.exe not found, so continuing to run setup.exe from media.05/03/2012 14:49:29.774 Attempt to initialize SQL setup code group05/03/2012 14:49:29.774 Attempting to determine security.config file path05/03/2012 14:49:29.774 Checking to see if policy file exists C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\security.config05/03/2012 14:49:29.774 .Net security policy file does not exist05/03/2012 14:49:29.774 Attempting to create .Net security policy file05/03/2012 14:49:31.915 Error: InitializeSqlSetupCodeGroupCore(64bit) failed05/03/2012 14:49:31.915 Error: InitializeSqlSetupCodeGroup failed: 0x84C4001305/03/2012 14:49:31.930 SQM key not found05/03/2012 14:49:31.930 Setup closed with exit code: 0x84C4001305/03/2012 14:49:31.930 ======================================================================After many many hours of various troubleshootings, I came up with this and I'm stumped.Framework 4 no longer uses caspol.exe per running the command line;C:\Windows\Microsoft.NET\Framework64\v2.0.50727>caspol.exe -all -resetMicrosoft (R) .NET Framework CasPol 2.0.50727.5420Copyright (c) Microsoft Corporation. All rights reserved.ERROR: Runtime error: This method explicitly uses CAS policy, which has been obsoleted by the .NET Framework. In order to enable CAS policy for compatibility reasons, please use the NetFx40_LegacySecurityPolicy configuration switch. Pleasesee http://go.microsoft.com/fwlink/?LinkID=155570 for more information.Now I extracted the executable and the configuration file used for the setup seems to indicate that it is using the legacy flags indicated in the CAS link.I ran the exact same command line on the 32 bit folderC:\Windows\Microsoft.NET\Framework\v2.0.50727>caspol.exe -all -resetAnd it successfully created security.config and security.config.cch in C:\Windows\Microsoft.NET\Framework\v2.0.50727\configIn desperation, I copied those files into the 64 bit folder; C:\Windows\Microsoft.NET\Framework64\v2.0.50727\configAnd ran the installation, successfully installing SQL 2012.Here's the rub, WHY can the security.config files not be created? It seems to indicate it tries to create them but fails, I am logged in as an administrator on the machine and I did run the setup using elevated rights (right click run as administrator)I'm flumoxed, anyone else run into similar issues? Have any clues or ideas?Thanks.ConnieThu, 03 May 2012 13:06:37 GMTconnielee.deadmanhttp://www.sqlservercentral.com/Forums/Topic1291743-2799-1.aspxAnyone using an Oracle subscriber with SQL 2012? We have a scripted deployment that works great on SQL 2008 R2 (and 2008, 2005), but when we run it on 2012, the distribution of the snapshot fails at the very end with an ORA-00942 error stating the "table or view does not exist". This is after all 342 pre, sch, idx, and bcp files have been processed successfully. The agent then starts over again, dropping all the tables and recreating them again. We are running SQL 2012 Developer on Windows 7 Enterprise SP1 (32bit) under Windows Virtual Server 2005 R2 on Windows XP SP2 (64 bit) for validation testing.Fri, 27 Apr 2012 12:37:50 GMTRonzohttp://www.sqlservercentral.com/Forums/Topic1270863-2799-1.aspxI have a laptop that has 64x SQL Server 2012, 86x Office 2010. When I create a project in SSDT and tried importing data from a database it works fine when I add in an Excel workbook I get an error. Screen shot is attached. I have tried installing the Access Database Engine and I still get the same error message. Does anyone have any ideas why I am getting this error?Thu, 22 Mar 2012 07:54:43 GMTcderosier 16389http://www.sqlservercentral.com/Forums/Topic1294189-2799-1.aspxMy Measures table has 50 Millions rows.Back with SQL 2008 R2 I could make a model that pointed at it and the model didn't try to import the data like the BISM models do with SQL 2012.The Visual Studio shell only seems to run in 32-bit. So when I import these 50million rows I exceed available memory, and VS crashes with an out of memory error.I know that when I get the model to the Tabular AS server I'll be ok, but since the design has to happen in 32-bit VS 2010, how do I get around the very large measures table?Wed, 02 May 2012 14:13:10 GMTmtassinhttp://www.sqlservercentral.com/Forums/Topic1292522-2799-1.aspxHey Everyone,I was looking for general differences between MS SQL 2008 and MS SQL 2012 just to start with.In depth differences are welcome too. However, I have found few such as,AlwaysOn High AvailabilityIntegration Services CatalogsAny input is appreciated!Mon, 30 Apr 2012 07:47:42 GMTKomodo_ERhttp://www.sqlservercentral.com/Forums/Topic1288649-2799-1.aspxI'm looking into updating my Microsoft certifications. Should I go for the SQL 2008 exam 70-432 or hold off until I can do the equivalent in 2012? I'm MCDBA qualified in SQL Server 2000. My company is still using 2000 but is about to upgrade to 2008 R2 and then to 2012 next year.It's a significant investment so I'd like any qualifications I get to be valid for as long as possible. I'd just like to get some thoughts on this. Many thanks,PeterMon, 23 Apr 2012 23:24:54 GMTpeterochttp://www.sqlservercentral.com/Forums/Topic1293384-2799-1.aspxHi -I have workingSQL 2012 availability group with 2 databases.. It works like a champ.So, I'm trying to add another database to the group but the difference, I'm trying to manually backup and restore the database on the secondary.. The backup and restore of a full and transaction log worked successfully...So - on the primary node - the database (matthew) is reporting synchronized.On the secondary the database is in a restoring state.W/in the availability groups, the database is marked with yellow caution.From SSMS, i've right clicked and selected 'Join to Availability Group' w/ success.I'm receiving the following message: Failed to join the database Matthew to the availability group.BLAHBLAHBLAH...Availability group DDL operations and permitted only when you are using the master database.Run the USE MASTER command, and retry your availability-group DDL command (Error 35208)...LOL - Found the resolution:ALTER DATABASE matthew SET HADR AVAILABILITY GROUP = AVGGROUPNAMETue, 01 May 2012 12:16:59 GMTcheshirefoxhttp://www.sqlservercentral.com/Forums/Topic1286522-2799-1.aspxJust figured this out today... Wanted to share...I've gotten this to work in our new SQL 2012 RTM 64-bit servers:This retrives data from DBase, Advantage DB, Sybase .dbf files directly using the Microsoft ACE OLEDB 12.0 64-bit drivers.Use MyDatabaseGOsp_configure 'show advanced options', 1reconfigure GOsp_configure 'Ad Hoc Distributed Queries', 1 reconfigureGOEXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1;EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1;--Must use all CAPS in the query parameter section, except the file name.SELECT COLUMN1,COLUMN2FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','dBASE IV;Database=\\RemotServerName\ShareName\Folder1\SubFolder1\','SELECT COLUMN1, COLUMN2 FROM DBASEFIL.dbf WHERE COLUMN3 = ''C''')EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 0;EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 0;GOsp_configure 'Ad Hoc Distributed Queries', 0reconfigureGOsp_configure 'show advanced options', 0reconfigure GOThu, 19 Apr 2012 09:46:59 GMTcARBONchttp://www.sqlservercentral.com/Forums/Topic1290825-2799-1.aspxHi.I have sharepoint 2010 installed and SQL Server 2012. With SQL 2012, if using reporting services in sharepoint integrated mode there is no longer a Reporting Services Service, instead it is fully integrated into sharepoint.This unfortunately leaves me with no idea how to enable kerberos for reporting services when using SSRS 2012 in Sharepoint integrated mode.Any info i can find is for SSRS 2008 and Sharepont, not SSRS 2012 and sharepont.Can anyone advise what needs to be done here to ensure im using kerberos?Thu, 26 Apr 2012 09:07:06 GMTwinston Smithhttp://www.sqlservercentral.com/Forums/Topic1292296-2799-1.aspxHi.I am working in a secured company which doesn't allow live internet connection, therefore I can't install SSDT using Web Platform Installer and we also don't want to install the intire 2012 client tools.Does any one has a solution for me?Thanks,Ran.Mon, 30 Apr 2012 01:51:07 GMTran.ovadiahttp://www.sqlservercentral.com/Forums/Topic1292621-2799-1.aspxI would like to link from a SQL 2008 instance to another server with SQL 2012 installed. Do I need to install the SQL 2012 Native Client on the server with SQL 2008 already installed or is there another way?Mon, 30 Apr 2012 09:51:49 GMTBarbWhttp://www.sqlservercentral.com/Forums/Topic1292274-2799-1.aspxHas anyone managed to get SSRS 2012 running using a managed service account? It works for both the SQL service and the SQL agent service, but no luck doing the same for SSRS. The doco here (http://msdn.microsoft.com/en-us/library/ms143504.aspx#Default_Accts) suggests that it should work.It's a native (ie non-Sharepoint) install of SSRS, and I'm changing the service account, rather than installing with the managed account, in case that makes any difference.Thanks!Mon, 30 Apr 2012 00:11:36 GMTJKG