Wednesday, March 7, 2012

Does anyone know if guest account must be enabled?

Hi a user is not able to run a windows application that uses SQL
authentication and was just wondering if the guest account have to be enabled
on the SQL Server for SQL authentication to work?
Thanks.
--
Paul G
Software engineer.There is a thread from Kimberly:
http://groups.google.de/group/microsoft.public.sqlserver.security/browse_thread/thread/ea9205103023d109/78b922f9b1e2a009?q=guest+account+sql+server+microsoft&rnum=3&hl=de#78b922f9b1e2a009
HTH, Jens Suessmeyer.
"Paul" wrote:
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enabled
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.|||No need for any type of guest account.
Only time I heard about that is if you are in separate domains and you don't have trusts and you are
using the Named Pipes netlib, which depends on the IPC$ share). I don't know if this is still the
case, but in any case moving to the IP netlib should remove that need.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:690F2DCE-4020-48A3-ACE7-36006029871C@.microsoft.com...
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enabled
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.|||ok thanks for the information. Sounds like it does not effect SQL login
--
Paul G
Software engineer.
"Jens Sü�meyer" wrote:
> There is a thread from Kimberly:
> http://groups.google.de/group/microsoft.public.sqlserver.security/browse_thread/thread/ea9205103023d109/78b922f9b1e2a009?q=guest+account+sql+server+microsoft&rnum=3&hl=de#78b922f9b1e2a009
> HTH, Jens Suessmeyer.
> "Paul" wrote:
> > Hi a user is not able to run a windows application that uses SQL
> > authentication and was just wondering if the guest account have to be enabled
> > on the SQL Server for SQL authentication to work?
> > Thanks.
> > --
> > Paul G
> > Software engineer.|||To me it wasn't clear whether you refer to the guest user inside a database, if so see Jens' reply.
Or if you refer to a Gust Windows account, if so, see my reply.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:C9EE6BC1-2F9B-4E9B-A585-DABB6A6F22B6@.microsoft.com...
> ok thanks for the information. Sounds like it does not effect SQL login
> --
> Paul G
> Software engineer.
>
> "Jens Sü�meyer" wrote:
>> There is a thread from Kimberly:
>> http://groups.google.de/group/microsoft.public.sqlserver.security/browse_thread/thread/ea9205103023d109/78b922f9b1e2a009?q=guest+account+sql+server+microsoft&rnum=3&hl=de#78b922f9b1e2a009
>> HTH, Jens Suessmeyer.
>> "Paul" wrote:
>> > Hi a user is not able to run a windows application that uses SQL
>> > authentication and was just wondering if the guest account have to be enabled
>> > on the SQL Server for SQL authentication to work?
>> > Thanks.
>> > --
>> > Paul G
>> > Software engineer.

No comments:

Post a Comment