Questions tagged [sql]

Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [mysql], [postgres], [mssql], or [oracle].

Filter by
Sorted by
Tagged with
0
votes
1answer
23 views

Cannot set SQL_MODE to Mysql 8

I have to set a persistent custom SQL MODE persistent to my server. I added this line in /etc/mysql/mysql.conf.d/mysqld.cnf [mysqld] ... sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,...
-2
votes
0answers
12 views

Getting a TLS 70 error on Windows 2012 Server, all of the sudden [closed]

Every thing has been working fine up till about 3 days ago. I cannot think of any changes that were made. however since 3 days ago. the Server seems to get this error " a fatal alert was received ...
2
votes
1answer
39 views

Change retention time for backup in Azure SQL Database

is there any way to change retention time for backup in Azure SQL? For example, there is some backup with retention time for 1 month and I want to change retention time for that backup for 1 year, is ...
-1
votes
1answer
24 views

Why SQL query does not work with subquery but works with comma seperated list? [closed]

I have query: SELECT p.[id], p.[page_file], p.[page_header], p.[page_icon] FROM [dbo].[setup_pages] AS p WHERE CONVERT(nvarchar(100),p.[id]) IN ( SELECT l.[access] FROM [dbo].[licenses] AS l ) ...
0
votes
0answers
30 views

how to hide server structure (hdd) in sql server 2017 from non admin users

In sql server 2017 i have create users but when they tray to restore database they can see hdd structure but cannot restore anything because don't have privilege, how to deny see even hdd structure ...
0
votes
0answers
17 views

Azure security center recommendation: Perform volume maintenance tasks is set to Administrators

I'm working through the Azure Security Center recommendations for ISO 27001 and have a recommendation to ensure that 'Perform volume maintenance tasks' is set to 'Administrators' The problem with ...
0
votes
1answer
91 views

How to take backup of 500GB SQL database data?

We tried to copy 500GB data to local drive using copy option in SQL management studio but it getting failed after 2 or 3 hours...is there any size limitation to copy? How much size script file should ...
0
votes
0answers
18 views

How to connect to Azure SQL database from SSRS using integrated authentication

Could you please share the steps or documentation links for configuring SSRS reports in an Azure virtual machine to Azure SQL database using Windows / network account? The Azure VM is domain joined ...
0
votes
0answers
6 views

Monitor performance of IIS UrlRewrite Extensibility Sample SQL Custom Rewrite Provider

I've implemented the SQL provider from IIS UrlRewrite Extensibility Samples and it seems to work well, but I'm wondering about the performance impact of IIS calling a stored procedure on an Azure SQL ...
0
votes
0answers
23 views

SQL Database on Azure is slow to datacenter, but fast to desktop?

We're hosting our app's development databases in Azure -- east region. From Pittsburgh, my office and home workstations interact with this database without any performance issues. Our testing web ...
0
votes
0answers
14 views

Why Can't I Access my Azure Resource Group for SQL Database?

I have been trying to access my Azure Resource Group for SQL Database without success for the past 3 days. Each time I try to access it, I'm being asked to sign up for a free account and when I try to ...
0
votes
0answers
10 views

Add custom from display name on Postfix+Dovecot+SQL

I have Postfix+Dovecot+SQL mail server on Debian. I'm trying to get the display name from the database (if available) and insert it by default to From: __display_name_here__ <username@domain.com>...
0
votes
1answer
30 views

sql injection “Slep”

how to determine ip address or url address logs ? i have this in my mysql-slow-query /usr/sbin/mysqld, Version: 5.5.62-0ubuntu0.14.04.1-log ((Ubuntu)). started with: Tcp port: 3306 Unix socket: /...
2
votes
1answer
43 views

SQLite works, but PostgreSQL migrated database causes ERROR - Django 3.0

Situation I have built Django 3.0 project with a couple of applications. I have created the accounts app based on following course and it's github Than I have created an application fro ...
0
votes
2answers
246 views

AWS RDS to PgAdmin Error saving properties Unable to connect to server: timeout expired

Short description: AWS RDS connecting server to PgAdmin 4, PostgreSQL 11 Done: I have done similar to this guy or to this aws guide but at the end when I click save it does not accept it for me. ...
0
votes
1answer
92 views

XAMPP on Catalina - Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' [closed]

i installed xampp to make a local website. i finished the website and tried to export the db to switch to production and i noticed that the DB in php my admin seemed to be empty ( which couldn't be ...
4
votes
1answer
2k views

Error creating Sql Server in Azure this location is not available for subscription

Im trying to create Sql Database resource and any location i select i get: "this location is not available for subscription" Im trying to create WebAPP with Database. Plan is pay as you go
2
votes
2answers
31 views

Decreasing OS drive free space on Azure VM running SQL Server 2016

Recently I noticed that drive C: is decreasing in free space on my Azure VM running Windows Sql Server 2016 (doing daily azure VM backups in Recovery Services Vault). Drive C: keeps adding 100-250mb ...
0
votes
2answers
66 views

Is it safe to have virtual memory in servers?

I'm not sure if it's safe to have virtual memory (pagefile.sys) in servers? Safe in the sense of: Would it affect the data in the cache that is being handled by RAM? Does it conflict if it will be ...
0
votes
0answers
20 views

No connection to SQL Availability Group via Azure ILB IP Address from other subnet

I have 2 subnets in my vnet, where the SQL AG is placed in the inside subnet. Also configured an azure (private) internal load balancer within this subnet. I can connect to AG via SSMS within this ...
0
votes
0answers
44 views

Azure SQL bacpac import job stuck - timeout on it?

Got some issues with a stuck azure sql bacpac import preventing me from importing the bacpac again to the database with the same name. The file is being pulled in from an Azure storage account. I ...
1
vote
0answers
27 views

AWS Performance Insight Huge Load from “Other” SQL

Engine: MySQL 5.7.26 Looking at my AWS Performance Insight metrics, I noticed that most of my Database load consumes the query marked "Other" Can I check what is hidden under this label? Screenshot:
0
votes
0answers
7 views

New Azure VM from custom Image adds a SQL Login for the Administrator User

I have a custom Azure Image, which originated from Microsofts SQL Server 2016 SP2 on Windows Server 2016 Image. It was originally created with SQL Authentication enabled. This created a SQL Login for ...
0
votes
0answers
32 views

Trying to figure out long run times with sqooping jobs (sql server to hadoop)

I inherited a new customer as a sql server dba and they are using some java-based framework that has a jdbc connection from sql server to hadoop. They have a sqooping job that runs once a day to do ...
0
votes
0answers
32 views

PostgreSQL service is constantly shutting down

I have a postgresql 11 database. I use Windows 10 OS. After my computer falls asleep I often have to manually turn on the service.Tell me maybe someone met such a problem.I'll be greateful for any ...
1
vote
1answer
130 views

Can't go back to root from postgres: forces to enter postgres password which it finds invalid

I've installed postgres on Ubuntu and it switched me to postgres user. I've opened psql created a database and then decided to switch back to root. However, it doesn't allow me: sudo su - results ...
-1
votes
1answer
38 views

how to choose server that can handle about 1 or 2 million visit of my website [duplicate]

I am building website using Angular and .net core, some modules will be written in python I have searched on hosting specs and know the difference between them and I am comfortable for dedicated ...
0
votes
1answer
33 views

Autotask PSA SQL query errors

We paid $150 to Autotask (now Datto) for a backup / export of our PSA data which they provided in the format of a .BAK file which is an SQL database. We need to extract data from the Autotask PSA ...
0
votes
0answers
24 views

SQL Sever on Azure using AD Authentication Integrated

I have created SQL Server on Azure and downloaded SQL Server Management Studio on my person laptop. If i want to login to to SSMS on my laptop, i am using SQL Server Auth, entering user id and ...
0
votes
1answer
25 views

Running VACUUM on all tables matching a certain condition

I have are large-ish database which consists of 100+ tables. A few of these tables are so big that running VACUUM on them takes a couple of hours, so I don't want to run it on these tables. Is there ...
0
votes
0answers
20 views

Can't run new Galera Cluster

I'm trying to run a new Galera Cluster on my local machine. I'm using CentOS 7 on Parallels Desktop. I followed all the instruction to bootstrap a new cluster but I keep getting this: MariaDB [(none)]...
0
votes
1answer
39 views

1364 - Field 'aim' doesn't have a default value

1364 - Field 'aim' doesn't have a default value Query: INSERT INTO mybb_users (`username`,`password`,`salt`,`loginkey`,`email`,`postnum`,`threadnum`,`avatar`,`avatartype`,`usergroup`,`...
0
votes
2answers
39 views

is it safe to port forward SQL server to whitelisted IP

I need to access an SQL server behind a router from an AWS EC2 instance. Is it reasonably safe to open a port on the router if I am white listing the IP of the EC2 instance? If there is a best ...
0
votes
5answers
3k views

How to protect Apache server from SQL injection [closed]

Without going into the platform underneath, is there any effective way to protect a web server from SQL injection? Any special Apache module or config? Would fail2ban be appropriate here?
0
votes
1answer
151 views

How to add new login for Microsoft SQL Server for all domain users

I would like to add MYDOMIAN\domain_users as new login in MS SQL 2012. So I create new login, choose mMYDOMAIN as localization but here I don't have option to add all domain users, I can only ...
0
votes
0answers
45 views

Connect from Azure SQL database to server behind firewall

I'm looking for a way to connect from Azure SQL Database to an on premise SQL server that runs behind a firewall. Creating the external data source is not a problem when the firewall is disabled, but ...
0
votes
0answers
171 views

Why does SQL Server keep creating the folder “C:\Program Files\Microsoft SQL Server\” when installing on another driver?

I specified a different drive wherever applicable during the SQL Server 2017 install. However, the directory C:\Program Files\Microsoft SQL Server keeps getting created. I basically have the expected ...
0
votes
0answers
22 views

MS SQL Server for Linux: Freeze user account after X failed login attempts?

I want to set up MS SQL Server for Linux on an Ubuntu 16.04 server and for security reasons would like to configure things so that database user accounts get frozen after X (lets say 10) failed login ...
0
votes
0answers
185 views

SSRS - Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host

I have this error message: enter image description here It's intermittent and calls a SSRS report, now if I run the same product at the Server works properly. My environment is SQL Server 2017 under ...
1
vote
0answers
1k views

WSUS mmc keep crashing

I have WSUS that use MS SQL 2012 as database. Updates are stored locally on WSUS server, since we have limited Internet bandwidth. All update classes are synced from Microsoft, except drivers and new ...
2
votes
2answers
333 views

MySQL using ridiculous amount of memory to import 1-2GB SQL files

I have a MySQL server running on an Ubuntu 18.04 machine via Docker. The machine has 32 GB of RAM. I have about 300 1-2GB SQL files which need importing into a database on the server, into a single ...
7
votes
3answers
1k views

Is a MySQL database a viable alternative to LDAP?

(Apologies if I'm asking the wrong kind of question or in the wrong place.) We run IT for our association (all volunteers). We have got a server with member database in OpenLDAP, mail server, ftp and ...
1
vote
0answers
231 views

Query Failed: Lost connection to MySQL server during query (Remote connection stable issues)

i've been reading a lot about this and didin't find any solution, that's why i am creating this topic. First im going to give you my dedicated server specifications root@...
0
votes
1answer
47 views

Cloned Server Cannot connect to SQL Server 2017 Instance

I just recently cloned a dev server from a production Microsoft Dynamics 365 server having SQL Server 2017 installed on it. Now when I log in to the dev Server and to SQL Server via the SSMS I am ...
0
votes
1answer
42 views

How to connect Azure Database migration service with on premise based source SQL server

I am trying to connect Azure Database migration service with SQL server which is in On premise VPN. Not able to establish the connection.
5
votes
3answers
854 views

Boot Windows from SAN

Am not so familiar with Storage. I have some questions around running Physical and Virtual Machines with SAN for Storage. Is it possible to boot OS from a SAN Storage attached to a Physical Server? ...
0
votes
0answers
136 views

Dovecot/Postfix Error: connect failed to database

I have a question and I hope you can help. I have an email server setup and running. A few days ago the following updates were installed: 2019-08-15 22:23:40 upgrade php-common:all 2:69+0~...
0
votes
0answers
200 views

SQL Server Username Length

I have a SQL Server 2008 running on Windows Server 2008. The database handles spatial data. I have a select group of users that are unable to use their domain accounts when working in the database as ...
0
votes
1answer
57 views

Microsoft Azure SQL Server with Single Database

I have created a Single SQL Database and a SQL Server on Microsoft Azure with a Basic Plant of MAX 2GB. Now I want to create another SQL Database of MAX Size 2GB. Can I create another SQL Database ...
0
votes
2answers
101 views

Automaticaly restoring SQL replication after power outage

I have two Sql databases, "MASTER" and "SLAVE", and I use Sql replication to get them synchronized. I'm using MariaDB 10 on both databases. The MASTER database is installed on a linux PLC using Docker....

1
2 3 4 5
25