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]...
759
questions
0
votes
1
answer
40
views
Installed SQL Express on IaaS VM in Azure, SQL Virtual Machine resource appeared in resource group?
I installed SQL Express on a Windows Server VM in Azure, a few days later a new resource appeared in the RG with the same resource name of the VM but as a SQL Virtual Machine.
I take it this won't ...
- 11
1
vote
1
answer
161
views
How can I activate the Linux version of Microsoft SQL Server 2022 Enterprise?
I followed the steps on the Microsoft website to install SQL Server 2022 on Ubuntu Server. After I entered the command on step 4 of the instructions to enter the setup wizard, I selected the ...
- 51
0
votes
0
answers
27
views
SQL Server database upgrade - 2016 to 2019
We upgraded our SQL server from 2016 to 2019. Now we need to upgrade/convert our custom 2016 database to make it 2019 compatible. What's the process? We are running SQL Server management studio 2019 ...
- 119
0
votes
1
answer
108
views
SSH tunnel to MS SQL Server works with PuTTY but not from ssh command line
I'm trying to create an SSH tunnel to MS SQL Server from my Windows 10 local computer. When I create a tunnel with PuTTY, it works flawlessly. But when I create the same tunnel in command line (...
- 121
0
votes
0
answers
14
views
I want to add a feature on my server [duplicate]
I want to modify the server configuration so that it saves wrong passwords that I tried to login to via SSH
Note that the server is Linux
0
votes
0
answers
724
views
VM and local network access with Port forwarding in UTM on M1
I'd like to connect a Win11 arm VM inside UTM on macOS M1 to a Win10 intel macbook pro in Bootcamp mode on my local network (wifi). I was advised to "use Emulated VLAN with port forwarding on and ...
- 101
0
votes
1
answer
265
views
Why can I no longer connect to SQL Server from another PC on my local network?
Why has a SQL Server client stopped connecting to SQL Server running on another node on my local network?
This has been working correctly for a long time. The client PC (PC A) was connecting two days ...
- 1
1
vote
0
answers
76
views
SSRS Sql Server Reporting Server Custom Security 2019 exception in Windows Server 2019
I am facing a problem with respect to SSRS(Sql Server Reporting Server) 2019 Custom security Exception in windows server 2019.
SSRS report works fine from winforms vb.net code in previous version of ...
- 11
0
votes
1
answer
47
views
Automate SQL Queries with a Config File
I am trying to generate a weekly list of reports, each in the form of a folder containing multiple excel files that use SQL queries. Is there a way to have a "config" file of some sort to ...
- 3
2
votes
2
answers
537
views
sqlcmd AAD token authentication fails with cannot discover user realm
I am trying to authenticate to Azure SQL database using AAD user account. According to the documentation I should use -G to enable AAD authentication and then pass the token via -P. So I try it with ...
- 1,015
0
votes
0
answers
37
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 ...
- 227
0
votes
1
answer
71
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 ...
- 111
0
votes
0
answers
23
views
How to view XML data retrieved from a SQL database?
I've got a MS SQL Server database full of XML test logs, and I've set up an Excel workbook with a Power Query table (screenshot here) to view the top-level information about the individual log ...
- 1
0
votes
1
answer
393
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 ...
- 962
1
vote
1
answer
517
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 ...
- 125
0
votes
2
answers
306
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
18
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 ...
- 31
0
votes
0
answers
193
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: ) (...
- 11
0
votes
1
answer
54
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 ...
- 115
0
votes
1
answer
3k
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 ...
sreeraj
1
vote
1
answer
211
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 ...
- 409
0
votes
0
answers
82
views
Dbeaver : SQL Server WINDOW functions giving syntax error
I have installed DBeaver as a flatpak in my Pop!_OS laptop. DBeaver is connected to an SQL Server 2019 image in a volume using Docker. SQL scripts run well, except for the following WINDOW functions:
...
- 111
0
votes
0
answers
107
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. ...
- 111
0
votes
0
answers
359
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 ...
- 111
0
votes
0
answers
110
views
MS SQL Server On-Premise Installation Keeps Saying ODBC Driver 17 installation is not found
Tried both downloaded .ISO and .EXE from the official Microsoft site, both failed on this ODBC 17 driver installation missing. With .ISO it prompted me to look for msoledb.msi file which is located a ...
- 101
12
votes
3
answers
4k
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 ...
- 121
0
votes
1
answer
424
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 ...
- 129
1
vote
0
answers
125
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 ...
- 11
0
votes
0
answers
15
views
Save SQL Server 'Server Name' values when running SQL Server as user with different domain
So I need to periodically run SSMS as a user other than the windows user I am logged into my machine as. This user has a different domain than the user I am logged into my computer as, therefore what ...
- 1
1
vote
3
answers
317
views
Avoid Excel to chop off the last digits of my numbers
As indicated in this URL, the largest number Excel can handle is about 10^307.
Nevertheless, Excel seems to have problems with smaller numbers too (about 10^17) as you can see from my example:
I'm ...
- 1,921
0
votes
1
answer
32
views
Advice about fixing SQL Server 2014 database performance
I noticed that a system I have in a production server is running slow so I start studying about the causes. This is a SQL Server 2014 database whose data file size is 361.472 KB and log file was 427....
- 267
0
votes
1
answer
359
views
Silent Install SQL without having to Restart
In short, I am running a silent install of SQL Server 2016 using a *.ini file. At the end of the installation, I must restart to use any sort of sqlcmd/invoke-sqlcmd to call a SQL file.
Does anyone ...
1
vote
1
answer
2k
views
Setup Failed Fatal Error during installation (0x80070643) SSIS Projects
I installed Microsoft visual studio 2019 and wanted to add the SSIS extension but got the following error.
Microsoft AS OLE DB Provider for SQL Server 2016: An error occurred during the installation ...
- 23
0
votes
0
answers
779
views
ODBC with active directory password authentication using a login ID and password not configurable
The server MYSERVER holds the SQL database MyDatabase. The account MYCOMPANY\myaccount is registered for MyDatabase with server roles public and sysadmin and with permission Connect SQL granted by sa. ...
- 197
1
vote
1
answer
1k
views
Painfully slow local development and MS-SQL connection
I know some may suggest that this question needs to be asked on StackOverFlow, but I do not believe this is not a Dev issue and probably an IT/Security thing. I have posted this on ServerFault as well....
- 125
0
votes
0
answers
98
views
MS-Access keeps stealing focus from VBA
When I'm working on MS Access VBA scripting, the Access application keeps stealing focus from VBA, even mid typing. So I will be typing code, there will be a pause, a brief lock up, and all of a ...
- 1
-1
votes
1
answer
405
views
ERROR dbeaver on manjaro
i downloaded dbeaver from the aur but it failed to open .
it gives :
" version 1.8 of JVM is not suitable for this product . Version 11 or greater is required"
but in the aur there is only ...
- 15
0
votes
1
answer
150
views
Microsoft SQL server management studio 18 commandline replacement
I have created an SQL file for my SQL server. When I double-click on that, Microsoft SQL server Management Studio 18 is opened, username and password are asked, the query is opened and I can launch it....
- 1,921
1
vote
0
answers
280
views
SSDT with Visual Studio Professional Edition vs Enterprise Edition
We need to setup SSDT for SSIS on SQLServer 2019. We would like to understand what is the difference if we go for Visual Studio Professional edition versus Visual Studio Enterprise edition. I see no ...
0
votes
1
answer
341
views
Group multiple excel rows just like SQL
I have some trading data as below :
I want to group data on some columns and do sum for Quantity and Average for price.
And output the data as SQL style like below.
How can i achieve this in excel. ...
- 103
0
votes
1
answer
180
views
MariaDB: How do I load a copy of a table into RAM for frequent reading?
Colleagues, tell me how to keep a copy of the table in RAM?
I have a database server on MariaDB. One of its databases contains a small table - about five fields and several dozen records. The records ...
- 1
0
votes
0
answers
481
views
SQLCMD Error 0xc000007b
The Environment:
Windows Server 2019 Standard
SQL Server 2019 Standard
SQL CMDLINE Utitlies V15 for x64
ODBC Driver 17 for x64
The Problem:
I am trying to run the sqlcmd command in Powershell and ...
- 395
1
vote
1
answer
608
views
MS SQL Server: Windows authentication works from a local account but not from an MS account
I use MS SQL Server Management Studio to work on a database using Windows authentication from my home Win64 laptop computer.
If I log my laptop to a local Windows account ("LocalAag"), I ...
- 149
1
vote
2
answers
554
views
Sysprep removes all SQL users
I have two instances running on SQL Server (2017) - SQLEXPRESS and MYINSTANCE
I've added a few users to MYINSTANCE
However when I run Sysprep on the device, it deletes all but sa and Builtin\Users.
It ...
- 235
0
votes
1
answer
241
views
"Operating System is not configured to use this application" when migrating a DB using the Access SQL server migration assistant
I have (re)installed Microsoft SQL Server migration assistant latest version today, and i have installed Ms SQL server Management studio 18 in order to migrate my accdb access database from Access to ...
- 13
-1
votes
1
answer
905
views
What is the difference between "client-server" and „file-server“ database? [closed]
I am trying to answer a question put on the exam but cannot find answer that is precise enough. Please help to understand what are the major difference between "client-server" database such ...
- 133
1
vote
1
answer
428
views
How can I share an Excel sheet with embedded SQL queries with another user without asking them for log-in credentials?
I created an Excel (Microsoft 365) sheet for a (non-tech-savvy) coworker that pulls data from a SQL database. However, he is not able to refresh the queries (by hitting 'Refresh All') on his machine ...
- 11
2
votes
1
answer
34
views
Can I separate some tables in my SQL DB for backups?
I've got a large database with many tables. Numbers not important. MSSQL 2017 (14.0.2037.2) on Server 2016 that I have full control of.
A huge amount of my data is in two or three tables. Imagine you ...
- 23
0
votes
0
answers
1k
views
Unable to install MS SQL Server or SSMS due to missing DLL, how do I find and install this DLL?
I have the exact issue as the OP of this question but their fix did not work for me:
Related Stack Overflow Question
I need to install MS SQL Server and SQL Server Management Studio on my computer. No ...
- 103
0
votes
2
answers
1k
views
Is NT SERVICE a local or shared network domain account?
The sql agent job runs under the NT SERVICE/InstanceName account.
Is the NT SERVICE domain private to the current computer or is it shared across all computers in the network?
- 194