Hot answers tagged

63

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 ...


24

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 /usr/share/postgresql/8.4/contrib/...


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

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, ...


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

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

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.


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

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

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 Links:...


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

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 ...


8

To answer your first question : If you are not sure, then just manually launch the setup.exe and verify. When you launch SQL Server 2008 installation using setup.exe, you will see: Below is for SQL Server 2008R2 : An alternative to running the setup executable, is to right click and look for the version there. It'll be something like 10, 10.50, 11,...


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

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

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

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

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

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 ...


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

Unfortunately, no. You are installing a program and making service and registry changes, etc. You need to run setup as an account that has local administrative rights. No workaround to this that wouldn't involve some back door into administrative rights. Best bet is to ask for someone to temporarily give you the rights or install it for you. Source: The ...


6

You can actually find out where your compiled binary is instructed to read options files. $ mysqld --help --verbose 110923 17:09:29 [Warning] Can't create test file /usr/local/mysql-5.6.2-m5-osx10.6-x86_64/data/laptop1113-2.lower-test 110923 17:09:29 [Warning] Can't create test file /usr/local/mysql-5.6.2-m5-osx10.6-x86_64/data/laptop1113-2.lower-test ...


6

Are you really trying to use Windows 8? No version of Oracle is supported on Windows 8 yet and, if history is any guide, I wouldn't expect any of them to work without patches that aren't available yet. Is Windows 8 even in public beta yet? I'd hate to try to take a class using an early beta operating system. Oracle 11.2 is supported on Windows 7 (which ...


6

I strongly recommend using Postgres.app from the Heroku team, which is also supported by them! It has a menubar icon and the menu has a psql item: You will also find psql included here if you want the same version of that as the server (path may vary by version): /Applications/Postgres.app/Contents/MacOS/bin If you want, you can add this path to your ...



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