Solved

help with SQL server name

Posted on 2015-01-13
21
221 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 45

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
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40546728
Hi,

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

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 45

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 45

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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 78

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 45

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 78

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 78

Expert Comment

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

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

What to do when Windows Update is not working correctly? What tools can I use to detect the cause of the malfunction problem? What does this numeric error code mean? These and other questions that you have been asking in the past are answered here (…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

705 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now