All Questions
Tagged with sql-server windows
60
questions
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 ...
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 ...
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 ...
0
votes
1
answer
350
views
Microsoft SQL server management studio 18 commandline replacement
I have created an SQL file for my SQL server. When I double-click on that, Microsoft SQL server Management Studio 18 is opened, username and password are asked, the query is opened and I can launch it....
1
vote
0
answers
406
views
SSDT with Visual Studio Professional Edition vs Enterprise Edition
We need to setup SSDT for SSIS on SQLServer 2019. We would like to understand what is the difference if we go for Visual Studio Professional edition versus Visual Studio Enterprise edition. I see no ...
1
vote
1
answer
2k
views
MS SQL Server: Windows authentication works from a local account but not from an MS account
I use MS SQL Server Management Studio to work on a database using Windows authentication from my home Win64 laptop computer.
If I log my laptop to a local Windows account ("LocalAag"), I ...
0
votes
0
answers
2k
views
Unable to install MS SQL Server or SSMS due to missing DLL, how do I find and install this DLL?
I have the exact issue as the OP of this question but their fix did not work for me:
Related Stack Overflow Question
I need to install MS SQL Server and SQL Server Management Studio on my computer. No ...
0
votes
2
answers
3k
views
Is NT SERVICE a local or shared network domain account?
The sql agent job runs under the NT SERVICE/InstanceName account.
Is the NT SERVICE domain private to the current computer or is it shared across all computers in the network?
1
vote
1
answer
1k
views
C drive getting full in windows 10 for no reason
I had 37 GB free on my main OS drive (C:) in my 512 GB SSD hard-drive. I installed a 2nd 1 TB drive anticipating needing more disk space soon. Just in few days c:\ drive got full for no apparent ...
0
votes
1
answer
99
views
What is "localcomputer" or domain and how to get it?
I am trying to install a program (Microsoft SQL Data Sync Agent), and in one step it is asking me the following:
Enter the account you want to run Windows Service under. E.g. domain\user. ...
2
votes
1
answer
2k
views
SQL Server (SQLEXPRESS) Service cannot start. It's referring to a file that doesn't exist
I'm learning how to create an application in Visual Studio and following a tutorial to create a service-based database. When I try to add the new item (service-based db) in Visual Studio, I got the ...
0
votes
0
answers
141
views
SQL Connection failure
A common question, I know; my particular circumstances: I have a solution developed in C# in Visual Studio connecting to an Azure SQL Server DB; until now, working fine; basically, for other reasons, ...
0
votes
0
answers
305
views
Trying to connect to SQL Server through SQL Server Management Studio for the first time won't connect
Hey all so my problem is that I try to connect before even accessing the object explorer or anything and have ended up with this error. I've tried using Windows Authentication which is what I want to ...
0
votes
1
answer
8k
views
Error 0x80070643 - Can't get the update
I'm trying to get the update which is Security Update for SQL Server 2016 SP2 (KB4293802) from Windows Update on my Windows 10. However it returns me Security Update for SQL Server 2016 SP2 (KB4293802)...