July 8, 2015 at 5:15 pm
I am having trouble with my connectionstring for an SQL Server 2012 on my Windows Server 2012 R2 machine.
http://www.connectionstrings.com/sql-server-2012/
Having trouble with myserverAddress.
What belongs there with SQL Server 2012?
DRIVER=SQL Server Native Client 10.0;SERVER=myserverAddress;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;Database=Testdb
July 9, 2015 at 5:33 am
philosophaie (7/8/2015)
I am having trouble with my connectionstring for an SQL Server 2012 on my Windows Server 2012 R2 machine.http://www.connectionstrings.com/sql-server-2012/
Having trouble with myserverAddress.
What belongs there with SQL Server 2012?
DRIVER=SQL Server Native Client 10.0;SERVER=myserverAddress;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;Database=Testdb
I believe SQL 2012 is Native Client 11.0, not 10.0.
If that doesn't work, post back.
July 9, 2015 at 6:17 am
Error code from RD Connection Broker - Configure High Availability: "write permission to sql database"
How do you create "RD Connection Broker having write permission to sql database"?
July 9, 2015 at 6:31 am
philosophaie (7/9/2015)
Error code from RD Connection Broker - Configure High Availability: "write permission to sql database"How do you create "RD Connection Broker having write permission to sql database"?
I haven't worked with HA yet. Have you googled the error yet?
July 9, 2015 at 6:40 am
In 2012 R2 in server "WIN-1" I have installed a copy of SQL Server 2012. I have added RDSCB into DNS Manager with a IP Address one up from "WIN-1". Not sure what to do with RDSCB?
I am trying to add it to RD Connection Broker, configure High Availiability:
Database Connection String:
DRIVER=SQL Server Native Client 11.0;SERVER=WIN-1;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;Database=Testdb"
Folder to store database files:
C:\dbData
DNS round robin name (ClientAccessName):
RDSCB.mysite.com
The error code I am getting from this:
-SQL Server Native Client is installed on RD Connection Broker server
-RD Connection Broker has write permission to sql database
How do you configure the sql database with RD Connection Broker write permission?
July 9, 2015 at 6:46 am
philosophaie (7/9/2015)
In 2012 R2 in server "WIN-1" I have installed a copy of SQL Server 2012. I have added RDSCB into DNS Manager with a IP Address one up from "WIN-1". Not sure what to do with RDSCB?I am trying to add it to RD Connection Broker, configure High Availiability:
Database Connection String:
DRIVER=SQL Server Native Client 11.0;SERVER=WIN-1;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;Database=Testdb"
Folder to store database files:
C:\dbData
DNS round robin name (ClientAccessName):
RDSCB.mysite.com
The error code I am getting from this:
-SQL Server Native Client is installed on RD Connection Broker server
-RD Connection Broker has write permission to sql database
How do you configure the sql database with RD Connection Broker write permission?
Brandie Tarvin (7/9/2015)
philosophaie (7/9/2015)
Error code from RD Connection Broker - Configure High Availability: "write permission to sql database"How do you create "RD Connection Broker having write permission to sql database"?
I haven't worked with HA yet. Have you googled the error yet?
July 9, 2015 at 12:20 pm
How do you find the SQL Login in SQL Server manager?
I have installed "SQL Server 2012" on the first install of "ws 2012". In my RD CB connection string the server=WIN-1 is the first install.
I do not have any traffic on port 1433 in IIS.
I do not know how to find the Log entry generated on the SQL Server?
I created a Group for "RDCB Computer Objects".
July 9, 2015 at 12:32 pm
philosophaie (7/9/2015)
How do you find the SQL Login in SQL Server manager?
Open up SSMS. Navigate to Security -> Logins. It should be there.
Those are the server level logins. If it's not there, try looking under <MyDatabase> -> Security -> Users.
You can use either Object Explorer or Object Explorer Details to do this navigation. You'll need to connect to the database in Object Explorer to do this navigation, though.
July 9, 2015 at 3:15 pm
I created a Group for "RDCB Computer Objects".
In "Properties>Member" entries Name:RDCB01 & RDCB02 how did the get there?
I Inserted into DNS Manager under mysite.com a Host called "RDSCB" with a IP address 192.168.1.2 but search in "RDCB Computer Objects" came up empty. Could this be it?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply