| Author |
Topic |
|
octo1212
Starting Member
4 Posts |
 Posted - 2010-05-14 : 16:56:48
|
| warning: i'm new to sql servers and administrating themi have a client who has a simple sql server for an inventory piece of software...it is called key-inventory (http://key-soft.eu/?p=software/key-inventory) and i had 3 PCs connecting to it inside the office (on the LAN)...it was a b**ch getting it setup because the sofware does not install very well for network use...i digress...now that, through their tech support staff, i have it working inside the office, they have 1 computer that needs to access it remotely...i'm using Hamachi as a VPN since it is straightforward to setup and administrate for such a small enterprise (the cost is nothing, which is a nice perk)...the trouble is it will not connect to the sql server remotely, even with Hamachi connected and working on both the remote and server PCs...i have the settings identical on the remote PC as i have them on the PCs inside the office but it rejects the connection like it did when things were configured incorrectly (go figure)...here is a screenshot of the error:http://screencast.com/t/MWIxMjY2NmEti've got it setup on port 1433 using tcp/ip...the server name is D6YSLP31...the sql server name is KEYSOFTSQLdo i need to adjust Hamachi?do i need to adjust the server?suggestions? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-14 : 17:08:45
|
So you have installed a second instance of sql server?The first instance of sql server normally has the name of the box and that shouild be D6YSLP31.If it is an instance then try as server name:D6YSLP31\KEYSOFTSQL
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
octo1212
Starting Member
4 Posts |
Posted - 2010-05-14 : 23:44:20
|
quote:
Originally posted by webfred
So you have installed a second instance of sql server?The first instance of sql server normally has the name of the box and that shouild be D6YSLP31.If it is an instance then try as server name:D6YSLP31\KEYSOFTSQL
No, you're never too old to Yak'n'Roll if you're too young to die.
the alias is "D6YSLP31" and the server is "D6YSLP31\KEYSOFTSQL"...i have that correct in the settings both on the server and the clients...http://screencast.com/t/MGY2MDQ3 |
|
|
|
octo1212
Starting Member
4 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
octo1212
Starting Member
4 Posts |
Posted - 2010-05-15 : 21:17:35
|
quote:
Originally posted by tkizer
Your alias is backwards. D6YSLP31 should be the server name. Are you sure it's listening on port 1433?The link shows all of the steps that will need to be done to resolve the issue. Start with telnet. If that doesn't work, then it's a network issue such as a firewall blocking access.Tara Kizer
not according to the vendor...in fact, this setup in the office works perfectly...i am certain it's listening on port 1433i will disable to firewall to verify it's not that... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
hamachi vpn