network profile
| bio | website | |
|---|---|---|
| location | Prague, Czech Republic | |
| age | 38 | |
| visits | member for | 1 year |
| seen | Jun 28 '12 at 21:25 | |
| stats | profile views | 0 |
Enthusiastic developer at NCR, spending most of his time around machine-to-machine interfaces. Published an arcane book in computational complexity.
|
Jun 5 |
comment |
Connecting to SQL Server using cached credentials Thank you for the extra info. We will go the local account way and maybe even buy your book :-) |
|
Jun 5 |
comment |
Why do we have SHRINKDATABASE command in SQL Server And, regarding the bloated LDF file, shrinkdatabase usually doesn't even work alone because of how virtual logs are allocated and rotated. (I found out I had to simulate some "load" while repeatedly shrinking.) technet.microsoft.com/en-us/magazine/2009.02.logging.aspx |
|
Jun 4 |
comment |
Connecting to SQL Server using cached credentials I get that. But you are saying that when AD is online, the service can log on, but no credentials will be cached for later use, because this particular log on is not interactive. Correct? |
|
Jun 4 |
awarded | Scholar |
|
Jun 4 |
accepted | Connecting to SQL Server using cached credentials |
|
Jun 4 |
awarded | Supporter |
|
Jun 4 |
comment |
Connecting to SQL Server using cached credentials This was the key bit of info I was missing. Can you please confirm my understanding? Suppose that I create a domain account that is allowed to log on interactively. Then credential caching will happen as configured when this user logs on as a normal user; but if I try to use the same account as a service logon account, such a service startup or database authentication will never result in caching the credentials in registry. Is that correct? |
|
Jun 4 |
comment |
Connecting to SQL Server using cached credentials @JonSeigel - Unfortunately not. All domain accounts have this problem (NETWORKSERVICE translates to the computer account). In fact we are considering to use a local non-domain account which is obviously a step back from security but a less drastic one than removing the whole system from the domain. |
|
Jun 4 |
awarded | Student |
|
Jun 4 |
asked | Connecting to SQL Server using cached credentials |
