



To use your current Windows user name and password, click Use Windows Authentication. Under Log on credentials, do one of the following, then click Next: Tip: If you know the name of the offline cube file that you want to connect to, you can type the complete file path, file name, and extension. Click OK in the message to connect using an unencrypted connection.įor more information about advanced connector options, see SQL Server database. If a connection to your SQL Server is not established using an encrypted connection, Power Query prompts you to connect using an unencrypted connection. If you do not want to connect using an encrypted connection, clear this check box, and then click Connect. After you select this, specify a user name and password to connect to your SQL Server instance.īy default, the Encrypt connection check box is selected to signify that Power Query connects to your database using an encrypted connection. Select this if you want to connect using Windows authentication.ĭatabase Select this if you want to connect using SQL Server authentication. Select the authentication mode to connect to the SQL Server database. For more information, see Import Data from Database using Native Database Query. If you want to import data using a native database query, specify your query in the SQL Statement box. Optionally, you can specify a Database Name as well. In the Microsoft SQL Database dialog box, specify the SQL Server to connect to in the Server Name box. If this is not the case simply edit the alignment string and extend it.Select Data > Get Data > From Database > From SQL Server Database. This is the the name visible to the user in Road Runner Select Write Copy the data base files to the cf card Copy the newly created data base files (examples on left) from the 12d working folder to the DBX folder on the CF card June 2005ģ1 6.2 Multi layer NOTES 1) Ensure that the alignment starts before the strings and finishes after the strings.

2) Strings can not reverse back on themselves and must run in the same direction as the alignment 3) If using data imported via Genio format ensure there is only one alignment string per work area Turn on the relevant road strings to be used in the layer along with the alignment if the layer is the finished surface Select option Survey=>Leica=>1200=>Roads Select the Simple tab Type in the Job name Tick the check box so that the database is created Tick check box to put all stringlines in a layer Select the Pick icon then select the alignment string Tick the check box if alignment string is to be included in level calculations Select the model name for the road strings Type in layer name for the strings. If this is not the case simply edit the alignment string and extend it. 30 6 XML / Data Base road strings (single or multi layers) 6.1 Single layer NOTES 1) Ensure that the alignment starts before the strings and finishes after the strings.
