Score of 21
What is "NT AUTHORITY" and "NT SERVICE"
A more technical explanation:
In Windows ACLs (access-control lists), permissions are applied to trustees - users, groups, or other security principals.
The trustees are uniquely identified by SIDs, ...
- reputation score 541
Score of 20
Accepted
How can I get rid of the "File Access Denied"?
Access permissions are not controlled by the "Read-only" checkbox; they're controlled by the "Security" tab (or the icacls.exe tool).
Open "Security > Edit..." and add ...
- reputation score 520890
Score of 16
Accepted
Why is "grep" unable to find matches in an SQL-Server generated script, even trivial ones?
grep doesn't have any file size limits so far as I know. It is far more likely an encoding issue. There are probably a lot of UTF-16, UTF-32 and even UTF-8 code points that are not encoded as 83 and ...
- reputation score 88707
Score of 15
Accepted
Additional User Account, Windows Authentication in SQL Server Management Studio
You need to add the user with his/her required roles and permissions:
In the SQL Server Management Studio, open Object Explorer
Click Server_instance_name > Security > Logins
Right-click Logins and ...
- reputation score 503653
Score of 9
SQL Installation hanging on windows 10
I had this issue with SQL Server 2019. The key part of this is:
Sco: Waiting for service 'msiserver' to accept the stop request.
I managed to force it to stop by running in an eleveated powershell ...
- reputation score 91
Score of 7
Is gradually growing swap usage an indicator for a memory leak?
Backing swap storage is a parameter that is consultable.
When it's sufficient then over-commitment of memory is not required.
My previous answer was not the real explanation.
The conclusion is then ...
- reputation score 503653
Score of 7
Why is "grep" unable to find matches in an SQL-Server generated script, even trivial ones?
grep is a traditional tool that has its limitations. Multibyte encodings, such as UTF-16 that you mentioned, are one of them - it can't handle them properly.
Instead of manually messing with encodings,...
- reputation score 17383
Score of 6
Accepted
Is there a way to enable tcp/ip protocol through powershell script or sql script?
Microsoft already provides guidance on this topic.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-2017
Using SQL ...
- reputation score 5186
Score of 6
Accepted
Where is the SQL Configuration Manager in SQL Server Management Studio 18?
The SQL Server Configuration Manager is part of SQL Server so in order to utilize it to manage the SQL Server protocols and such, you first need to install SQL Server as far as I know because it's ...
- reputation score 43299
Score of 5
Cannot uninstall SQL Server Management Studio 18 after forcefully stopping setup midway
I followed some steps from here which worked for me in similar situation:
Uninstalled SSMS 17.
Deleted "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18"
Deleted "HKLM\SOFTWARE\...
- reputation score 51
Score of 5
Does Azure Backup for Windows Server affect regular SQL Server backups on the same server?
I wanted to clarify as per that post you linked to in the question and you are asking about "to be protected even better from a possible ransomware attack" specifically as per the. . .
"You can ...
- reputation score 43299
Score of 4
Accepted
SQL Server started, but SQL Server Management Studio not connecting to it
Modern MS SQLServer don't require you to use the name MSSQLSERVER to connect to the default instance anymore (I honestly don't recall that being a thing since SQLServer 2000). You will see the string ...
- reputation score 37837
Score of 3
SSMS 2017 - How to restore .sql file association?
All of these answers are wrong. You have to repair SSMS. If you manually reassign .sql files, they will open with SSMS, but not in the proper way, which leads to multiple instances.
In my case ...
- reputation score 182
Score of 3
Accepted
SQL with an error
You have the creation of the table done correctly, but you aren't telling SQL what you want to do with the data you have after it.
To INSERT data into a table you need to use the following syntax:
...
- reputation score 8131
Score of 3
Does a Window 10 license allow using it as a Web server?
You cannot legally use Windows 10 to serve public websites with IIS/SQL server due to the 20 device limit. Please also note that the limit is not for concurrent connections but for the named devices (...
- reputation score 199
Score of 3
Accepted
What is the difference between 'client/server' and 'file-handling' systems?
The correct answer depends on who wrote the exam question (you should be asking your actual teacher for resources), but this is how I understand the terms:
In "client-server" databases, the ...
- reputation score 520890
Score of 3
Accepted
Avoid Excel to chop off the last digits of my numbers
First option - format the cells as text ahead of time. I don't much like this one, since it needs that extra step, but if the cells are already formatted as text BEFORE you paste it in, that ...
- reputation score 1032
Score of 3
Is gradually growing swap usage an indicator for a memory leak?
I think this is because of:
when something has been paged out and later read back in, the kernel will not remove it from the page file until either the file is otherwise full or the page in RAM is ...
- reputation score 261
Score of 3
Error installing SQL Server Database Engine Services with SQL Server 2019 on Windows 11 Home
The installation storage device seems to have/report an inappropriate sector size.
Take a look at Troubleshoot errors related to system disk sector size greater than 4 KB and Microsoft support policy ...
- reputation score 1416
Score of 3
Accepted
Automate SQL Queries with a Config File
Does this help?
In the same folder I placed a file named "config.txt" and also the workbook this macro is run from.
The config file contents:
You can use this macro to extract information ...
- reputation score 429
Score of 3
Accepted
How can I activate the Linux version of Microsoft SQL Server 2022 Enterprise?
No activation is required on the Linux version of SQL Server, but to use it "legally", you must own a licence to use the version of SQL Server that you selected during the initial setup.
...
- reputation score 203
Score of 3
Accepted
What does Microsoft mean by "on-premises software" in their Cloud VM SQL Server documentation?
Microsoft’s documentation is mixed up.
That linked documentation is horribly confused and seems to be legacy documentation “hacked” to add off-premises concepts and terminology.
The Microsoft ...
- reputation score 59451
Score of 3
Accepted
What are Base64 strings?
Base64 is a 6-bit encoding of 8-bit binary data, typically using characters a-z A-Z 0-9 / + (and usually = as final padding). "Base64 strings" would therefore be plain ASCII strings that ...
- reputation score 520890
Score of 2
Why does it take so long for SQL Management Studio to connect?
For me, the problem was that my machine name was longer than is allowed by NETBIOS (15 characters). Once I shortened it, navigating SSMS became lightning fast.
Windows warns you if you try to set your ...
- reputation score 21
Score of 2
Azure DevOps: In Azure SQL Publish Deployment, Missing values for the following SqlCmd variables:env master
In your pipeline, for the SQL Server Database deploy task. Add the following to "Additional Arguments" box. This way the parameter will be mapped when SqlPackage.exe runs the parameterized script.
/v:...
- reputation score 21
Score of 2
MySQL Workbench 8.0 Users and Privileges tab is blank
I had the same issue in MySQL Work Bench 8.0 and have executed the following script which resolved the same blank issue.
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password';
- reputation score 121
Score of 2
Accepted
unixODBC Driver Manager SQL Server Error
I had this exact error on Ubuntu 19.04 yesterday & today, and thought I might be able to help, after hours of frustration.
I used the command "ldd /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17....
- reputation score 136
Score of 2
Is there a way to enable tcp/ip protocol through powershell script or sql script?
I haven't worked out how to iterate through multiple instances installed on the same machine, but here's a script to enable TCP and Named Pipes for a named instance.
- reputation score 176
Score of 2
Accepted
Visual Studio (SSDT) SSIS create new project issue
I have just "fixed it".
I had to reinstall the Microsoft SQL Server Data Tools - Visual Studio 2017.
Uninstall the program:
Download again the installer for data tools stand alone for 2017.
This is ...
- reputation score 36
Only top scored, non community-wiki answers of a minimum length are eligible