Solved

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

Posted on 2014-04-14
3
252 Views
Last Modified: 2014-05-07
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
Comment
Question by:philb19
3 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 40001155
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
 

Author Comment

by:philb19
ID: 40001207
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
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 500 total points
ID: 40032179
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now