پسورد برای SQlServer2000

[par1234]

سلام
آیا این امکان هست که روی SQLServer2000 پسورد قرار داده بشه؟یعنی مثلا زمان باز کردن enterprise manager از ما برای ورود ، پسورد خواسته بشه . ممنون میشم راهنمایی کنید

[ealireza]

به نظرم به SA رمز بدی حله ...
سروری هم که LOCAL بصورت خودکار تعریف شده حذف کن

[Kamyar.Kimiyabeigi]

شما میتونین در SQL Server Enterprise در قسمت Security و در قسمت Login هم کاربر جدید تعیین کنین با سطح دسترسی دلخواه و هم میتونین برای کاربرهای پیش فرض SQL کلمه عبور بزارین

[Achchan]

شما میتونین در SQL Server Enterprise در قسمت Security و در قسمت Login هم کاربر جدید تعیین کنین با سطح دسترسی دلخواه و هم میتونین برای کاربرهای پیش فرض SQL کلمه عبور بزاری
You are badly locked in Balderdash.At best case you have misunderstood the basic concteps of SQL Server.Due to 2-layer model of security in SQL Server then you can set security mechanisms in both layers: Think about it and please think again! What is the relationship between *Login* folder in SQL Server and *Security* folder in each database? Are they equivalent?! Please at least Books OnLine when you want to help others.Your post is misleading.
Logins are about "Server level security" that you can use two modes of Authenticatio for that.If you are using "Windows authontication" so you can't do anything about EM or any other tool.
Users are database object which may map predefined logins or windows groups.I strongly recommand you to read Books online or have a look at: http://www.sqlservercentral.com/columnists/awarren/loginsusersandrolesgettingstarted.asp
-Feel free to mail me: baronc_rampantc@yahoo.ca

[Kamyar.Kimiyabeigi]

You are badly locked in Balderdash.At best case you have misunderstood the basic concteps of SQL Server.Due to 2-layer model of security in SQL Server then you can set security mechanisms in both layers: Think about it and please think again! What is the relationship between *Login* folder in SQL Server and *Security* folder in each database? Are they equivalent?! Please at least Books OnLine when you want to help others.Your post is misleading.
Logins are about "Server level security" that you can use two modes of Authenticatio for that.If you are using "Windows authontication" so you can't do anything about EM or any other tool.
Users are database object which may map predefined logins or windows groups.I strongly recommand you to read Books online or have a look at: http://www.sqlservercentral.com/columnists/awarren/loginsusersandrolesgettingstarted.asp
-Feel free to mail me: baronc_rampantc@yahoo.ca
تا زمانی که شما به این سایت احترام نگذارید و پستهاتونو فارسی ننویسید, اونها رو نمیخونم

[Achchan]

Sorry but it does not change anything.A helpful english post is more better than a wrong answer in farsi or any other language.Instead of being depressed try to read and learn fundamental I think you really need it.
-Good luck!

[Kamyar.Kimiyabeigi]

Sorry but it does not change anything.A helpful english post is more better than a wrong answer in farsi or any other language.Instead of being depressed try to read and learn fundamental I think you really need it.
-Good luck!
با توجه به روندی که پیش گرفتین فکر نمیکنم در Topic ها به پستهاتون توجه بشه و من دیگه به پستهاتون جواب نمیدم
موفق باشین

[Achchan]

Sorry again and more for your sadness. It is a fact: Don't bother yourself to read or not to read my posts,hey boy I am not you boss or anything else like that! Try to read more and learn.Don't forget professional ethics and go ahead.I don't want to punish you: Just a recommandation.Think about it.Also if you changed your decision to post me(You have said it 2 post before this! ) why you didn't bother yourself and post a *technical reply* not your depression document? Try to be technical instead of being in suburb of technology and misleading others..
-Good luck boy!

[m-khorsandi]

درود


Sorry but it does not change anything
چرا امکانش هست و راه حل هم، تایپ فارسی هست.


A helpful english post is more better than a wrong answer in farsi or any other language
مسلما" همینجوری هست که میفرمائید، اما شما فکر میکنید پست هایی که تا حالا داشتید مشکل گشا بوده،
در صورت امکان جوابهاتون رو مرور کنید.

[Achchan]

Really really sorry for nervous posters.Try to reply to original poster who has a real problem not to me.I think it is not a bad thing to be unaware and not skillful but it is so bad to be unaware about this subject and push the posts toward not useful, nervous posts.
I say again : it is a fact that your posts were irrelevant.You say my posts are so too! I am happy that at least you accept that yours are irrelevant!This was a great step boy! If my post was not useful(That I don't think so personaly) at least I point the origianl poster to a useful reference,didn't me?

I strongly recommand you to read Books online or have a look at: http://www.sqlservercentral.com/col...tingstarted.asp
Be fair, and don't get angry for your lack of knowledge,read and learn!It is so easy if you are not lazy!And if it is not your way so you should leave this category,it is the nature of computer world my angry friend.
-Good luck in your training career!