asked on

SQL Express 2005

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

lcohan

"... 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 "

07vette

ASKER

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.

ASKER CERTIFIED SOLUTION

lcohan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

lcohan

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)"

07vette

ASKER

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."