108

In later versions of SQL Server, the configuration manager is implemented as an MMC plugin. There are two ways of accessing this: Navigate to c:\windows\system32 and look for a file with the name SQLServerManagernn.msc, where nn is the version of SQL Server you have installed. For SQLServer 2014, the name is SQLServerManager12.msc. You can double-click on ...


85

I would recommend you try turning off hardware acceleration to help rule out driver issues. If you go to Tools -> Options... then in the General section there is a Visual Experience section. Please untick all three boxes and see if it makes a difference.


31

I have found the answer on the server fault site: https://serverfault.com/a/491235/171795 Unfortunately I can't vote the guy up (https://serverfault.com/users/166318/eirik-toft) as I don't have any reputation on that site (or this site that my question got migrated too) However, I thought I would leave this answer here as a signpost to his answer. To work ...


25

Here are the steps I did to fix this: Login to the SQL Server using a local account which has administrative privileges account (eg: .\Administrator) Once you have logged into Windows, open SQL Management Studio Connect to the SharePoint SQL instance using Windows Authentication Enable Mixed Mode Authentication (this is not enabled by default for the ...


25

On Windows 10 Pro, the number of connected devices is limited to 20. The Windows 10 license states: Device connections. You may allow up to 20 other devices to access the software installed on the licensed device for the purpose of using the following software features: file services, print services, Internet information services, and Internet connection ...


18

If you're willing to play a little fast and loose with the definitions, NT_AUTHORITY essentially refers to the Windows operating system itself. Or perhaps as "things the OS authorizes on your behalf." (At first, NT meant New Technology, a version of the OS generally meant for businesses. It contrasted with the less strict, less secure Windows 9.x kernels ...


17

I found more information here: "To give your SQL Server account access to this folder, we first have to verify the account used to login to SQL Server. Open SQL Server Configuration Manager and navigate to SQL Server Services. Right-click SQL Server (MSSQLSERVER) and select properties. On the Log On tab, you should see where the account to login as is ...


17

check this microsoft doc page for sql server configuration manager. snippet (May 2021): SQL Server 2019 C:\Windows\SysWOW64\SQLServerManager15.msc SQL Server 2017 C:\Windows\SysWOW64\SQLServerManager14.msc SQL Server 2016 C:\Windows\SysWOW64\SQLServerManager13.msc SQL Server 2014 C:\Windows\SysWOW64\SQLServerManager12.msc SQL Server 2012 ...


17

It appears the requirements for SQL 2016 you need windows 8 or greater. The reason may be because windows 7 is on extended support. This means that if you are not on service pack 1 it's already not supported by Microsoft. For more detail on the requirements: https://msdn.microsoft.com/en-GB/library/ms143506.aspx#hwswr You also need to look at if your OS ...


16

Maybe you uninstalled Visual Studio 2010? Try installing the isolated package: Microsoft Visual Studio 2010 Shell (Isolated) Redistributable Package


16

Solved it by right clicking the shortcut -> Properties -> selected Compatibility -> Change settings for all users -> Run this program as an Administrator - and then made sure that the account that I wanted to use as "Run as" account are in the local administrators group.


12

For SQL migrations, use the free and open source SQL Database Migration Wizard. I had a 5GB database with couple ~10 million records and tried the route via Generate Script and than ran it with sqlcmd.exe. First of all, the generated script was not always working correct. Secondly, sqlcmd.exe can fail on large files too, complaining about available memory. ...


11

So I finally figured it out. Here are my steps. Open a new Excel worksheet (I'm using Excel 2010) Click on the Data tab on the ribbon Click the dop down on "From other sources" Select "From Microsoft Query" Select your datasource Pick any table to populate the Columns in your query box - this doesn't matter as we'll override it later - and click Next Keep ...


11

.Net Framework should be built into Windows 10 already and you can enable it from control panel. Do the following to enable .Net Framework on your Windows 10 Press Windows + R keys on the keyboard. Type “appwiz.cpl” in the “Run” command box and press “ENTER”. In the “Programs and Features” window, click on the link “Turn Windows features on or off”. Check ...


11

I couldn't find any users through the UI but I was able to add a login like this: create login [AzureAD\FirstLast] from windows;


10

There is absolute no need to reinstall SSMS or VS. Just find the VS shell installer in the folder, where SSMS installer unpacks its files: 1033_ENU_LP\redist\VisualStudioShell\VSSetup and install it.


10

You need to add the user with his/her required roles and permissions: In the SQL Server Management Studio, open Object Explorer Click Server_instance_name > Security > Logins Right-click Logins and select New Login On the General page, in the Login name field, type the name of a Windows user Select Windows authentication Depending on the role and ...


9

A more technical explanation: In Windows ACLs (access-control lists), permissions are applied to trustees - users, groups, or other security principals. The trustees are uniquely identified by SIDs, which are strings starting with S-1- and can be formatted as human-readable strings such as NT AUTHORITY\SYSTEM for S-1-5-18. Whoever came up with this design ...


8

Yahooo!! I fixed it! I found this link and at the very bottom "Wael" wrote the following: SSMS Depends on Visual Studio 2010 IDE, which if not installed the SQL Server Setup will do, but if any version is present, the setup will ignore it, even at repair Re Install, I figured that the SSMS needs Visual Studio 10 IDE to run, which I've removed ...


8

If you just want the database runtime for development you can install Visual Studio 2015 or 2017 and SQL Server data tools, which includes LocalDb, a development runtime version of the engine.


7

I've tried SkipRules option from another answer with SQL Server Express 2014: run SQLEXPRWT_x86_ENU.exe just to extract files then close it cd SQLEXPRWT_x86_ENU setup.exe /ACTION=INSTALL /X86 /SkipRules=RebootRequiredCheck Then the setup process didn't complain on "Reboot required" rule but still failed at the end with the following messages: A previous ...


7

To change it back enter for the field This account: NT AUTHORITY\NetworkService, then clear the password (suggested with dots) and select OK. Now you can start the service again.


7

The SQLEXPR32_x86_ENU.exe is 32 bit only. This is done to reduce the package size for ease of distribution. This means that the package can only be installed on 32 bit systems. The SQLEXPR_x86_ENU.exe is compatible with both 32 and 64 bit systems, but is still the 32 bit version of SQL Server. The SQLEXPR_x64_ENU.exe is compatible only with 64 bit systems....


7

This is a school example of obsolete statistics - a query runs well and then, without any obvious reasons, becomes very slow. SQL Server statistics become inaccurate when databases are in use and many transactions occur. The problem troubleshooting starts with analyzing the slow query. If the difference between the estimated and actual number of rows in a ...


7

This is an access denied error. It means the user performing the installation doesn't have the necessary rights. Several users have found success creating a new user, configuring them as a local administrator, and then running the installation logged in as this user. More Info: http://geekswithblogs.net/vitus/archive/2009/09/26/workaround-for-sql-2008-...


7

Creating a SQL Server Compact Edition database file in Microsoft Visual Studio 2017 Microsoft is dropping support for SDF files with Visual Studio It appears Microsoft deprecated SQL Server Compact and it's suggested to use SQL Server Express moving forward instead. The file extension for SQL Server Compact DB data files is SDF so just plan to the use SQL ...


7

Open up services and find the following entries: SQL Server Browser SQL Server (WINTEN) Go into their properties and make a note of the paths to the executables. In Windows Firewall with Advanced Security create 4 new inbound rules which allow the connection both these programs for TCP and UDP. I normally do this via the standard Windows Firewall (...


6

like stated in http://blogs.msdn.com/b/hansr/archive/2006/02/17/patchreboot.aspx there is also an important key from windowsupdate HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\RebootRequired this must also be 0 or not present.


6

What a gratuitous P.I.T.A ! I was able to make it work by using the "Data Connection Wizard" following these steps.... Select "Other/Advanced" from Data connection Wizard, then hit "next". I thought that localDB as created by sqlserver express would go as "SQL Server". Apparently not! though I can't fathom why. Select "SQL Server Native Client 11.0" as ...


6

In fact, you do not need all the environment variables for each the instance SQL Server. And well, if you check the environment variables needed to install and run queries or tasks. However, the problem can be solved directly. SET App32=c:\Program Files (x86)\ SET App64=c:\Program Files\ SET SQL32=%App32%Microsoft SQL Server\ SET SQL64=%App64%Microsoft ...


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