Error setting up database

[DogBot]

When I try to set up a datasource I get:

The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either
invalid or not running.

What does this mean

[Jochem van Dieten **AdobeCommunityExpert**]

DogBot wrote:

> When I try to set up a datasource I get:
>
> The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
> Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either
> invalid or not running.

That you are trying to connect to a SQL Server instance that is
either invalid or not running :)

Is the database running? Can you connect to it with other tools?
Are there any firewalls in the way?

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion

[elDonrico]

are you using SQLServer or mySQL?

if it is SQL do you have a connection limited license? (like 10 people) in the
CF admin under the properties of your datasource, advanced button, check the
limit connections box and restrict to ... 10

read over this, maybe it can help you...
<a target=_blank class=ftalternatingbarlinklarge
href="http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18245">[url]http://w[/url]
ww.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18245</a>

[elDonrico]

also, are you using an XP Pro machine that runs this SQLServer? or 2000/2003? cause XP pro will limit you to 10 connections.

[DogBot]

<blockquote>quote:<br><hr><i>Originally posted by: <b><b>elDonrico</b></b></i>
are you using SQLServer or mySQL?

if it is SQL do you have a connection limited license? (like 10 people) in the
CF admin under the properties of your datasource, advanced button, check the
limit connections box and restrict to ... 10

read over this, maybe it can help you...
<a target=_blank class=ftalternatingbarlinklarge
href="http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18245">[url]http://w[/url]
ww.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18245</a><hr></blockquote>

I write this for the benefit of anyone with the same problem.

I was able to create a datasource using Window's ODBC Datasource adminstrator
(start, administrative tools, ODBC), no problem, so I used the ODBC socket
Dirver on the CF Admin to connect to that datasource succesfully, but I dont
understand why I had to do it this way.
In the past I was able to connect simply using the Microsoft SQL Driver.
I was running MS SQL Express (the CTP release) on Win XP Pro. The problem
started when I upgraded to the final release of Express(Non CTP).

Anyhow I am connected now. Thanks everyone for the suggestions (by the way I
did play with reducing the number of connections, even to just one and it did
not work)