Skip to main content
Share Your Experience: Take the 2024 Developer 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
1 vote
0 answers
46 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 ...
Keith's user avatar
  • 111
1 vote
0 answers
20 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?
Nathan Smith's user avatar
0 votes
1 answer
38 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 ...
YDY's user avatar
  • 21
-1 votes
2 answers
265 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. ...
Mark's user avatar
  • 79
0 votes
1 answer
41 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 ...
Nathan Smith's user avatar
-1 votes
1 answer
33 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. ...
Nathan Smith's user avatar
0 votes
2 answers
796 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 ...
tobymax's user avatar
0 votes
0 answers
76 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. ...
Marian's user avatar
  • 101
0 votes
1 answer
233 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)...
LinuxGnut's user avatar
  • 217
0 votes
1 answer
111 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 ...
JohnDoe's user avatar
0 votes
1 answer
77 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. ...
Jack Duece's user avatar
0 votes
0 answers
29 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,...
JukEboX's user avatar
  • 835
0 votes
2 answers
236 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 ...
JukEboX's user avatar
  • 835
0 votes
0 answers
31 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","...
Neo's user avatar
  • 1
0 votes
2 answers
639 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 ...
RAN55's user avatar
  • 3
1 vote
1 answer
63 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 ...
Mighty's user avatar
  • 111
0 votes
0 answers
138 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 ...
Gytis Varnelis's user avatar
0 votes
0 answers
238 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 ...
Marvin Fratzke's user avatar
-1 votes
1 answer
705 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 ...
santhosh's user avatar
  • 103
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 - ...
Shanebagel's user avatar
-1 votes
1 answer
120 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 ...
boog's user avatar
  • 240
0 votes
0 answers
88 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 ...
Fictor's user avatar
  • 1
0 votes
1 answer
111 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 ...
billsecond's user avatar
0 votes
0 answers
284 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 ...
mrlizard's user avatar
0 votes
0 answers
42 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 ...
GKOS's user avatar
  • 1
0 votes
0 answers
149 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 ...
NicolasSens's user avatar
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 ...
Potatan's user avatar
  • 13
0 votes
3 answers
732 views

How to grant persmission for this sql?

How to grant permission for this? Thank you for your help! ERROR is : ERROR 1142 (42000) at line 2: CREATE command denied to user '@'localhost' for table 'student' CREATE TABLE STUDENT( ID INT ...
bigstreet's user avatar
0 votes
2 answers
3k views

How can I use a value returned from one dataset to build a query for a different dataset, in SSRS?

I'm using SQL Server Report Builder 3.0 to create a report. I have two tables and I want to look up a value in one table and then use that to select a value from the second table. Example as follows: ...
Potatan's user avatar
  • 13
0 votes
0 answers
234 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 ...
James's user avatar
  • 1
0 votes
3 answers
78 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()" ...
tach's user avatar
  • 131
0 votes
1 answer
800 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 ...
Sahasrar's user avatar
0 votes
0 answers
352 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 ...
AGK's user avatar
  • 101
0 votes
1 answer
185 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 ...
pbuchheit's user avatar
  • 171
-1 votes
2 answers
2k 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 ...
pbuchheit's user avatar
  • 171
0 votes
1 answer
290 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 ...
R2Bleep2's user avatar
1 vote
2 answers
2k 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%...
mikef0x's user avatar
  • 13
2 votes
1 answer
4k 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 ...
CloudSysPro's user avatar
1 vote
1 answer
1k 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.
woodyboow's user avatar
1 vote
1 answer
147 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 ...
Andy White's user avatar
4 votes
2 answers
15k 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 ...
fajin yu's user avatar
  • 215
0 votes
1 answer
86 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 ...
HadiB's user avatar
  • 9
1 vote
0 answers
461 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 ...
SophisticatedBear's user avatar
2 votes
1 answer
1k 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 ...
ChimpyMonk75's user avatar
0 votes
1 answer
133 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 ...
Rich Vieira's user avatar
0 votes
1 answer
20k 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 ...
thexbuttonisntworking's user avatar
0 votes
1 answer
592 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 ...
Randy's user avatar
  • 1
0 votes
1 answer
92 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. ...
Someone2's user avatar
  • 103
0 votes
1 answer
56 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 &...
gfsadmin's user avatar
0 votes
0 answers
391 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 -...
JukEboX's user avatar
  • 835

1
2 3 4 5
26