Tag Info

Hot answers tagged

40

UPDATE June 24, 2015 If you want the shiny new June 2015 release of Management Studio, which includes 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 independent from SQL Server, go here (and you can read about it here and here). If you ...


16

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


13

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


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

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

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


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

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


10

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


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

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


9

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


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.


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

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


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

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


7

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


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

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.


6

Windows Vista Service Pack 1 is actually not supported by SQL Server 2008 R2. In addition to my multiple suggestions to really clean 2008 R2 off your system (again see instructions here), I strongly recommend you install Service Pack 2 before trying again. If you're going to completely reinstall your OS, you might consider Windows 7 which has a longer ...


6

Its a two step process. In the installer select Maintenance/Edition Upgrade to upgrade your existing instance. Run the installer again and select Installation/...or add features to an existing installation/Add features to an existing instance.


6

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


6

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.


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

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

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


5

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



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