[Webinar] Learn how to a build a cloud-first strategyRegister Now

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

Not able to connect Sqlserver database which is installed in another system by using SqlServer Management studio

Hi Experts,

I have installed SqlServer 2008 R2  in my laptop and have installed SqlServer 2008 R2 in another system (LAN). I want to access/view  Sqlserver database from my laptop.

 I want to view all databases, Sqlserver tables which is in another system by using Sqlserver management studio R2 Express which is in my laptop.

Can you help me step by step.


Thanks.
0
Tapan Pattanaik
Asked:
Tapan Pattanaik
3 Solutions
 
AnujCommented:
Assuming both the servers are installed in same domain

Enable TCP/IP on both servers -  Go to SQL Server configuration Manager(you can find this in start-> program files-> SQL Server 2008 R2), Expand SQL Server network configuration , Click Protocols for MSSQLSERVER , then enable TCP/IP on the right side tab. like wise you need to do the same for  SQL Server native client configuration also.
Do this at both the servers.

Allow Remote Connections.
run this at both servers
sp_configure 'remote access',1
RECONFIGURE WITH OVERRIDE

Once the above steps are done, Connect to the server from your laptop using an account that have permission on the server. This account can be either windows account or sql account.

0
 
sachinpatil10dCommented:
0
 
Tapan PattanaikSenior EngineerAuthor Commented:
I have solved this issue by using this link. This link has actual answer to my question.

http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

I want to give points to experts.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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