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,295
questions
-4
votes
0
answers
27
views
connection with sql server
My task is to create a database in MS SQL that can be accessed via IP. I opened port 1433 in the router and in Windows. I set port 1433 in sql scm, the 2ip port is open. I have a static IP. But when ...
0
votes
0
answers
14
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 ...
0
votes
1
answer
33
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 ...
-1
votes
2
answers
138
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.
...
0
votes
0
answers
24
views
how do I decide which dublike statistics should delete?
I ran a query on SQL server that found duplicate statistics. As a result of this query, 1 record was returned. Under the AutoCreatedStatistics column it says "_WA_Sys_00000004_5F167B5D" and ...
0
votes
1
answer
35
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 ...
-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. ...
0
votes
2
answers
395
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 ...
0
votes
0
answers
62
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. ...
0
votes
1
answer
173
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)...
0
votes
1
answer
100
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 ...
0
votes
1
answer
63
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. ...
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,...
0
votes
2
answers
143
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 ...
0
votes
0
answers
27
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","...
0
votes
2
answers
405
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
vote
1
answer
59
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 ...
0
votes
0
answers
122
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
215
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
597
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 ...
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 - ...
0
votes
0
answers
292
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 ...
-1
votes
1
answer
103
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 ...
0
votes
0
answers
46
views
InfluxDB influxQL v1.8 : Wrong timestamp used for writing to database
I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a ...
0
votes
0
answers
84
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 ...
0
votes
1
answer
90
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 ...
0
votes
0
answers
255
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 ...
0
votes
0
answers
32
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 ...
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
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 ...
0
votes
3
answers
644
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 ...
0
votes
2
answers
2k
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:
...
0
votes
0
answers
213
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 ...
0
votes
3
answers
73
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()" ...
0
votes
1
answer
780
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 ...
0
votes
0
answers
343
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 ...
0
votes
1
answer
159
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 ...
-1
votes
2
answers
1k
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 ...
0
votes
1
answer
272
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 ...
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%...
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 ...
1
vote
1
answer
953
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.
1
vote
1
answer
142
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 ...
3
votes
2
answers
13k
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 ...
0
votes
1
answer
85
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 ...
1
vote
0
answers
428
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 ...
2
votes
1
answer
976
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 ...
0
votes
1
answer
127
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 ...
0
votes
1
answer
18k
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
...
0
votes
1
answer
562
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 ...