Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

how to give password to database of sql server

 
   Database Help (Home) -> Programming RSS
Next:  Securing Data Through Views  
Author Message
yogesh shrikhande

External


Since: Sep 26, 2006
Posts: 1



(Msg. 1) Posted: Tue Sep 26, 2006 4:12 am
Post subject: how to give password to database of sql server
Archived from groups: microsoft>public>sqlserver>programming (more info?)

i want to give password to mssql 7 database password because when i
distrubuted mssql database that does not open
by other computer use even though he use attach method
plz tell me how i give security to my database

thanks
yogesh

 >> Stay informed about: how to give password to database of sql server 
Back to top
Login to vote
Uri Dimant

External


Since: Aug 24, 2003
Posts: 1744



(Msg. 2) Posted: Tue Sep 26, 2006 2:17 pm
Post subject: Re: how to give password to database of sql server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi
<http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=1&tabid=2> --------Security
SQL SERVER











"yogesh shrikhande" wrote in message

>i want to give password to mssql 7 database password because when i
> distrubuted mssql database that does not open
> by other computer use even though he use attach method
> plz tell me how i give security to my database
>
> thanks
> yogesh
>

 >> Stay informed about: how to give password to database of sql server 
Back to top
Login to vote
Tibor Karaszi

External


Since: Jan 29, 2004
Posts: 1559



(Msg. 3) Posted: Tue Sep 26, 2006 2:27 pm
Post subject: Re: how to give password to database of sql server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

There is no concept of "database password" in SQL Server. If your customer doesn't succeed with the
attach, they are probably doing something incorrect, and we need the error message returned by SQL
Server. Also, make sure you actually detach the database before sending the database files.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"yogesh shrikhande" wrote in message

>i want to give password to mssql 7 database password because when i
> distrubuted mssql database that does not open
> by other computer use even though he use attach method
> plz tell me how i give security to my database
>
> thanks
> yogesh
>
 >> Stay informed about: how to give password to database of sql server 
Back to top
Login to vote
fedf

External


Since: Oct 11, 2010
Posts: 1



(Msg. 4) Posted: Mon Oct 11, 2010 9:13 am
Post subject: RE: how to give password to database of sql server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Back to top
Login to vote
Display posts from previous:   
Related Topics:
Can I give a order rule for bookmarks? - I have an insert button on my page, which inserts a row in a table with 6 columns (6 formfields) everytime I press it. What I want to know is that everytime I insert a row, is there a way I could make sure that the formfields have ordered bookmarks? In....

ASP+Different Server(2 SQL Server installed in different P.. - Dear all: I have a problem about ASP link with 2 different SQL Server. (2 SQL server installed in 2 different PCs) I have few tables stored in Server A. (The source) and for some reason I create few tables in Server B. I am tring to use ASP to select..

Database Server Name within SQL Server Management Studio - Is there any way to discern which table belongs to which server when I open a table within SQL Server Management Studio??? Some clarification...if I open a DEV Table, I'd like the tab within SQL Server Management Studio to disclose the server in which...

SQL Server View on two Database Server question - Hi, In my SQL Server 2000, I would like to create a VIEW across two databases on two database servers. How do I do that? Thanks for help. Jason

How to copy fields from one database on one server, to fie.. - Sorry for the long title, but that's what I'm looking to do. Here's the info I have... Source DB: STData on Server Number 1 Source Table: tblMBCust Source Field: cust_11 Destination DB: IBSWIN on Server Number 2 Destination Table: customer Destination...
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]