Tag Info

New answers tagged

0

I have a similar problem, the error "The procedure entry point RpcImpersonateClientContainer could not be located in the dynamic link library RPCRT4.dll" is shown when starting some programs (for instance KeePass.exe a password store program). The only point in common with your problem is that I also upgraded from Windows 7 64bit to Windows 10 but the ...


5

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


1

Just to add on, the removal of BUILTIN\Administrators and NT AUTHORITY\SYSTEM from being default sysadmin was for the change in security with Microsoft products; going to the secure by default methodology. I am sure some portion of compliance had influence in Microsoft and SQL Server team choosing to do this as well. Which actually, the main one that ...


4

You're right: system administrators can gain sysadmin access, but you will find entries in the default trace for that action. Moreover, it requires restarting the service at least twice, which would hardly go unnoticed. Not granting sysadmin privileges to BUILTIN\Administrators is a change introduced in SQL Server 2008. In my opinion it's a good idea: it ...


2

Using the local administrators group has been the default for a long time. But mainly in large enterprise environments you have an operations team for windows and a seperate operations team for SQL Server. Allowing everone to easily(!) gain access can be considered as security problem. Allowing only the current user can be explained with "secure by default". ...


0

Read and follow the instructions. a is not a valid directory path. Based on your screenshot, it should be C:\Users\Ashish Jain\Desktop\global-11g-schema-1-128202.


1

I installed SQL Server Developer Edition (x64) instead, and in the end it worked! I have successfully setup this edition. Actually, the key point is the part of Feature Selection. If you click Select All option at Feature Selection, this installation will probably fail. At least, it has failed for me (using a Client OS). Instead of this, you should ...


2

You are installing SQL Server 2014 Enterprise Edition on Windows 10 (a client OS), which is not supported. If you were to take this case to Microsoft they would say you are trying an unsupported scenario. Although your installation won't fail as such if you are trying to install Enterprise Edition on a client OS, what is the point in wasting such a costly ...


2

Uninstall the Visual Studio 2010 Shell, this was done by downloading the installer. Once downloaded, run the installer and remove the VS2010 Shell component. Once done, run the SQL 2014 Management Studio installer or do a repair on your existing installation, this will itself reinstall the VS2010 Shell components. Then it opened for me.


1

The problem is solved after changing the location for datafile in 'install_olaptrain.sql', and changing the 'ho impdp' statement to the given below string resolves any login error in Oracle 12c: ho impdp olaptrain/manager@//localhost:1521/my_pdb dumpfile=OLAPTRAIN12232009.DMP directory=OLAPTRAIN_INSTALL But then "ORA-06512: at "SYS.UTL_FILE", line 536" ...


1

You can use this link to download latest SSMS separately. At the time of writing, this is SQL Server Management Studio July 2015 preview.


0

First, search the installation log. In my instance it was under the following path: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\*.* In that log I found the following entries: 2015-08-07 11:16:50 Slp: Sco: Attempting to open registry subkey 2015-08-07 11:16:50 Slp: Sco: Attempting to open registry subkey ...


0

There was a great reply to this question posted on Bret Ozars site in his article. "Why Nobody ever patches their sql Servers". http://www.brentozar.com/archive/2015/08/why-nobody-ever-patches-their-sql-servers/



Top 50 recent answers are included