Ensure that the TCP Dynamic Ports entry is blank,and that TCP Port is set to 1433 as belowĮnsure that you restart the SQL Server service after doing this to make sure the changes are applied to the process. Scroll down to the bottom of this dialog box and look for “IP All”. When Enabled, right-click on TCP-IP and choose Properties. Open SQL Server Configuration Manager, expand SQL Server Network Configuration, and click on the Protocols tab. Next, we need to ensure that the SQL server service is listening on port 1433. ![]() Interestingly, the timeout (600) is why we see such a long delay when the wizard errors out during connection. Click on the Connections tab, and ensure that “Allow remote connections” is ticked as below. Right-click on the instance name (top of the left-hand pane) and choose Properties. Once installed, run SQL Server Management Studio and log in. It is available as part of the SQL Express install or you can download it separately. If you didn’t already, install SQL Server Management Studio (SMSS) on your SQL Express system. This seems to indicate a generic failure to establish a network connection.Ĭheck the obvious causes first – is the SQL Server service running? Is network access enabled? Is the firewall correctly configured? Is DNS functioning correctly? If these all check out, it may be that remote connections aren’t enabled. In this case, we can see that the error is “A network-related or instance-specific error occurred while establishing a connection to SQL Server”. There is a log file that you can check to get the real error, it is located in C:\Program Files (x86)\Norskale\Norskale Infrastructure Services and the log is called Citrix WEM Database Management Utility Debug Log.txt Sometimes you may see the Database Creation Wizard hang for a long period of time after you have supplied the details, and then throw up this (really helpful!) error After WEM Infrastructure Services installation, you are prompted to run the Database creation wizard and supply the required credentials Usually in proof-of-concept situations, I recommend simply using an SQL Express instance that you install locally to the WEM system. When you install Citrix Workspace Environment Management (WEM), you need to connect to a database instance. ![]() You may see this error setting up WEM on SQL Express.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |