Tag with [sql-server] the question related to each database server that implements SQL (Structured Query Language) and not related with the specific Microsoft one. For the latter use the specific tag [ms-sql], or if related with a specific version with the relative tag [sql-server-2012], [sql-server-2008]...
Questions tagged [sql-server]
785 questions
77
votes
2 answers
Where is SQL Server Configuration Manager in Windows 10?
I just have upgraded to Windows 10 and I can't find SQL Server Configuration Manager.
I have MSSQL 2008 and 2014 installed, but there is no SQL Server Configuration Manager in "All Apps" in the Start Menu.
Below is a picture of how I used to find it…
malakrsnaslava
- 2,893
45
votes
1 answer
SQL Server Management Studio graphical glitches
I had installed SQL Server Management Studio 2014 and 2016 and the 2016 version had a strange behaviour. I uninstalled it and installed 2017, but it had the same behaviour. What happens is that some icons disappear when I do a mouse over and then…
38
votes
12 answers
How do I open SQL Server Management Studio?
How do I open SQL Server Management Studio?
I installed it but I don't see where I can open it.
Alex Gordon
- 743
36
votes
2 answers
What is "NT AUTHORITY" and "NT SERVICE"
I can find many info on what is "NT AUTHORITY" slash "something". Same for "NT SERVICE". But not for the part before the slash. I run into them from time to time in my work. I might receive documentation with, e.g. Domain Admins, which sometimes…
ZygD
- 2,577
29
votes
7 answers
Move database from SQL Server 2012 to 2008
I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server.
The 2008 server cannot restore backups created by a 2012 server (I have tried).
I cannot find any options in 2012 to create a 2008 compatible backup. Am I…
Rich
- 274
23
votes
16 answers
Why does it take so long for SQL Management Studio to connect?
Considering that Microsoft SQL Server is not, technically, a slow database management system, I keep wondering why it often/usually takes such a long time for SQL Management Studio to connect.
This happens even when nobody else is accessing the…
Andrew J. Brehm
- 5,342
23
votes
2 answers
How to: Database Model in Visio 2013
I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
Shaz
- 651
22
votes
8 answers
Rule "Restart computer" failed when installing SQL Server 2008
When trying to install SQL Server 2008 Developer and Enterprise editions on a Windows 7 box I've got this message:
Rule "Restart computer" failed.
A computer restart is required. You must restart this computer before installing SQL Server.
Of…
Pablo Fernandez
- 11,649
20
votes
2 answers
How to install SQL Server 2016 on Windows 7
I know it's clearly stated in System Requirements that Windows 7 is not supported. But I'm sure that these limitations are artificial to force users to buy newer versions of Windows. And also as I suppose there is no serious changes in system core.…
19
votes
3 answers
Does a Window 10 license allow using it as a Web server?
I am looking to set up a Web server for a project.
The server would be using a custom application developed in VB.Net using SQL Server for data storage. The application uses 3rd party components (DLL's) that are available for Windows only.
In a…
Hussain Akbar
- 313
18
votes
8 answers
SQL management studio hangs when opening after being closed down on dual screen
I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014.
If I drag the management studio screen across to my 2nd display, and then close it down, when I open it again, it opens on the…
user218317
18
votes
2 answers
Why Can't SQL Server Management Studio Access The "My Documents" Folder in Windows 7?
I have a database backup located in my Windows 7 Documents folder (C:\Users\Aaron\Documents...), and I'm trying to restore it using SQL Server Management Studio. However, the program is unable to access anything within the Users\Aaron directory…
AaronSieb
- 343
17
votes
7 answers
Cannot find one or more components. Please reinstall application
I am running Windows 8, 64 bit and have SQL Server 2012 installed. I downloaded the client tools, looked in the directory for SQL Server Management Studio, and see it's there. When I try to run SQL Management Studio I receive the error message: …
Chris
- 181
16
votes
1 answer
Do I need SQL Server paths in my PATH environment variable for it to work?
SQL Server adds things to my PATH environment variable, and over time that bloat makes me hit the 2048-char limit in Windows 7. Do I really need them there for SQL Server to run? This is on a development machine so I want to have several versions…
Rory
- 2,200
15
votes
1 answer
Default SA password of SQL Server automatically installed by SharePoint Server 2010 setup
I installed SharePoint server 2010 recently on a test server. It was installed in standalone mode.
After the installation, I realized that it had installed SQL Server Express 2008 (10.0.2531.0) automatically as well.
I need to know the password for…
thilina R
- 2,973
- 5
- 28
- 36