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