Connect to local DB hostedin another PC in Network

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Connect to local DB hostedin another PC in Network

Author

Topic

lanti_p
Starting Member

15 Posts

Posted - 2011-12-14 : 04:15:57

Hello guys,

My name is Lanti, and I am new to SQL Server, both Programming and Administration.
I need to connect to a local db that is hosted in a PC on our network, but in my PC I have installed just the SQL Server tool.
Can you please help me on this issue?

I am running on Windows 7 using SQL Server 2008 R2.
Same regarding the other PC hostind the local DB.

Thank you all and regards,
Lanti

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-14 : 04:20:53

you can use IP address of remote machine or its machine name as server name after connecting to SQL Server management studio in your machine and opening new connection window. I hope sql server db is installed as default instance in other machine, if not, you need to use machinename\instancename

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sunnyleoneo
Starting Member

19 Posts

Posted - 2011-12-14 : 04:33:07

Yes, you can connect with out any problem.

Please check below link which describe how to connect to database using sql server management studio.

http://www.serverintellect.com/support/sqlserver/connect-database-ssmse.aspx
http://www.asp.net/web-forms/videos/sql-2005/using-sql-server-management-studio

lanti_p
Starting Member

15 Posts

Posted - 2011-12-14 : 04:44:54

Thank you for your answer,

quote:
I know how to connect to a remote server
that hosts the db. The problem stands with connecting to
a stand-alone PC on the network, in which a local db has been created

Yes, I have tried connecting using the machine name (even the IP address),
but I am getting the same error

quote:
TITLE: Connect to Server
------------------------------

Cannot connect to billk5136.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 5)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=5&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

But I have not tried connecting machine_name\instance_name ...

What can I do to find out the instance in the local PC?

girma
Starting Member

1 Post

Posted - 2011-12-14 : 04:47:23

Follow the following steps:

1. Open the Sql server management studio
2. Right click on your server name
3. Click Connect
4. Select Database engine for server type
5. select/type the server name (either name of the machine or ip address). If it is not installed on default instance, write servername\instantname
6. Enter appropraite authentication username and password and click connect.

Enjoy SQL.....

No matter, we will solve it!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-14 : 04:48:39

first check if sql server service is running in remote server. go to services.msc and check for mssqlserver service

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

lanti_p
Starting Member

15 Posts

Posted - 2011-12-14 : 05:06:57

Yes,

I checked the services.
They are up and running! (Also, I can ping the remote machine)

I even created a new login, on the remote PC, but I still can not connect to the db. Is there anything from PC side that I should check?

quote:
TITLE: Connect to Server
------------------------------

Cannot connect to 10.214.129.42\master.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-14 : 05:10:19

is remote pc in same domain as your machine?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

lanti_p
Starting Member

15 Posts

Posted - 2011-12-14 : 05:19:41

yes, the remote pc is in the same domain

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources