Connecting to Another SQL Server on same network
Posted on 2014-01-15
Hi all, So I'm trying to connect to a SQL Server 2008 R2 from another machine on the same network. The builds are identical.
Perhaps one issue is that the machine/DB names are also identical so I'm trying to connect using IP address in Server name.
I currently receive error "SQL Network Interfaces, error: 25 - connection string is not valid).
I've checked all the normal things. The target SQL sevrer is running, its TCP/IP is enabled, the firewalls have all been taken down, I've reset the sa password, I can successfully ping the target machine.
I'm not entirely sure what should be in my server name but I've tried all kinds of variations... e.g. \\192.168.157.165\LOGIN_NAME or just \\192.168.157.165\
Hopefully you've got some ideas coz I'm out!!!!