Questions tagged [sql-server]
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]...
773
questions
75
votes
2
answers
223k
views
Where is SQL Configuration Manager in Windows 10?
I just have upgraded to Windows 10. I can't find SQL Server Configuration Manager. I have MSSQL 2008 and 2014 installed but there is no configuration manager in "All Apps".
This is just a picture of ...
45
votes
1
answer
14k
views
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 ...
38
votes
12
answers
246k
views
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.
33
votes
2
answers
143k
views
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 ...
29
votes
7
answers
110k
views
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 ...
23
votes
16
answers
109k
views
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 ...
23
votes
2
answers
69k
views
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?
22
votes
8
answers
79k
views
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 ...
20
votes
2
answers
88k
views
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 ...
18
votes
8
answers
33k
views
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 ...
18
votes
3
answers
12k
views
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'...
18
votes
2
answers
50k
views
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 ...
17
votes
7
answers
35k
views
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 ...
16
votes
1
answer
6k
views
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 ...
15
votes
1
answer
250k
views
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) ...