Member Avatar for HunainHafeez

i'm trying to access a database backup that i usually keep in my pc's hard disk, trying to access it via my laptop. Both pc and laptop has SQL SERVER 2008 with same server name, using windows authentication, i spent 2 days but can't figure out that how to access it remotely ? I'm using ZTE wifi as a hotspot for internet connectivity, PC is connected to it via cable while laptop wirelessly.

  • 2 Contributors
  • 5 Replies
  • 133 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by JorgeM
Member Avatar for JorgeM

with same server name

Both computers have the same name? That's not going to allow you to connect from one PC to another if you try by name. The source PC will know its name and therefore the name will resolve to itself. Can each PC have its own unique hostname?

commented: yes jorGem, +2
Member Avatar for HunainHafeez

yes jorGem, both can have, i even changed it, now

Member Avatar for JorgeM

Before you can use SQL management studio, first verify network connectivity. Any local firewall enabled on either system? Can you resolve each other's hostname? Can you PING each other.

When these answers are yes, then focus on the application layer.

Member Avatar for HunainHafeez

ok jorGem, seems like i have to pick my CCNA notes again :D though i'm CCNA certified but still don't remember those things :D

Thanks bro

Member Avatar for JorgeM

no problem. too many things to keep track of at the same time...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.