twomey_paul
asked on
SQL 2005 Express Remote Connections to BCM
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?
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?
ASKER
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?
There is no f/w on laptop, firewall at head end allows all traffic etc.
Very odd!
Any more suggestions?
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..
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..
ASKER
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...
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...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Helpful comments.
twomey_paul,
Can you kindly let us know why a C grade for this question..
Kindly look at grading guidelines here:
https://www.experts-exchange.com/help.jsp#hs=29&hi=403
Can you kindly let us know why a C grade for this question..
Kindly look at grading guidelines here:
https://www.experts-exchange.com/help.jsp#hs=29&hi=403
* 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/