Sep 17, 2012 at 10:18 PM
Edited Sep 17, 2012 at 10:21 PM
You just do it at the start and that will work throughout the whole script. Your DB Server is then the alias, ie, SQLDEV123 and NOT the server name.
The reason for them throughout the script, depending on the SharePoint Farm setup - some databases might be on other SQL servers. Example: Search, UPS etc. or, they are required to be different names.
Create="true" DBInstance="SQLSERVERHERE" DBPort=" "
The above is at the start of the file, if you don't need to change it - that should be the only time you need to enter it.
If you are creating an alias (recommended!), <DBServer> is actually the value of the SQL alias; otherwise it's the NetBIOS name of the SQL server or instance.
If you leave <DBServer> blank throughout the script, the default DBServer value for the farm is used. The above appears throughout the script, it will use <DBServer>
from the start.