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

learn more… | top users | synonyms

0
votes
2answers
197 views

Buying MS SQL server, confused about CAL needs [closed]

I'm extremely confused as to which version of SQL server to buy... I've found versions for around $599 and then some for around $1,100... Currently we're running Express and only need to upgrade ...
0
votes
1answer
597 views

SQL Server Management Studio 2014 won't start: Exception has been thrown by the target of an invocation

I'm on Windows 7 Professional SP1. I just installed SQL Server Management Studio 2014 using the 64-bit download from Microsoft: SQLManagementStudio_x64_ENU.exe, and when I click on the shortcut in ...
1
vote
1answer
87 views

How to debug unattended installation of MS SQL Server 2012?

How can I diagnose and debug a configuration file for an unattended installation of MS SQL Server 2012? What I'm doing -- I'm building an installer for a product. The product requires MS SQL Server ...
1
vote
1answer
23 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 ...
0
votes
1answer
332 views

Upgraded to windows 10 and now can't connect to sql server 2012

I upgraded to Windows 10 on my laptop. I have opened SQL Server Management Studio, but it can't connect to the server. I have looked at a few other questions, but nothing seems to work. I get the ...
0
votes
0answers
17 views

Cannot connect to SQL Server 2008 R2 from 3rd party program

I am running SQL 2008 R2 on a pc. I usually connect to a server instance from a 3rd party program all on the same machine, but suddenly I cannot connect. When I try I get message about network ...
1
vote
1answer
224 views

SQL Server Results to File Creates extra lines at end

When I route the output of my queries to a file, there are one or two blank lines at the bottom. When I run the query though SSMS (2008 or 2012), I get two extra blank lines. When I run the query ...
0
votes
1answer
304 views

Port 80 used by Microsoft-HTTPAPI/2.0

The port 80 is used by Microsoft-HTTPAPI/2.0 and cannot be stopped. I have tried many solutions, but no one worked. Here is what I have done. Also, here is what is on the page : Not Found HTTP Error ...
1
vote
0answers
431 views

Hibernate Entities generated using IntelliJ have no Foreign Keys generated

I have a normalized SQL Server database with 20+ tables on it that created using SQL Server Management Studio 2014. I am able to connect to this database in IntelliJ and follow along with the steps ...
5
votes
2answers
7k 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 ...
0
votes
1answer
23 views

Copy columns between tables in different servers

Recently I moved to SQL Server 2012 from SQL Server 2005. Current scenario worked without any problem in SQL Server 2005. 1)Connect to server A 2)Open table X 3)Copy 3 columns(Clicking ...
0
votes
0answers
25 views

Export from SQL server 2008 to Excel 2013 put results on specific cell

I'm using SQL Server 2008 also i have Excel 2013, i have query to return count, and now i'm looking to export the results to excel sheet that "already created" and put the results on specific cell, ...
2
votes
1answer
2k views

How do I allow multiple people to open my Access database?

I have an incredibly simple Access database. It has one pass-through query and that's it (no tables). The query simply executes a stored procedure against a SQL Server database to display the ...
0
votes
0answers
43 views

Plesk Windows server & MSSQL

I am running Windows Server 2012 R2 with Plesk 12 and SQL Server 2014. Going to : Home -> Tools & Settings -> Services, I can see with green : SQL Server (MSSQLSERVER), SQL Server (...
0
votes
0answers
19 views

How to detect if someone is running perfmon locally or remotely against my server

One of my Microsoft SQL servers is lagging and I'm wondering if someone is running perfmon on it either locally or remotely - how can I detect if someone is running perfmon on the server (either ...
1
vote
0answers
210 views

How to install SQL Server ODBC driver on OSX?

I'm using MySQL Workbench on a Macbook to migrate a SQL Server database to MySQL. When I try to connect to SQL Server I get the error: The ODBC driver that was selected for the source connection ...
0
votes
1answer
148 views

SQL server missing in ODBC

I installed a SQL Express server on a 32-bit Windows 2008 server r2. I installed this while installing a Phoenix fueling station program. When I am trying to add a user DSN in ODBC I am unable to find ...
0
votes
1answer
172 views

SQL Server Management Studio (SSMS) 2012 slow to show results in Grid only

I generally use Microsoft SQL Server Management Studio 2012 (11.0.3000.0) with query results being displayed in a grid. As of 3 or 4 days ago query results have been quite slow, but only ...
1
vote
1answer
135 views

How best to check connectivity of web server to database?

Our IT admin is asking for an api endpoint in our web application to use as a health check. The logic in the api should perform any simple database query to ensure that the web server can connect to ...
0
votes
1answer
92 views

Replace a filepath column in SQL with new file structure

I have recently changed the structure of a drive where I keep a lot of my 'estimating' files. The problem is, I use a program that has references to some of those files, in the old structure, stored ...
0
votes
0answers
92 views

Why does SSMS incorrectly report an invalid object name when the object does exist?

Why does SSMS incorrectly report an invalid object name when the object does exist? e.g. the table BinCollectionDay is in the current database And even better, how do I stop the incorrect ...
0
votes
1answer
314 views

SQL Server CTP installer - The application cannot find one of its required files

I have downloaded the exe file to install SQL Server 2016 CTP4. When I run the exe, it gives me the following message: The application cannot find one of its required files, possibly because it was ...
0
votes
1answer
11 views

formating of dates in sql server

This is my query select projectname,CONCAT([Budget Health],[ProjectBaseline0StartDate],[ProjectActualStartDate],[ProjectStartDate]) as budgethealth from [dbo].[MSP_EpmProject_UserView] Output is: ...
0
votes
0answers
14 views

Sql Blocked Query automation

I am running a Windows server 2012 standard and SQL Management Studio 2012 on it, i would like to get a dump of all the blocked queries to a excel sheet, if the queries get accumulated (greater than)>...
1
vote
1answer
81 views

Connecting to MS SQLServer from a Linux box

I am trying to connect to MS SQLServer from an application that I have written (using Qt) which runs on Linux. Here are some details of the setup: The SQLServer box (SQLBox) is part of my domain (...
0
votes
1answer
1k views

Updating MS SQL Server from 10.50.1600 to 10.50.1617

How do I update my MS SQL Server from the version 10.50.1600 to 10.50.1617? I have downloaded the KB from here https://www.microsoft.com/en-us/download/details.aspx?id=26304 but i am still not ...
0
votes
0answers
9 views

How can you edit the list of servers displayed in the SSMS Connect to Server dialog?

How can you edit the list of servers displayed in the SQL Server Management Studio "Server Name" field of the "Connect to Server" dialog? I've got various old servers that I'd like to remove from the ...
0
votes
1answer
20 views

Is it possible to get SQL string generated from clicking through UI commands in SQL Server Management Studio?

Ok, so SQL Server Management Studio (SSMS) lets me backup and restore SQL databases, which is pretty awesome an application QA Tester. It allows me to test different starting configurations without ...
0
votes
0answers
20 views

Can I simply rename a TDE-encrypted SQL Server database?

I encrypted an SQL Server database using TDE.  What happens when I rename the database?
1
vote
1answer
604 views

Cannot set static IP address using Netsh

I have followed this article to set the following environment: DC: Windows Server 2008 R2 Enterprise (Full Installation) - Domain controller for the lab network, contoso.com SQL-A: Windows Server ...
0
votes
1answer
86 views

Huge amount of virtual size used by sqlservr.exe - is that normal?

I'm checking memory leak on my computer currently, is that the high usage of virtual memory by the sqlservr.exe related
0
votes
1answer
7 views

Is SQL Server likely to give errors given this usage profile?

I'm developing a web service using asp.net web api 2 which is to be the owner of my SQL Server database. To simplify things, I'm writing a separate MVC site that is to use the same database, but ...
2
votes
1answer
76 views

How to load files according to Created Date in Windows command prompt

In SQL Server using xp_cmdshell, I was able to load files according to Modified date using a command for e.g., z: & forfiles /m *.jpg /s /d 07/16/2015 /c “cmd /c echo @fdate @ftime @path” But I ...
0
votes
0answers
341 views

SQL Installation hanging on windows 10

I've tried installed every version of SQL Express I can get my hands on (And I've got the MSDN SQL 2016 CTP 2). Everythings hangs, and always at this point. I've a feeling its a .net related issue ...
1
vote
1answer
840 views

Sharing a database over the local network

We have some plate nesting software at work which I use daily. Recently, I thought I'd try to get the shared database up and working so the boys in the workshop could use the software on another PC (...
0
votes
1answer
50 views

Rebooting Old Server

I have a question that may be really easy to answer. Our company got a new server a while ago. This server acts as our DNS, SQL, Web, NAS, and Active Directory. We are moving to a new office and I ...
0
votes
1answer
59 views

How can I detect the changes in my SQL Server database

I want to know the exact changes in my SQL Server database? Can I see the complete changes in a SQL Database
2
votes
3answers
21k views

SQL Server not working after upgrading windows 10 from windows 8.1

My Sql server 2012 has stopped working and now its not letting me login. Here is the error: https://drive.google.com/file/d/0ByGXmosQgHUqdGw4alFSb3otVkk/view?usp=sharing TITLE: Connect to Server ...
0
votes
1answer
52 views

How to unlimit the number of simultaneous connections on windows?

How can I make microsoft windows to accept more then 20 connections, I have a microsoft sql server express that seems to be dropping connections after 20 connections. Any sugestions? Windows 2008 ...
0
votes
0answers
55 views

See SQL Server Reporting Services without logging in?

I have installed SQL Server 2015 with SSRS and I have some reports I need to run, but in order to access http://reportsserver/Reports I need to start Internet Explorer in administrator mode. This is ...
0
votes
1answer
128 views

Making a pivot table month filter

I'm trying to compile some reports through an Excel pivot table connected to a MS SQL database. Now the data I'm working with consists of a bunch of dates formated as dd/mm/yy. I want to make a filter ...
10
votes
1answer
20k 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://...
0
votes
0answers
62 views

RDP, IIS, SQL Server no longer working

Remote desktop, as well as SQL Server 2008 R2, as well as IIS 7.5 have all mysteriously stopped allowing connections via my local network. Originally, I thought that this could be the result of a root ...
0
votes
0answers
255 views

How to port forward through two routers in a network

I am trying to connect my SQL server through public network. So, I am having lots of problem in understanding it. One router is AirOS's(Outside my house) another is Iball's Baton(Inside my house). ...
0
votes
1answer
406 views

Compatibility between Windows 7 and Windows 10. [closed]

I receive the free update from Microsoft for Windows 10. At the moment I'm using Windows 7 Ultimate. I have several question, for which I can't find anything in google or at least my search words was ...
0
votes
0answers
27 views

Error When Logging In

I am able to log in with Windows Authentication, but my user account does not have any permissions to perform the operation (e.g. Exec, grand, alter, create…etc). Even though I am not able to create ...
0
votes
0answers
109 views

Unable to open SSMS from run window

I'm having an issues that bugs me and can't seem to be able to solve it. I have SQL Server 2005 and 2012. For the 2005 instance this is my path (for both 2005 and 2012 the path that leads straight to ...
0
votes
0answers
23 views

How do you create a sql 2014 cluster disk for a cluster across multiple hyper-v machines

I have an SQL 2014 cluster spread across multiple physical machines running Windows Server 2012 and Hyper-V. I'm attempting to install Skype for Business 2015. However the install script appears to ...
3
votes
1answer
52 views

Images Stuck on Server

I've run into a strange problem with images being "stuck" on the server. The problem began when I uploaded an updated picture via FTP (I use Cyberduck for Mac) to override the picture. This didn't ...
0
votes
1answer
292 views

Error Installing Windows SQL Server on Windows Server 2012 R2

I have been completely unable to install Windows SQL Server Express on Windows Server 2012 R2. Every time, I get: TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: Wait ...