SQLExpress - command line - more thoughts
Posted: Wed Oct 24, 2007 7:51 am
Hi
Have now done more investigation. This problem is down to permissions but..... the plugin creates the instance, but the SQLExpress install does not create the instance data directory, so when I was copying my data files to an instance data directory (which didn't exist, but IA created for me), the correct permissions were not applied, if I copy my data files to the MSSQL.1 data directory all is fine (NETWORK SERVICE) has the correct permissions on this directory. Copying files to the MSSQL.1 data directory would work but is not a perfect solution in that MSSQL.2, MSSQL.3 etc may exist.
The question therefore is - why isn't the install creating the instance data directory. Is this an IA problem or something that needs looking at with SQLExpress, either way suggestions would be helpful. I don't think creating the instance directory and applying the permissions would be do-able in that the generated user for NETWORK SERVICE is obscure to say the least.
Help !!!
Have now done more investigation. This problem is down to permissions but..... the plugin creates the instance, but the SQLExpress install does not create the instance data directory, so when I was copying my data files to an instance data directory (which didn't exist, but IA created for me), the correct permissions were not applied, if I copy my data files to the MSSQL.1 data directory all is fine (NETWORK SERVICE) has the correct permissions on this directory. Copying files to the MSSQL.1 data directory would work but is not a perfect solution in that MSSQL.2, MSSQL.3 etc may exist.
The question therefore is - why isn't the install creating the instance data directory. Is this an IA problem or something that needs looking at with SQLExpress, either way suggestions would be helpful. I don't think creating the instance directory and applying the permissions would be do-able in that the generated user for NETWORK SERVICE is obscure to say the least.
Help !!!