Do not enable the sa account unless your application requires it. It is important that you use a strong password for the sa login. On the Security page, under Server authentication , select the new server authentication mode, and then click OK.
In Object Explorer, right-click your server, and then click Restart. On the General page, you might have to create and confirm a password for the sa login. The following example enables the sa login and sets a new password. The following example uses an extended stored procedure to modify the server registry. Serious problems might occur if you modify the registry incorrectly. How can we make this better? Please provide as much detail as possible. Contact our Support Team.
Request Case Start Chat. Translation Feedback How can we make this translation better? Get notified about latest updates to this technical article? Yes No. Do you want to Unsubscribe? Questions or issues with the site? Send Feedback. Please rate your online support experience with Esri's Support website. Follow the steps below to change an existing instance to use SQL Server authentication for its application and warehouse databases.
Open a text editor such as Notepad as an administrator, by right-clicking its shortcut and choosing Run as administrator. Updated application database connection string. Note To change the credentials when the connection string is encrypted, first decrypt the connection string using the dt command line tool , then update the credentials.
To resume the secure state, encrypt the connection string when you have updated the credentials. The warehouse database connection is defined in Dundas BI's configuration settings :. Log into Dundas BI as an administrator, and click the Admin icon in the main menu on the left. Choose Server Authentication and enter the ID and password. If it's running, please kill the process or stop the service.
Book Creator Add this page to your book. Book Creator Remove this page from your book.
0コメント