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
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Accessing SQL Server on home network

Author  Topic 

gftgrill
Starting Member

2 Posts

Posted - 2010-05-29 : 18:23:06
I'm trying to set up an instance of SQL Server Express 2008 on my home network.

server machine is Windows 7 Ultimate x64.

I want this computer to run an instance of SQL server that I can access via my windows XP laptop.

when I open SQL Management Studio in XP, I click on Connect and choose Database Engine.

Under server name I click on "browse for more", then I click Network Servers.

there are no items in this list.

Is there something that I'm missing? is sql express not capable of network traffic (local computer only)?

thank you for your help

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-29 : 18:47:30
Type in ServerName\InstanceName into the field, replace ServerName and InstanceName with the appropriate values. InstanceName is probably SQLEXPRESS.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

gftgrill
Starting Member

2 Posts

Posted - 2010-05-29 : 22:20:41
thanks, I figured out that windows 7 (host) firewall was preventing me from seeing the sql server instance. once I turned that off, it worked just like you said.
Go to Top of Page
   

- Advertisement -