Skip to main content

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

Filter by
Sorted by
Tagged with
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 ...
malakrsnaslava's user avatar
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 ...
José Antonio Rodríguez Pascual's user avatar
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.
Alex Gordon's user avatar
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 ...
ZygD's user avatar
  • 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 ...
Rich's user avatar
  • 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 ...
Andrew J. Brehm's user avatar
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?
Shaz's user avatar
  • 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 ...
Vadim Ovchinnikov's user avatar
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 ...
user avatar
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'...
Hussain Akbar's user avatar
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 ...
AaronSieb's user avatar
  • 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 ...
Chris's user avatar
  • 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 ...
Rory's user avatar
  • 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) ...
thilina R's user avatar
  • 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" ...
Ivan's user avatar
  • 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 ...
Micro's user avatar
  • 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 ...
dnolan's user avatar
  • 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 ...
Taenkeren's user avatar
  • 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 ...
Rory's user avatar
  • 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 ...
Curtis's user avatar
  • 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 ...
Andrej Kuklin's user avatar
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 ...
Steve Wranovsky's user avatar
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 ...
RoboShop's user avatar
  • 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://...
JohnnyO's user avatar
  • 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 ...
Moeb's user avatar
  • 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 ...
Madoc Comadrin's user avatar
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 ...
ilija veselica's user avatar
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 ...
James Dunn's user avatar
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 ...
Kris van der Mast's user avatar
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 ...
Arseni Mourzenko's user avatar
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 ...
Daniel's user avatar
  • 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 ...
Angelo's user avatar
  • 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 ...
noocyte's user avatar
  • 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 ...
Zapnologica's user avatar
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\...
PP.'s user avatar
  • 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 ...
RossFabricant's user avatar
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 ...
Fredrik Johansson's user avatar
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?
cc0's user avatar
  • 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 ...
Dan's user avatar
  • 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 ...
DevT's user avatar
  • 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 ...
Adrian Grigore's user avatar
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?
Sheen's user avatar
  • 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 ...
Martin's user avatar
  • 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 ...
water's user avatar
  • 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 ...
CadentOrange's user avatar
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 ...
OscarRyz's user avatar
  • 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....
Umber Ferrule's user avatar
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....
Reboog711's user avatar
  • 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 ...
Raphael Nazirullah's user avatar

1
2 3 4 5
16