unable to authenticate to sql express 2005 - the sql is in the dmz - the client connecting is in the internal LAN

using mixed authentication

or just sql it fails

error 18456

i can telnet to the sql port 1433
its an authentication issue - running windows 2008 r2 (both client and server)

the dmz server is in a workgroup
the internal client is in a domain - its something to do with this i believe
LVL 1
philb19Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DBAduck - Ben MillerConnect With a Mentor Principal ConsultantCommented:
You can use another SQL Account, but you cannot use Windows Authentication.  So you can create a login on the SQL Server that is a SQL Login and then grant access to the resources you want it to access in the databases and use that.

You don't "have" to use sa as it is just another SQL account that is built-in.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
usually this is a firewall in the middle blocking traffic, and you need to touch your firewall guys to open the port 1433 (at least) between your lan and your dmz ..
0
 
philb19Author Commented:
thanks - firewall wasnt isue as i could telnet to 1433. I managed to resolve by using sql account sa - I was trying to use other accounts
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.