Sunday, February 19, 2012

Dollar sign behind user name

What does the $ (dollar sign) means behind the SQL Server login?
I had a SQL Server login something like this "DomainName\User$".
Peter ChanThis is generally a computer account. If a service runs under Local System
or Network Service on a remote computer it can be allowed access to SQL
across the network via it's computer account (which is the credential it
passes over the network)
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1175854131.654355.132230@.y80g2000hsf.googlegroups.com...
> What does the $ (dollar sign) means behind the SQL Server login?
> I had a SQL Server login something like this "DomainName\User$".
>
> Peter Chan
>

No comments:

Post a Comment