The requested instance is either invalid or not running

[plarts]

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.

[plarts · Accepted solution]

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.

[BKBK]

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

[plarts]

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.

[BKBK]

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.