Can I access SQL Server 2005 via a Window XP pro workgroup network?

Hi,

I am new to SQL Server and I am trying to install SQL Server 2005 Express or Stnadard Edition on a computer runing XP pro on a XP's workgroup network using a router. Can I access the the database from another computer running XP pro on the same network? If I can, what setting do I need when installing SQL 2005 in order to do this?

Any help is appricated.

Make only sure that you enable remote connections, see the Screencast for this on my site for a detailed explanation.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Calling the New server Registration Dialog window

Hi,

I'm aware of using SmoApplication.EnumAvailableSqlServers to list network SQL Servers, however I would like to go a step-further and a call the "New Registered Server" dialog (follow the below link), in a similar way that you can use an instance of DataLinksClass to call a udl style connection string builder.

Is this an object that can this be called, or will I need to build it?

http://www.thesalemlot.com/serverreg.jpg

Thanks

Drew

AS SQL Server MS is just a WIndows application built on top of SMO you can′t call this functio, you have to build that on your own. Bu you can take the one Microsoft has built as a template. Simply refelctor the code and take this a a good starting point to built your own register diallog.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Well, I'd never heard off Reflector until you mentioned it. But if I understand you correctly, this could really help me for this and future projects. I've download it, but am unsure how to use it. I'd appreciate it if you could spare a moment to explain it. How do I load that particular part of SMO to view the code behind it?

Thanks

Drew

|||Well you have to reflector the code of SSMS to find the appropiate parts. Find the Forms section within the assembly and see what is happening behind the scenes-

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||THANKS FOR REGISTERED MY NEW WINDOW

Calling the New server Registration Dialog window

Hi,

I'm aware of using SmoApplication.EnumAvailableSqlServers to list network SQL Servers, however I would like to go a step-further and a call the "New Registered Server" dialog (follow the below link), in a similar way that you can use an instance of DataLinksClass to call a udl style connection string builder.

Is this an object that can this be called, or will I need to build it?

http://www.thesalemlot.com/serverreg.jpg

Thanks

Drew

AS SQL Server MS is just a WIndows application built on top of SMO you can′t call this functio, you have to build that on your own. Bu you can take the one Microsoft has built as a template. Simply refelctor the code and take this a a good starting point to built your own register diallog.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Well, I'd never heard off Reflector until you mentioned it. But if I understand you correctly, this could really help me for this and future projects. I've download it, but am unsure how to use it. I'd appreciate it if you could spare a moment to explain it. How do I load that particular part of SMO to view the code behind it?

Thanks

Drew

|||Well you have to reflector the code of SSMS to find the appropiate parts. Find the Forms section within the assembly and see what is happening behind the scenes-

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||THANKS FOR REGISTERED MY NEW WINDOW