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 ...
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 ...
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 = ...
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 ...
-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 ...
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 ...
-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 ...
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 ...
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 ...
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: ...