Solved

help with SQL server name

Posted on 2015-01-13
21
249 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 50

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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40546728
Hi,

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

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 50

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 50

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 81

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 50

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 81

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 81

Expert Comment

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

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

737 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