Tag Info

New answers tagged

0

if you have administrator permission, after entering "sqlplus sys as sysdba" command press the enter. and press the Enter again for password will let you query the database ! and then you can change the password for sys from $ Tables. hope this help


0

If you start Firebird as an application, then Firebird must either be located in a normal folder (not a system folder under UAC protection like Program Files), or you need to run it as Administrator. The reason is that Firebird needs write access to several files in its own program folder, which doesn't work without privilege elevation. Better yet: run it ...


0

You can find Adam Bartoszewicz's instructions here on Google Groups (also published on Pavel Stehule's blog): Download and install PostgreSQL 9.3.4 for Win32 from http://www.enterprisedb.com Download and install Microsoft Visual C++ 2010 Express Lern tutorial http://blog.2ndquadrant.com/compiling-postgresql-extensions-visual-studio-windows The ...


1

I see no reason you can't do this. Typically, you would perform the following steps. Move the *.dbf files found in %ORACLE_BASE%\oradata\ to a safe place. Move the files found in %ORACLE_BASE%\fast_recovery_area\ to a safe place. Move the spfile found in %ORACLE_HOME%\database\spfileXE.ora to a safe place. Install a new Oracle instance and Configure it ...


1

There is an advantage to this that will become apparent once the system has been running for a while: you can have both instances running at different release levels. Imagine encountering a bug that is creating problems in one of your applications. There is a hotfix available, but you are not sure whether or not it will create a problem in your other ...


5

An instance, whether default or named, has its own set of program and data files, as well as a set of common files shared between all instances of SQL Server on the computer. For an instance of SQL Server that includes the Database Engine, Analysis Services, and Reporting Services, each component has a full set of data and executable files, ...


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


1

I was able to get guidance from the following MSDN link: Configure Windows Service Accounts and Permissions. The pertinent section (bookmarked in the link) is "File System Permissions Granted to SQL Server Per-service SIDs or Local Windows Groups". The short version for the solution is that either Read, Execute or Full Control are needed on the leaf-level ...



Top 50 recent answers are included