Adobe Community: Message List - The requested instance is either invalid or not running

Re: The requested instance is either invalid or not running

forums_noreply@adobe.com — Thu, 20 Feb 2014 11:23:34 GMT

Sorry about the misunderstanding. You are right. I meant that you should mark your own answer of 17th February 11:23 P.M. as the correct one.

Thanks for your generosity, however, I deserve no credit! You may mark my response as 'helpful', but certainly not as the correct answer.

Re: The requested instance is either invalid or not running

forums_noreply@adobe.com — Thu, 20 Feb 2014 11:08:30 GMT

Ok, I understand well and I agree to help all.

But the terminology of this forum is not strict ?

i do not see any button like " this question as answered"

I see "correct" may be it is ?

But this is not the same meaning.

Answered = the solution has been given

Correct = that answer is true (may not solve the question ?)

This is my understanding.

Thanks for strictness.

Pierre.

Re: The requested instance is either invalid or not running

forums_noreply@adobe.com — Wed, 19 Feb 2014 13:44:00 GMT

It is nice to hear you finally solved it. Please kindly mark this question as answered, as it will surely save someone else time.

Re: The requested instance is either invalid or not running

forums_noreply@adobe.com — Mon, 17 Feb 2014 22:20:57 GMT

I reply myself :

After 2 days of trials.

Finally, replacing the instance name : LARDE\SQLEXPRESS by 127.0.0.1

It did connect successfully.

I do not understand, on local it works .... but ...

(I think it is a chance of all possible cobinations)

I really prefer developping than playing with these silly things.

The requested instance is either invalid or not running

forums_noreply@adobe.com — Sun, 16 Feb 2014 13:47:54 GMT

I try to set up a datasource to SQL server 2008 Express.

And I get always that message :

The requested instance is either invalid or not running.

I spent a full day looking at all forums threads, I have learn a lot,

Looking through all Google return on that subject, but it still not working.

I ask for help to solve this situation.

Here is my situation :

- Windows server 2008 R2 - CF9.0 - SQL server Express 2008

- Working through TSE (terminal server)

- on SQL server , I can acces the management studio, connect, create DB, anything

- I can Stop/Restart the SQL server service throuh the SQLconfig manager

- I have enable TCP/IP in SQLserver for 2 IPs : 127.0.0.1 and the server externel IP on which I connect through TSE, both on port 1433

- SQL server Express 2008 is installed on Hard Disk D: (not on C:) (C is small for diskspace)

- The SQL server Instance showed in SQL management Studio is : LARDE\SQLEXPRESS

- Authentification in SQL server : SQL server and Windows

- the CF datasource is declared as follow :

Driver : Microsoft SQL server

datasource name : any

database : the accesible SQL database name where i created a new table

server : LARDE\SQLEXPRESS port : 1433

no login

And I get this error in CF admin datasource : The requested instance is either invalid or not running

- I tried also with a new connection on SQLserver (username/password),
add it in the datasource declaration (user login)

same error.

It seems to me that it is a question of Coldfusion access to that instance of SQLserver

I have the same config at home on local, all is working fine. (difference is TSE)

Thanks for any idea, help.