Client unable to establish connection (SQL-08001)

[font=Book Antiqua][color=#000000][color=black][font=Bookman Old Style]Hi,

We get the below error when previewing a dcr ( using DB) from a remote computer.

Preview And Generate Error:

iw_sql_open: [Microsoft][ODBC SQL Server Driver]Client unable to establish connection (SQL-08001) [Microsoft][ODBC SQL Server Driver]
[Named Pipes]ConnectionOpen (CreateFile()). (SQL-01000) (DBD: db_login/SQLConnect err=-1)

:\default\main\ \WORKAREA\Web\templatedata\ \ \presentation\news.tpl

If we preview the same dcr from the server (Teamsite Box) , the preview is working with out any error.
Note:
I tested the connection to the database through inline cmd in DCT. It is working for both server and
remote client. I used the Perl code to set the environment information
Sys Details
DBI Smiley Surprised

DBC / MDAC 2.8
Winodws 2000/SQL Server 2000
TeamSite 6.5.0 SP 2

Please advise
Vin[/color][/font][/color][/font]

Find more posts tagged with

Comments

Adam Stoller

Chances are you're missing some setting or environment variable that is preventing the code from generating the correct connection string when run on the remote server - I suggest you add debugging to your code to see what the connection string is from both the TeamSite and remote server so that you can verify this.

iwTech

I tested the [color=black]setting and environment variable , but I could not find the error

[/color]

But some other tests that work around

I added my users to the Domain Group and changed the credentials (editor ),
They can preview the pages with out database connection error (remote /local)
Tested the db connectivity from the TS server , it is working
I created my users to the TS server (Local Users) and added the credentials (editor ),
They could not preview the pages ( Same database connectioin error) (remote/local)

But for both credentials , my inline calls to the DCR , which using the database is working
H

ow to debug the error ?

Please advise ,

Vin

Adam Stoller

Hi
I tested the [color=black]setting and environment variable , but I could not find the error
[/color]
But some other tests that work around

I added my users to the Domain Group and changed the credentials (editor ),
They can preview the pages with out database connection error (remote /local)
Tested the db connectivity from the TS server , it is working

I created my users to the TS server (Local Users) and added the credentials (editor ),
They could not preview the pages ( Same database connectioin error) (remote/local)
But for both credentials , my inline calls to the DCR , which using the database is working
H
ow to debug the error ?

Please advise ,

Vin

I'll hazard a guess ... if the users are only local accounts on the TeamSite server than the DB server doesn't know anything about them, and thus it will never work.

Again, that's just a guess.

motlnt

[font=Book Antiqua][color=#000000][color=black][font=Bookman Old Style]Hi,
We get the below error when previewing a dcr ( using DB) from a remote computer.
Preview And Generate Error:
iw_sql_open: [Microsoft][ODBC SQL Server Driver]Client unable to establish connection (SQL-08001) [Microsoft][ODBC SQL Server Driver]
[Named Pipes]ConnectionOpen (CreateFile()). (SQL-01000) (DBD: db_login/SQLConnect err=-1)
:\default\main\ \WORKAREA\Web\templatedata\ \ \presentation\news.tpl
If we preview the same dcr from the server (Teamsite Box) , the preview is working with out any error.
Note:
I tested the connection to the database through inline cmd in DCT. It is working for both server and
remote client. I used the Perl code to set the environment information
Sys Details
DBIDBC / MDAC 2.8
Winodws 2000/SQL Server 2000
TeamSite 6.5.0 SP 2

Please advise
Vin[/color][/font][/color][/font]

Are you using named pipes or TCP/IP?
can you try this options individually?

==========
Interwoven certified consultant
TS 6.7.1 on RedHat Linux
Lets make Earth GREEN

iwTech

Hi,

We are using TCP/IP (Network Library option) for Microsoft SQL Server DSN Configurations

I changed Network Library option for Microsoft SQL Server DSN Configurations to Named Pipes
- Shows the same error

I am still not able to understand the logic behind the connectivity

because the db connectivity is working for the inline call to the dcr .. (TS Local Users)

Why it is not working for the PT?

Please advise

Vin

iwTech

Hi
The error has been identified and resolved .( cmd iwreset –a [font=Wingdings][font=Wingdings][color=red]J [/font]resolved the error )[/font]
[/color]Lesson [font=Wingdings][font=Wingdings][color=lime]J [/font]:- If you made any changes to the Data Source , [/color]you should restart the TeamSite Server

[/font]How to use/conf Perl DBI for DCT’s / PT’s
Env: [color=#000000][size=2][font=Book Antiqua][ Windows 2000 /TeamSite 6.5.0 SP 2 ][/font][/size]
[/color]
For DCR’s

Create an .ipl file [example erl_dbi_callout.ipl ]
Define environment variables in the .ipl file
Save the .ipl file at httpd\iw-bin\
Call the .ipl file using an inline cmmd from the DCR
[example : c:\iw-home\iw-perl\bin\iwperl c:\iw-home\httpd\iw-bin\perl_dbi_callout.ipl"]

[size=2]For PT’s

[font=Bookman Old Style]Create a .tpl file [ presentation/test.tpl]
Define environment variables in the .tpl file[/font]
Configurations
Follow the configuration steps for publishing

MOST IMPORTANT [ TS Server ]

Administrative tools
Open -> Data Source (ODBC)
Open -> System DSN
Select->System Data Source [user defined /example QL_CONN]
Select ->Configure -> Next ->Client Configuration
Select -> TCP/IP [ By default Named Pipes] ->Ok

[color=red]Restart TeamSite [ iwreset –a]
[/color]Vin[/size]