The issue wasn't permissions exactly. It was the inability to create a directory from the server name/ server source when it's name is like tcp:myCloudData.database.windows.net,5588. So I have added a rudimentary check in the ParseServerName function to look for a colon.
With the example above I choose myCloudData as the parsed server name. I also check for a blank name and if it is I select the computer name as a last resort otherwise we would create a hidden folder eg .MyDatabaseName
I hope this is clear and I am open to input and suggestion.
The issue wasn't permissions exactly. It was the inability to create a directory from the server name/ server source when it's name is like tcp:myCloudData.database.windows.net,5588. So I have added a rudimentary check in the ParseServerName function to look for a colon.
With the example above I choose myCloudData as the parsed server name. I also check for a blank name and if it is I select the computer name as a last resort otherwise we would create a hidden folder eg .MyDatabaseName
I hope this is clear and I am open to input and suggestion.