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.
| Author |
Topic |
|
JeffHurley
Starting Member
3 Posts |
 Posted - 2005-01-04 : 10:34:44
|
| Hi all,I am creating an asp/sqldmo script to go thru the server groups that I have registered thru EM. This worked fine on my old computer which was: windows ME with MSDE(7.0), and no Firewall on it . My new computer is running XP Pro with SQL Server 2000 Enterprise Evaluation, Norton Internet Security firewall. Is there something different in the configuration or property setting that I need to do.When I run osql -L on the old computer, it lists all sql servers on both computers; on the new computer, the command only reveals the servers on the local machine. Did I install this wrong or is it something else? Thanx for any help.Thank You Jeff Hurley |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-01-05 : 15:41:18
|
osql -L does not rely on the EM registration... are you on a domain? Or are you running in a workgroup? Also you may want to see if someone turned off the named sql pipes and hid the server this could have occured after registration... One quick check is to use EM and see if the server displays in the list of known servers. |
 |
|
|
JeffHurley
Starting Member
3 Posts |
Posted - 2005-01-06 : 11:28:04
|
| i am set up in a local workgroup at home, the servers that i have registered all show up in EM, they just will not show up thru my script. when i compared the registries between the two computers, the locations for the registrations were not the same, would this have something to do with this? How do i find out if the pipes were turned off?Thank You Jeff Hurley |
|
|
|
|
|
|
Registered Servers are not listed