Questions tagged [sql-server]

Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

Filter by
Sorted by
Tagged with
0 votes
0 answers
17 views

error 17054 severity 16 state 1 sql server 2014 enterprise edition

Our new database is just inaccessible. I have tried to find it in the error log and find this error during that time. So when we went to the Configuration manager. we were seeing Browser service, SQL ...
user avatar
  • 1
-1 votes
0 answers
11 views

SQL - How to avoid reading value from XML column due to performance issue

I am new to SQL , could you please suggest me how do I improve below SQL code, I have observed using SQL profiler - XML reading operation is taking too much of time. Kindly let me know how do I ...
user avatar
  • 1
1 vote
0 answers
21 views

Ansible task for updating/cleaning up dbatools failing

I keep the Installation of the dbatools.io PowerShell module updated on my MSSQL Servers with a simple Ansible playbook which includes the following task: #################### UPDATE DBATOOLS #########...
user avatar
  • 129
0 votes
0 answers
20 views

MSSQL reportserver behind web application firewall

Good Morning everyone! First, please just point me in direction, where can I look into documentation. I should get a consultant, but as a DBA, I want to solve this issue by myself. Issue: Management ...
user avatar
  • 1
0 votes
0 answers
7 views

SQL server CDC sync to SQL server express

Is there some built-in or some simple tool for syncing CDC tables to SQL server express. CDC server is remote and I only have read only access to it if that's important.
user avatar
0 votes
0 answers
19 views

how to install a software with sql database in a domain with different windows clients on windows 2016 server

I have a domain (Windows 2016) and 4 clients (Windows) attached to it. Now I need a software which hase inbuilt mysql server. How do I install that software so that the software will be accessed from ...
user avatar
0 votes
0 answers
8 views

Automated Backup for SQL VMs "Key not valid for use in specified state."

In Azure, when enabling Automated backups for SQL virtual machine (MS SQL in a VM), the operation fails. Similar errors occur with Azure Backup for SQL VMs. The Azure Portal reports: { "...
user avatar
  • 396
0 votes
0 answers
26 views

Can't install/uninstall SQL Server

When I try to install SQL Server Express I got this error Unable to install SQL Server (setup.exe) Then I'm trying to uninstall everything related to the SQL server to avoid previous installation ...
user avatar
  • 101
1 vote
2 answers
48 views

Veeam SQL Server Database Publishing Fail with unexpected error code 3

So we have been experimenting with Veeam Backup & Replication for a while now. We setup a dedicated VM for Veeam Backup Server which performs daily backups of all our infrastructure components. We ...
user avatar
0 votes
0 answers
10 views

Post-Installation Configuration of SQL Server Instance on EC2

AWS Cloud Formation allows automated creation of EC2 instances in Windows Server Failover Cluster with SQL Server installed on top in Failover Cluster Instances. There is a lot of documentation about ...
user avatar
  • 101
0 votes
1 answer
13 views

Adding a security certificate to a remote sql server

I'm in the process of trying to add a security certificate to a sql server running on a remote machine. I managed to generate the cert, but I'm a bit lost on the next step. All the instructions I have ...
user avatar
-1 votes
2 answers
23 views

Unable to find user account to set permissions for private key

I'm trying to set up a security certificate for a sql server. According to the documentation, I need to set up the permissions so that the sql server instance can read the private key. I tried setting ...
user avatar
2 votes
2 answers
566 views

Free up memory in Windows Server 2019 for SQL Server instance?

We have Windows Server 2019 Standard (x64) with 64GB memory. The screenshot below shows the memory usage at 96% with the SQL Server Windows NT running and using 344.5 MB. This is the Task Manager ...
user avatar
  • 175
0 votes
1 answer
51 views

How to determine the common name (CN) for a microsoft sql certificate?

I'm in the process of trying to set up a self signed certificate for connecting a jetty server to a development sql database. I'm following the instructions here: https://codekabinett.com/rdumps.php?...
user avatar
0 votes
0 answers
15 views

dotnet core web application cannot reach remote SQL Server

I have a setup with a dotnet core web application. It is deployed in an Azure VM running Ubuntu. The web is served in nginx. This particular web application accesses a number of different databases. ...
user avatar
0 votes
1 answer
19 views

Recomendations for Data Transfer between heterogeneous sources/destinations

I apologize if this is not the right forum for this kind of question. We need to transfer data between DB Servers (MySQL, MSSQL), CSV files, API Sources (Web Services), etc. and we are looking into a ...
user avatar
  • 101
0 votes
0 answers
27 views

Can't login to SSRS (SQL Server Reporting Services) using SSMS (SQL Server Management Studio)

I'm having an issue logging on to my reporting server via SSMS. I use the same hostname\instance found in the reporting server config GUI at the top. This used to work, but I have made some changes ...
user avatar
0 votes
0 answers
74 views

SSMS connections dropping with SoftEther

We've recently changed VPNs from OpenVPN to SoftEther; it's working great so far, with one exception: SQL Server Management Studio. For some reason, either SSMS or the SQL Server seems to drop the ...
user avatar
  • 3,680
0 votes
0 answers
55 views

PDOException could not find driver when pdo_sqlsrv is installed

Date: 2022-02-28 15:57:17 Exception detail: /var/log/DirectBuy/root-directbuyla-exp_1280c91f9f.json Class: PDOException Line: 138 Documentation Link: No Documentation Message: could not find driver =...
user avatar
  • 7
0 votes
0 answers
48 views

GCP Cloud sqlserver enable sa user

I see on this question that is a way to enable sa user in GCP Cloud sqlserver ... but its not clean how he made it. So, theres a way to enable sa user in GCP Cloud sqlserver?
user avatar
0 votes
1 answer
68 views

SQL Server - How to split single mdf file into multiple, and partition table data across them?

In the hopes of improving SQL Server performance, I'd like to take my simple 1-file (1 mdf & 1 ldf) database and split up the mdf files (and maybe the ldf files) across multiple disk drives. I'm ...
user avatar
  • 111
1 vote
0 answers
152 views

PHP PDO Very Slow on Fetch

I have a problem with a couple of queries running in PDO on PHP connecting to MSSQL server 2019. I have checked the time in SSMS and its fast. I have also added some timers into my code so I can see ...
user avatar
  • 11
0 votes
0 answers
19 views

How to set SQL-Always-On in Kubernetes Linux container?

I raised 3 pods of SQL servers in Kubernetes: 1 as a primary DB 2 others as Secondary DBs I want to set SQL-Always-On feature between those 3 DBs in a way that: In SSMS the 3 DBs will be "...
user avatar
  • 67
0 votes
0 answers
32 views

SQL Server - Optimizing Performance of a Large Dataset

I'm using SQL Server running on an Azure VM with 8 SSDs. The SSDs are grouped together in Storage Spaces as 1 disk - in order to increase the capacity and also to combine the IOPS/Throughput. But the &...
user avatar
  • 111
0 votes
0 answers
33 views

Accessing MSSQL server remotely through mikrotik

I have a following setup: Server with MSSQL installed with remote connections allowed Mikrotik router I have setup all the necessary things on MSSQL: Tcp port Firewall Allow remote connections On ...
user avatar
1 vote
1 answer
39 views

SQL Database restore to different edition?

I have SQL server 2008 R2 standard in house server and want to move my database to SQL 2019 Web edition in VM in AWS cloud. Can I just backup database and restore it there? would that work? or ...
user avatar
0 votes
1 answer
45 views

Painfully slow local development

I know some may suggest that this question needs to be asked on StackOverFlow, but I do not believe this is not a Dev issue and probably an IT/Security thing. I will post this question on Superuser as ...
user avatar
  • 101
0 votes
1 answer
2k views

How to replace/update Apache Log4j 1.2.x with 2.17?

My vulnerability scanner recently flagged an unsupported installation of Apache Log4j in a version of MS SQL we just recently deployed (SQL 2019). It causes two high-priority findings that I must get ...
user avatar
0 votes
0 answers
26 views

Can SQL Server Users have limited read only in SSMS and read-write in the .net application?

Our software requires the business users (of the software) to have read and write access to the database (MS SQL Server). The users are added to an active directory group with this SQL permission. The ...
user avatar
0 votes
1 answer
50 views

How Should FSx Shares be Created for SQL Server Drives on EC2?

We're in the process of planning the migration of our whole platform into AWS. The current thinking is that we will host our instances on EC2 and use FSx as the file system. However, I can't find ...
user avatar
  • 101
0 votes
0 answers
26 views

Monitor local SQL Server traffic

I am running a local instance of MS SQL server 2014 Developer Edition, I enabled the certificate based encryption on it, so I want to verify that all the incoming and outgoing traffic is encrypted. I ...
user avatar
  • 101
0 votes
1 answer
317 views

Unable to connect SQL Server from PHP using Windows Authentication

I'm trying to connect to MS-SQL Server from PHP-8.0 (hosting on IIS-10 localhost) using SQL Server Driver for PHP, i.e., SQLSRV-5.9. While connecting from a PHP page, if I use SQL Server ...
user avatar
0 votes
0 answers
18 views

Can't connect to sql server by instance name

I have a user 'user_1' requesting access to sql server 'server1'. The user_1 is in domain 'domain1' and the sql server 'server1' is in domain2. After I granted the user with permission, he found he ...
user avatar
0 votes
2 answers
2k views

PHP unable to identify sqlsrv_connect() function while trying to connect SQL Server

I'm trying to connect to my local MSSQL Server from a simple PHP file using the sqlsrv_connect() function, but every time I'm calling the file in the browser through localhost, it's throwing a 500 (...
user avatar
1 vote
1 answer
51 views

MySQL is 100% CPU over the past week, no idea why, details below

I'm trying to work out why MySQL is hitting 100% over the past week: It's a server that does network/server monitoring called LibreNMS. Top: https://pastebin.com/1qypfm0n Here I access MySQL and look ...
user avatar
0 votes
1 answer
676 views

Run SQL script on Ms SQL Server docker container creation

I want to run sql script on MS SQL container setup. If I do everything separately all works fine: Run container docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Password" -p 1434:...
user avatar
  • 103
0 votes
0 answers
42 views

Hosting provider requires giving out server's admin password because of Microsoft audit

I am using a Windows OS VPS from a smaller, local provider for 1 year, everything was good until I started to license a MSSQL Web from the provider itself. They ask me to share my OS's admin password ...
user avatar
  • 1
0 votes
0 answers
21 views

issue on reading XML extended-events MSSQL

Currently I was wondering if someone could shed some light on the issue I'm having. I'm currently trying to use this tutorial to find Blocked Processes and Deadlocks https://www.brentozar.com/archive/...
user avatar
0 votes
0 answers
30 views

MS SQL-Server 2014 - Is it possible to trigger an Event/Script, when a certain Query comes along?

I'd like to have the possibility to accomplish a certain routine (fi. trigger a external node script or any kind of script/method whatever), when certain queries come along in MS SQL Server 2014. Is ...
user avatar
  • 181
1 vote
0 answers
74 views

Does NT SERVICE\MSSQLSERVER require Kerberos authentication if the sql instance is on the local machine?

I had a bizarre issue today where NT SERVICE\MSSQLSERVER was being denied login as a service on a domain joined computer. I also noticed group policy was not being applied via gpupdate /force. I ...
user avatar
0 votes
1 answer
52 views

Sql Server Standard 2019 Core Licensing [duplicate]

*Sorry, found other licensing questions on the site so naturally assumed these were ok here... The suggested post did not answer the question I specifically asked Please remove the post if I've ...
user avatar
1 vote
0 answers
110 views

MS SQL server 2019 failover cluster - Event ID 18456, Login failed for user 'domain\server1$'

New MS SQL server 2019 installation on Windows Server 2019, failover cluster role enabled; fully patched Windows, SQL 2019 CU 11. Nodes: server1 - 10.10.10.1 server2 - 10.10.10.2 Instances: sql1 sql2 ...
user avatar
  • 1,529
0 votes
0 answers
54 views

Calculating IOPS in a SQL Server EC2 - RDS migration

I'm evaluating costs for a possible migration of a SQL Server that is currently running on Amazon EC2 to Amazon RDS. On the EC2 instance I have six volumes, described as follows: type size IOPS gp2 ...
user avatar
1 vote
1 answer
3k views

Can't install MS SQL Server on Ubuntu 21.10

I am trying to install Microsoft SQL Server on Ubuntu 21.10 and I am getting an error. I noticed that Microsoft page doesn't mention 21; so maybe it's not possible yet. But Canonical announcement ...
user avatar
  • 533
0 votes
1 answer
86 views

MS SQL connection failure log for TLS/encryption issues

I have an application which has suddenly failed to login to a MS SQL database on the same LAN. On the client side logs I can see: [Microsoft][SQL Server Native Client 11.0]Encryption not supported on ...
user avatar
  • 1
2 votes
1 answer
77 views

SSH using public key losing Authentication on windows server

I want to SSH from my laptop (A) to Windows Server (B) and run commands against SQL Server (C) from powershell. All three in one windows domain. I'm running built-in openssh server and client for ...
user avatar
  • 131
0 votes
0 answers
71 views

Is a ZVOL considered copy-on-write anymore if I format it with another filesystem?

According to official requirements from Microsoft, SQL Server 2019 only supports either ext4 or xfs. I suspect that a Copy-On-Write filesystem such as btrfs or zfs may hurt the performance of the ...
user avatar
  • 153
1 vote
0 answers
169 views

MS Sql Server 2019 setup fails on Ubuntu 20.04

I am trying to install SQL Server 2019 Developer Edition on Ubuntu 20.04 by following - https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver15 The setup ...
user avatar
  • 11
0 votes
0 answers
22 views

SQL Sync Scenarios (on-prem to Azure)

I would like your help making a decision on the following: We have a local SQL server and we would like to sync to either Azure SQL on VM or Managed Instance using Sync Framework 2.1. From what I ...
user avatar
0 votes
1 answer
97 views

"Access Denied" when running SQL Server Installation Center Tools

With MS SQL Server 2019 on Windows Server 2019, I am attempting to do something pretty simple: Run the "Installed SQL Server Features Discovery Report" tool that comes in the SQL Server ...
user avatar

1
2 3 4 5
95