Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
268 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 143

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
 
LVL 1

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 25

Accepted Solution

by:
DBAduck - Ben Miller earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

927 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