andreacaloni
Basic Member
Posts:18
 |
| 2008-02-14 04:00 PM |
|
During installation of Image Server I keep on receiving an error while the installer checks the connection to the database. The message error is: "Connection test failed. Please check connection details and ensure they are correct".
I am using SQL Server 2005 Express. I have configured it to use SQL Server authentication, and I have activated the protocols Shared Memory, Named pipes, TCP/IP.
Does anyone can help me about this issue ? |
|
|
|
|
henry
Senior Member
Posts:259
|
| 2008-02-14 04:21 PM |
|
A few things to look at:
- The obvious item would be to ensure that you have the SQL Express checkbox enabled.
- Our testing has also found that for SQL Server 2005 Express specifically that the SQL Server Browser service must be running
- Finally it may help to first attempt connecting using the same credentials through SQL Server Management Studio Express. It's much more verbose if there is an error. The most common situation we've run into during testing is that the sa account is not enabled by default in SQL Server 2005 Express
Thanks for trying out the product.
Henry |
|
|
|
|
andreacaloni
Basic Member
Posts:18
|
| 2008-02-14 04:51 PM |
|
- the SQL Express checkbox is enabled
- the SQL Server Browser service is running
- I connected successfully with the same credentials through SQL Server Management Studio Express. Both using the sa account (previously enabled), both using another account.
- I have also checked the firewall permissions... |
|
|
|
|
henry
Senior Member
Posts:259
|
| 2008-02-14 05:25 PM |
|
Do you think you could share what values your are inserting into the dialog? In particular, the value for the 'DB Server Hostname' field would be helpful.
Also if you can provide the value for 'Server Name' that you use when connecting with SQL Server Management Studio Express it might help us out too.
Thanks,
Henry |
|
|
|
|
andreacaloni
Basic Member
Posts:18
|
| 2008-02-14 05:36 PM |
|
- 'DB Server Hostname': I tried all the following:
PC-Home (my hostname)
PC-Home\SQLEXPRESS
...and all the combination in upper/lower case...
10.0.0.3 (my ip address)
- in SQL Server Management Studio Express I use PC-HOME without any error. |
|
|
|
|
henry
Senior Member
Posts:259
|
| 2008-02-14 05:47 PM |
|
Using the loopback ip might be worth trying: 127.0.0.1
However, you said, "- in SQL Server Management Studio Express I use PC-HOME without any error.". If in SQL Server Management Studio Express it's only 'PC-HOME' and not 'PC-HOME\SQLEXPRESS' then please try un-checking the SQL Express checkbox. It's because checking the box adds '\SQLEXPRESS' to the IP or hostname. |
|
|
|
|
andreacaloni
Basic Member
Posts:18
|
| 2008-02-14 06:03 PM |
|
finally I found the way: it works using just localhost as DB server hostname, and without checking the "check if the server versio is SQL EXPRESS".
Thank you for your help... |
|
|
|
|
steve
Senior Member
Posts:1932
|
| 2008-02-14 06:07 PM |
|
Thanks for sticking through with the installation until we had it figured out! Hopefully this will help other people when they first install the product.
We're looking forward with any feedback or questions you or other users may have.
Steve |
|
| Real-time support available to Clinical Edition and Team Edition customers |
|
|
cnagrani
Advanced Member
Posts:60
|
| 2008-02-16 07:52 PM |
|
Steve
I amhaving the same problem I tried using localhost but still gte the same error I am unable to install the image server.
Chandru |
|
|
|
|
steve
Senior Member
Posts:1932
|
| 2008-02-16 11:01 PM |
|
Hi Chandru, First, I assume you've followed the instructions here before you started setup? IE, if you're using SQL Express, you have the SQL Browser enabled, and you've enabled TCP/IP connections to the database? Also, did you experiment w/ 127.0.0.1 as the database server, with the SQL express box checked and unchecked? Any details you can give on what database you have installed and then what settings you are using in the installer would be helpful. Thanks, Steve |
|
| Real-time support available to Clinical Edition and Team Edition customers |
|
|
cnagrani
Advanced Member
Posts:60
|
| 2008-02-17 12:38 PM |
|
Steve
I followed the instructions enabled the options tried 127.0.0.1 tried localhost but no avail I don't know what I am doing wrong.
Chandru |
|
|
|
|
cnagrani
Advanced Member
Posts:60
|
| 2008-02-17 01:21 PM |
|
details
tried
I used my windows auto User Name Chandru Nagrani
password *****
db server name
tried 127.0.0.1
tried local host
tried checked unchecked SQL Express
Chandru |
|
|
|
|
henry
Senior Member
Posts:259
|
| 2008-02-17 09:28 PM |
|
Hi Chandru,
In your last post you mentioned, "I used my windows auto User Name Chandru Nagrani".
Could you give the sa account a try? Also, if it's a new instance of SQL Express then please just double check that the SQL Server Authentication mode is on and that the sa account is enabled - SQL Express disabled the account by default.
Henry
|
|
|
|
|
cnagrani
Advanced Member
Posts:60
|
| 2008-02-18 09:38 AM |
|
Is there any way to manually install the image server.
I managed to create the database manually using the source however I am still having issues when I run the
ClearCanvas.ImageServer.ShredHostService.exe I get connectivity problems.
I ma going to try an install the imageserver on a clean new machine and see if that works.
Chandru |
|
|
|
|
cnagrani
Advanced Member
Posts:60
|
| 2008-02-18 09:54 AM |
|
I used 127.0.0.1 and checked the sqlexepress box and the installed succecced.
Thanks now on to see if I can learn about the app and it's source. Is there still a plan for a developer's conference in June 2008
Chandru |
|
|
|
|
fleetwoodfc
New Member
Posts:5
|
| 2008-02-18 05:23 PM |
|
I had the same "Connection test failed. Please check connection details and ensure they are correct" issue. As you suggested I gave the sa account a try - SQL Express in SQL Server Authentication mode and that worked fine
|
|
|
|
|
norman
Senior Member
Posts:813
|
| 2008-02-19 08:23 AM |
|
Hi Chandru,
Whether we have the developer's conference depends on 1) demand and 2) how busy we are at that time. We haven't asked if there's interest yet, so we're not sure about 1). We know though that we'll be busy, since will be in the middle of some deployments at the hospital. Check back with us every now and then. Thanks for asking!
Norman |
|
|
|
|
nupi
New Member
Posts:10
|
| 2008-11-23 11:22 AM |
|
Is anyone out there??? I am so frustrated after spending 48 hrs. trying to communicate with SQLexpress.
I have all services enabled. I followed all suggested settings. I have no problems communicating via SQL manager.
One thing (of many) i am not sure wher the "SQL checkbox" is. Can't find. Please help!!! |
|
|
|
|
steve
Senior Member
Posts:1932
|
| 2008-11-23 10:39 PM |
|
Are you installing the 0.95 release? Or a development build ? With the 0.95 release, you do not add "/SQLEXPRESS" to the connection string, but with the latest development builds you must add this. If you are using a development build, you should enter the server in the same exact format in the installer as you specify it when setting up the connection with the management studio. If you are using the 0.95 release, you would drop "/SQLEXPRESS" as mentioned.
Steve |
|
| Real-time support available to Clinical Edition and Team Edition customers |
|
|
southrider
Posts:10
|
| 2009-01-03 10:17 AM |
|
In my experience, there ara a couple items to check:
-- first, look if the software antivirus used is blocking our tcp/ip ports over our network connection.
-- look if the sqlexpress is running fine, and is pretty setup. The Shared memory and tcp/ip connection protocols should be enabled first and the sqlbrowser to.
-- and if the connection string is not working yet, try this, ".\SQLEXPRESS" or the instance name that we are using, works fine with the localhost (is the basic conection to it) and the shared memory connection is made using that connnection string.
PD: I'm aplogize for my bad english, i speak spanish. |
|
|
|
|