Wrox Programmer Forums
Go Back   Wrox Programmer Forums > C# and C > C# 2005 > C# 2005
| Search | Today's Posts | Mark Forums Read
C# 2005 For discussion of Visual C# 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 8th, 2007, 02:12 PM
Friend of Wrox
 
Join Date: Dec 2006
Location: , , .
Posts: 176
Thanks: 0
Thanked 0 Times in 0 Posts
Default enterprise manager security

hi
how can i set the user name and password for opening Enterprise manager?
  #2 (permalink)  
Old April 8th, 2007, 10:52 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

The username and password of what? SQL Server? A specific account in SQL? Can you be more specific?

-Peter
  #3 (permalink)  
Old April 9th, 2007, 09:33 AM
Friend of Wrox
 
Join Date: Dec 2006
Location: , , .
Posts: 176
Thanks: 0
Thanked 0 Times in 0 Posts
Default

let me to explain more
my problem is that i have an application that work with database
i don't want any one able to open my database file on the enrerprise manager and modification my data base file manually
help me
  #4 (permalink)  
Old April 9th, 2007, 12:50 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

I think what you are looking for is simply SQL server security. You need to establish security logins to the database(s) you wish to secure. Provide the appropriate access to whomever needs it. Of course, if someone can access the sql server computer directly (sit down at a terminal or login thru remote desktop) then it's likely that they can just launch the management tools from the terminal with administrative access. I'm not sure what you can do about that.

-Peter
  #5 (permalink)  
Old April 9th, 2007, 04:03 PM
Friend of Wrox
 
Join Date: Dec 2006
Location: , , .
Posts: 176
Thanks: 0
Thanked 0 Times in 0 Posts
Default

how can i establish logins to my sql database(s)?
how cani provide security for whomever i want?
thanks
  #6 (permalink)  
Old April 9th, 2007, 04:15 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

Have you tried looking at the documentation?

http://msdn2.microsoft.com/en-us/library/ms130214.aspx

-Peter


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enterprise Manager Problems Jan_Ma ASP.NET 1.0 and 1.1 Basics 3 October 22nd, 2003 07:50 AM
Enterprise Manager Jan_Ma SQL Server ASP 1 October 17th, 2003 08:45 AM
Enterprise Manager Jan_Ma Classic ASP Databases 1 October 17th, 2003 08:44 AM
Enterprise Manager Problems Jan_Ma SQL Server 2000 1 October 17th, 2003 08:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.