Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

-1
votes
0answers
15 views

Cannot log in SQL server 2012 [on hold]

I have a problem log in with Windows Authentication, here's the problem showed in the image
0
votes
0answers
9 views

MySql workbench can't connect to SQL Server 2017 with ODBC on macOS 10.14

I run SQL Server 2017 in docker and i have install the Microsoft ODBC Driver 17 for SQL Server. The document is here https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-...
0
votes
0answers
5 views

MS SQL Lock on sys tables

I have noticed that certain schema info tables, like for example sys.columns or sys.sql_modules are locked and I cannot query them. When I do, the query runs for ever with no result. I have tried to ...
0
votes
0answers
7 views

Can sql server enterprise monitor other instances of sql servers

I understand that policy based management can be run on sql server enterprise to administer other sql instances but can it be used to monitor performance of those instances without third party tools?
0
votes
0answers
10 views

Single update to datetime field correctly updates, update to multiple lines fail

Working in SQL 2014 I created a temp table from a backup db copy of Table 1 with the goal of copying a restored version of ##T2 into T1. When I run: UPDATE T1 SET T1.datetimecolumn = '2019-1-1 00:...
0
votes
1answer
66 views

Microsoft SQL Server Management Studio 18 fails to start after installing XAMPP/MAMP on Windows 10

When I try to launch SQL Server Management Studio 18, I get a Windows chime and no other response or error messages. Initially, after installing SSMS 18 and SQL Server 17, both worked fine for a day ...
0
votes
0answers
11 views

Direct ISO package link of Microsoft SQL Server Developer 2017?

Do anyone know the direct ISO package link for Microsoft SQL Server Developer 2017. I found one in my.visualstudio.com but this link seems to expire after some days. I need a stable link which do not ...
0
votes
0answers
9 views

Error trying to setup/start SQL Server 2019 on Ubuntu

I'm trying to setup MSSQL server 2019 on my ubuntu server and i'm running into some really cryptic errors. Whenever I run the setup command: "sudo /opt/mssql/bin/mssql-conf setup" I get the following ...
-1
votes
0answers
15 views

SSRS Custom Security Extension Loses Cookie on Search

I have built a custom security extension for SSRS to implement forms authentication in SQL Server 2017. It works as designed as long as the authenticated user navigates through the reports and ...
0
votes
0answers
13 views

TFS 2017 update

TFS 2017 version of TFS 2017 with update 3 wanted to high. but i didn't know what i need to do if i get the following error TF255441: An orphaned SQL Server login is associated with the following ...
0
votes
0answers
8 views

How do I remove the query itself from output of SQLCMD query?

I'm trying to output the results of a scheduled saved query to a CSV file, but the query itself is being added at the head of the output file. This is making processing the file downstream more ...
0
votes
1answer
17 views

Force SQL Server 2019/Ubunti to use ipv4 instead of ipv6

We are testing usability of Microsoft's SQL Server on Linux servers for our internal products, and we ran into a bump during config. We are trying to setup and configure SQLServer 2019 (preview) and ...
0
votes
0answers
7 views

Cannot connect Bitnami server in DataGrip [closed]

I had some troubles with Ampps before. Since last week, I couldn't start Apache anymore in Ampps. This problem (and because my teacher switched) is why I decided to install Bitnami instead. In ...
0
votes
0answers
16 views

SQL Server Patch Fails (SP2\CU4)

I am currently on Windows Server 2012R2, SQL Server 2016 sp2\cu4. On 2/24/19 I attempted to install sp2/cu5, then on 4/27 i attempted to install sp2/cu6... both of these failed. From what I understand ...
-1
votes
0answers
10 views

DataSync Azure very slow (first syncro worked fine in 5mn)

I'm doing some DataSync tests with an Azure free account. I do synchronization from an on-premises SQL Server database to the HUB in Azure. Initially the hub and Syncdb are new empty databases. I ...

15 30 50 per page