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]...
775
questions
74
votes
2
answers
222k
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 ...
- 2,813
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
245k
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.
- 733
33
votes
2
answers
142k
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 ...
- 2,487
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 ...
- 274
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 ...
- 5,252
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?
- 651
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
87k
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
32k
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 ...
user218317
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'...
- 303
18
votes
2
answers
49k
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 ...
- 343
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 ...
- 181
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 ...
- 2,100
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) ...
- 2,953
14
votes
2
answers
83k
views
Network Service Account password
In order to debug a SQL Server 2008 stored procedure, I would like to change the account that the SQL Server (MSSQLSrver) service is running under, namely, changing the account from "Network Service" ...
- 2,254
13
votes
5
answers
42k
views
Clean reinstall SQL Server Management Studio
I am on Windows 8.1, Professional edition. I installed SQL Server Management Studio 2012 x64 and everything worked well. I installed Visual Studio 2013 and everything worked well.
Then, I installed ...
- 421
13
votes
4
answers
42k
views
Which ports to open for Microsoft SQL Server?
Having searched the internet a few times on the best way to open up SQL Server connectivity through windows firewall i've yet to find a best way of doing it. Does anyone have a guaranteed way of ...
- 243
13
votes
3
answers
10k
views
SQL management doesn't run as different user after Win10 Anniversery update
Last night I updated Windows with the 10 anniversary update and now I am experiencing the following issue;
I right click on the SQL Management Studio 2016 and chose "Run as a different user" - after ...
- 391
12
votes
1
answer
5k
views
How do I add an AzureAD user to SQL Server for windows authentication
When users are logging in to a Windows 10 desktop with an Azure Active Directory account how do I add them as a user to SQL Server? Using the Search dialog from the Add Login dialog doesn't seem to ...
- 2,100
12
votes
1
answer
49k
views
Why don't I have SQL Profiler on SQL Server Management Studio?
I'm running SQL Server Management Studio 2008 (Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 ))
However I cannot find the option to open SQL Profiler.
I was ...
- 546
12
votes
3
answers
7k
views
Is gradually growing swap usage an indicator for a memory leak?
I’m trying to understand whether I have a memory leak on my server (Windows Server 2012R2). The server has 48 GB RAM and was designed to run only a DBMS (a SQL Server 2014) but there are also other ...
- 121
12
votes
1
answer
38k
views
How to remove Crash Dump Files under Windows 7
My Windows 7 hard drive suddenly filled up today. After doing some research, I downloaded and ran WinDirStat. This identified that 29% of my hard drive was occupied by Crash Dump Files (*.mdmp). I ...
- 305
11
votes
2
answers
3k
views
preserving \n from SQL Server Management Studio
I have a column called EventLog varchar(max) and can be pretty big because essentially it stores the event log of an entire batch process.
The problem is that when I go into the query window and do ...
- 3,606
11
votes
1
answer
26k
views
When will SSDT-BI be available for Visual Studio 2015
From Microsoft's download page, SSDT-BI (SQL Server Data Tools Business Intelligence) for Visual Studio 2013 is available but not for 2015. When will Microsoft release SSDT-BI for VS 2015?
https://...
- 1,305
10
votes
4
answers
14k
views
MS Access vs MS SQL Server
These are two offerings from Microsoft - MS Access and MS SQL Server.
What type of users/uses is Access meant for? Apart from the degree of usage (in terms of number of users), are these two products ...
- 804
10
votes
2
answers
60k
views
Is it safe to uninstall MS SQL server from my PC?
My OS is Windows 7. When cleaning unnecessary sofrware from my computer I noticed that I have lots of SQL related programs installed. I don't know with what program thet came, I don't do anything SQL ...
- 1,197
9
votes
2
answers
14k
views
Disable SQL Server at windows startup (VS 2010)
After I installed Windows 7, booting lasted for about 40 seconds. Then I installed VS2010 and booting is 20 seconds longer. In task manager I see SQL Server process running. Is there a way to disable ...
- 277
9
votes
1
answer
26k
views
Additional User Account, Windows Authentication in SQL Server Management Studio
I am transitioning my work laptop to a coworker (who we'll call Mary Smith) who is taking my place on my team as I move on to other things. One of the tools we use is Microsoft SQL Server Management ...
- 213
8
votes
3
answers
15k
views
Windows 10 .NET 3.5 installation
I'm on build 9841 of Windows 10. I downloaded .NET 3.5 SP 1 full. I double click the installer but nothing happens. Is that .NET version not compatible with Windows 10? I need it to install SQL Server ...
8
votes
3
answers
74k
views
How to remove a broken installation of SQL Server 2008?
After installing the Service Pack 2 of Microsoft SQL Server 2008, the SQL Server failed to start. Trying to repair this, I've done some stupid things, which results now in the situation in which I ...
- 1,826
8
votes
2
answers
15k
views
Creating a SQL Server Compact Edition database file in Microsoft Visual Studio 2017
I'm following a tutorial for using C# in Microsoft Visual Studio 2017 Community edition. I'm supposed to add a new SQL Database to my project and give it the extension .sdf.
In the tutorial they ...
- 233
8
votes
2
answers
18k
views
Excel: How to connect to a sqlserver localDB
I have created a LocalDB that I can work with in MS sqlserver management studio 2014, linqpad, and visual studio 2013.
Here is the part of the "connection property" dialog in SSMS which shows the ...
- 1,093
8
votes
6
answers
7k
views
Why am I not able to create a backup plan for TFS?
I am trying to create a backup plan using the TFS Power Tools but I keep running into this error message:
I have checked that the account has Full Control on the share, I can edit, create and delete ...
- 553
8
votes
3
answers
3k
views
SMS slow when connecting to Azure SQL Server
I host 2 databases on Azure SQL Server Db. Two very small 40Mb databases. Very limited access to them. If I look at my DTU, its like 0 peaking at 5%.
However when ever I open either of the databases ...
- 201
7
votes
3
answers
7k
views
Creating a named pipe on Windows
I want to write a large dataset from a SQL Server 2005 database using BCP (bulk copy program).
Ideally I'd like to do the following:
bcp MyDatabase..MyTable OUT STDOUT -c -t, |gzip -c c:\temp\...
- 2,815
7
votes
2
answers
1k
views
SQL Server Management Studio ignores default DB
When I use SQL Server Management Studio to log in to databases, it ignores my default DB and always puts me in master. I checked that my Windows user has a login with the correct DB set, and I tried ...
- 233
7
votes
1
answer
6k
views
Slow user session in Windows 2016 Server with SQL Server Standard
I've recently installed a Windows 2016 Server with SQL Server 2016 Standard. The setup is being used as an IIS webserver with Reporting Services.
Anyhow, when connecting to the server via RDP, the ...
6
votes
2
answers
15k
views
SQL server 2008 and 2012 on the same instance of Windows
Is it a problem to have both of these installed on the same Windows instance? I.e. will one break the other or impact it negatively in any way?
- 335
6
votes
1
answer
48k
views
Query parameters in an external connection to sql server
I want to do exactly this: http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/ but I want to do it in Excel 2010 and also I am querying SQL Server instead of MS ...
- 252
6
votes
2
answers
21k
views
Unable to install SQL 2014
When I'm trying to install SQLEXPRADV_x64_ENU i got following error.
SQL Server Setup has encountered the following error:
There was an error generating the XML document.
Error code ...
- 235
6
votes
2
answers
1k
views
Does Azure Backup for Windows Server affect regular SQL Server backups on the same server?
I have a virtualized Windows Server 2019 instance configured as failover cluster node with SQL Server 2016 Availability Group node running on it. I have already set up "traditional" SQL server ...
- 1,873
6
votes
1
answer
18k
views
How can I get sql server profiler installed
I have Sql Server 2008 R2 installed. But in Management Studio, under Tools menu, I don't see Profiler. What feature do I need to install in order to get profiler?
- 221
5
votes
11
answers
13k
views
Less daunting front end for SQL Server
We currently have a few users who have been using Access very succesfully to throw around large amounts of data.
We've now got to the point where the data is just too large to be held in Access, as ...
- 4,244
5
votes
3
answers
3k
views
How to use Microsoft SQL Server 2008 as a simple database for testing
As a student, I get Microsoft SQL Server 2008 R2 for free through MSDNAA. I installed it, but I seem to be at a loss for how to use it to test database queries, and how to construct a database with ...
- 51
5
votes
1
answer
21k
views
How Do I Investigate a CPU Usage Spike Without Being Present?
I have a server that's mysteriously using up a lot of CPU late at night, when it shouldn't be under heavy load. This causes some database calls to time out, and I've set up some alerts in PerfMon to ...
- 294
5
votes
2
answers
9k
views
How can I start using MS-SQL Server ( express )
I have just installed Microsoft SQL Express from here: http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx
I need it because an example of some code I have uses it.
How do I start using ...
- 4,131
5
votes
2
answers
203
views
How do I connect to a SQL Server DB to run some queries?
I have a SQL Server DB but have no idea how to connect to it to run some queries. I naively assumed that I'd be able to open up a DB in a similar fashion to Microsoft Access, but can't seem to do this....
- 3,509
5
votes
2
answers
11k
views
Where is the SQL Configuration Manager in SQL Server Management Studio 18?
I am setting up a new computer, a Surface Laptop 3. I have installed SQL Server Management Studio 18.4, downloading it from here.
I am just trying to install client tools and not the server software....
- 209
5
votes
3
answers
20k
views
Cannot uninstall SQL Server Management Studio 18 after forcefully stopping setup midway
I installed SQL Server 2017. It installed fine. I connected and turned it on (the server). Worked fine.
Then I downloaded the SSMS 18 setup. When I started the SSMS setup exe, it progressed to half ...
