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]...
775
questions
0
votes
0
answers
42
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
35
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
74
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
0
answers
70
views
Error when connecting to DB Server with Management Studio 20.1: An exception occurred while executing a Transact-SQL statement or batch [closed]
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 ...
- 101
0
votes
2
answers
38
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
295
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
50
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
49
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
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 ...
0
votes
0
answers
498
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
417
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
400
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