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].
1,294
questions
-1
votes
0
answers
27
views
SQL Always On cluster issue after servers restored from backup
I have an issue with a SQL Always On cluster after servers were restored from backup due to a security incident.
The database servers environment report that cluster computer accounts still exist, are ...
- 1
0
votes
0
answers
13
views
Initial patch install checking via SCCM query
I want to make a better query for Windows Server OS patching (2016 & 2019). The one listed below is what I wrote that my company currently uses. If a newly built servers OS install time is ...
- 101
166
votes
10
answers
440k
views
GRANT SELECT to all tables in postgresql
Is there a one-liner that grants the SELECT permissions to a new user postgresql?
Something that would implement the following pseudo-code:
GRANT SELECT ON TABLE * TO my_new_user;
1
vote
2
answers
4k
views
SQL Server 2012 Native Client returns missing DLL error on install
OS: Windows 7 Pro SP1
Whenever I try to install the SQL Server 2012 Native Client x64 the install process gets to the end, the "removing backup files" stage then throws up this error:
"There is a ...
CommunityBot
- 1
32
votes
11
answers
21k
views
To improve SQL performance, why not just put lots of RAM rather than having faster hard disks?
People keep telling me that in order to improve an SQL server's performance, buy the fastest hard disks possible with RAID 5, etc.
So I was thinking, instead of spending all the money for RAID&...
- 50.6k
4
votes
1
answer
2k
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 ...
- 11
0
votes
0
answers
15
views
Microsoft Configuration Manager Issue
I cannot join the primary site to an existing hierarchy while installing Microsoft Configuration Manager. SQL and the SCCM Server are connected. Am I doing something wrong?
Problem with Configuration ...
-1
votes
2
answers
196
views
SQL is not showing up when trying to connect to it via odbc from a client computer after migrating database to a new server
I installed SQL 2012 on a new Server 2022 vm and restored a database on the new server from a SQL generated backup. The new SQLserver/instance is not showing up in the Odbc client on a windows client.
...
- 16
0
votes
1
answer
34
views
Unable to install Nectari's BILicense Server software on Windows Server
Trying to install the BILicense Service for Sage X3 SEI (Sage Enterprise Intelligence) on a Windows 2019 server. This is a prerequisite before installing SEI for Sage X3. Straight out of the gate it ...
- 21
0
votes
1
answer
37
views
Microsoft Configuration Manager Server Sharing
I have my SCCM Server connected to the SQL Server via ESXI through two different VM's. I have Microsoft Configuration Manager on my SCCM trying to get it connected to the SQL Server. How do I connect ...
- 2,594
0
votes
1
answer
1k
views
How best to allow SQL Agent Jobs to be edited and run by a team of developers, without handing out Sysadmin rights?
I'm trying to find or devise a way to allow a team of developers to be able to amend SQL Agent Job steps and schedules, but that doesn't involve Sysadmin rights for the devs. As I can't assign ...
- 183
-1
votes
1
answer
31
views
How do I point my SQL Server VM to my SCCM Server VM?
WMI Provider Error: Access is denied. [0x80070005]
I cannot connect the SQL Server to the SCCM Server with two seperate VM's.
I have two VM's on my ESXI Host. I am trying to point one VM to another. ...
- 2,594
0
votes
2
answers
540
views
SQL Server Services won't start and database engine can't be accessed
So my SQL server can't be connected to after the computer crashed while connecting to it over RDP. The MSSQLSERVER, UALSVC and MSSQL$SQLEXPRESS services are all set to automatic (the ualsvc is set to ...
- 1
0
votes
0
answers
66
views
How to properly use MediaWiki with $wgDBadminuser?
I have to set up a fresh MediaWiki and am getting increasingly upset with config recommendations that don't seem to work well when configured as outlined in the official documentation.
Two servers. ...
- 101
0
votes
1
answer
195
views
MySQL Update Statement taking long time to update small table with 4 rows
I've got a ridiculously small table in MySQL that consists of four rows of data. Updating this table is taking a long time, often upwards of 50 seconds.
CREATE TABLE log_CacheQueueEntity
( ID int(11)...
- 1,511
1
vote
3
answers
318
views
MySQL Monitoring - Cloud Instances - No System Access
Are there any MySQL monitoring suites/tools built to use on systems such as Amazon RDS where you do not have system access? Looking for something beyond custom tools (nagios, zenoss, ganglia, hyperic)...
- 601
3
votes
2
answers
14k
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 ...
CommunityBot
- 1
0
votes
1
answer
106
views
MS SQL How Attach a duplicate database
I only have a single Microsoft SQL server, i have a database lets call it DB1, I recovered the DB1.mfd and DB1_log.ldf file and saved it in a different location on the same server. Now when i try to ...
- 51.9k
2
votes
2
answers
46k
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. ...
- 2,318
0
votes
2
answers
183
views
Set SPN To SQL With NT AUthority
I am trying to add SPN entries for my SQL server but SQL server is running under an NT Authority account like SYSTEM or LOCAL SERVICE.
When I put in the setspn code it says it can't find the user. Is ...
- 835
0
votes
0
answers
316
views
SSMS 19 issue with AWS RDS
still pretty new to SQL administration so please bear with me. We recently updated to SQL Server Management Studio 19 and have been running into issues.
The long and short of it is I am trying to get ...
- 141
0
votes
1
answer
69
views
Server running MS SQL getting login request from another server every minute
I have a Windows Server 2016 virtual machine running IIS 10 and MS SQL Server 2016. Every minute I'm getting a "Login failed for user" message in the event log. Sometimes 3 times per minute. ...
- 736
0
votes
0
answers
28
views
WSUSUTIL SQL Database Gives Multiple Errors
I have a secure connection setup for WSUS and I am trying to connect to my SQL SUSDB. When I do that I have tried multiple connections and it has given me the following for each:
SERVER.DOMAIN.NET,...
- 835
0
votes
0
answers
30
views
What's the ODBC SparkSQL Source Format for Connecting with PHP ODBC & Spark?
What's the ODBC SparkSQL Source Format for Connecting with PHP ODBC & Spark?
Here's the code I need to edit:
$conn = odbc_pconnect("CData ODBC SparkSQL Source","user","...
- 1
0
votes
2
answers
513
views
Cannot login to SQL with active directory or SQL authentication
Im installing SQL reporting services. After installation, the databases was created correctly and have the user permissions assigned.
A login domain\reportaccount is also created.
The problem is when ...
- 1
1
vote
1
answer
60
views
SQL Server Management Studio 2019 save to CSV and then import it after test
I'm fairly new to SQL, and I'd like to do some quick testing.
I'm about to update a field in 81 records in a table. After each test, I'd like to get back where I started. I've saved off my query ...
- 51.9k
2
votes
1
answer
4k
views
Cannot generate SSPI context SQL Server 2016
First post here :)
I've been trying to connect to a SQL server 2016 in a pc using SSMS 2016, both EXPRESS editions.
Server shows up in Network Servers window.
I'm trying to connect with HOSTNAME\...
CommunityBot
- 1
10
votes
6
answers
19k
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,...
- 111
0
votes
0
answers
131
views
SQL DB failing to send server email - intermittent
Recently, we noticed an issue in SASS 2014 logs regarding the failure of some emails to send:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using ...
0
votes
0
answers
228
views
could not load private key asn.1 decoding failure Navicat
I have a Problem with my Navicat when i want to connect with a SSh-Key to our Company Servers i cant because Navicat give the folloing Error: could not load private key asn.1 decoding failure
Has ...
-1
votes
1
answer
631
views
Mysql server eating all RAM (100GB) when load is running
I am using Mysql - Server version: 8.0.29 MySQL Community Server - GPL
My server has 100GB RAM.
Of it I allocated innodb_buffer_pool_size as 90 GB
SET GLOBAL innodb_buffer_pool_size = 96636764160;
I ...
- 2,558
0
votes
0
answers
2k
views
Getting an error in SQL Server 2019: The certificate chain was issued by an authority that is not trusted
I've enabled "Encrypt connection"
I've enabled "Trust server certificate"
I've added the TrustServerCertificate=true to my connection string
I've confirmed the service is running - ...
16
votes
9
answers
58k
views
Where are credentials for SQL Management Studio saved?
When we logged into SQL Management Studio(using Server Name, Login and Password) with checked "Remember Password". I need to know, where it save in PC.
I need to format my PC. And when we install SQL ...
- 271
4
votes
3
answers
9k
views
Is it possible to get a list of all jobs that access a database in SQL server?
Is it possible to get a list of all jobs that access a database in SQL? I can't figure a way to do this. I can get a list of all jobs but not what dbs they access.
Thanks
-1
votes
1
answer
111
views
Anybody familiar with the Shoretel database?
I have a copy of the local db from our old shoretel voip system... which is no longer in service.
I've been tasked with trying to locate information pertaining to calls to and from specific numbers ...
- 5,932
1
vote
1
answer
1k
views
How likely is a Split Brain situation when dealing with Galera clusters?
Assuming I have a server setup where a quorum vote is always satisfied, how likely will a Split Brain situation occur with Galera? My understanding is Galera does its best to avoid it, but does that ...
- 2,558
135
votes
4
answers
386k
views
Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?
I'm trying to grant all privileges on all tables of a given database to a new postgres user (not the owner). It seems that GRANT ALL PRIVILEGES ON DATABASE my_db TO new_user; does not do that. After ...
0
votes
0
answers
86
views
Configure xenforo 1.2.9 Using phpmyadmin 4.x with php 5.6.4 on IIS 10, Windows Server 2019
Versions/Programs:
xenforo 1.2.9, phpmyadmin 4.x, php 5.6.4, MySQL 8.0.32 IIS 10, Windows Server 2019
I am trying to host a local server for tinkering on an old computer I have. This server will be ...
- 1
147
votes
9
answers
251k
views
How to dump a Microsoft SQL Server database to a SQL script?
Is there any way to export a Microsoft SQL Server database to a SQL script?
I'm looking for something which behaves similarly to mysqldump, taking a database name, and producing a single script which ...
- 181
0
votes
1
answer
102
views
Secure SQL Server and other traffic with end to end security
All,
I am wondering if there are any best practices or ways that I can open up secure access to a service such as (for example) SQL Server, or any other program normally requiring a port to be opened ...
- 186
0
votes
0
answers
266
views
WSB Not Working
Trying to get WSB working on a server running SQL. The current setup is this.
Server OS is 2019
Backup target is an iSCSI target configured on a NAS, its setup as a local drive on the server
Backups ...
- 71
0
votes
0
answers
35
views
SQL Server Logical Reads increased 10x in past week
I'm not an SQL DBA by any serious standard but I am trying to figure out why the logical reads have gone bonkers on a DB I have for a line of business app.
the image below shows a 10 x increase in ...
- 1
1
vote
1
answer
2k
views
SQL Server: "This filegroup cannot be used as a backup destination" error when attempting restore
When running a command like the following:
"RESTORE FILELISTONLY FROM DISK='\\\\server\\folder\\DummyDB.bak'"
I'm getting this error:
Backup destination "\\server" supports a FILESTREAM filegroup. ...
CommunityBot
- 1
0
votes
0
answers
148
views
GCloud SQL timed out on a Docker container
I have a flask app in a Paperspace Deployment Docker container. It is connected to a Google Cloud SQL (MySQL).
Here are the variables in the YALM parameters:
env:
- name: CLOUD_SQL_CONNECTION_NAME
...
0
votes
1
answer
1k
views
Cannot connect to sql server from vpn client
I have a client that using openvpn is connecting to a remote lan where i have a openvpn server (zeroshell)
i can use any service without troubles.
Now i am trying to connect to a sql server sitting on ...
CommunityBot
- 1
0
votes
2
answers
119
views
SQL Server backup app
We are using DPM 2010 to backup our Hyper-V cluster however we require an client/agent and server SQL backup app for all of our Windows VMs, as to purchase an Enterprise DPM licence for each VM is to ...
- 1
1
vote
1
answer
2k
views
MySQL Corrupt Table - No Space left - Index File too big
I noticed that one of my servers was running out of disk space, due to heavy MySQL usage.
I stopped everything using the database, freed up some space and restarted mysqld.
Now, I checked my table ...
CommunityBot
- 1
0
votes
1
answer
2k
views
SCCM - Find when an application deployed to a specific computer
Is it possible to find when SCCM ran a deployment against a specific client PC, from the server? (CAS, primary or even secondary will do so long as I can script through to the data starting with only ...
CommunityBot
- 1
2
votes
1
answer
3k
views
SQL error log can't create/write to file
I'm quite new to server administration but a keen learner, so if I miss anything or you need any extra info let me know and I'll do my best to provide it ASAP :)
I'm running WordPress on a developer ...
CommunityBot
- 1
4
votes
5
answers
9k
views
Use SQL varchar(max) or text?
I'm using SQL Server 2005 and I have a column where I need to store large amounts of text (sometimes over 8000 characters, the varchar limit). Is there a disadvantage to using the "text" data type? ...
- 1,213