Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have two application servers that a configured quite similarly, however there is a discrepancy between them when they attempt to connect to a server name with a space appended to the end.

So, for exnmple, given the server name 'MySQLServer' (without quotes):

  • Machine 1 connects to MySQLServer with the names 'MySQLServer' and 'MyServer '

  • Machine 2 connects to MySQLServer with the name 'MySQLServer' but not 'MyServer '

Any thoughts anyone?

share|improve this question

closed as not a real question by mailq, TheCleaner, John Gardeniers, Scott Pack, mdpc Dec 5 '12 at 16:49

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Trim the space and go on. – mailq Sep 29 '11 at 11:23
How are you connecting? – GregD Sep 29 '11 at 11:54
@Maliq: Yes, that would fix it, however I'm wondering why its different on the two servers – James Wiseman Sep 29 '11 at 12:02
@GregD: I'm connecting:Simply through the Query Analyser/Enterprise Manager tool login dialog – James Wiseman Sep 29 '11 at 12:02

Check the alias setup on each application server.

You should use the program named "Client network utility" into MSSQL group.

share|improve this answer
Nothing indicative in here. Both are identical. – James Wiseman Sep 29 '11 at 14:12
DNS settings? Check also c:\windir\system32\drivers\etc\hosts. – lg. Sep 29 '11 at 15:48

Not the answer you're looking for? Browse other questions tagged or ask your own question.