I am installing XenApp 7.8, including the SQLExpress 2012 option rather than using an existing SQL server.
I've successfully installed the Delivery Controller including the SQLExpress installation. I used the default values throughout and there were no errors. The software is installed on a clean 2012 R2 Standard member server in a domain. I was logged in as domain admin during the installation.
The next stage is to configure the Delivery Controller. I ran Citrix Studio, again as domain admin, and selected the "Deliver applications and desktops to your users" option. I choose the "An empty, unconfigured site" option when prompted to create a site, give the site a name, and click Next. At the Databases screen it suggests names for all three of the databases. I select "Create and set up databases from Studio", leave the suggested database names in place, leave teh Location as localhost\sqlexpress and click Next.
My understanding is that the wizard should now prompt me to create the databases as they don't already exist on the SQLExpress instance. However, it starts the "Validating database details" process then I get this error, and no prompt to create the databases:
"The validation of database NOFLogging on server instance localhost\sqlexpress failed. The associated sql error was "Connection timeout expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to the server was [Pre-login] initialization = 3, handshake = 12596. Fix the SQL error then continue."
There are associated Windows event ID's 18456 in the logs for the Site, Logging and Monitoring databases:
"Login failed for user mydomain\myuser. Reason: Failed to open the explicitly specified database 'NOFSite'. [CLIENT: <local machine>]"
I installed SQL Management Studio and verified that I can access the SQL instance using the mydomain\myuser account. This is the domain admin account so it should have all the required rights.
How can I resolve this problem? I'm no doubt doing something wrong but I can't see where in the installation instructions I've gone wrong.
Question
Elsa Pratt
I am installing XenApp 7.8, including the SQLExpress 2012 option rather than using an existing SQL server.
I've successfully installed the Delivery Controller including the SQLExpress installation. I used the default values throughout and there were no errors. The software is installed on a clean 2012 R2 Standard member server in a domain. I was logged in as domain admin during the installation.
The next stage is to configure the Delivery Controller. I ran Citrix Studio, again as domain admin, and selected the "Deliver applications and desktops to your users" option. I choose the "An empty, unconfigured site" option when prompted to create a site, give the site a name, and click Next. At the Databases screen it suggests names for all three of the databases. I select "Create and set up databases from Studio", leave the suggested database names in place, leave teh Location as localhost\sqlexpress and click Next.
My understanding is that the wizard should now prompt me to create the databases as they don't already exist on the SQLExpress instance. However, it starts the "Validating database details" process then I get this error, and no prompt to create the databases:
"The validation of database NOFLogging on server instance localhost\sqlexpress failed. The associated sql error was "Connection timeout expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to the server was [Pre-login] initialization = 3, handshake = 12596. Fix the SQL error then continue."
There are associated Windows event ID's 18456 in the logs for the Site, Logging and Monitoring databases:
"Login failed for user mydomain\myuser. Reason: Failed to open the explicitly specified database 'NOFSite'. [CLIENT: <local machine>]"
I installed SQL Management Studio and verified that I can access the SQL instance using the mydomain\myuser account. This is the domain admin account so it should have all the required rights.
How can I resolve this problem? I'm no doubt doing something wrong but I can't see where in the installation instructions I've gone wrong.
Can anyone help?
Link to comment
9 answers to this question
Recommended Posts
Archived
This topic is now archived and is closed to further replies.