Solved

help with SQL server name

Posted on 2015-01-13
21
240 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
  • 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 48

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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40546728
Hi,

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

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 48

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 48

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 80

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 500 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 48

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 80

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 80

Expert Comment

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

821 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