Solved

Citrix XenApp 6.5 -  New Farm Setup

Posted on 2014-07-25
18
675 Views
Last Modified: 2014-08-03
I am in the midst of setting up a new Citrix Farm on a 2008 R2 box.  I have everything installed, and all looks well, but we cannot connect to the server from the Citrix Receiver or the old XenApp client.  I did enable legacy support.

I think my problem may lie in the Storefront setup.  Primarily in the database setup for the Storefront.  I'm not sure I set up a database correctly for the Storefront to use.  I filled in the server name of the box itself, because Citrix installed SQL Server 2008 Express.  I filled in a Database name and assumed the system would create one.  Yet when I test the Database connection it fails?  

Can anyone help me out as to where I went wrong in the setup of this farm?  I have Applications published and such, but I keep getting errors saying Receiver cannot contact server "ServerName".
0
Comment
Question by:mfehrmann
  • 12
  • 6
18 Comments
 
LVL 14

Expert Comment

by:Justin Yeung
ID: 40219987
what version of your storefront?
0
 
LVL 14

Expert Comment

by:Justin Yeung
ID: 40219996
can you post the log file from your storefront server

http://support.citrix.com/proddocs/topic/dws-storefront-12/dws-troubleshoot.html
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 40220092
Citrix Receiver Storefront
Version 2.0.0.58

I'm going to enable logging and will post back shortly.
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 40220102
Oh yeah, all kinds of "Data Source unavailable with connection string" logs.  As I assumed it can't find a database.

How do I configure a SQL database for Storefront on this box?  It's a Server 2008 R2 and has SQL Server 2008 Express installed.  

Data source unavailable with connection string 'Integrated Security=SSPI;Server=ServerName;Database=XENAPP' and provider 'System.Data.SqlClient'System.Data.EntityException, System.Data.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
The underlying provider failed on Open.
   at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
   at System.Data.EntityClient.EntityConnection.Open()
   at System.Data.Objects.ObjectContext.EnsureConnection()
   at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
   at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1[TResult](IEnumerable`1 sequence)
   at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
   at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
   at Citrix.DeliveryServices.DazzleResources.SubscriptionAdo.Models.Data.AdoSubscriptionsManager.ReadVersion()
   at Citrix.DeliveryServices.DazzleResources.SubscriptionAdo.Models.Data.AdoSubscriptionsManager..ctor(IIdGenerator idGenerator, String connectionString, String providerName)

System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
HelpLink.ProdName: Microsoft SQL Server
HelpLink.EvtSrc: MSSQLServer
HelpLink.EvtID: 2
HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink
HelpLink.LinkId: 20476
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
0
 
LVL 14

Expert Comment

by:Justin Yeung
ID: 40220122
so obviously you don't have the connection to the database as you already know.

what is the name of the instance that you created?

you can actually use sql studio management tools to test the connection, if you are not sure what you are looking for.

enabled sql browser services, start sql studio management tool, browse db and find the db.
it should be like this SERVERNAME\INSTANCEDBName

set that name to your storefront db
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 40220128
That is the thing. I'm not sure an instance was created. I assumed the installation would have taken care of that for me.

I'm downloading SQL Management Studio Express now
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 40220155
OK, this isn't my first rodeo with SQL Server Express, but what the heck is going on here? I'm trying to install SQL Mgmt Studio Express and it just keeps bringing me back to SQL Server Installation Center?  Why?
0
 
LVL 14

Expert Comment

by:Justin Yeung
ID: 40220169
that's normal, studio tool is a part of SQL installation.

same like Exchange management tool which will bring up the exchange server installation as well. you just need to select the tool to be installed.

example.
http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 40220197
Oh wow, thank you!  I was doing exactly as this article described, I wasn't click new instance.  Anyways, from what I can see, the only instance I have so far is CITRIX_METAFRAME - SQLEngine - Version 10.1.2531.0 - Express.
0
IT, Stop Being Called Into Every Meeting

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 5

Author Comment

by:mfehrmann
ID: 40220201
Now I received an error about needing to update MS VIsual Studio to SP1.  Looks like I'll have to get around that first.
Thank you for sticking through on this!
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 40220203
SQL-Error.jpeg
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 40220235
I'm going 2,000 MB of Windows Updates, I'll pick this project back up Monday morning!  Thanks so far.  

I'm guessing I'll have to create a new Instance for Storefront correct?  What are the steps?
0
 
LVL 14

Expert Comment

by:Justin Yeung
ID: 40220240
I think the easiest way is to delete the store and recreate it.
0
 
LVL 14

Expert Comment

by:Justin Yeung
ID: 40220244
and you should already has an installation done of studio tools.
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 40220248
I can delete the store and re-create, but where in the process does it create a SQL Instance for me?  I just built the store this morning and I didn't see the step to create an Instance for the Store?
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 40225516
Alright, finally I have SQL Management Studio installed. I was correct in stating that the only SQL Database Citrix installed was "CITRIX_METAFRAME" which I don't believe is for the Citrix Storefront.

So...  What do I need to do to get Storefront to install a database to use?  Or how do I go about setting this up?  

Thanks!
0
 
LVL 5

Accepted Solution

by:
mfehrmann earned 0 total points
ID: 40227878
I blew away the server and am starting over.  Going to go right to Receiver 2.1 so I don't have to deal with a database driven StoreFront.
0
 
LVL 5

Author Closing Comment

by:mfehrmann
ID: 40237112
No solution was found, had to wipe the server and start over.
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

#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
CITRIX XENAPP 6.5 FARM CUSTOM POLICY - CHANGE MANAGEMENT WINDOW REBOOT SCHEDULE
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

758 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

19 Experts available now in Live!

Get 1:1 Help Now