Viewing 15 posts - 1,411 through 1,425 (of 2,701 total)
this google gets you a few hits https://www.google.com/search?q=powershell+change+sql+server+service+account&oq=powershell+change+sql+ser&aqs=chrome.0.0l2j69i57j0l4j69i60.7272j0j7&sourceid=chrome&ie=UTF-8
but I advise you to use GMSA accounts instead of username/password - safer and you won't have to worry about them anymore.
September 10, 2020 at 5:22 pm
Developer = Enterprise - just not licensed for production use.
no other limits neither differences.
September 2, 2020 at 1:37 pm
I do not see any issues, but I would use developer edition.
taking in consideration who you are advising this to I have to clarify this - Developer edition CAN't...
August 31, 2020 at 11:34 pm
neither is good - but having the single set statement just makes it easier for you to change your code when time comes your users complain about bad data
August 31, 2020 at 7:39 am
it does not work like that - it is not the "login name" that counts as a user, but the user of the application (or device) that connects to the...
August 29, 2020 at 4:54 pm
on the linked server provider and properties ensure that the property "allow inprocess" is set to true.
August 28, 2020 at 7:50 am
specify the full path to that executable - that is basic stuff for any operating system - either it is on the PATH or full path needs to be specified
August 27, 2020 at 12:47 pm
you did not supply enough details - what is the job and how does it connect to ANY server.
getting data out of a server can be done in a multitude...
August 27, 2020 at 11:01 am
it does not need to be on admin group for this purposes. - but it will need permissions on the folder in question
logon as a batch and/or logon as a...
August 26, 2020 at 6:35 pm
can't think of much more - except - is the output filename UNC or Drive letter based? if UNC change it to local drive .
August 26, 2020 at 6:19 pm
I would try and change from executing a SSIS step (which seems to be what you are doing) to execute a command line instead - see if it makes a...
August 26, 2020 at 5:45 pm
Hello Folks,
Same package with same options (picked from SQL Server Agent command line only) is run manually by opening a command prompt and invoking DTexec utility, the destination gives...
August 26, 2020 at 2:10 pm
Other that creating a parameter table the job reads from, I don't know anyone else that has been able to do it either.
out of curiosity what did...
August 26, 2020 at 7:07 am
that really is normally task for 3 individuals - good luck finding someone that can fill all of them.
August 25, 2020 at 8:38 pm
Other that creating a parameter table the job reads from, I don't know anyone else that has been able to do it either.
out of curiosity what did you mean...
August 25, 2020 at 4:25 pm
Viewing 15 posts - 1,411 through 1,425 (of 2,701 total)