Search:

Is that a long word for "bug"? ;)

Mike

;) OK - that link helped!

??? :confused:

And it is only bl00dy working! :):):)

Thank you Wil - you are a lifesaver!

Mike

Thanks Wil

So TCP Dynamic ports = 0 and TCP Port = 1433? So... there are 4 sections... IP1, IP2, IP3 and IPAll - I have set those values (0 for TCP Dynamic Ports on IP1, IP2 and IP3 - it doesn't...

Wil

OK, how to check (and change) the port being used. Can't seem to find where that is.

Mike

Samuel

I was using Windows auth, but I think I'll have to change to SQL Server Auth and set up a specific DataFlex account.

Mike

Wil

It is using port 1433. I'm not connected ATM, but I'm pretty certain. :(
Mike

Samuel - 98 - see original post.

Mike

Note: telnet to the IP address of the server and port 1433 does not connect, so that's probably why it can't connect to the DB, but the underlying question is why does telnet (or indeed anything) not...

OK, nothing seems to be helping...

DataFlex 19.1 on Windows Server 2019 Standard (server) and Windows 10 Pro (client). Now... the server in question is a Domain Controller and using that as a DB...

Hans

OK, checked that - it is allowing remote connections.

So that's not it. :(

Mike

Hans (thanks for jumping in - you are entirely welcome and appreciated! :))

Yes, I think Michael was sugggesting the same thing. I don't have access to the customer's server right now, but...

Clive

It is using Windows authentication, so I'm not sure this applies. Maybe I'm wrong.

I might try the UDL file thing - didn't know about that.

Mike

Peter - thanks, useful advice. I'll give that a look. I assume you mean DBBldr from the workstaton? Its fine on the server.

Mike

Michael

Thanks for that - when I get back in (the customer dosn't like RDP, so I'm having to use Quick Assist through his workstation to connect) I'll give that a look. It is SQL Server Express,...

Michael

Thanks for that, but...

TCPIP is enabled on the server. SQL Server port 1433 is open in Windows Firewall. :(

I can't connect to the DB on the server (from the workstation) from...

Hi

OK, I'm dumb, but as it happens I've never actually done this before.

I have a system that I have installed on a customer's server and I have migrated their data into SQL Server. All runs...

Roel

No promises, but your suggestion has got me thinking. ;) (Always dangerous!)

Mike

Thanks Chuck - reading it now.

Mike

Sean

Ah! OK, that's something to bean in mind.

Thanks.

Mike

Garret - yes, that's exactly where I found it. :)

Mike

Samuel

Thank you. That cracked it. I deleted the database, created again, in the "Options" page of the Properties panel I changed the collation sequence to case semsitive (CS, not CI) and re-did...

Samuel

Thank you for that - now I just need to work out how to make that change! :)

I'll get there!

Mike

The collation is currently SQL_Latin1_General_CP1_CI_AS - what should it be? Even assuming I can work out how to change it!

Mike