Problems when connecting to a SQL Server 2000 when the name has a trailing space

Question

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?

@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

score 1 · Answer 1 · answered Sep 29 '11 at 12:04

1

Check the alias setup on each application server.

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

answered Sep 29 '11 at 12:04

lg.

4,649
3
21
20

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

Problems when connecting to a SQL Server 2000 when the name has a trailing space

1 Answers1