Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2003-08-29 : 20:49:37
|
| hi all!We recently installed sql server 2000 developer edition.We set up security using mixed mode.Today, one of our peers complained to management that he was "having problems" using sql server because it was a developer version and that it was set up incorrectly.Can someone please shed some light on two issues for me.One, is there any major difference between developer edition and enterprise edition other than the fact that developer edition cannot be used for live production database and that it can't be used for failsafe and recovery purposes.As far as fully functional database is concerned, is there any difference between developer edition and enterprise edition?Second, is it better to use mixed authentication mode or windows only authentication mode?Thanks in advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-30 : 01:25:29
|
| >> is there any major difference between developer edition and enterprise edition no see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp>>it can't be used for ... recovery purposesYes it can - depends what you mean but you can backup and restore.>> is it better to use mixed authentication mode or windows only authentication mode?Depends on the security strategy (clients that need to connect). Windows only maybe easier to manage but allowing sql server logins can be useful.What does he say is incorrect about the setup?Make sure you have set the recovery model on the databases to simple or have implemented transaction log backups.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2003-08-30 : 07:20:17
|
| thank you very much for the clarification, especially the matrix.He didn't say what was wrong with it. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-30 : 13:47:58
|
| Sounds like he might be having problems because he doesn't understand it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2003-08-31 : 09:36:51
|
| I agree with you.Secondly, I spend a lot of time trying to educate these programmers who got jobs straight from college that trying to point out someone's fault while blowing your own horn no longer guarantees job security.He uses the following connection method:emailDB.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=safety;Data Source=pt2.The current set up with our sql server db is:Authentication Mode: Mixed (sql server and windows)Startup service account: System Account.nr, Is there something wrong with this setup?Second, how secure is the above connection mode which my partner uses?Thanks again for all the clarifications you have given.I am more confident now with my position on these issues. |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-08-31 : 11:44:29
|
| Integrated Security=SSPI <--- NT authentication;He is using NT authentication which is what you want.For more information on security and how to secure your server seewww.sqlsecurity.com |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-31 : 17:09:29
|
| Using the local system account is a bit dubious - probably would want to use a domain account.But you can't run a live system on the developer edition so that is probably OK unless you want email or something like that.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2003-08-31 : 18:26:45
|
| Ok, we are actually using the developer edition for development and testing only, which is why it is hard to understand why a big deal was being made about the developer/enterprise edition and also the setup.We do have enterprise edition that is setup with the windows authentication mode only and uses a domain account.One last question on this and I would have gotten as much information as I could get.If we retain the mixed mode option and change the account from system account to a domain account, can we still make the following code work?emailDB.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=safety;Data Source=pt2.I know this is more a web component question. |
|
|
|
|
|
|
|
|
database question