SQL 2005 Express Remote Connections to BCM

twomey_paul
twomey_paul used Ask the Experts™
on
Hi All,

I am trying to connect to Business Contacts Manager over a VPN connection from a laptop and I cannot.  If I try on the local LAN I can.

My servers subnet is 192.168.0.x and my laptop's 192.168.10.x .

I have done the obvious like configure the Surface Area on SQL to allow remote connections, I can telnet from the laptop to port 1152 etc.

The message I recieve in the event log is 17806: SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. (Client; 192.168.10.3).

Also

Event ID 18452.  Login failed for user". The user is not associated with a trusted SQL Server connection.  (Client: 192.168.10.3)

Any ideas please?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Then you have to enable Mixed mode Authentication in SQL Server by

* Right Click Server in SSMS and choose Properties
* Go to Security Tab and Choose Authentication Mode as Windows Authentication and SQL Server Authentication.

Restart SQL Server services which should help.

If you haven't enabled remote connections properly (or have enabled it), just ensure whether it was done properly as per

http://www.linglom.com/2007/08/31/enable-remote-connection-to-sql-server-2005-express/

Author

Commented:
Thanks for the response but I have done these suggestions already and re-checked them and still my vpn laptop will not connect.

There is no f/w on laptop, firewall at head end allows all traffic etc.

Very odd!

Any more suggestions?
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Ok, try checking this from the remote machine

telnet sqlserverip 1433

replace sqlserverip with the IP of the machine where SQL Server resides and 1433 with the port on which SQL Server listens.

Above should open up a blank window from command prompt else you have some network connectivity issues..
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Author

Commented:
Yup, this works fine from the remote machine!

In addition, I started a new database on another server and when I try and connect to the database it prompts me to change my password on the server so as it tallys with the password on the local laptop?

As far as i can see all user accounts are matched with passwords...
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> Yup, this works fine from the remote machine!

Then you don't have any issues in your network connectivity.
Try connecting to your SQL Server in SSMS by placing servername,1152 in place of Servername.

>> when I try and connect to the database it prompts me to change my password on the server so as it tallys with the password on the local laptop?

Seems like you are using Windows Authentication.
Is there by any chance that those two SQL Servers are in Different domains or the Windows users belongs to different domains.

Author

Commented:
Thanks for your replys so far...

I do have authentication in mixed mode on the SQL server/s (the two I have tested thus far).  The two servers are both on the same domain, however the user account of the laptop is a local user account.

I created the a user account ON SSMS under Logins as a SQL login with exact same credentials as the credentials I use for the local login username and password on the laptop.  (This works when I plug the laptop onto the LAN).

Cheers
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> however the user account of the laptop is a local user account.

Try using or configuring it with a Domain user account or the account configured in your other Server to confirm whether there are any other issues in your setup..
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
Commented:
Ok Please set authentication of SQL Server to Mix mode.

You error itself says the log in user is not authenticated.

Author

Commented:
Helpful comments.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
twomey_paul,

Can you kindly let us know why a C grade for this question..
Kindly look at grading guidelines here:

http://www.experts-exchange.com/help.jsp#hs=29&hi=403

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial