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.
HunainHafeez
9
Posting Whiz
Recommended Answers
Jump to Postwith 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 …
Jump to PostBefore 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.
All 5 Replies
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
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?
HunainHafeez
commented:
yes jorGem,
+2
HunainHafeez
9
Posting Whiz
yes jorGem, both can have, i even changed it, now
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
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.
HunainHafeez
9
Posting Whiz
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
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
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.