473,583 Members | 3,165 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Basic SQL Server Question

After creating database in SQL Server , it generates .mdf , .ndf
datafiles .
Generally if we get those datafiles then we can create the database
with tables/data on another machine by using those datafiles.

I want to know, if we can we protect this? I don't want another user
to take those files and create database on another SQL Server. Is
there any option available in SQL server while creating database to
protect this file with password or any darn thing for protection that
would not allow to create the database by using those file or any
workaround.

Thanks in advance for your help.
Jul 20 '05 #1
1 1120

"Ashwani" <en**********@y ahoo.com> wrote in message
news:c1******** *************** ***@posting.goo gle.com...
After creating database in SQL Server , it generates .mdf , .ndf
datafiles .
Generally if we get those datafiles then we can create the database
with tables/data on another machine by using those datafiles.

I want to know, if we can we protect this? I don't want another user
to take those files and create database on another SQL Server. Is
there any option available in SQL server while creating database to
protect this file with password or any darn thing for protection that
would not allow to create the database by using those file or any
workaround.

Thanks in advance for your help.


No, that's not possible (you can set a password on a backup set, though).
However, since only administrators should be able to access the server
filesystem, the best approach is simply to ensure that you're following
standard security procedures: NTFS permissions are properly set
(administrators and the MSSQL service only), no users have direct access to
the filesystem, no one has sysadmin access except sysadmins etc.

You can use the MBSA to check your current security configuration:

http://www.microsoft.com/technet/sec.../mbsahome.mspx

Also see the resources here about securing SQL Server:

http://www.microsoft.com/sql/techinf...ty/default.asp

Simon
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
9273
by: Michael Foord | last post by:
#!/usr/bin/python -u # 15-09-04 # v1.0.0 # auth_example.py # A simple script manually demonstrating basic authentication. # Copyright Michael Foord # Free to use, modify and relicense. # No warranty express or implied for the accuracy, fitness to purpose
3
1464
by: nick | last post by:
Hi, I'm pretty much a database beginner and have what I think is a basic question: If I have a table which has a 'status' column and I can have say three statuses: "active", "pending", "inactive". Is it better to break these out into a different "Statuses" table? On the one hand it seems to me it would be better to be in a different
1
1613
by: mark wade | last post by:
Thanks for any help in advance. I am new at HTML. I have two programs to use to develop a website (personal) Frontpage and HTML-Kit. My question is, if I use Frontpage, I am limited to using IIS as a server. Just wondering if Microsoft has any types of hooks in the App that would limit the hosting platform. I also plan on using basic...
6
1753
by: msnews.microsoft.com | last post by:
Hello All, I am very new to ASP.NET and I have a basic question. Can somebody please explain? I have an .aspx Web Page with a textbox control. When the Page initially loads I am calling a Javascript function to write a text information in the text box.
13
15545
by: Pete | last post by:
I'm cross posting from mscom.webservices.general as I have received no answer there: There has been a number of recent posts requesting how to satisfactorily enable BASIC authorization at the HTTP level but as yet no fully useful answer. I too have been trying to call an apache/axis webservice which desires a username/password from my C#...
4
257
by: CSharpguy | last post by:
I'm not sure if this is the correct forum or not, but I have a basic question. Currently we have are doing calculations via stored procedures and then returning the results back to the client in either a web page or a winForm style application. There are times that the stored procedure takes 20 minutes or 3 hours to run. Now, our database...
1
1483
by: frankhanretty | last post by:
Do I have to install Visual basic on the remote terminals as I did on the server? I have an visual basic 5 application running fine on my client's server and he is now networked. He wants to run the visual basic applicaton that runs on his server on the remote terminals. (he has two networked to his server) My question is do I now have to install...
10
3316
by: CCLeasing | last post by:
How do I communicate between different user instances of my windows forms project? Im trying to write a program that will run on a network of 15 pcs. 5 of the pc's will run the admin part of the program. and the rest of the pc's will run the salesman part of the program. Both forms (the admin form, and the salesman form) at this stage...
2
4336
by: Dave Dean | last post by:
Hi all, I'm just starting out in sockets/network programming, and I have a very basic question...what are the 'security' implications of opening up a socket? For example, suppose I've written a simple chat server and chat client. The server opens a socket, listens on a port, and accepts incoming connections. The clients open a socket and...
4
3086
by: Chris Asaipillai | last post by:
Hi there My compay has a number of Visual Basic 6 applications which are front endeed onto either SQL Server or Microsoft Access databases. Now we are in process of planning to re-write these applications into Visual Basic.Net. My managers main thought is that Visual Basic 6 is (or has!) stopped being supported by Microsoft.
0
7896
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7827
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8184
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
5701
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5375
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3820
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3845
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2334
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1434
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.