Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

PB8 fail to connect to untrusted SQL 2K

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gbkhor - 26 Jul 2008 02:54 GMT
hi

Not sure this is the correct forum or not, but it related to SQL server
I had one PB8 (8.0.2.9506) program that FAIL to connect to two
different untrusted domain where the SQL version is SQL2K.
I able to connect it using SQL enterprised manager at the same PC and
even SQL analysed but NOT via PB8 program.

I had tested with PB10 (10.2.1.9004) program, it able to do it.

Kindly advice what is needed to be changed at PB8 or on this SQL server

Note: the untrusted domain is Win2003 AD

thanks in advance
Roy Harvey (SQL Server MVP) - 26 Jul 2008 03:11 GMT
I guess that PB8 might mean PowerBuilder, though a google search
mostly came back with Pro-Biotic Acidophilus.   8-)

At any rate, are you trying to connect using Windows authentication or
SQL Server authentication?  I would expect Windows authentication to
fail from an untrusted domain, but SQL Server authentication should
work as long as the client can find the server.  Is it possible that
the connections that work are using SQL Server authentication
(connecting as sa, for example) but the failures are using Windows?

Roy Harvey
Beacon Falls, CT

>hi
>
[quoted text clipped - 11 lines]
>
>thanks in advance
gbkhor - 28 Jul 2008 03:10 GMT
Hi Roy

Yes, PB8 is powerbuilder

I'm using SQL Server authentication and not Windows. It Fail

thanks

>I guess that PB8 might mean PowerBuilder, though a google search
> mostly came back with Pro-Biotic Acidophilus.   8-)
[quoted text clipped - 24 lines]
>>
>>thanks in advance
Roy Harvey (SQL Server MVP) - 28 Jul 2008 12:38 GMT
>Hi Roy
>
[quoted text clipped - 3 lines]
>
>thanks

Check the network protocol that is used by the connections that work,
and by the ones that don't work.

Roy Harvey
Beacon Falls, CT
gbkhor - 28 Jul 2008 15:12 GMT
Hi Roy

I believe the network protocol is OK, how to double confirm?it is "SQL
Server client network utility"?, if yes, then the network protocol is OK

but i still getting the error

thanks

>>Hi Roy
>>
[quoted text clipped - 9 lines]
> Roy Harvey
> Beacon Falls, CT
Roy Harvey (SQL Server MVP) - 28 Jul 2008 15:59 GMT
>Hi Roy
>
[quoted text clipped - 4 lines]
>
>thanks

What I meant was compare the network protocol used by the working
connections to that trying to be used by the clients that do not
connect.

Roy Harvey
Beacon Falls, CT
gbkhor - 30 Jul 2008 15:06 GMT
Hi Roy

I had confirm, the same network protocol doesn't work at untrusted domain

thanks

>>Hi Roy
>>
[quoted text clipped - 11 lines]
> Roy Harvey
> Beacon Falls, CT
gbkhor - 31 Jul 2008 15:26 GMT
Hi all

I found the solution, this is due to NTWDBLIB.DLL was not the latest
version, after replace with latest version, issue resolved

thanks to Roy for the help as well

> Hi Roy
>
[quoted text clipped - 17 lines]
>> Roy Harvey
>> Beacon Falls, CT
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.