2022 Developer Survey is open! Take survey.

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

SQL Server 2014 enterprise edition suddenly stop accepting the connections

We are seeing that our server will suddenly stop accepting new connection from SQL Server. The server itself is still accessible via RDP, but sharepoint portal/SSMS and any other remote SQL connection ...
user avatar
  • 1
0 votes
0 answers
25 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
0 votes
0 answers
18 views

AWS RDS Mysql 8.0 instance tables appear to be deleted

I connect to the production database and launch "SHOW TABLES" command, and the response is "Empty set". I never launch a DROP table command on this database. Database log shows ...
user avatar
-1 votes
0 answers
55 views

Connecting to a DB server using telnet

I have a db server that can only be accessed by from another server[cant access it from my local device] and the DB server can only be accessed using telnet, SSH is not supported by the DB server. My ...
user avatar
  • 1
0 votes
3 answers
28 views

Mariadb legacy support

I have old version of php site, which uses unescaped 'row_number' column number in its sql queries. It seems in the new version of mariadb there has been new function called "row_number()" ...
user avatar
  • 131
0 votes
1 answer
27 views

Why my simple searching query is too slow?

I don't know why searching in my "cities" table is so slow. My query looking for a table "cities" located about 25km from the city. I use this simple query and the database takes ...
user avatar
0 votes
0 answers
27 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
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
0 votes
1 answer
24 views

Can I move my encryption key (used for SQL always encrypted) from a key vault in one Azure tenant to another?

We have migrated a database (backup to .bacpac and restore to the new tenant) but the database was encrypted using always encrypted and the key is stored in the original tenant's key vault. I can look ...
user avatar
1 vote
2 answers
53 views

restrict access to a specific URL with .htaccess

Hello i am running server with xenforo. i would like to know how can i restrict url from .htaccess. Url is : https://mywebiste.com/index.php?members/find&q=oi%5Bp%5C&_xfRequestUri=%2Findex.php%...
user avatar
  • 13
0 votes
0 answers
24 views

How does dovecot performs the hash comparison process without using salt in password

I got a mail server using dovecot, postfix with mysql I insert an email user through the following sql statement: insert into users(email, password) values('dave@example.com',ENCRYPT('secret')) ...
user avatar
0 votes
0 answers
73 views

How do I use the pgpass.conf file to allow promptless connection to a database

for testing purposes I have a postgres service/database running on my local computer. Right now I am using a batch file to change default userlogin, but I cannot use SET PGPASSWORD to pass along a ...
user avatar
1 vote
1 answer
42 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
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
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
1 vote
1 answer
110 views

How to create a new user with sysadmin privilege in Azure SQL Server?

I need to create a new user with sysadmin privilege. I went to the Azure portal > Query Editor. Then I run this commands. Unfortunately I got this error: Any help is welcome.
user avatar
0 votes
0 answers
16 views

Export "Failed to export: Internal error encountered."

I am receiving an error when trying to export and save a query to a CSV (Google Drive) sheet. The error "Failed to export: Internal error encountered."
user avatar
1 vote
1 answer
52 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
2 answers
793 views

Why can't I grant select privileges to all table in schema with PostgreSQL?

I have a database my_database, and it have some tables named my_table_1, my_table_2, ... , my_table_128 under schema public. I need to grant select privileges for all tables in schema public to user ...
user avatar
  • 145
0 votes
1 answer
45 views

I have a sql server with a pictures table with 25 million entries and it has become too slow to query. currently have a xeon E5-2667v3 with 32g of ram [duplicate]

I have a sql server with a pictures table with 25 million entries and it has become too slow to query i currently have a Xeon E5-2667v3 with 32g of ram, I am looking to get a hp ProLiant Gen 9 and I ...
user avatar
  • 9
1 vote
0 answers
76 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
2 votes
1 answer
157 views

MYSQL is at 197% CPU usage ~ not allowing site to run

Spec: 8 GB memory / 4 vCPUs / 25 GB ssd Ubuntu 20.04 My website got hit with a DDoS recently and had this continuous high CPU usage error for 4 days and the site will not load up, I take a look using ...
user avatar
0 votes
0 answers
66 views

Extracting encoded SQL attack statements from IIS/Apache Logs

I'm working on a cybersecurity application and one of its features is machine learning to detect SQL injection attacks. I'm in the research phase right now and I'm looking at data collection and ...
user avatar
  • 101
0 votes
1 answer
30 views

SQL Server 2016 Log Shipping and Transaction Replication

Good Morning, I have a SQL Server 2016 that is doing Log Shipping to a DR Site. I currently want to also to Replicate (Transactional) specific Tables to another Server for Reporting Purposes. Will ...
user avatar
0 votes
1 answer
2k views

Error 258 when connecting to sql server instance over the network

Can't connect to a sql server instance over the network, and all SSMS gives me is a 258 error. Everything is supposed to be correct. Both machines are inside a domain and the user was added to the ...
user avatar
0 votes
1 answer
208 views

sp_send_dbmail succeding but sometimes failing

Also posted in Stack Overflow. Any feed back would be much appreciated. I have a need for a SQL job to send multiple emails, and I have come across this error that I am unable to find any solutions ...
user avatar
  • 1
0 votes
1 answer
49 views

Rolling Backups of .sql files

I'm having a bunch of docker-containers containing different databases. For every container there is a Jenkins-Job which performs a daily backup of the database as a .sql-file and then zips this file. ...
user avatar
0 votes
0 answers
28 views

Oracle SQL command without input prompt

In Oracle Database I need to execute SQL command RECOVER DATABASE UNTIL CANCEL BACKUP CONTROLFILE;. After that I got input prompt. I should enter CANCEL. Is there a way to enter only one command with ...
user avatar
  • 1
0 votes
1 answer
26 views

SQL Converting strings to date [closed]

this has really baffled me for a few days and am seeking help. I am using SQL Server 2017. I am trying to handle strings from a free format field and either convert them to a date in the format of &...
user avatar
0 votes
0 answers
57 views

SQLCMD CMD Line Tools Fails install

I recently installed the most recent version of SQL CMD Line Tools. I installed it using these directions. I ran the following command to make sure the module is installed: Get-Module -ListAvailable -...
user avatar
  • 761
0 votes
1 answer
33 views

Logparser - Selecting data in the past 2 weeks

I am trying to use LogParser to return the data from my iis log files for the past 2 weeks. When I run the following I get "Error: Syntax Error: : no valid content: expecting opening parenthesis ...
user avatar
0 votes
0 answers
121 views

Connection string for my SQL Server connection from C on Linux

I am trying to connect to SQL Server using C program on Linux. My connection string is this: DRIVER = {ODBC Driver 17 for SQL Server}; Server = 192.168.0.25,52000;Database = db; UID = ud, PWD = pw; ...
user avatar
0 votes
1 answer
46 views

SQL server connection TCP/IP overt Ethernet [closed]

I have two PCs. There is SQL Express installed on one of them. TCP/IP settins are here: tcp/ip settings tcp/ip settings When I perform Test-NetConnection on local computer I get But when I do it ...
user avatar
-1 votes
1 answer
61 views

Users and Roles Extraction in Oracle

I've tried to write a query to have a users/roles extraction, i don't have much SQL skills as well as on oracle, so I started with this: SELECT A.GRANTEE, A.GRANTED_ROLE, B.ACCOUNT_STATUS FROM ...
user avatar
0 votes
1 answer
122 views

repmgr for streaming replication - standby register

I'm testing repmgr tool and I'm a little bit confused. Everything's fine until standby register step. What should I have configured on standby server? From docs I assumed that standby should't have ...
user avatar
  • 487
0 votes
0 answers
22 views

Has anyone here tried using ZWAMP as a dedicated SQL instance for long-term data collection?

By "ZWAMP", I mean this product, especially its MySQL implementation. What I'm really aiming to learn here are the inherent, hardware independent, data storage size, complexity, and duration ...
user avatar
0 votes
2 answers
123 views

How does Google Cloud Platform handle database backups with --async flag?

I'm currently working on adding an extra step to our companies CI/CD pipeline so we make backups of the database before making a deployment that could potentially run migrations on our database. To ...
user avatar
0 votes
0 answers
64 views

Some Google Cloud SQL Authorized Network IPs do not work?

I use Google Cloud SQL for my databases. It's connected to my website and working just fine, but I also authorized my local computer to access the Database via Sequel Pro. But for today, I went to my ...
user avatar
0 votes
1 answer
59 views

Error code ElasticPoolOverStorageUsage

I'm trying to create a new database in our Azure SQL elastic pool and getting the following error code. Error code: ElasticPoolOverStorageUsage. We have a total space of 32GB and based on the ...
user avatar
  • 1
0 votes
1 answer
22 views

How to best setup SQL 2019 with 6 drives?

SQL 2019; Dell R710 2x2.93 GHz x5670; 144 GB RAM; 6 - 2 TB drives Derived from a previous question (posted here 10 years ago), I figure 3 x RAID 1 is the best way to go. Please correct me if I am ...
user avatar
0 votes
1 answer
46 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 ...
user avatar
0 votes
1 answer
87 views

Accessing SQL Server Remotely - Connection fails when attempting to connect with new external domain

The Scenario is: Right now, we can remotely access SQL server using SSMS or a ODBC connection using the SQL driver. We are currently using sql1.mydomain.com We are switching to sql2.mydomain.com. When ...
user avatar
0 votes
1 answer
176 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.
user avatar
  • 1
0 votes
1 answer
64 views

creation of sql database impossible

When trying to create a SQL database in the Azure Cloud I always get a validation error. Neither the database nor the database server are created as result. I have no clue about the reason for this. ...
user avatar
0 votes
1 answer
294 views

Cluster network name blank in SQL cluster node configuration (setup exit with “Error code 0x84C00001”)

I created 2 nodes fail over Microsoft cluster Windows 2016. On the node 1 an SQL 2014 server clustered has been installed, the new role is working and is online in the cluster management console. Now ...
user avatar
0 votes
1 answer
76 views

Unable To Access SSAS via MSMDPump File and URL

I had this same issue when trying to connect to SSAS via a MSMDPump file, as stated in this article. String reference not set to an instance of a String. Parameter name: s (mscorlib) I got the ...
user avatar
0 votes
2 answers
718 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 ...
user avatar
  • 13
0 votes
1 answer
2k 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 ...
user avatar

1
2 3 4 5
26