Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Warwick
Starting Member
7 Posts |
 Posted - 2007-06-18 : 18:47:25
|
| I have a New default instance of SQL2k5 installed and i am trying to setup access to the this via a vpn.The VPN is setup and allows access to the server and can T/S to the server and perform everything all ok.When trying to connect over the VPN with SSMS installed on my laptop I am able to connect using Windows authentication only by using Named Pipes. To accomplish this i perform a Net Use ..... and everything works fine.However if i specify in the connection tab to use TCP/IP it fails with an unknown username or password. The Event Viewer on the server shows this and for what ever reason the username / pwd is that of my laptop and not of the account used in the VPN setup or the net use.Also if i try to connect to the SQL Server over the VPN using VS 2005 it also gives the same issue. I need to get this sorted so that TCP is able to be used.Thx in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-18 : 18:49:58
|
| Can you use SQL authentication instead? I'm not sure that there is a way to control the current security context that is passed to SQL Server.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Warwick
Starting Member
7 Posts |
Posted - 2007-06-22 : 02:30:19
|
| I am not really sure on this but i created an alias to the Instance using TCP/IP and i was able to connect to the instance using the alias and also by NT auth utilizing the TCP/IP.i then disconnected and tried just connecting to the instance and it works.no changes. but this is very bizare |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-22 : 15:39:16
|
| Did you specify ip address and port number in alias? If so, means there was naming resolution issue. |
|
|
|
|
|
|
SSMS Connection over VPN