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
-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 ...
TryHardSummer's user avatar
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 ...
Nathan Smith's user avatar
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 ...
YDY's user avatar
  • 21
-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. ...
Mark's user avatar
  • 79
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 ...
Merve's user avatar
  • 1
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 ...
Nathan Smith's user avatar
-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. ...
Nathan Smith's user avatar
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 ...
tobymax's user avatar
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. ...
Marian's user avatar
  • 101
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)...
LinuxGnut's user avatar
  • 217
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 ...
JohnDoe's user avatar
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. ...
Jack Duece's user avatar
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,...
JukEboX's user avatar
  • 835
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 ...
JukEboX's user avatar
  • 835
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","...
Neo's user avatar
  • 1
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 ...
RAN55's user avatar
  • 1
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 ...
Mighty's user avatar
  • 111
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 ...
Gytis Varnelis's user avatar
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 ...
Marvin Fratzke's user avatar
-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 ...
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
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 ...
Daniel W.'s user avatar
-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 ...
boog's user avatar
  • 240
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 ...
6a5h4's user avatar
  • 1
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 ...
Fictor's user avatar
  • 1
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 ...
billsecond's user avatar
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 ...
mrlizard's user avatar
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 ...
GKOS's user avatar
  • 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 ...
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
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 ...
bigstreet's user avatar
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: ...
Potatan's user avatar
  • 13
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 ...
James's user avatar
  • 1
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()" ...
tach's user avatar
  • 131
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 ...
Sahasrar's user avatar
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 ...
AGK's user avatar
  • 101
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 ...
pbuchheit's user avatar
  • 171
-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 ...
pbuchheit's user avatar
  • 171
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 ...
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
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.
woodyboow's user avatar
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 ...
Andy White's user avatar
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 ...
fajin yu's user avatar
  • 205
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 ...
HadiB's user avatar
  • 9
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 ...
SophisticatedBear's user avatar
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 ...
ChimpyMonk75's user avatar
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 ...
Rich Vieira's user avatar
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 ...
thexbuttonisntworking's user avatar
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 ...
Randy's user avatar
  • 1

1
2 3 4 5
26