Questions tagged [sql-server]
Tag with [sql-server] the question related to each database server that implements SQL (Structured Query Language) and not related with the specific Microsoft one. For the latter use the specific tag [ms-sql], or if related with a specific version with the relative tag [sql-server-2012], [sql-server-2008]...
773
questions
0
votes
0
answers
62
views
Word shows error message when saving a docx on an SQL FILESTREAM
I have a SQL Server. I created access to a file stream table.
I have a UNC path to the specific folder \Pc\mssqlserver\DBShare\Files. I can open the explorer and I can navigate through the subfolders ...
0
votes
1
answer
250
views
Is it possible to have a replica for MS SQL multi cloud?
I have a task where a Microsoft SQL database which is hosted on an AWS Windows EC2 instance and will need to have a replica on Azure. This is so that a team who manages the Azure infrastructure can ...
0
votes
1
answer
1k
views
What can cause PowerShell to not support "-As Datatables" in a Invoke-Sqlcmd query
I'm trying to track down a failure on a CI server. It's running a PowerShell command:
$dt = Invoke-Sqlcmd -server $dbServer -database $dbName $sqlQueryReport -As DataTables -QueryTimeout 900
This ...
1
vote
1
answer
1k
views
Connect to SQL Server instance via VPN from WSL2
I'm trying to connect to a SQL Server instance from WSL2 (Arch Linux) with this command:
sqlcmd -S tcp:XX.XXX.XXX.XX\\stix -U service_stix -C
But I get:
Sqlcmd: Error: Microsoft ODBC Driver 18 for ...
0
votes
2
answers
1k
views
What's the point of having mysql root password for root user?
As a root user on Fedora I have install mysql server with a mysql root password . Then I forgot the password and used sudo mysqld_safe --skip-grant-tables & and bypassed the password , did some ...
2
votes
0
answers
20
views
Is it possible to restore a single project plan from a full database backup
Using MS Project 2013, one of our PCO deleted tasks from a project plan, while work had been entered via timesheets on those same tasks, some of which weren't approved, yet.
The project is now in a ...
0
votes
0
answers
357
views
How to run sqlcmd.exe as a windows service?
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (...
0
votes
1
answer
80
views
Windows 10 Home Has my Sql Server (SSMS) been hacked? Weird passwords I did not assign in sys.syslogins
I am running Sql Server Dev 2017 with SSMS and Windows Authentication in Windows 10 Home Edition.
My SqlServer is and always has been offline (TCP/IP is disabled for my SqlServer, no inbound rules in ...
0
votes
1
answer
5k
views
Error installing SQL Server Database Engine Services with SQL Server 2019 on Windows 11 Home
I am facing an issue in installing SQL Server 2019 on my Windows 11 Home machine.
The problem is
Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential ...
1
vote
1
answer
1k
views
SQL Server 2019 Configuration won't connect but Management will
I have an odd situation...
I have my SQL Server 2019 database on encrypted disk (Windows 11) so this is first attached after computer started.
So in the past I would launch SQL Server Configuration ...
0
votes
0
answers
161
views
Error while importing csv file using MSSQL Import extension in Azure Data Studio on Pop!_OS
I have an Intel Aspire 5738 laptop which has Intel Core 2 Duo processor T6400 (2.00 GHz, 800 MHz FSB) on which i have installed the latest version of POP!_OS. The CPU does not support virtualization. ...
0
votes
0
answers
553
views
Install Microsoft SQL Server on Pop!_OS
I am trying to install Microsoft SQL Server on the latest Pop!_OS 22.04 LTS (jammy) but receiving following errors:
sudo apt-get install mssql-server
Reading package lists... Done
Building dependency ...
12
votes
3
answers
8k
views
Is gradually growing swap usage an indicator for a memory leak?
I’m trying to understand whether I have a memory leak on my server (Windows Server 2012R2). The server has 48 GB RAM and was designed to run only a DBMS (a SQL Server 2014) but there are also other ...
0
votes
1
answer
533
views
Problems connecting to database on remotesql.com
I have been using remotemysql.com as a remote database and have had issues attempting to log in since 1.5 days ago.
I'm getting SQL connection error: connect ECONNREFUSED in my app and ...
1
vote
0
answers
291
views
Excel ODBC connection to MS SQL server refresh issue
I've created an ODBC connection in Excel in order to create pivots on a large table held in MS SQL Server.
The connection string looks like this:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist ...