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
>
Showing posts with label peter. Show all posts
Showing posts with label peter. Show all posts
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
>
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
>
Subscribe to:
Posts (Atom)