Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
262 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
 

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Using a hta file with MSSQL agent to schedule a script job 4 39
SQL query and VBA 5 45
tools to scan a SQL server's problem 14 26
SQL View / Qtry 3 11
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

860 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