AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Connection string sql native client 109/22/2023 Open the SQL Server Configuration Manager, open the TCP/IP Properties under SQL Network Configuration and set the listen all option to NO. Once you have configured the RDS Connection Broker login, you will see it appear under logins in the security folder for the SQL instance. In the Server Roles page select DBCreator, Sysadmin and public. Configure security permissionsĬreate a security group and add the RDCB servers as members.Īdd all connection brokers into the security GroupĬreate a new user and add the Group name to the login name. Select default settings for the reporting services. You can set a Service account, for this example i have used the defaults.Įnter the User names that can access SQL administrator and a SA password. For this example i am using SQL Express 2012 and a single instance.įor more information on high available SQL Solutions please see the following link:
0 Comments
Read More
Leave a Reply. |