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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2004-09-09 : 06:46:40
|
| I work in a large public organisation which has two IT teams, one of which manages a VLAN that is essentially contained within the network of the other group. As if this doesn't cause enough issues (see other posts), I'm not having difficulties connecting to a SQL server and was wondering if anyone has any suggestions as to why. The situation is this. The network we have is a Novell one. Within the VLAN there is an NT domain which I can authenticate to. My SQL servers sit inside this VLAN and I have no problems accessing them. I now want to access a (SQL) server that is not in the VLAN, and I believe is not in an NT domain. If I do a search from my XP Pro laptop, I can see the box, however when I try to use Enterprise Mangler (and using SQL authentication) I get the error:-a connection could not be established... SQL Server does not exist or access denied....I'm fairly sure that I am using the correct login name and password (though I have asked for confirmation of these, which I an still awaiting). What else can I try? Could it be that something is Case Sensitive? Which elements are case sensitive?thanks in advancesteveSteve no function beer well without |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-09-09 : 06:56:34
|
quote:
Originally posted by elwoos I'm not having difficulties connecting
I'm so glad ;)If you were having difficulties, I might suggest that it could be authentication related, if you enable failure auditing you can check what username and password is going to the server, maybe this might provide a clue?-------Moo. :) |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-09 : 06:56:48
|
| If you are registering it from EM, if you click the button next to server, does it appear in the box? If so then it will be a login issue, if not then you may want to try connecting via the IP address and see if that works...Passwords will be case sensitive, the rest of the information shouldn't be, depending on your collation of course... |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-09 : 08:03:30
|
quote:
however when I try to use Enterprise Mangler
 i've heard so many words the em is called but definitely not a mangler... lolzanyways, better check with your netadmin, there might be some restrictions in the vlanto know if account is ok, use it inside the vlan |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-09 : 15:43:57
|
| had one yesterday where the client called me in at a fat fee rate 'coz they couldn't connect from A to B and it turned out that someone had created an ALIAS (in SQL's Client Network Utility) and got the wrong IP address for the server ... so connect failed every time 'coz it wrongly resolved the IP address to the wrong one).So I presume because you can see the machine from XP that you can ping it? How about SQLPing it? try registering using the IP address instead of "name"? is it running on port 1433, or something else?Kristen |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-09-10 : 10:27:30
|
| Now here's a mystery. If I put the IP address into EM I can register it on my XP machine, and if I do a search for the server name it is found, however I can't ping it from the command line. (This machine was configured I think to be part of the VLAN.) My Windows 95 machine (don't ask!!) CAN ping it, which is how I got the IP address, this machine has nothing really to do with the VLAN apart from authenticating to it.Is it me or is it confusing? Something to do with DNS maybeAnyway, thanks to all for the suggestions, especially Kristen coz you're idea worked. btw, how do I do a SQLPing? All I need to do now is work out where all the data has gone!! Watch this spacethanks againsteveSteve no function beer well without |
|
|
|
|
|
|
|
|
Now you see it, Now you don't