Hello

I am very eager to try out your software but I can not get past the database check in the instal program.

• I have installed the following:
  SQL 2005 sp2 - running version SQL Server 9.0.3042
  SQL Express management console
  IIS
  .NET 3.0
  ASP.NET Ajax Extensions 1.0
• I have done the following to SQL
  TCP/IP connections enabled
  SQL Server browser enabled
  Authentication = mixed mode
  sa user enabled
  Surface area config = tcp/ip and named pipes
• I have disabled the firewall and have no antivirus software loaded
  I can connect to the SQLserver using the management console from numerous workstations as the sa.
  I can connect to the sqlserver using osql from numerous workstations.
• When I run the clear canvas server install program i get the connection failed message.
• I have tried to connect to other sql databases on the network and get the same error
• The message appears within the same amount of time no matter what I type into the boxes. What am I missing?

I had the same problem - the instructions say to use IP\SQLEXPRESS or just SQLEXPRESS.

I logged to SQL server management express, and it listed the server name as my computer name (FHSHSA101) \SQLEXPRESS

So in ClearCanvas, Try the name of your Server\SQLEXPRESS

In my case i used FHSHSA101\SQLEXPRESS and it worked like a charm

Hope this helps

I am having the same problem.  You refer to the SQL Express Checkbox enabled.  Where can I find that checkbox.  It doesn't appear on any of the screens during installation.

 

I have been working on this now for about 10 hours.  Everyone has been wonderful and is offering advice. Unfortunately it is quite antecdotal. Mostly they just stumbled on what works on thier own computer and offer that for help. It is very nice of them but not braodly applicable.

I must say that if we don't get a documented metod of screen shots, exact settings and protocols the ImageServer installation process alone will doom this product.

What support software such as IIS and SQLServer Express needs to be installed and in what order? The install program should look for this and abort if it is not found. Messages ned to say what is not available.

What are the exact settings in SQLExpress throughout all of its setup parameters?

Where does one get the password that it is looking for?

I am sure there are many other parameters but these are deadly ones.

Hi Bill,

First, on the subject of the SQL Express Checkbox, that was in our initial 0.90 release installer, but we removed it in subsequent installers because we thought it confused the issue. When this box was checked, we were appending /SQLEXPRESS on the end of the server name. We decided to add the note instead in the installer to add this string to the hostname when connecting to a SQL Express database.

Concerning SQL Express installation, we do in the Appendex of the User's Manual have screen shots on configuring SQL Express. have you taken a look at this? The password you enter in our installer is the sa password that is setup when SQL Express is configured in "Mixed Mode".

Steve

Hi Steve

Thanks

I did all of those things again after reading your post. No matter what I do I get the same error that the connection failed. Through SQL Server Configuration Manager the connection works fine

-Bill.

Hi Bill,

Thanks for your efforts and for being tenacious. I'm sure many users will be grateful for the tips. We'll look to incorporate them into the guide.

N.

 

There seems tobe no way to past a screen shot here.  If you know of one please let me know. The insert image icon only lets you see CC's browser and the url won't let it point back to my machine.  Cut and past doesn't work either.

-Bill

Here is the error I get when trying to open a patient study in IMageServer 1.3. Everything seems towork except I can't open a study. I get the same message whether I use name or case number.

Error:
Sys.WebForms.PageRequestManagerParserErrorException: The message received from this server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.
Details: Error parsing near ‘

Don't suffer anymore

at the window where you setup the user, password, and instance set as follow

user: sa
password: "your password"
server: "yourmachine\SQLEXPRESS"

Has anyone managed to get a connection to SQLSERVER 2008/Windows Server 2008?
I am quite familiar with sqlsever logins, and have tried every combination of user account, with or without the servername and a slash preceding it, and tried 127.0.0.1 and localhost and the servername.

I have tried this with both integrated and non-integrated accounts. My own connect strings that I create using the UDL file method seem to work fine.

I am not using a named instance.

I am able to get in to my database using the sql command line:

OSQL  -Usa -Pmypassword

 

 

 

thanks!

Ok,
I got passed this step with SQLSERVER 2008.
For whatever reason, the sa account works.
My settings in the database connect box are:
Username: sa
pw: *********
db server: mymachinename

I am not sure why my other sql accts did not work since they had full admin access.

 This forum post discusses using the 1.3 version of the ImageServer with SQL 2008:

http://www.clearcanvas.ca/dnn/Commu...fault.aspx

Hello my problem is, i have sql2000 sql2005 and sql2008 in my server, i tried to connected with the sql2005 instance, but not work, what step i passed?

FYI, the ImageServer supports SQL 2008 & SQL 2005. Since you have 3 instances of SQL on the same box, you must have given each a instance name for connections. I believe you'd have to put in the database server in the installer as something like "localhost/NAMEDINSTANCE", where NAMEDINSTANCE is the name of the Sql 2008 or 2005 server.

Steve