[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

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
0
philb19
Asked:
philb19
1 Solution
 
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
 
DBAduck - Ben MillerPrincipal 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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now