All Questions
Tagged with sql-server security
15
questions
0
votes
1
answer
80
views
Windows 10 Home Has my Sql Server (SSMS) been hacked? Weird passwords I did not assign in sys.syslogins
I am running Sql Server Dev 2017 with SSMS and Windows Authentication in Windows 10 Home Edition.
My SqlServer is and always has been offline (TCP/IP is disabled for my SqlServer, no inbound rules in ...
1
vote
1
answer
2k
views
Painfully slow local development and MS-SQL connection
I know some may suggest that this question needs to be asked on StackOverFlow, but I do not believe this is not a Dev issue and probably an IT/Security thing. I have posted this on ServerFault as well....
0
votes
1
answer
96
views
What are the real risks of making a Azure SQL DB accessible for all Azure Services?
This is more of a general question regarding network security which came up while I was brainstorming about SQL Databases on Azure.
When you configure a SQL Database you have the Option to make the ...
1
vote
0
answers
358
views
How to set up SQL User that can only do one thing (run stored procedure) and nothing else?
I would like to allow any user within a certain group of our domain access to login to one of our databases and run a specific Stored Procedure. This is the only action these users should be able to ...
0
votes
0
answers
732
views
Converting exported private key from Microsoft SQL Server to PEM and back to PVK
I have need to backup the cert and private key for SQL TDE and store that on a KeySecure key management system.
I can do the backup and get the files, and have no issue with converting the ...
1
vote
1
answer
2k
views
SQL Sever Management Studio 2008 does not let me back up my database
I tried to back up a server I created in SQL Server, but I received the following message:
TITLE: Microsoft SQL Server Management Studio
Backup failed for Server 'LAPTOP-6D0L83DV\SQLEXPRESS'.
...
0
votes
1
answer
945
views
How to securely connect a Webserver to a Database server through WAN
I have two servers, one that will be hosting a database. The other a website.
The one hosting the website should be able to accept and sent requests from any IP. The database server should ideally ...
0
votes
1
answer
175
views
What ports do I need to open for offshore to access our SQL Server db?
When using SSMS, for example, for connect to a SQL Server, I would specify the server name to which a wanted to connect as well as the Authentication method, in this case, Windows Authentication. If ...
-1
votes
2
answers
735
views
SQL Server Database Encryption [closed]
Let's say two programmers are working on a website for a store. They've created a small database for an online store. Users would have to register and provide a username(e-mail address) password,home ...
0
votes
0
answers
1k
views
How can I access my home MS SQL Server DB from a remotely hosted web service?
As can probably be seen (if not already see below) I am fairly networking illiterate. Here is what I would like to do:
Setup a SQL Server DB hosted on a computer I have in my home.
I want to be able ...
2
votes
1
answer
3k
views
The Login is from an untrusted domain - domain setup with computer level login
I have a SQL Server 2008 R2 database I'm attempting to connect to using ADO.NET using integrated security in the connection string.
The database resides on a 64-bit Windows Server 2003 machine. The ...
1
vote
1
answer
233
views
How to find my network and database access [closed]
Our company gets audited pretty regularly and I was wondering if there's an easy way to find out which accounts have access to what on our network?
We're an all windows development shop, so all our ...
3
votes
3
answers
2k
views
Is my system compromised? I got message about ntoskrnl.exe
I am not sure this question belongs her or not but let me try.
When I get to office this morning One of my colligues had a problem with his laptop and told me he had trouble restarting it and when he ...
1
vote
1
answer
213
views
How do I find out what my SQL Server database audit records contain?
I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?
13
votes
4
answers
42k
views
Which ports to open for Microsoft SQL Server?
Having searched the internet a few times on the best way to open up SQL Server connectivity through windows firewall i've yet to find a best way of doing it. Does anyone have a guaranteed way of ...