can i have more than 1 login ?
hi Carol,
"Carol Carrot" <CarolCarrot@.sofsof.net> ha scritto nel messaggio
news:yYOdnQn7CvSPvLvcRVn-pQ@.comcast.com...
> can i have more than 1 login ?
>
I do not probably understand you question, but SQL Server allows for sure
multiple logins, both Windows and SQL logins... please start reading at
http://msdn.microsoft.com/library/de...ar_da_0n77.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||HI. Thanks. I mean does he MDSE allow for multiple logins.
Thanks
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2omnqoFbkrv9U1@.uni-berlin.de...
> hi Carol,
> "Carol Carrot" <CarolCarrot@.sofsof.net> ha scritto nel messaggio
> news:yYOdnQn7CvSPvLvcRVn-pQ@.comcast.com...
> I do not probably understand you question, but SQL Server allows for sure
> multiple logins, both Windows and SQL logins... please start reading at
>
http://msdn.microsoft.com/library/de...ar_da_0n77.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Carol,
"Carol Carrot" <CarolCarrot@.sofsof.net> ha scritto nel messaggio
news:rPmdneUmlYaFpLvcRVn-hQ@.comcast.com...
> HI. Thanks. I mean does he MDSE allow for multiple logins.
MSDE is SQL Server... and share the same architechtural design regarding
permission and security...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Yes I know MSDE is a stripped-down SQL Server.
My question was about the security (logins).
Of course, there are differences between MSDE and SQL Server.
I wondered if logins was one of them.
Thank you for answering my question when you told me logins is the same in
MSDE and SQL Server.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2on811Fcsb0eU1@.uni-berlin.de...
> hi Carol,
> "Carol Carrot" <CarolCarrot@.sofsof.net> ha scritto nel messaggio
> news:rPmdneUmlYaFpLvcRVn-hQ@.comcast.com...
> MSDE is SQL Server... and share the same architechtural design regarding
> permission and security...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Carol,
"Carol Carrot" <CarolCarrot@.sofsof.net> ha scritto nel messaggio
news:fe6dnailS5GgR7vcRVn-qA@.comcast.com...
> Yes I know MSDE is a stripped-down SQL Server.
> My question was about the security (logins).
> Of course, there are differences between MSDE and SQL Server.
> I wondered if logins was one of them.
exactely the same... the differences between full blown SQL Server and MSDE
are not in this area...
you can find some of them at
http://www.microsoft.com/sql/msde/pr...o/features.asp and
http://www.microsoft.com/sql/evaluat...ew/default.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||so, to go thru a pig's butt for a slice of bacon, the anser is "yes"
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2op1hrFcoqi3U1@.uni-berlin.de...
> hi Carol,
> "Carol Carrot" <CarolCarrot@.sofsof.net> ha scritto nel messaggio
> news:fe6dnailS5GgR7vcRVn-qA@.comcast.com...
> exactely the same... the differences between full blown SQL Server and
MSDE
> are not in this area...
> you can find some of them at
> http://www.microsoft.com/sql/msde/pr...o/features.asp and
> http://www.microsoft.com/sql/evaluat...ew/default.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi Carol,
Please avoid trying to be smart about this. It isn't helpful. I'd ask you to
consider two basic things: Andrea contributes non-stop to this group, day
after day and English isn't his first language. Personally, I think a reply
that points out where to find a list of the actual differences is more
useful than just a "yes".
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Carol Carrot" <CarolCarrot@.sofsof.net> wrote in message
news:9_adnYGgk9Uo47rcRVn-ig@.comcast.com...
> so, to go thru a pig's butt for a slice of bacon, the anser is "yes"
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:2op1hrFcoqi3U1@.uni-berlin.de...
> MSDE
>
|||Well, I was hoping i could help him be more concise and accurate without
interference.
I think he does a great job. Yes is the right answer. IMHO.
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:e6s69yCiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi Carol,
> Please avoid trying to be smart about this. It isn't helpful. I'd ask you
to
> consider two basic things: Andrea contributes non-stop to this group, day
> after day and English isn't his first language. Personally, I think a
reply[vbcol=seagreen]
> that points out where to find a list of the actual differences is more
> useful than just a "yes".
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Carol Carrot" <CarolCarrot@.sofsof.net> wrote in message
> news:9_adnYGgk9Uo47rcRVn-ig@.comcast.com...
visual
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment