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
55
views
SQL Server ceases to function due to insufficient memory
I have used a locally installed instance of SQL Server for my software development work on various laptops over the past 16 years.
About 3 weeks ago, I started using a new laptop and almost ...
- 103
0
votes
1
answer
40
views
Can't log into SSMS using a DNS name from the hosts file
In both my server (that hosts SQLS server) and my Pc, I have this entry in the hosts file:
I am using Windows Authentication to log into the SSMS.
Using servername MYSQLSERVER in the SSMS on my Pc, I ...
- 263
0
votes
0
answers
80
views
How to install SQL Server Developer edition on Windows 2022 Azure Pipelines?
Installing SQL Server Express on Windows 2022 Azure Pipelines is easy.
Here is my code:
function Test-IsAdmin {
$currentUser = [Security.Principal.WindowsIdentity]::GetCurrent()
$principal = ...
- 481
0
votes
2
answers
39
views
Why does SSMS generate many tilde files when saving a SQL file?
I'm using SQL Server Management Studio (SSMS) 20.1 to edit a file containing SQL commands. The file itself, sqlCommands.sql, is being provided via a WebDAV server that we've written. If we make an ...
- 187
-1
votes
1
answer
355
views
SQL Server 2022 express download error
I was trying to download SQL Server 2022 Express in windows 11 and received an Exit code(Decimal): -2061893606.
Then I checked log and saw SystemConfigurationCheck report.
Everything is okay except ...
0
votes
0
answers
72
views
I can't start the MSSQLSERVER on new esxi host
I am a student currently studying virtualization and SQL. After obtaining approval from my instructor, I attempted to transfer a virtual machine (VM) to my personal laptop.
However, upon doing so, I ...
- 69
0
votes
0
answers
61
views
Upgrading SQL SERVER 2014 to 2022 using WIX installer
I am making a exe using Bootstrapper WIX installer for my application. I am trying to update the SQL Server 2014 to SQL Server 2022 using the exe itself.
Here is the scenario, currently the ...
1
vote
1
answer
51
views
No internet connection when scheduled task starts or when Sql server agent job starts
I've a task that runs daily which is failing because it starts without internet connection.
I tried to tick wait for network but it doesn't work either.
I tried to register the task with System and ...
- 151
-1
votes
1
answer
54
views
Add User to database that is on server canot be found
I have a SQL Server Express instance, 2 databases on the server 3 and 4.
Server 4 has [IIS APPPOOL.NET v4.5] as a user
I want to add [IIS APPPOOL.NET v4.5] as a user to Server 3.
Cannot get Database ...
0
votes
0
answers
536
views
An error occurred but no ODBC error information was available
I have an odd issue with Excel 365 v16.0.16827.20278 installed on a host machine. When trying to access an ODBC source, used successfully by several other individuals, Excel throws the error
An error ...
- 1,236
0
votes
0
answers
26
views
RDP Session Utilizing Connections from Multiple NICs on Local Computer
I apologize if this sounds complicated.
We've recently setup a RDS for users to utilize an application that queries a SQL Database Server for security cameras setup at a manufacturing plant (located ...
-1
votes
1
answer
435
views
Attuinity connectors SSIS package migrate to SSIS 2022
I have 2015 SSIS solution with attuinity oracle connectors, I am unable to open the package in VS 2022 since it does not support attuinity any more, I get Object reference not set to instance of the ...
0
votes
0
answers
38
views
SQL Server Connection to Excel Workbook
Upon re-opening my excel workbook, the SQL Server connection and associated queries are not saved and unable to be refreshed. How do I resolve this issue? I am accessing the DB via a remote connection ...
- 1
0
votes
1
answer
414
views
Unable to access sql servers from host machine DNS issue
Bonjour,
I'm trying to learn MS SQL Server
Configuration: VMWARE 17 Pro - 3 VMs Windows Server 2019 with SQL Server 2019; Network Adapters: Ethernet0(Internet), VMware(static) ; VM Network : Host-Only ...
- 25
0
votes
1
answer
1k
views
Invalid command line argument when install Microsoft SQL Server
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068052377
Start time: 2023-08-18 11:44:13
End time: ...
- 1
0
votes
0
answers
64
views
Program wont connect through OpenVPN
I have a MAC M1 that needs to run a windows native app (no MAC option of such app) and to do so I installed a Windows 11 arm x64 with VmWare Fusion - the app that runs needs to connect to SQL on my ...
- 1
0
votes
0
answers
543
views
Connect to a remote sql server without port forwarding
On our main office we have a Windows 10 Pc that has Sql server. Here we have the database.
On another office ( that is not on local network ) we have another windows 10 Pc , with an application that ...
- 1,061
2
votes
1
answer
504
views
Microsoft SQL Server 2014 Standard Edition - Minimum Setup
We have a corporate license for Microsoft SQL Server 2014 Standard Edition and for time to time I have to install (or re-install it) on different Servers and computers. The setup folder size is about ...
- 123
0
votes
0
answers
28
views
Can onenote have runners
Is there a way to make OneNote recognize snippet of code (of tsql) and execute sample (top 50 of the select) of the output and include the answer like jupyter for python?
a. Native method to run a ...
- 125
0
votes
0
answers
217
views
Multiple values using the N prefix
I need to put multiple values in the @RefValue parameter to speed up the result:
I tried :
@RefValue = N'204' --205 '
however, it only returned the value of the register 204.
Command:
DECLARE @...
- 663
0
votes
0
answers
2k
views
"Error encountered during SQL installation"
During my internship at a company that utilizes Sage software, I faced challenges while attempting to install Microsoft SQL Server, which is required for Sage. I encountered multiple errors during the ...
- 1
0
votes
1
answer
292
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
3
votes
1
answer
2k
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 ...
- 193
0
votes
0
answers
475
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 ...
- 129
0
votes
1
answer
1k
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 (...
- 131
0
votes
0
answers
2k
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
927
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
125
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
56
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
2k
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,035
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 ...
- 247
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 ...
- 111
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 ...
- 964
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 ...
- 175
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 ...
- 31
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: ) (...
- 11
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 ...
- 115
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 ...
sreeraj
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 ...
- 439
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. ...
- 111
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 ...
- 111
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 ...
- 121
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 ...
- 138
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 ...
- 21
0
votes
0
answers
32
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
2
votes
3
answers
826
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 ...
- 2,283
0
votes
1
answer
67
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....
- 337
0
votes
1
answer
781
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
4k
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