up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
1  
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
feedback

1 Answer

up vote 1 down vote

Check the alias setup on each application server.

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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