SQL Express 2005

07vette
07vette used Ask the Experts™
on
I installed SQL Express 2005 on a server on a different Vlan and I cannot see it via SQl server Management studio express. I can see other SQL server express 2005 instanse on the same Vlan.

So to clairify:
I have SQl server Management studio express installed on my PC which is on Vlan.112.
I installed SQL Server Express 2005 on a Server that is on Vlan .5.
When I am in SQl server Management studio express and I "browse for more" servers and click the "Network Servers" tab it only shows Database Engines for instances that are on my Vlan .112.
I checked and all the SQL services are running ..ex. the SQL Server service and Browser service. Just to be sure I temporarily disabled the Firewall Service.
What am I doing wrong?

The server is a VMWARE 5 VM guest running MS 2008 R2 DataCenter

Thanks in advance
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst

Commented:
"... I cannot see it via SQl server Management studio express."

Can yo access it (register it) and connect to it in SSMS by using that SQL IP? You should if you are authorized to work on that "different Vlan "

Author

Commented:
Yeah I can manually enter the name servername\SQLserver and access it that way, but it doesnt show in the network servers tab. If it is not an option I dont have a problem with it. I just want to make sure there is nothing that I am doing wrong.

Thanks for your quick response Icohan.
Database Analyst
Commented:
Is it a SQL Browser service runing on that box? That is the service making it visible/accessible via network.

http://msdn.microsoft.com/en-us/library/ms181087(v=sql.90).aspx
lcohanDatabase Analyst

Commented:
A bit more details at:
http://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/


"What if SQL Server Browser service is stopped?
 
[...]
 •Also your named instances will not be published in the list of SQL Server instances on the network (which could be a good thing)"

Author

Commented:
Yes my Sql Browser services was running on the Server, but the article you provided gave this little tid bit, which is exactly what I am experiencing.

Read Below.
http://msdn.microsoft.com/en-us/library/ms181087(v=sql.90).aspx

"Troubleshooting can be difficult depending on where UDP 1434 is blocked. If blocking is done at the router between subnets, SQL Browser will work if the remote machine is on the same subnet, but not if it is across the router boundary on another subnet."

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial