Viewing 15 posts - 1,441 through 1,455 (of 7,191 total)
It's not something I can cover in a forum post, I'm afraid. You can start here. Once you have a PowerShell command that works, you can call it...
June 8, 2017 at 4:48 am
I don't know. The best way is to replicate the problem in a different environment and then test. I'm intrigued by this, so if you post some scripts I'll try...
June 8, 2017 at 4:04 am
I wouldn't use the guest user if you don't have to. The difference between EXECUTE AS and IMPERSONATE, as I understand it, is that the former is a statement, whereas...
June 8, 2017 at 3:22 am
Use a script such as the one shown here.
John
June 8, 2017 at 3:03 am
June 8, 2017 at 2:59 am
Why is it important for you to do this? Often an index scan is the more appropriate operation. We'll need, at the very minimum, table DDL and the query you...
June 7, 2017 at 9:45 am
It looks as if the SQL Server Browser service isn't working properly on Node 1, then. What happens if you try to connect from a different computer - your own...
June 7, 2017 at 7:19 am
When EXECUTE AS CALLEREXECUTE AS CALLER is specified, IMPERSONATEIMPERSONATE permissions are not required. -- This is why I wonder if you need impersonate access added to the Procedure
EXECUTE AS CALLER isn't specified....
June 7, 2017 at 5:56 am
June 7, 2017 at 5:46 am
What was the something that happened to the database? Do you have a backup of the database taken before that thing happened?
John
June 7, 2017 at 5:14 am
Taken from Microsoft's EXECUTE AS page:
To specify EXECUTE AS on a login, the caller must have IMPERSONATE permission on the specified login name and must not be denied the IMPERSONATE ANY LOGIN permission. To specify EXECUTE...
June 7, 2017 at 5:11 am
You didn't confirm that SQL Server Browser is running on both nodes.
When you say you can only connect in Node1, does that mean that when you run SSMS...
June 7, 2017 at 5:02 am
A strange way to do things. I prefer to use DML commands for what are essentially DML operations. If you use DDL commands, the user executing them needs higher permissions...
June 7, 2017 at 4:14 am
Luckily, Name is one of the properties that the command returns:
Get-Cluster | fl...
June 7, 2017 at 3:28 am
Viewing 15 posts - 1,441 through 1,455 (of 7,191 total)