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
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. ...
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 ...
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 ...
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.
...
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)...
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 ...
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
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 ...
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 ...
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. ...
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. ...
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
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","...
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 ...
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 ...
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 ...
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
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 ...
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 ...
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
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 ...
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 ...
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
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
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 ...
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 ...
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 ...
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 ...
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 ...
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 -...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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`,`...
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 ...
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
...
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 ...
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 ...
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 ...