| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2004-06-04 : 06:11:08
|
| Hello all,I am trying to connect to a sql server which is on WAN from a machine which is in LAN.It gives the following error:Unable to connect to server xxx.xxx.xxx.xxx :Server: Msg 17, Level 16, State 1[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.I have gone thru the KBID:287932 and 32086. No use.The ports for sql on the firewall are open. Even tried connecting by shutting down the firewall.ANy and all help highly appreciated.Regards,Harshal.He is a fool for five minutes who asks , but who does not ask remains a fool for life!http://www.sqldude.4t.com |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-04 : 06:17:06
|
| Can you ping the SQL box?Have you got an account? Can it log in locally?You could try a different login, or enable auditing on the sql box to see how far the attempt is getting.-------Moo. :) |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-06-04 : 06:38:09
|
quote:
Originally posted by mr_mist
Can you ping the SQL box?Have you got an account? Can it log in locally?You could try a different login, or enable auditing on the sql box to see how far the attempt is getting.-------Moo. :)
Yeah i can ping the server tried it with different login didn't work.I'll try auditing now..thanks for the reply.regards,Harshal.He is a fool for five minutes who asks , but who does not ask remains a fool for life!http://www.sqldude.4t.com |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-04 : 06:42:15
|
| Is the SQL Service running?-------Moo. :) |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-06-04 : 06:43:46
|
quote:
Originally posted by mr_mist
Is the SQL Service running?-------Moo. :)
Sure its runningHe is a fool for five minutes who asks , but who does not ask remains a fool for life!http://www.sqldude.4t.com |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-06-04 : 06:59:55
|
Problem solved  It worked after I mapped the sql server in windows explorer.Thanks for the help. Regards,Harshal.He is a fool for five minutes who asks , but who does not ask remains a fool for life!http://www.sqldude.4t.com |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-04 : 11:26:59
|
| That's not really the best way to do that, although it works. lolAre you using an LMHosts file by any chance? If you are, you need to add an entry in there for this server. MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-04 : 12:59:29
|
| You could also just create an alias to it using the Client Network Utility. Just specify the IP address and port number in it.Tara |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-06-07 : 00:34:08
|
quote:
Originally posted by derrickleggett
That's not really the best way to do that, although it works. lolAre you using an LMHosts file by any chance? If you are, you need to add an entry in there for this server.
derrick,Agreed this is not the best way but there seems no other way,I had tried adding adding an entry in the file hosts and also in the file LmHosts but it didn't work.quote:
You could also just create an alias to it using the Client Network Utility. Just specify the IP address and port number in it.Tara
Tara,Been there done that.it didn't work either, that was the first thing I had tried.but some how it doesn't seem to work.It connects only when the server is mapped.Thanks for the input.Regards,Harshal.---------------------------------------He is a fool for five minutes who asks , but who does not ask remains a fool for life!http://www.sqldude.4t.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-07 : 12:29:19
|
| It has to do with credentials then.Tara |
|
|
|
|
server connection error