?
Solved

help with SQL server name

Posted on 2015-01-13
21
Medium Priority
?
266 Views
Last Modified: 2015-01-23
I am in the process of learning how to set up high availability RDS server on MS Server 2013.

I am using this as a guide https://msfreaks.wordpress.com/2013/12/09/windows-2012-r2-remote-desktop-services-part-1/comment-page-2/#comment-2134

I’m getting stuck when specifying the connection string details. To make things easy I have used the same server names as the author

It specifies :

DRIVER=SQL Server Native Client 11.0;SERVER=ITWDC01;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=ITWRDCB

Where does the Database=ITWRDCB come from? I get an error that it cant find it when trying to apply these settings.

During the sql setup I specified “default” as was suggested, but what is the actual name in this case.

Any suggestions?
0
Comment
Question by:roy_batty
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 6
  • 3
  • +1
21 Comments
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40546681
Hi,

it is name of your database , you can check it like this:

select @@servername  

Open in new window

0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40546709
That connection string only works if you have the same SQL Server version, machine name and database name.

DRIVER=SQL Server Native Client 11.0 --> This driver allows connections to SQL Server 2012 & 2014
SERVER=ITWDC01 --> The server name where SQL Server is installed
Trusted_Connection=Yes --> Means that will use the current user credentials to connect to the database. Be sure that your user has access to SQL Server and permissions is the database
APP=Remote Desktop Services Connection Broker --> Informational only. Can be removed
DATABASE=ITWRDCB --> The database name. Change to your database name
0
 
LVL 1

Author Comment

by:roy_batty
ID: 40546710
OK that is the name of the server. I have already tried that in the connection string and it says in cant connect to the sql database.

I can ping the server using its hostname.
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40546728
Hi,

is the MS SQL port allowed on your Windows Server Firewall?
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40546731
Check the SQL Server version and if you user has permissions on the database.
0
 
LVL 1

Author Comment

by:roy_batty
ID: 40546918
I have configured the firewall to allow the sqlservr.exe but I have just completely disabled the firewall on the SQL Server and that didnt help either.

I am logged into the server as the domain administrator.

I am using the Express version of SQL. How do I find the exact version?

Also how do I check that I have permission?
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40546931
Ok, being a SQL Server Express the default instance name should be SQLEXPRESS so change the server name in the connection string to SERVER=ITWDC01\SQLEXPRESS.
0
 
LVL 1

Author Comment

by:roy_batty
ID: 40546969
I'm still getting the same error. The exact error I'm getting s below:

the database specified in the database connection string is not available from the RD connection Broker Server.

The connection string I have used now has :

SERVER=ITWDC01\SQLEXPRESS

Database = SQLEXPRESS
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40546981
Don't change the database name. Only the server, that is the SQL Server instance name. Database should be ITWRDCB.
0
 
LVL 1

Author Comment

by:roy_batty
ID: 40547015
I think you mean ITWDC01.

Well I tried it as below and that doesnt work.

DRIVER=SQL Server Native Client 11.0;SERVER=ITWDC01\SQLEXPRESS;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=ITWDC01

Is it a permissions issue?
0
 
LVL 82

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 2000 total points
ID: 40547934
open the sql configuration managerClient Protcols TCPIP must be enabledEnable set to yes using the drop down and restart the sql server instance
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40548402
I think you mean ITWDC01.
No. I really mean DATABASE=ITWRDCB

DRIVER=SQL Server Native Client 11.0;SERVER=ITWDC01\SQLEXPRESS;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=ITWRDCB
0
 
LVL 1

Accepted Solution

by:
roy_batty earned 0 total points
ID: 40555624
In the end it wasn't anything to do with the database name.

Run the SQL configuration tool and enable IP not using dynamic ports in SQL network configuration.
0
 
LVL 1

Author Comment

by:roy_batty
ID: 40555772
I've requested that this question be closed as follows:

Accepted answer: 0 points for roy_batty's comment #a40555624

for the following reason:

Expert got close but didn't mention the particular area that needed amending. I would like to offer points for helping but I have accepted my own solution.
0
 
LVL 82

Expert Comment

by:David Johnson, CD, MVP
ID: 40555635
Isn't this what I said in http:#a40547934
0
 
LVL 1

Author Comment

by:roy_batty
ID: 40555755
Not exactly no, but I appreciate it was fairly close and feel you deserve points here but didn't want it marked as the final answer
0
 
LVL 82

Expert Comment

by:David Johnson, CD, MVP
ID: 40555773
should get points for the assist
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40557170
So you ended up with the initial connection string?
DRIVER=SQL Server Native Client 11.0;SERVER=ITWDC01;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=ITWRDCB
0
 
LVL 1

Author Comment

by:roy_batty
ID: 40558921
Yes
0
 
LVL 1

Author Closing Comment

by:roy_batty
ID: 40566009
Thanks for the help David and sorry for the points confusion. I know for the future. :)
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question