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
0answers
14 views

Prioritize\speed up stored procedure

I've got a stored procedure with loops and what not inside and recursive calling of other stored procedure and recursive calling of the stored procedure itself. This stored procedure has a lot of ...
0
votes
1answer
45 views

Microsoft SQL Server Mangement Studio gives error when trying to add device for restoring backup

Yes in Management studio I am trying to restore a backup from another server. So I am doing the following: This is a fresh install of SQL Server 2017 express Right Click on the Databases Folder and ...
0
votes
0answers
15 views

Upgrade SQL sever 2017 Enterprise evolution to standard in Windows failover cluster in EC2

I'm trying to upgrade a SQL server enterprise evaluation to the standard edition (paid) on a Windows failover cluster in the EC2 instance. I plan to apply for the Server + Cal standard license on the ...
-1
votes
0answers
22 views

(Robocopy) Output shows 1 mismatch file, i would like to know what that means

Total Copied Skipped Mismatch FAILED Extras Dirs : 1 0 1 0 0 0 I get 1-2 mismatched files, i would like to know why that is and what it ...
-2
votes
0answers
23 views

Use if else sql statement with two selects [migrated]

Currently I have the following SQL query DECLARE @UgpEntry VARCHAR(50) IF (@UgpEntry = -1) SELECT t1.ItemCode as sapitemcode , t1.CodeBars as Barcode , t1.ItemName as description ,LEFT(...
0
votes
0answers
12 views

SQL Server: allow access to databases of particular Availability Group only

Is it possible to configure clustered SQL Server in a way that allows users connected to a listener of an AlwaysOn Availability Group to access databases belonging only to this Availability Group? ...
0
votes
0answers
10 views

Can I get the PID of an executable started by SQL Agent?

I have multiple SQL Agent jobs that call an executable via a CmdExec job step. The master.sys.dm_exec_sessions table will tell me when one of these executables is running, but the host_process_id ...
1
vote
1answer
79 views

How can I check if SQL Server 2019 Standard is activated on Server Core? [duplicate]

I installed SQL Server 2019 Standard on Windows Server 2019 Core from an ISO that I downloaded from our MSDN. It specifically stated that there is "No product key required" when I downloaded ...
1
vote
0answers
27 views

Grant database access through GPO

I have a domain in which I have couple servers with dedicated SQL Server databases. I also have couple external companies that need access to this servers and databases on different permission level (...
0
votes
1answer
20 views

Axapta 3.0 How to change Company permission for user?

We got an old axapta 3.0 Server to manage of one of our customers. The problem is our customer needs this old server to access old company data and no one has a plan how to administrate it. We need to ...
0
votes
0answers
27 views

Unable to activate SQL Server Agent after upgrade from Express to Standard

I have just upgraded a MS SQL-server Express 2019 to Standard using the documentation from Microsoft here: Upgrade to a Different Edition of SQL Server. Everything went well and looking at properties ...
0
votes
0answers
10 views

Do SQL Server 2016 Web Edition have CAL License? [duplicate]

I am looking for information of SQL Server 2016 Web Edition if it have CAL license but have not found any. Background: I have a web application for 20 concurrent users. We are planning to have SQL ...
0
votes
1answer
39 views

Any PowerShell Script to Backup and restore Ms-sql database using dB username and password?

I am looking for a PowerShell script which can take backup and restore MS-SQL databases using SQL authentication.
0
votes
0answers
43 views

Continuous windows events 4648 and 4624 generated when ODBC driver is configured with Integrated windows authentication

We are running a C# application in my VM,which is configured to run as a windows service. The service runs as local system account and talks to a locally installed SQL database server. I have access ...
1
vote
0answers
29 views

Determine if there's Network Traffic over a TCP/IP Connection using PowerShell in Windows?

I had a situation where an application was "hanging" in accessing the database. I was able to see that there was a connection by using Get-NetTcpConnection -RemotePort x This showed that ...
0
votes
0answers
19 views

Cannot connect to ms sql server

After alot of time i'm stuck on getting my project to work. I'm trying to deploy my .netcore app to docker my 2 frontend container are running my backend api fails with network related instance ...
0
votes
1answer
12 views

SQL Server Linked Server readonly as security measure

I've got a configuration with to separate VLANs. In one of te VLANs, a Microsoft SQL server is running and doing it's thing. I'd like to read (and only read) data from this server from the second VLAN....
0
votes
0answers
19 views

Where and how I can know the license's model of the software microsoft sql server 2014 standard?

Where and how I can know the license's model of the software microsoft sql server 2014 standard? (per Core/ Server + CAL)?, time left for the license? with powershell or sql commands for example?
0
votes
0answers
54 views

SQL Server 2019 installation fails with 'There was an error generating the XML document'

SQL Server 2019 installation fails with the 'Exit code was '-2068774911'. See log for possible error messages.' OS is a freshly installed Windows Server 2019, 10.0.17763 Examining the %programfiles%\...
0
votes
1answer
51 views

Ideal Server Deployment for Windows Server 2019 Active Directory, File Server, and SQL Server

So, we have new compliance regulations we're being required to meet and our current infrastructure isn't quite good enough to handle it. What we need is: 2 x Active Directory Domain Controllers, DNS, ...
0
votes
0answers
8 views

Sqlserver: maintenance-task fails

On one particular Sqlserver (2016) we have an issue with a maintenance task. The task consists of a single t-sql-statement: USE DbaUtils GO EXEC pDoSomething In about about 5% of executions, this job ...
0
votes
0answers
17 views

SQL Server Always On Availability Group Database Mirroring Certificate Zero Downtime Renewal Procedure?

Here I have a 2-node SQL Server 2016 AlwaysOn Availability Group cluster, with 1 primary and 1 secondary, and there are certificates that encrypt the traffic from node 1 -> node 2, and node 2 -> ...
3
votes
1answer
51 views

SQL Server Always On Availability Group Zero Downtime Update Procedure

Here I have a 2-node SQL Server 2016 AlwaysOn Availability Group cluster, with 1 primary and 1 secondary. The question is - what is the optimal way to install Microsoft Updates on the servers in the ...
0
votes
1answer
22 views

Connectivity aws → sqlserver AG global listener with dynamic ip

Having an app in aws with subnetworks mapped to onprem sqlserver single instance by ip; After sqlserver migration to 2 nodes AG I need to create rule for aws to access AG global listener which is ...
0
votes
0answers
77 views

2 SQL Server instances on a single machine: one can register an SPN, the other cannot

I have a Server 2019 machine that is running 2 instances of MS SQL Server. One is running as the default instance on port 1433 under the user NT Service\MSSQLSERVER. It successfully registers an SPN ...
1
vote
1answer
24 views

How can I grant rights to update ServicePrincipalName when I can't see that option in the list?

I'll happily close this if its a dumb question. I am trying to grant rights to SELF on an AD service (user) account for a MSSQL Server instance account. Problem is I cannot see the check box for Read ...
0
votes
1answer
30 views

Can SQL Server 2019 perform equally well under Linux and Windows (same hardware)?

We have recently installed SQL Server 2019 on a server, running Ubuntu 20.04 (server edition). Under our specific use case, executing integration testing against this SQL Server instance, it takes 2-3 ...
0
votes
1answer
448 views

I'm getting “The server response was: 5.7.57 SMTP” When using an Office365 hosted Email on my SQL Database Mail

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2021-02-01T13:38:08). Exception Message: Cannot send mails to mail server. (The SMTP ...
0
votes
1answer
114 views

Is possible to have multiple database users with db_owner permission on a SQL database?

I have setup a remote SQL server, which contains some databases. One user with certain login can create a database on server and after that can assign other users (each one with certain login) to new ...
0
votes
0answers
29 views

SQL Server Express - How to prohibit access from Domain Admins

Per comment suggestion, this question has been posed on this forum from Stackoverflow. I need a way to lock a SQL Server Express database that is deployed to a PC, which may or may not be on a domain. ...
0
votes
0answers
15 views

How to retreive publishing profile or certificate from azure in order to backup database

I'm attempting to backup my mssql 2014 DB using url method to an azure blob. However it requires either a certificate or publishing profile from azure. I do not know how to retrieve either. Can ...
0
votes
0answers
39 views

VSS Writer for SQL Server Continually Fails

On some of our SQL servers we are continually getting errors reported in Azure Recovery Vaults about the VSS writers failing. On the servers I am running "vss admin list writers" and it ...
0
votes
1answer
85 views

Cannot connect to local sql server while connected to a vpn and split tunnel is enabled

I'm trying to connect to my local sql server while vpn is connected but it throws an error saying 'The target principal name is incorrect. Cannot generate SSPI context. (.Net SqlClient Data Provider)'...
0
votes
0answers
14 views

SQL Issues with Draytek 2862

I switched from a Sonicwall TZ210 to a Draytek 2862 recently, I have port based 2 VLANS. VLAN1 - Main Office 192.168.1.1 VLAN2 - WIFI 192.168.2.1 They are not inter-lan linking as they need to be kept ...
1
vote
1answer
26 views

Need PowerShell function to pick up existing folder which is changing on server reboots

I have one requirement in PowerShell that whenever server restarts we get new folder like "50d6f41f80668b6e3bd635dd78175527" in specific location, the same file we use in below piece of code ...
0
votes
0answers
16 views

Console Window Host High CPU on SQL Server

Recently we started having really high CPU usage on all our SQL servers. A reboot will repair this issue but only for about 24 hours then CPU ends up pegged at 100% again until we reboot it again. ...
0
votes
2answers
160 views

Microsoft OLE DB Driver connection string for RDS High Availability

I need to configure RDS Farm High Availability based on Windows Server 2016 with MS SQL Server 2016. One of the steps is connect to database. All available guides tell me to use SQL Server Native ...
0
votes
1answer
20 views

Where to view server logs for cases when SQL Server cannot provide concurrent connections

Our SQL Server DB is load-heavy and there are certain instances where the server cannot provide more connections to applications. We are currently suffering from logouts and there are suspicions that ...
0
votes
1answer
53 views

Which is my SQL server name for connecting to the online database by SSMS?

I created a database 'dbDemo' (MS SQL Server 2012) by Plesk on Google Cloud Platform and for connecting to this database from another local machine I changed the TCP Port 1433 on my online server ...
1
vote
0answers
41 views

Use HTTP/2 together with PHP SQLSRV extensions?

I have a web site (Apache/2.4.46, HTTPS) using PHP7.3, MariaDb 10.4, MSSQL for Linux (mcr.microsoft.com/mssql/server:2019-latest), running on a Debian 10 server. My setup works perfectly using HTTP/1....
0
votes
0answers
11 views

Connecting to azure sql vm using site to site connectivity

I'm having issues connecting to mssql db on an azure sql vm from my on premise network using azure vpn. I've established a successful policy-based connection to the azure gateway, and created a dns ...
0
votes
0answers
19 views

MySQL workbench database import from Azure SQL

I am currently trying to use the MySQL Workbench migration wizard to import a database located on an Azure SQL Managed instance to an on-premise MySQL server, but i have an issue with the wizard: it ...
0
votes
1answer
26 views

SQL Server CPU getting pegged after day or two of uptime

I have a few SQL Server 2016 servers on Windows Server 2016. Lately they've begun having major slowdown issues with the CPU being pegged. If I reboot it resolves the problem but over the next 24-48 ...
0
votes
0answers
293 views

Zabbix MSSQL Monitoring - Failed: cannot extract value from json by path

I already create new host on zabbix 5.0 LTS For monitoring SQL Server (2012). I using default template from zabbix (Template DB MSSQL by ODBC). this macros I set on host {$MSSQL.DSN} => devdb {$...
0
votes
0answers
23 views

Sqlserver on GCP : How to assign sqlserver agent roles to an user?

Looks like default admin user doesn't have permissions to create an user in msdb. Tried creating a user in msdb (both with ssms and EXEC sp_adduser) but user doesn't have required permissions. Below ...
0
votes
0answers
18 views

SQL Server on Ubuntu - backups best practices?

I've installed MS SQL Express on an Ubuntu VPS, after moving from a shared hosting windows plan for a low traffic .net core site. What is the best practices to backup the databases? I'm currently ...
1
vote
1answer
689 views

pecl: command not found when trying to install PHP SQL Server driver

I need to be able to access MSSQL databases from PHP and I'm trying to activate the driver to do so, since mssql php natively was removed after PHP 5.6. Here's what I tried: sudo su curl https://...
1
vote
1answer
108 views

Adding RAM to SQL server ruins performance

Current setup: We have a very large table that has a bigint pk and a nvarchar(1025) field. The only index is the PK. We have another table that is a bigint_fk to the first table with a checksum of ...
3
votes
1answer
168 views

How do you check/start SQL browser service under linux?

I have just installed MS-SQL 2019 under Ubuntu 20.04 (the first time I have installed this Db under linux). I opened up port 1433 and can connect to it via the server IP address with Management studio ...
0
votes
1answer
835 views

“An existing connection was forcibly closed by the remote host” when trying to connect to azure sql server

I'm trying to deploy a SQL database to my azure SQL server. When I'm trying to connect to my target server, I get the error listed below. I'm using Microsoft SQL Server management studio 18 with ...

1
2 3 4 5
94