Link to home
Start Free TrialLog in
Avatar of cesemj
cesemj

asked on

Unable to connect to SQL server 2008 R2 over the network

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!
ASKER CERTIFIED SOLUTION
Avatar of Aaron Tomosky
Aaron Tomosky
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cesemj
cesemj

ASKER

You were right but how do I find which error is causing the problem,
Avatar of cesemj

ASKER

I'm sorry, how do  I find which rule is causing the error
Avatar of cesemj

ASKER

Thanks for your help, I found the location where to change the ip.  :)