Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 115
  • Last Modified:

Connecting to Another SQL Server on same network

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!!!!
0
Clever_Bob
Asked:
Clever_Bob
  • 6
  • 6
1 Solution
 
HuaMinChenBusiness AnalystCommented:
Are the services of that DB server up? Try to put

192.168.157.165\INSTANCE_NAME_OF_SS_ON_THAT_SERVER

as server name, to connect
0
 
Clever_BobAuthor Commented:
Thanks for the help. Still same error unfortunately.

Now trying to connect using \\192.168.157.165\WIN-RSVBTR9M8A2

(I presume thats the instance name, its what get returned when I run "Select @@ServerName")

and using SQL authentication and TCP/IP
0
 
HuaMinChenBusiness AnalystCommented:
No, please instead Instance name, which is the one you can see within services.msc. Please see the attached for highlighted name which is the Instance name.
dis.png
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
HuaMinChenBusiness AnalystCommented:
Please check Fig 1 above.
0
 
Clever_BobAuthor Commented:
my list in services.msc contains

SQL Server (MSSQLSERVER)

as yours does but no other instance like you suggest. Perhaps this is part of the problem?
0
 
HuaMinChenBusiness AnalystCommented:
Try to connect to this

192.168.157.165\MSSQLSERVER
0
 
Clever_BobAuthor Commented:
same result :(

Why does your list contain two instances for SQL Server though? Mine just has one
0
 
Clever_BobAuthor Commented:
The error is actually a bit longer than that. "Server not found or not accessible", "allow remote connections" and then "SQL Network Interfaces, error: 25 - connection string is not valid"
0
 
HuaMinChenBusiness AnalystCommented:
Are you using Sql server management studio to connect? Is that Instance name already started, within services.msc?
0
 
Clever_BobAuthor Commented:
I'm actually getting a new error now

" (provider: TCP Provider, error: 0 – No such host is known.) (Microsoft SQL Server, Error: 11001)"
0
 
HuaMinChenBusiness AnalystCommented:
Can you ping 192.168.157.165?
0
 
Clever_BobAuthor Commented:
yep, no problem with the ping
0
 
Kevin CrossChief Technology OfficerCommented:
MSSQLSERVER is the default instance; therefore, you should connect with just 192.168.157.165 or the DNS name of the SQL Server.  If that does not work, ensure that you have remote connections enabled.  

Please reference Guy's article:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_1881-Connect-to-your-SQL-Server.html

It provides some screen shots of the configuration manager where you can enable the TCP/IP protocol and ensure (if you have multiple IP addresses) that SQL is listening on the one you are trying to connect with.  Further, if the system has a firewall, ensure that the TCP port (e.g., 1433) listed in the TCP/IP properties is open.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 6
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now