All Questions
Tagged with windows sql-server
261
questions
-1
votes
2
answers
60
views
How to Return the SQL_DB log files (.ldf) to the default Application
I have tried to open a "log" file of SQL DB with Windows Notepad application. Unfortunately, I forgot to remove the tick from the checkbox of “Always use the selected program to open this ...
0
votes
2
answers
170
views
Server's Disk Queue Length is high, but Disk Bytes/sec is lower than it's capable of
I have an environment running SQL Server on a Windows VMWare platform using a SAN with SSDs set up in RAID 6, and using Veeam for server backups and LiteSpeed for SQL Server backups.
I've had a ...
- 101
0
votes
1
answer
45
views
Server running MS SQL getting login request from another server every minute
I have a Windows Server 2016 virtual machine running IIS 10 and MS SQL Server 2016. Every minute I'm getting a "Login failed for user" message in the event log. Sometimes 3 times per minute. ...
1
vote
1
answer
729
views
How to setup Windows Remote Desktop Connection Broker HA with SQL Server Express?
I am preparing an environment in which Remote Desktop Connection Broker for which HA is to be based on SQL server (windows server standard 2022)
In my case, the SQL server is MS SQL Server Express ...
1
vote
1
answer
1k
views
Can no longer connect to server (an error occurred during the pre-login handshake)
Apologies if this isn't the place to ask this, or if it isn't enough information to go off of. I'm pretty new at this and don't know what or where else to ask.
Since two nights ago, nobody can connect ...
- 11
1
vote
1
answer
3k
views
Can't find NT SERVICE\MSSQLSERVER to give it Read privs on a cert
I've got SQL Server 2016 happily running under the default account NT SERVICE\MSSQLSERVER. Now, though, I need to give that pseudo-account read priv on a newly installed SSL Certificate.
The pseudo-...
- 223
0
votes
3
answers
2k
views
How to test Windows Service Account can login to SQL Server database?
How to test that a Windows AD service account has been granted access to read from a SQL Server database server via Windows Authentication ?
This would need be an isolated test independent of any ...
- 207
0
votes
1
answer
361
views
How to setup an Azure Windows VM for multiple users to RDP to their unique MS Access file?
I have 2 Azure VMs. One will act as an application server. The application is an Access file. This Access file connects to a separate Microsoft SQL Server database on a different Azure VM which will ...
0
votes
0
answers
2k
views
Swap memory 95% on SQL server running on Windows Server
I had an interesting situation the other day where a customer's SQL server was at 95% swap memory utilisation. This occurred on a Windows server running SQL Server.
The customer has 64GB RAM, and the ...
- 219
0
votes
0
answers
27
views
how to install a software with sql database in a domain with different windows clients on windows 2016 server
I have a domain (Windows 2016) and 4 clients (Windows) attached to it. Now I need a software which hase inbuilt mysql server. How do I install that software so that the software will be accessed from ...
- 101
1
vote
2
answers
2k
views
Veeam SQL Server Database Publishing Fail with unexpected error code 3
So we have been experimenting with Veeam Backup & Replication for a while now. We setup a dedicated VM for Veeam Backup Server which performs daily backups of all our infrastructure components. We ...
- 21
0
votes
1
answer
126
views
Adding a security certificate to a remote sql server
I'm in the process of trying to add a security certificate to a sql server running on a remote machine. I managed to generate the cert, but I'm a bit lost on the next step. All the instructions I have ...
- 161
-1
votes
2
answers
1k
views
Unable to find user account to set permissions for private key
I'm trying to set up a security certificate for a sql server. According to the documentation, I need to set up the permissions so that the sql server instance can read the private key. I tried setting ...
- 161
3
votes
2
answers
12k
views
Free up memory in Windows Server 2019 for SQL Server instance?
We have Windows Server 2019 Standard (x64) with 64GB memory.
The screenshot below shows the memory usage at 96% with the SQL Server Windows NT running and using 344.5 MB.
This is the Task Manager ...
- 205
1
vote
1
answer
3k
views
How to determine the common name (CN) for a microsoft sql certificate?
I'm in the process of trying to set up a self signed certificate for connecting a jetty server to a development sql database. I'm following the instructions here: https://codekabinett.com/rdumps.php?...
- 161
0
votes
0
answers
45
views
Hosting provider requires giving out server's admin password because of Microsoft audit
I am using a Windows OS VPS from a smaller, local provider for 1 year, everything was good until I started to license a MSSQL Web from the provider itself. They ask me to share my OS's admin password ...
- 1
0
votes
1
answer
469
views
MS SQL connection failure log for TLS/encryption issues
I have an application which has suddenly failed to login to a MS SQL database on the same LAN.
On the client side logs I can see:
[Microsoft][SQL Server Native Client 11.0]Encryption not supported on ...
- 3
2
votes
1
answer
422
views
SSH using public key losing Authentication on windows server
I want to SSH from my laptop (A) to Windows Server (B) and run commands against SQL Server (C) from powershell. All three in one windows domain. I'm running built-in openssh server and client for ...
- 131
2
votes
1
answer
12k
views
How can I check if SQL Server 2019 Standard is activated on Server Core? [duplicate]
I installed SQL Server 2019 Standard on Windows Server 2019 Core from an ISO that I downloaded from our MSDN. It specifically stated that there is "No product key required" when I downloaded ...
- 785
1
vote
0
answers
421
views
Grant database access through GPO
I have a domain in which I have couple servers with dedicated SQL Server databases. I also have couple external companies that need access to this servers and databases on different permission level (...
- 151
1
vote
0
answers
122
views
Determine if there's Network Traffic over a TCP/IP Connection using PowerShell in Windows?
I had a situation where an application was "hanging" in accessing the database. I was able to see that there was a connection by using
Get-NetTcpConnection -RemotePort x
This showed that ...
- 425
11
votes
2
answers
6k
views
gMSA account authentication failure during password rotation
When our gMSA accounts are automatically rotated, we see login failures for around 1-10 minutes. This is particularly apparent for gMSA client accounts that connect to MS SQL server, but I think it ...
- 153
1
vote
0
answers
229
views
How to ensure a directory exists before starting SQL Server upon Windows startup?
How can I ensure that a directory exists upon Windows Server system startup, before SQL Server starts?
I'm running SQL Server 2017 on Windows Server 2019 on an Azure VM. I'd like to store my tempdb on ...
- 115
0
votes
1
answer
798
views
How to take backup of 500GB SQL database data?
We tried to copy 500GB data to local drive using copy option in SQL management studio but it getting failed after 2 or 3 hours...is there any size limitation to copy?
How much size script file should ...
0
votes
0
answers
152
views
Windows 2019 server on Azure, SQL memory crash
I'm running a website on Azure, I've got my own VM with Windows 2019, MSSQL server and IIS installed.
This is the second time the following happend now in about 3 months. The website has been up for ...
- 1
-2
votes
1
answer
96
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. ...
- 101
1
vote
0
answers
47
views
Client App using MS SQL Server 2000 periodically requires sa to reconnect client
I am now supporting a funky old app from 2000 that is an MS SQL Server 2000 client. For some unknown reason, random staff members will periodically not be able to log in to the app. I then have to ...
- 11
1
vote
2
answers
563
views
no permission to connect to the WMI provider - after sql server installation
I am the administrator of a windows server 2016.
After installing sql server, I want to use the sql server configuration manager to have a look at what ports and accounts are there, check if all is ok....
0
votes
0
answers
1k
views
Why does SQL Server keep creating the folder “C:\Program Files\Microsoft SQL Server\” when installing on another driver?
I specified a different drive wherever applicable during the SQL Server 2017 install. However, the directory C:\Program Files\Microsoft SQL Server keeps getting created. I basically have the expected
...
- 101
1
vote
1
answer
355
views
256TB, GPT disk, I can, but should I?
I just learned (thank you Kevh) that a GPT drive on Windows can hold 256TB
Unlike MBR that limits each partition to only 2TB in size, each partition in GPT can hold up to 2^64 blocks in length (...
- 113
1
vote
0
answers
1k
views
Nesting gMSA in security group for use in ACLs
I'm trying to solve a conundrum for my DBAs and developers. We have an application that is running under a gMSA (group managed service account) identity. This application needs to access a SQL ...
- 3,459
0
votes
1
answer
145
views
ejabberd and MS SQL on Windows?
Is it correct that if I install ejabberd on Windows machine I cannot use MS SQL instead of Mnesia? https://docs.ejabberd.im/admin/configuration/#microsoft-sql-notes seems to suggest it, it says, "For ...
- 121
3
votes
1
answer
10k
views
Blue question mark on SQL server and SQL server agent?
I just installed MS SQL server 2017 on MS Server 2019. All installation process were fine. Using SSMS 18 access SQL server locally was fine, no issue at all.
But when I use SSMS 18 connecting SQL ...
- 902
0
votes
1
answer
947
views
Switch AWS EC2 Instance from sql server enterprise to standard
I'm trying to downgrade my ec2 instance from sql enterprise to sql standard or express, the thing i wanna keep the server content and i can't start from scratch.
i've tried uninstalling sql server and ...
- 111
1
vote
2
answers
61
views
Can I see the actual collation (of e. g. Latin1) as used in for instance MySQL or Windows? The order of characters, not the name
I searched, and all I find is descriptions of the names, and the selection of collations.
For example:
_Zulu
0Alpha
Alpha
alpha
usually sorts this way (on US Windows, most SQL servers etc.), ...
- 173
4
votes
2
answers
63
views
How we can have the ability to build a new sharepoint server which have the same sharepoint patches installed
we have couple of sharepoint 2013/2016 farms, and they all shared these architecture :-
one sharepoint application server which have sharepoint server installed.
one database server which have the ...
0
votes
1
answer
157
views
SQL Server 2017 Database Mail Silent error
I have made an installation of a development environment in VMWare that contains:
Windows Server 2016
SQL Server 2017
The objective is to perform migration tests of a base that is currently in:
...
- 131
2
votes
0
answers
390
views
How does DPAPI protect the master key for a service account?
I am trying to understand the security of TDE for MSSQL. The documentation says it relies on Windows DPAPI. DPAPI generates a master key using a user's credentials. This works well for human users ...
- 151
1
vote
0
answers
2k
views
SQL Server service: the service did not start due to a logon failure (Error 1069)
I am administering a database server running SQL Server 2016. The MSSQLSERVER service has been running under a domain account (with a password that does not expire) for a long time now with no ...
- 53
0
votes
1
answer
775
views
Is it possible for a group policy to interfere with a Sql Server Express installation?
We have a software package that our customers install on their user's laptops.
Part of the installer runs MS's Sql Server Express 2014.
We're passing the command-line options to to the installer ...
- 193
2
votes
2
answers
287
views
windows server backup. how to restore msssql database
it's theoretical question. If i have a window server 2012 r2 which have mssql server installed. I add role windows server backup.
So can restore the database which was backuped by windows server ...
- 33
5
votes
1
answer
8k
views
How can I get Microsoft Command Line Utilities 14 for SQL Server to install?
In order to run a third-party WSUS script (against the Windows Internal Database) I downloaded the x64 version of the Microsoft Command Line Utilities 14 for SQL Server, but when I attempt the ...
- 6,025
1
vote
1
answer
349
views
Can I restore a SQL Server instance from file backups only?
Our windows 2016 server failed to restart after a windows update yesterday.
In order to avoid the update that crashed it issue (whatever it was), I'm in the process of rebuilding it clean.
So I've ...
- 111
0
votes
0
answers
810
views
After windows 10 update, cant connect to sql server from program on a shared folder
After the new windows 10 update (may 10) my program cant connect to the sql server anymore. The executable is on a shared folder on another computer.
I've tried to run it as administrator, disabled ...
- 123
-2
votes
1
answer
61
views
Migrating a small office to a Windows cloud environment [closed]
I’m looking for the best way to migrate the IT of a small non-profit which I support to a Windows cloud environment. I’d appreciate your advice on choosing an affordable and friendly cloud provider ...
- 235
0
votes
1
answer
3k
views
Unusual SQL Service Account - Service did not start due to logon failure
This is crazy, so please bear with me. This is NOT incorrect password.
I have a SQL Service Account that will NOT authenticate. I am an experienced server guy and have tried all the basics with a ...
- 11
1
vote
3
answers
5k
views
MSSQL Server Connection without port number
I have a Microsoft SQL Server database on a Windows VM currently serving data over over server.fq.d.n,<port-number>. Users are able to connect to this database just fine using this <fqdn>,&...
3
votes
0
answers
536
views
Issue affecting general performance in Server 2012 R2
Back in 2016, We deployed a solution for one of our customers that was an Windows 2012 R2 RDS solution with 2 session host servers, a web server, a couple of file servers, a SQL server and an exchange ...
- 541
1
vote
1
answer
1k
views
How to configure delegation in an ASP.Net Core 2.0 app on windows with users authenticated via Azure AD
The Setup:
I have a web app written in ASP.NET Core 2.0 that authenticates against Azure AD using OpenID Connect. It is running on a machine that is part of an Azure AD domain. The app does have an ...
- 111
1
vote
0
answers
2k
views
Disks offline after reboot
Using Esxi 5.5, I created a 3 node windows failover cluster in Windows Server 2016 in order to run SQL Server 2016 Always On High Availability. Each node of the cluster has 3 disks (O/S, Data and Logs)...