SqlServerKudos - Stories tagged with Installation

Installation

atom rss
1
kudos
spam Kudos Remove

Guidance on installation to a multi-server PowerPivot for SharePoint farm.
published 55 days, 14 hours, 34 minutes ago posted by sasa 65 days, 11 hours, 50 minutes ago
Friday, July 16, 2010 2:17:41 PM GMT Tuesday, July 06, 2010 5:01:26 PM GMT
Guidance on installation to a multi-server PowerPivot for SharePoint farm.
SQL Server 2008 R2 has opened gates for endless opportunities for Organisations & Developers to take advantage of newest technologies. I'm getting to know these new features such as PowerPivot Features , the technical documentation refers that PowerPivot workbooks are like Excel workbook (.xslx) files that contain large, related datasets that you build in a separate PowerPivot window in Excel, and use with PivotTables and PivotCharts in a worksheet. This add-in can be downloaded from MS download...(read ... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Best Practices, configuration, cpu, Installation, Memory, multiple, powerpivot, resources, server, SharePoint, SQL Server
1
kudos
spam Kudos Remove

SQL server 2008 R2 setup - feature installation, side-by-side support with previous versions
published 60 days, 14 hours, 54 minutes ago posted by sasa 69 days, 15 hours, 25 minutes ago
Sunday, July 11, 2010 1:56:55 PM GMT Friday, July 02, 2010 1:26:41 PM GMT
SQL server 2008 R2 setup - feature installation, side-by-side support with previous versions
Here is a setup based question raised in my recent SASSUG usergroup meeting when specifying about slipstream installation during the installation of SQL Server 2008 R2. Once you click on Setup application and pass through the screens with default & input values until the point you reach SQL Server 2008 R2 setup - Setup Role screen. You will be presented with 3 options (see screenshot below): SQL Server Feature Installation - where you pick and choose to install SQL Server Database Engine services...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: .net framework, compatability, Installation, pre-requisite, r2, side-by-side, slipstream, SQL Server, Version, windows installer
1
kudos
spam Kudos Remove

SQL Server 2008 R2 setup error: SQLEngine: --SqlServerServiceSCM: Starting SQL via SCM (-mSqlSetup ………)
published 89 days, 17 hours, 6 minutes ago posted by sasa 98 days, 19 hours, 27 minutes ago
Saturday, June 12, 2010 11:45:32 AM GMT Thursday, June 03, 2010 9:24:39 AM GMT
SQL Server 2008 R2 setup error: SQLEngine: --SqlServerServiceSCM: Starting SQL via SCM (-mSqlSetup ………)
A bit of background on the installation setup of SQL Server 2008 (SP1) release onwards, that you need slipstream the installation. This is nothing but you could just install the SQL 2008 + Service Pack release as one time, which is a time-saving mechanism. Peter Saddow from SQL Server development team has shown example from the blog about how it looks when you install (see below): Coming back to the subject line I was presented with the error when trying to perform a slipstream installation of SQL...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: download, Installation, integration services, package, slipstream, SQL Server, SQL Server 2008
1
kudos
spam Kudos Remove

SQL Server Setup Portal - a preview and planning of what you are about to setup?
published 103 days, 18 hours, 7 minutes ago posted by sasa 111 days, 20 hours, 26 minutes ago
Saturday, May 29, 2010 10:43:47 AM GMT Friday, May 21, 2010 8:25:27 AM GMT
SQL Server Setup Portal - a preview and planning of what you are about to setup?
There is a myth (rather a wrong impression) in database world that SQL Server setup is pretty easy, what you do is insert setup-media into drive and click next....next.....next, well it is not!!! Here is the opportunity to see the SQL Server 2008 R2 setup process, along with prepare & install/upgrade. There needs lot of consideration such as installation pre-requisites, features/editions, security considerations etc. and also the upgrade advisor, very useful tool to simulate the upgrade process...(read m... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: best practice, DBA, Installation, Process, setup, SQL Server, SQL Server 2008 R2, step by step, upgrade advisor
1
kudos
spam Kudos Remove

SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download
published 119 days, 19 hours, 19 minutes ago posted by sasa 128 days, 21 hours, 46 minutes ago
Thursday, May 13, 2010 9:31:46 AM GMT Tuesday, May 04, 2010 7:05:02 AM GMT
SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download
IN contintuation to SQL Server 2008 R2 announcement here is the good news for MSDN & Technet subscribers, see SQL Server 2008 R2 is now available to MSDN and TechNet subscribers go to your relevant subscriptions to download. Don't forget to uninstall the previous & current SQL Server 2008 R2 CTP releases (by taking database backups) and install afresh for further testing. Good luck.... more to come on R2 here!...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: backups, best practice, Blocking, database, Installation, r2, SQL Server
1
kudos
spam Kudos Remove

SQL Server 2008 R2 CTP Whats new - MDM: Master Data Management
published 255 days, 7 hours, 23 minutes ago posted by sasa 264 days, 19 hours, 34 minutes ago
Monday, December 28, 2009 9:27:47 PM GMT Saturday, December 19, 2009 9:17:41 AM GMT
SQL Server 2008 R2 CTP Whats new - MDM: Master Data Management
Master Data Services is a new feature that is evolving within SQL Server, that consists new changes within R2 (CTP) edition which helps enterprises standardize the data people rely on to make critical business decisions. As per the Microsoft documentation it offers: Master data hub that provides central management of master data entities and hierarchies Thin-client stewardship portal that provides secure, role-based Web access to master data Versioning of all data entities and hierarchies Human workflow.... (more)
category: News | clicked: 2 | comment | | source: sqlserver-qa.net
tags: buffer, configuration server, ctp, Deploy, Installation, Master Data Management, master data services, MDS, new features, SQL Server
1
kudos
spam Kudos Remove

SQL Server Installation issues Rule "Long path names to files on SQL Server Installation media" failed
published 257 days, 7 hours, 33 minutes ago posted by sasa 266 days, 19 hours, 43 minutes ago
Saturday, December 26, 2009 9:17:54 PM GMT Thursday, December 17, 2009 9:07:47 AM GMT
SQL Server Installation issues Rule "Long path names to files on SQL Server Installation media" failed
Whenever you plan or proceed for a SQL Server installation, it requires the following steps: Review installation requirements, installation options, system configuration checks, and security considerations. Run SQL Server Setup to install, upgrade, or migrate to SQL Server. Use SQL Server utilities to configure SQL Server. The above process & procedures are followed regardless of whether you chose to use SQL2008 Installation wizard or install from command prompt. Coming on when you choose from...(read more) (more)
category: News | clicked: 2 | comment | | source: sqlserver-qa.net
tags: best practice, check, description, directory, disk, Installation, path, rules, Security, setup, SQL Server
1
kudos
spam Kudos Remove

Pause the passive node to apply SQL2005 Service Pack or hotfix
published 325 days, 13 hours, 29 minutes ago posted by sasa 335 days, 8 hours, 35 minutes ago
Monday, October 19, 2009 3:22:40 PM GMT Friday, October 09, 2009 8:16:42 PM GMT
Pause the passive node to apply SQL2005 Service Pack or hotfix
With SQL Server 2005, Microsoft tried to be helpful in enabling its installer to apply the service pack or hotfix automatically on the passive node(s) in a cluster. In my own experience, this has not worked out too well. Very often, when the installer flagged the upgrade status of the service pack ot the hotfix as failure next to Database Service, the information I found in the log file was that attempt to patch the passive node had failed. You could scour the log files, google the internet, and/or open... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: Cluster, Installation, SQL Server 2005
1
kudos
spam Kudos Remove

SQL Client config, 32 and 64 bit
published 354 days, 15 hours, 29 minutes ago posted by sasa 364 days, 8 hours, 9 minutes ago
Sunday, September 20, 2009 1:21:58 PM GMT Thursday, September 10, 2009 8:42:20 PM GMT
SQL Client config, 32 and 64 bit
Say you want to change the preferred netlib connection order. Or add a server alias. You can do this using the "SQL Server Configuration Manager" program. But installing this on each client machine where you want to do the modification might not feel that attractive. Another option is to use a tool like regmon while doing the config on a reference machine, sniff the registry modifications and then shoot these out to the client machines. This might be overkill, though. Yet another option is to use the... (more)
category: News | clicked: 2 | comment | | source: sqlblog.com
tags: Installation, Troubleshooting