All Questions
Tagged with sql-server windows-10
33
questions
0
votes
1
answer
276
views
Is it possible to use sp_addrolemember on a SQL Server database without Management Studio? Only using sqlcmd
I’m trying to avoid installing Management Studio on multiple servers.
Is it possible to add Sp_addrolemember to a database only using sqlcmd?
I tried:
sqlcmd -S .\SQLEXPRESS -E
USE [DBName]
EXEC ...
2
votes
1
answer
37k
views
How to remove SQL Server completely?
I have a faulty installation of SQL Server and want to remove it completely. The problem is there are too many entries in Apps & features in control panel (Uninstall programs).
I followed this ...
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
2
answers
317
views
Is it safe to kill and uninstall sqlserver.exe?
I am a student who mainly works with Visual Studio/Visual Studio Code/Emacs. I think the SQL server was installed with visual studio. I don't really do anything related to SQL servers and especially ...
1
vote
0
answers
647
views
Can't connect from Excel to SQL Server 2017 on Windows / On Mac it works
I have the following setup: A Windows Server running SQL Server 2017 joined to a domain. Some groups of the AD Domain have the permission set to sysadmin and public.
When I open Excel (Version 1908) ...
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. ...
5
votes
2
answers
11k
views
Where is the SQL Configuration Manager in SQL Server Management Studio 18?
I am setting up a new computer, a Surface Laptop 3. I have installed SQL Server Management Studio 18.4, downloading it from here.
I am just trying to install client tools and not the server software....
18
votes
3
answers
12k
views
Does a Window 10 license allow using it as a Web server?
I am looking to set up a Web server for a project.
The server would be using a custom application developed in VB.Net using SQL Server for data storage. The application uses 3rd party components (DLL'...
1
vote
0
answers
971
views
Why won't SSMS-Setup-ENU.exe start?
I need to install SQL Server Management Studio. I downloaded the setup file then I click on the setup file to install it, but nothing happens.
I tried to open it as administrator. Yet again, nothing ...
0
votes
0
answers
671
views
Cannot install SQL Server Migration Assistant for Access due to missing Data Access Object libraries
I have a requirement to migrate some MS Access databases to SQL Server, and would like to use the Microsoft SQL Server Migration Assistant 8.3 for Access. One of the pre-requisites for installing SSMA ...
0
votes
1
answer
927
views
Unable to Install Microsoft SQL Server Management Studio Express
I'm trying to install Microsoft SQL Server Management Studio Express (SSMSE).
version: SQLServer2005_SSMSEE_x64.msi
I get the error:
"The installer has encountered an unexpected error installing ...
1
vote
1
answer
321
views
Unable to delete a sql backup file(~2.1 TB ) even as an Admin
I have a SQL job which created a transaction log backup which is around ~2.1Tb.
Using the same SQL job few more log backups are created and those are of low size. (~200 MB).
When I tried to delete the ...
0
votes
1
answer
82
views
My new installation of SQL Server Management Studio 18.2 have a trouble with its UI
Every time I start the applications it's UI is disappearing. Like this Disappearing UI, or like this Disappearing UI
Please help me to solve that problem. Thanks for your attention.
0
votes
1
answer
4k
views
Unable to uninstall SQL Server Integration Services Projects Extension
I installed SQL server, then SSDT from VS installer and after that the SSIS Extension v3.0 for VS Community 2019. But now that I try to uninstall it I get the following error:
Some components will ...
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)...