Hot answers tagged

60

If you want the shiny new 2016 monthly releases of Management Studio, which include a handy check for updates mechanism, negates the need for a full setup program and download (since it only retrieves the components you need), as well as a release cycle completely independent from SQL Server, go here (and you can read about it here and here). If you use ...


23

Locate the psql binary. (In a terminal, run locate psql | grep /bin, and make note of the path. (In my case, it's /opt/local/lib/postgresql90/bin/, as it was installed using MacPorts.) Then, edit the .bash_profile file in your home folder (e.g. mate -w ~/.bash_profile assuming you've textmate), and add the needed line so it's in your path, e.g.: export ...


14

It's an external module for Postgres. You should install the postgresql-contrib-8.4 (or your pg version) package via apt: apt-get install postgresql-contrib-8.4 Then you find the sql install file somewhere in the /usr/share/postgresql folder, and you'll need to run pgcryto.sql on the database. psql -d <database> -f ...


13

I had a similar isssue - Win7SP1, VS2010SP1, SQL2008R2, Powershell 2 etc. Every prerequisite was there and still SQL Server 2012 Developers edition did not install. Completing with the following error message for most of the features: Feature: Database Engine Services Status: Failed: see logs for details ...


12

Note that I'm working on Ubuntu 12.04, which uses postgresql 9.1. There, I needed to: sudo apt-get install postgresql-contrib And then in my database: postgres@ztrustee:~$ psql test psql (9.1.3) Type "help" for help. test=# CREATE EXTENSION pgcrypto; CREATE EXTENSION And now I can use pgcrypto functionality, gen_random_bytes(): test=# create table ...


12

Yes SQl server installation is likely to fail if you are trying to install it on root of a drive which is never advisable and has security implications. Actually it is related to permission setting on specific folders. As per this connect item Based on further investigation this issue is due to the fact that SQL tightens the ACL for default data/log ...


11

The cool way is to use an unattended installation script that simply is called from each server, where the media for the installation is on a central directory on your network, that is accessible from each server. You will have to run the script in an elevated mode, which this is fairly easy in PowerShell. You will need to use the CLI to extract the hotfix, ...


11

I knew I had faced this before and managed to figure it out, so I searched my drives and found a batch file I had written last time. For anyone else who experiences this issue, what you need to do is to run the server daemon with the --bootstrap parameters. Here is the script I used to dump all the databases out to an SQL file and re-import them (that is, ...


11

No, no and again no. One instance, one server, Always. The reasons have to do with the SQL Server memory manager and CPU scheduler architecture, it really works best if it has the whole box to itself and nothing else runs on the box. 'Partitioning' of resources (max server memory, affinity mask) solves some problems and introduces more. If you want to ...


11

Install the additional module btree_gist as is mentioned in the manual at the location you linked to: You can use the btree_gist extension to define exclusion constraints on plain scalar data types, which can then be combined with range exclusions for maximum flexibility. For example, after btree_gist is installed, the following constraint will ...


10

Two solutions: Install oracle manually the first time. Then zip all ORACLE_HOME and for future installation simply do: Unzip oracle_home into the new home Run $ORACLE_HOME/bin/relink all Run ./runInstaller -silent -attachHome ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Oracle_Home_Name>" Other solution (not my preferred but ...


10

You will select "Microsoft SQL Server 2012 (64-bit)" Upon loading of the setup wizard, you will select the instance for SQL Server 2012. The next screen you check the shared component you want to remove.


10

If the correct auditing is turned on, and the security event log hasn't rolled over it'll be in there. Failing that it may not be. You could look at NTFS file permissions and ownership, and what accounts have sysadmin rights and possibly figure it out.


9

Integration Services is not "Instance aware". The rest (Analysis, Reporting, DB) are. Note that SSIS doesn't need to be instance aware either. The service itself is pretty pointless and doesn't need to running. You simply need the SQL Server common binaries installed to run packages. The service is for SQL Server Agent and SSMS to browse packages etc ...


9

From BOL: During installation of SQL Server 2012, Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade SQL Server, verify that you have at least 6.0 GB of available disk space on the system drive for these files. This requirement applies even if you install SQL Server components to a non-default drive. ...


9

You can download and install SQL Server Management Studio using the links provided in: Scott Hanselman's website There are links to various SSMS versions (2012, 2014, for x86, x64), as well as links to various SQL-Server Express versions. By the way, you can also use the latest SSMS 2014 to manage your 2012 database.


9

Yes, just separate the rules with a space, for example: /SkipRules=PerfMonCounterNotCorruptedCheck FacetPowerShellCheck While SkipRules is undocumented, the list of rules is documented at: Edition Upgrade Rules Even more information at: SQL 2012 Setup Rules – The 'Missing Reference'


8

This part is unusual: ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe/ This needs to be char-by-char identical every time. I see it ends with a slash here, which is non-standard, and I suspect that you've added it by mistake. Adding a slash will result in "ORACLE not available" in so-called bequeath sqlplus, I've just experimented on my system. Try again ...


7

Can I have this 32 bit installation use more memory using locked pages? In the past, my answer would have been (a heavily qualified) "yes". Using AWE (address windowing extensions) would enable up to 64GB memory. Unfortunately (from your point of view, perhaps) 32-bit AWE was removed from the database engine starting with SQL Server 2012. In previous ...


7

As stated in BOL here: Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of SQL Server to native 64-bit using SQL Server Setup. However, you can back up or detach databases from a 32-bit instance of SQL Server, and then restore or attach them to a new instance of SQL Server (64-bit) if the databases are not published in ...


7

Following up on my comment, you have to select ENU\x64\SQLEXPRADV_x64_ENU.exe for installation. Download link. Then run the installation package and follow instruction until you get feature selection page. Follow rest of the steps and complete the installation. Now Verify the RS installation : Note: You must be logged in as a member of the local ...


7

Most likely /etc/my.cnf or /etc/mysql/my.cnf. Also check /home/username/my.cnf and /home/username/.mysql/my.cnf If no luck there you can run find / -type f -name my.cnf That will scan you're entire disk where non priviledged access is allowed (which is fine; it should find it, i'm assuming your distro came with it and you're able to connect or you ...


7

Indeed this setup is possible. When the developers open Sql Server Management Studio, instead of connecting to a locally installed instance (not necessary given your requested setup, but I would still install it) then they would connect to the shared instance on the development server. That is how our shop is setup.


7

This answer applies to modifying the PostgreSQL source code by applying a "diff" or "patch". It's not about installing minor version updates; to do that, just download and run the installer. To alter the PostgreSQL server its self or its procedural language runtimes, you will generally need to recompile PostgreSQL from scratch. On Windows that's a bit of ...


6

Actually Sql server has two types of component\features. 1. Instance specific features 2. Shared Features And Database Engine, Analysis Services, and Reporting Services are part of instance specific features which has to copy many files for installing new instance. http://msdn.microsoft.com/en-us/library/ms143786.aspx


6

A simple and complete solution to error ' Could not find database engine startup handle' in below link Reason for the error can be 1.The account which user selected on Server Configuration page window ( during installation) is somehow not able to bring SQL Server database engine services online. Either is lacks privilege or it is corrupted. During ...


6

Kendra Little did a great article on this: http://www.brentozar.com/archive/2014/08/sql-server-edition-change-standard-edition-enterprise-evaluation/ Microsoft article on supported upgrade paths: http://msdn.microsoft.com/en-us/library/ms143393.aspx First, note that not all downgrade scenarios are supported (You didn't provide the exact version you are ...


6

Have you looked under Advanced Security Settings? The arrows point to the modifications I've often had to specifically apply when installing SQL Server on Windows 2012 R2. For the SQL Server Root Directory, I'll give full control to the SQL Server Process account. Related official documentation: Configure File System Permissions for Database Engine ...


6

Your title says you have an installation problem, but I don't think this is the case (it seems like you have installed SQL Server okay, you just can't find it). Of course I don't know exactly what options you selected during setup, but from the programs applet, it seems like you should have at least one instance installed. The Browse for Servers dialog is ...


6

Absolutely possible. Developer Edition is identical to Enterprise Edition with the exception of its licensing. Be sure to review the licensing information to ensure your intended use matches the allowed use.



Only top voted, non community-wiki answers of a minimum length are eligible