724 reputation
21835
bio website desertpenguin.org
location Zurich, Switzerland
age 37
visits member for 5 years, 7 months
seen Dec 18 at 15:05

Not a penguin and not a Linux user either.


Mar
13
comment SQL Server bulk import from fileshare. How can I get SQL Server to see the share?
I'm not sure I can make the tool do that. I'd have to sync with the developers.
Mar
13
comment SQL Server bulk import from fileshare. How can I get SQL Server to see the share?
I don't see what this would achieve.
Mar
12
revised SQL Server bulk import from fileshare. How can I get SQL Server to see the share?
edited body
Mar
12
comment SQL Server bulk import from fileshare. How can I get SQL Server to see the share?
That solves a different problem. As I described, I have a tool running on server A.
Mar
12
asked SQL Server bulk import from fileshare. How can I get SQL Server to see the share?
Feb
21
comment Running external programs from PowerShell results in error. Why?
Alas this is not possible. Company has very rigid rules and won't allow such changes.
Feb
21
comment Running external programs from PowerShell results in error. Why?
I think the error message is the last few words of something like "<name> is not an operable program or batch file" so something is apparently found. The programs do exist and can be started from the command line outside the script.
Feb
15
comment Running external programs from PowerShell results in error. Why?
Yes. I cannot install software on the machines. I can only run scripts to configure one product on them.
Feb
15
asked Running external programs from PowerShell results in error. Why?
Feb
8
awarded  Popular Question
Feb
3
comment Query another cluster group from SQL server?
Sending alerts is just using databasemail to send mails to operators. But those mails need to contain the name of the active application node. I guess I have to go with running cluster.exe from SQL Server, even though doing such is discouraged (but if there is no other way...).
Feb
3
asked Query another cluster group from SQL server?
Feb
1
revised Service running as local system on server A connecting to SQL server on server B. How?
added 461 characters in body
Feb
1
comment Service running as local system on server A connecting to SQL server on server B. How?
Specifically, msdn.microsoft.com/en-us/library/ms143504.aspx says that the local service account has the same privileges as members of the users group while local system has "has extensive privileges on the local system and acts as the computer on the network". I don't know where you found your definitions of the accounts, but it is wrong. Local system does have network access.
Feb
1
comment Service running as local system on server A connecting to SQL server on server B. How?
Again, that contradicts Microsoft's documentation. It is wrong.
Jan
31
comment Service running as local system on server A connecting to SQL server on server B. How?
blogs.msdn.com/b/dataaccesstechnologies/archive/2010/01/29/… claims the opposite. But regardless, I cannot use the network service account.
Jan
31
revised Service running as local system on server A connecting to SQL server on server B. How?
added 274 characters in body
Jan
31
comment Service running as local system on server A connecting to SQL server on server B. How?
What does double hop mean here?
Jan
31
comment Service running as local system on server A connecting to SQL server on server B. How?
Yes. But changing the default login in ODBC didn't seem to affect this.
Jan
31
comment Service running as local system on server A connecting to SQL server on server B. How?
I thought it was also localsystem?