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].

310 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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. ...
Ariel's user avatar
  • 423
1 vote
1 answer
185 views

SQL Server Authentication vs Windows Authentication

I am a SQL Server newbie and would really appreciate any help. I have created a new login (test2) with sql server authentication and granted select & vierw definition permission on another schema ...
user avatar
1 vote
1 answer
796 views

Don't see job schedule added by sp_add_jobschedule in SQL Mgmt UI

I'm running a script like below on a SQL Server box and, even though it finishes correctly, then when, on SQL Mgmt UI, I right click on that job's properties, go to Schedules, I cannot see the ...
Ariel's user avatar
  • 423
1 vote
1 answer
367 views

Failed Simple Maintenance Plan only when Full Backups do not run

Let me start off that I'm new to SQL administration and have inherited an older server that serves the main DB for our day in/out operations. So, my apologies in advanced to my beginner questions. ...
Josh's user avatar
  • 11
1 vote
1 answer
752 views

backup sql databases, folders; 7ZIP and copy to ftp

We are quite stuck with which solution to choose for this backup issue: What should happen: First, there should be an interface were to choose several sql databases (sort of checkboxes or whatsoever)...
laurens's user avatar
  • 397
1 vote
2 answers
136 views

Move MSSQL Server to another Server

So I'm about to move a MSSQL Server to another better hardware server. I need to make sure I'm moving everything. I made a small list of what I think I need to move: Databases (ofcourse :)) MSSQL ...
Shlomi's user avatar
  • 331
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
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
0 votes
2 answers
449 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
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. ...
Marian's user avatar
  • 101
0 votes
1 answer
66 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
0 answers
29 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
463 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
0 votes
0 answers
124 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
216 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
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
303 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
0 votes
0 answers
47 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
0 answers
258 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
33 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
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
220 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
0 answers
345 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
166 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
0 votes
1 answer
129 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
569 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
0 answers
327 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
0 votes
1 answer
364 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 ...
thehouseisburning's user avatar
0 votes
0 answers
30 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 ...
boxcartenant's user avatar
0 votes
1 answer
125 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 ...
Andrew's user avatar
  • 1
0 votes
1 answer
45 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 ...
ferb_badrobot's user avatar
0 votes
1 answer
127 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 ...
WhiteIntel's user avatar
0 votes
1 answer
946 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 ...
Influence's user avatar
0 votes
1 answer
254 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 ...
David Rogers's user avatar
0 votes
1 answer
3k 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 ...
Gary Simmons's user avatar
0 votes
1 answer
427 views

SQL instance IP address pointing to the SQL server hostname

Our SQL instances IP addresses are pointing to the same DNS entry (which is the SQL server name) although the TCP/IP is enabled. My question is, how do you set up the SQL instances IP address and ...
neb's user avatar
  • 11
0 votes
0 answers
802 views

SQL Server generating 1G dump files

I have a SQL Server generating large dump (mdmp) files, some of them are 1 GB in size, these are generated daily, sometimes 2 or 3 in a single day. This server is used heavily for PowerBI reports. ...
The One's user avatar
  • 113
0 votes
1 answer
895 views

How to take backup of 500GB SQL database data?

We tried to copy 500GB data to local drive using copy option in SQL management studio but it getting failed after 2 or 3 hours...is there any size limitation to copy? How much size script file should ...
bhuva nesh's user avatar
0 votes
2 answers
124 views

Is it safe to have virtual memory in servers?

I'm not sure if it's safe to have virtual memory (pagefile.sys) in servers? Safe in the sense of: Would it affect the data in the cache that is being handled by RAM? Does it conflict if it will be ...
Alan's user avatar
  • 1
0 votes
1 answer
120 views

1364 - Field 'aim' doesn't have a default value

1364 - Field 'aim' doesn't have a default value Query: INSERT INTO mybb_users (`username`,`password`,`salt`,`loginkey`,`email`,`postnum`,`threadnum`,`avatar`,`avatartype`,`usergroup`,`...
Umair's user avatar
  • 1
0 votes
1 answer
1k views

How to add new login for Microsoft SQL Server for all domain users

I would like to add MYDOMIAN\domain_users as new login in MS SQL 2012. So I create new login, choose mMYDOMAIN as localization but here I don't have option to add all domain users, I can only ...
zuku's user avatar
  • 61
0 votes
0 answers
1k views

Why does SQL Server keep creating the folder “C:\Program Files\Microsoft SQL Server\” when installing on another driver?

I specified a different drive wherever applicable during the SQL Server 2017 install. However, the directory C:\Program Files\Microsoft SQL Server keeps getting created. I basically have the expected ...
Goku's user avatar
  • 101
0 votes
1 answer
714 views

Cloned Server Cannot connect to SQL Server 2017 Instance

I just recently cloned a dev server from a production Microsoft Dynamics 365 server having SQL Server 2017 installed on it. Now when I log in to the dev Server and to SQL Server via the SSMS I am ...
Pro Funter's user avatar
0 votes
0 answers
692 views

SQL Server Username Length

I have a SQL Server 2008 running on Windows Server 2008. The database handles spatial data. I have a select group of users that are unable to use their domain accounts when working in the database as ...
Kyle's user avatar
  • 1
0 votes
1 answer
63 views

Microsoft Azure SQL Server with Single Database

I have created a Single SQL Database and a SQL Server on Microsoft Azure with a Basic Plant of MAX 2GB. Now I want to create another SQL Database of MAX Size 2GB. Can I create another SQL Database ...
Paras's user avatar
  • 1

1 2
3
4 5
7