Skip to main content

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]...

Filter by
Sorted by
Tagged with
0 votes
0 answers
57 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 = ...
Daan's user avatar
  • 481
0 votes
0 answers
33 views

Error when connecting to DB Server with Management Studio 20.1: An exception occurred while executing a Transact-SQL statement or batch

When i try to connect to an SQL Server 2022 Express instance using Management Studio 20.1 running on the same instance, i get the following error: =================================== Error connecting ...
Naryoril's user avatar
  • 101
0 votes
2 answers
37 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 ...
kc2001's user avatar
  • 187
-1 votes
1 answer
223 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 ...
mehmed aras's user avatar
0 votes
0 answers
69 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 ...
Roberto's user avatar
  • 69
0 votes
0 answers
40 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 ...
Suman jha's user avatar
1 vote
1 answer
48 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 ...
Axeltherabbit's user avatar
-1 votes
1 answer
53 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 ...
classicaspordeath's user avatar
0 votes
0 answers
467 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 ...
Matt's user avatar
  • 1,236
0 votes
0 answers
24 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 ...
PicassoAlbo's user avatar
-1 votes
1 answer
393 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 ...
Manju Raj's user avatar
0 votes
0 answers
37 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 ...
Frank N.'s user avatar
0 votes
1 answer
388 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 ...
yamihero777's user avatar
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: ...
yi jie's user avatar
  • 1
0 votes
0 answers
63 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 ...
exodus's user avatar
  • 1
0 votes
0 answers
526 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 ...
alex's user avatar
  • 1,061
0 votes
0 answers
318 views

Setting up Windows server 2022 to VPN server

I'm trying to set up application and VPN connection on new Win Server 2022 like it's currently set up on old Win Server 2008 and I'm stuck...Basically I'm trying to mirror everything on Win Server ...
user3746480's user avatar
2 votes
1 answer
469 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 ...
knoami's user avatar
  • 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 ...
e-Fungus's user avatar
  • 125
0 votes
0 answers
211 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 @...
Clamarc's user avatar
  • 663
0 votes
0 answers
1k 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 ...
Skeptic's user avatar
0 votes
1 answer
268 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 ...
tezx's user avatar
  • 11
3 votes
1 answer
1k 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 ...
Felix An's user avatar
  • 193
0 votes
0 answers
461 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 ...
yonikawa's user avatar
  • 129
0 votes
1 answer
984 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 (...
BigBob's user avatar
  • 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 ...
saner's user avatar
  • 101
0 votes
1 answer
888 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 ...
arnoldh's user avatar
1 vote
0 answers
122 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 ...
Gurudath R's user avatar
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 ...
SQPooya's user avatar
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 ...
Jan Hudec's user avatar
  • 1,035
0 votes
0 answers
61 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 ...
xMRi's user avatar
  • 247
0 votes
1 answer
236 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 ...
Sean's user avatar
  • 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 ...
Mason Wheeler's user avatar
1 vote
1 answer
985 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 ...
Rick Stanley's user avatar
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 ...
user1731887's user avatar
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 ...
user21833's user avatar
0 votes
0 answers
354 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: ) (...
Mark's user avatar
  • 11
0 votes
1 answer
79 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 ...
MSIS's user avatar
  • 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 ...
user avatar
1 vote
1 answer
973 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 ...
Tom's user avatar
  • 439
0 votes
0 answers
157 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. ...
sifar's user avatar
  • 111
0 votes
0 answers
547 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 ...
sifar's user avatar
  • 111
12 votes
3 answers
7k 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 ...
Andrej Kuklin's user avatar
0 votes
1 answer
532 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 ...
Shuri2060's user avatar
  • 138
1 vote
0 answers
278 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 ...
dwcecil's user avatar
  • 21
0 votes
0 answers
27 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 ...
Siah's user avatar
  • 1
2 votes
3 answers
802 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 ...
Dominique's user avatar
  • 2,259
0 votes
1 answer
62 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....
jstuardo's user avatar
  • 327
0 votes
1 answer
757 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 ...
rockerx208's user avatar
1 vote
1 answer
3k 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 ...
ryan's user avatar
  • 23

1
2 3 4 5
16