SQLAssAS (7/28/2015)
I have permission.. and I'm running the package via Visual studio trying to get it working, thats why I specified that I have permission.
Okay... a quick Google search on this suggests you might try substituting a double-backslash for the single one just prior to "Microsoft SQL Server" in the following:
Instead of this:
@key = 'Software\Microsoft\Microsoft SQL Server\MSSQLServer\SuperSocketNetLib\Tcp\IpAll',
try this:
@key = 'Software\Microsoft\\Microsoft SQL Server\MSSQLServer\SuperSocketNetLib\Tcp\IpAll',
Here's where I found it:
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)