tag:blogger.com,1999:blog-6461067935478170803.post5211775934441595695..comments2024-03-05T10:37:06.810-06:00Comments on | Exit | the | Fast | Lane |: Native RDS in Server2016 - Part 4 - Scaling & HAPeterhttp://www.blogger.com/profile/07331743507096012047noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-6461067935478170803.post-80617042758269240122017-10-19T10:04:38.457-05:002017-10-19T10:04:38.457-05:00It very well could be. The DB you're using nee...It very well could be. The DB you're using needs to be setup right with appropriate permissions for the account you're using to connect with. Gets a bit hairy in this space I'm afraid. Peterhttps://www.blogger.com/profile/07331743507096012047noreply@blogger.comtag:blogger.com,1999:blog-6461067935478170803.post-36468426388036551272017-10-18T15:04:10.594-05:002017-10-18T15:04:10.594-05:00Thank you for the info and help Peter.
Although n...Thank you for the info and help Peter.<br /><br />Although now i get a different error;<br /><br />its this one in the article.. i've double checked the setup and all looks ok... do you think its my SQL servers?<br /><br />https://social.technet.microsoft.com/wiki/contents/articles/10393.rd-connection-broker-ha-sql-permissions.aspx<br /><br />Jason Chaplinhttps://www.blogger.com/profile/01450975882439584015noreply@blogger.comtag:blogger.com,1999:blog-6461067935478170803.post-55263978236394380102017-10-18T14:38:17.223-05:002017-10-18T14:38:17.223-05:00Try this, in your case it would be: Driver={SQL Se...Try this, in your case it would be: Driver={SQL Server Native Client 13.0};Server=tcp:cbc-vsql.,1433;Database=CB-DB1;Uid=;Pwd=;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;<br /><br />Make sure to update your ODBC driver, add the domain to your SQL server name and update the SQL account and password in the string. Anything in the string above in brackets <> requires your input, remove those brackets when you add your info. Peterhttps://www.blogger.com/profile/07331743507096012047noreply@blogger.comtag:blogger.com,1999:blog-6461067935478170803.post-10054906189071119732017-10-18T11:16:11.924-05:002017-10-18T11:16:11.924-05:00Hi Peter,
Thanks again for the quick response.
I...Hi Peter,<br /><br />Thanks again for the quick response.<br /><br />I do have mixed Auth as per the guide I used? <br /><br />My DB server is call BC-VSQL and The instance created is SQL2016 and the DB itself is called RDSFARM<br /><br />Could you confirm for me exactly where this needs to go in the string so i don’t get anything wrong?<br /><br />Also when I used 13.1 native driver, nothing exisited in the drop down of the servers at the bottom. Is there something on the DB server itself I need to do to get it to work<br />Jason Chaplinhttps://www.blogger.com/profile/01450975882439584015noreply@blogger.comtag:blogger.com,1999:blog-6461067935478170803.post-56216456570478551362017-10-18T11:10:28.824-05:002017-10-18T11:10:28.824-05:00You might try upgrading your ODBC drivers to 13.1 ...You might try upgrading your ODBC drivers to 13.1 just to ensure the latest. Also, by your error looks like you're using Windows Auth for the DB so your connection string format needs to be a bit different: Driver={SQL Server Native Client 13.0};Server=tcp:cb-sqls1.database.windows.net,1433;Database=CB-DB1;Uid=sqladmin@contoso;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;<br /><br />From: https://docs.microsoft.com/en-us/windows-server/remote/remote-desktop-services/rds-connection-broker-cluster?f=255&MSPPError=-2147217396 Peterhttps://www.blogger.com/profile/07331743507096012047noreply@blogger.comtag:blogger.com,1999:blog-6461067935478170803.post-41893814070932029392017-10-18T10:38:27.470-05:002017-10-18T10:38:27.470-05:00Hi Peter,
Thank you for coming back to me so quic...Hi Peter,<br /><br />Thank you for coming back to me so quickly.<br /><br />It’s using v11 of native client and ODBC link.<br /><br />It’s version 17.3 of SQL (latest download)Jason Chaplinhttps://www.blogger.com/profile/01450975882439584015noreply@blogger.comtag:blogger.com,1999:blog-6461067935478170803.post-58994631684680537152017-10-18T09:13:50.380-05:002017-10-18T09:13:50.380-05:00Hi Jason,
Which version of SQL and the native cli...Hi Jason,<br /><br />Which version of SQL and the native client are you using? Also triple check the syntax of your connection string. This step is a bit of a pain. Peterhttps://www.blogger.com/profile/07331743507096012047noreply@blogger.comtag:blogger.com,1999:blog-6461067935478170803.post-9886241239923778322017-10-18T08:08:52.101-05:002017-10-18T08:08:52.101-05:00Hi,
i am having an issue following this guide. i ...Hi,<br /><br />i am having an issue following this guide. i have followed it to the point but i keep getting the error;<br /><br />"Specified database connection string uses Windows Authentication, corresponding to dedicated database configuration. please provide a connection string with database specific authentication for shared database configuration, that contains user name and password."Jason Chaplinhttps://www.blogger.com/profile/01450975882439584015noreply@blogger.com