May 31, 2019 at 1:19 pm
I'm running my first real SQL 2017 (Dev edition) install and find that I can't seem to deliberately place the system database files (aside from tempdb) in a location of my choosing. When I name the instance (the default / named instance install page) the path is auto-named with no edit boxes available. When I get to the Server Configuration page, I can alter everything but the "System database directory" line.
Any ideas what is going on here?
Also, I'm installing Analysis Services for the first time. If I'm reading my Google links right, the server mode is "hardset," IE, Microsoft doesn't provide a way to change the server mode naturally, once it's installed. Correct?
I am seeing a fudge or two listed in the results but they appear to be user-created workarounds rather than official Microsoft fixes. Please let me know if I'm correct or incorrect on this later bit.
May 31, 2019 at 1:44 pm
No, I have not found a place to move the system databases.
I let the install finish, and move them as part of the post-install steps
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 31, 2019 at 3:00 pm
It is doable but must be done through regedit and careful scripting.
Adam Zacks-------------------------------------------Be Nice, Or Leave
May 31, 2019 at 6:19 pm
That's what I thought. Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply