Solved

Unable to connect to SQL server 2008 R2 over the network

Posted on 2013-10-23
4
984 Views
Last Modified: 2013-10-23
Server Config
-----------------
Server 2008 R2
SQL Server 2008 R2
SQL Server Configuration  Manager:
1) Protocols for MSSQLSERVER (TCP/IP Enabled)
2) IP10: IP Address 127.0.0.1, TCP PORT 1433
3) IP ALL: TCP PORT 1433

Firewall: MSSQL is listed 2 times:
1) Local: Any - 3306, Remote: 200.101.47.0/24
1) Local: Any - 1433, 1434, Remote: 200.101.47.0/24

ServerIP: svrParts-01 (Hostname), 192.168.1.5, 255.255.255.0, 192.168.1.1(Gateway), 192.168.1.2(DNS)

My System IP: systemo5 (Hostname),  192.168.1.34, 255.255.255.0, 192.168.1.1(Gateway), 192.168.1.2(DNS)

Hi,

I am trying to connect to a SQL Server 2008 R2 DB from my local system on the same network but not able to.  I can log into the SQL server using windows authentication or SQL Server Authentication (sa account ) no problem.  I

I tried to connect to my the server using SQL using a db connection in Visual studio but no luck:
Data source: Microsoft SQL Server (SQL Cliet)
Server Name: svrParts-01 or 192.168.1.5:1433
Use SQL Authetication: sa and password
connect to database: dbParts
Test Connection message: The server was not found or was not accessible. Verify instance name is correct and that SQL server is configured to allow remote connections. (provider: SQL Network Interfaces, error 25 - Connection string is not valid).

or

An error has occurred while establishing a connection to the server when connecting to SQL server 2005, this failure may be caused by the fact that under default settings SQL server does not allow remote connection. ( provider: Named Pipes Provider, error: 40 – could not open a connection to SQL server. )

Thanks in advance!
0
Comment
Question by:cesemj
  • 3
4 Comments
 
LVL 38

Accepted Solution

by:
Aaron Tomosky earned 500 total points
ID: 39596118
The firewall looks odd. Turn off the firewall just to test. If that works, put the right ip addresses in there.
0
 

Author Comment

by:cesemj
ID: 39596157
You were right but how do I find which error is causing the problem,
0
 

Author Comment

by:cesemj
ID: 39596159
I'm sorry, how do  I find which rule is causing the error
0
 

Author Comment

by:cesemj
ID: 39596211
Thanks for your help, I found the location where to change the ip.  :)
0

Featured Post

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now