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
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 ...
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 ...
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 ...
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 ...
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 @...
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 ...
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 ...
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 ...
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 ...
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 (...
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 ...
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
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 ...
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 ...
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 ...