System Admin

7-Dec-03 7:38

I'm working with a SQL Server 7 project, and using the Enterprise Manager to view the results of my code. Although everything seems to be operating correctly, when I open the Enterprise Manager and expand the console tree to reach my server I get a popup message that says, in effect, "The server \\MASTERCYLINDER is not known to be running." Clicking OK opens the connection well enough, but I'm wondering what I have to do to make it "known" that the server is running. The SQL Server is up to date, SP4 already installed. Any ideas?

"Your village called -
They're missing their idiot."

Mike Dimmick11-Dec-03 2:08

Mike Dimmick

11-Dec-03 2:08

SQL Servers are discovered using the NetBIOS browse mechanism, IIRC. Try the browstat command:

C:\Documents and Settings\mike.dimmick>browstat view 1 corp
Remoting NetServerEnum to \\IAD-PC on transport \Device\NetBT_Tcpip_{EFDF994C-74
B8-42EC-BBA4-30FB07E6E6D1} with flags ffffffff
4 entries returned.  4 total. 20 milliseconds
 
\\5D-DOMAIN         NT   05.00 (W,S,PDC,TS,DL,NT,MBR,02000000)
\\IAD-PC            NT   05.01 (W,S,NT,PBR,BBR)   Ian's PC
\\MIKESPC           NT   05.00 (W,S,PQ,NT,PBR)
\\SH-DELL           NT   05.01 (W,S,SQL,PQ,NT,PBR)    Simon's Laptop

An 'SQL' entry indicates that SQL Server is running.

If it takes a long time to find out whether a server is running or not, it probably means that browsing is broken on your network. It doesn't work terribly well in a non-domain environment, we've found, particularly if the master browser shuts down. You might find that running browstat tickle will sort out the browser tables.

Roger Wright11-Dec-03 4:57

11-Dec-03 4:57

Mike Dimmick wrote:
SQL Servers are discovered using the NetBIOS browse mechanism

Interesting throwback for Win2K. I tried the browstat command - it's not recognized by the OS. But it's still a useful clue. I routinely block NetBIOS traffic at the firewall, so this may be contributing to the problem. Oddly, though, this didn't occur before I had to re-install SQL Server 7, and my firewall settings didn't change. Thanks for some good clues.

"Your village called -
They're missing their idiot."

Mike Dimmick11-Dec-03 5:13

Mike Dimmick

11-Dec-03 5:13

Actually, it looks like it's sending some message to your workgroup, but only sends to the primary workgroup. My PC here is on our domain, but the migration has stalled. The status display works for servers on the domain, but not on the workgroup (even though I've sorted out the browsing on the workgroup).

browstat is part of the Windows 2000 Support Tools, which are on your Windows CD (the SUPPORT\TOOLS folder, IIRC).

Roger Wright11-Dec-03 5:51

Windows Network Speed Issue

11-Dec-03 5:51

Found it. It looks to be far more handy for workgroups than domains, and this PC is a domain of one. Thanks for the reminder, though - I'd forgotten about that Support Tools folder. There's lots of goodies in there! Big Grin | :-D

"Your village called -
They're missing their idiot."

Windows SNMP Traps

Gleb6-Dec-03 21:42

Gleb

6-Dec-03 21:42

Hi.
Does anyone know how can I set the SNMP agent to send trap on CPU in windows OS using Windows SNMP service.
Example : I need that SNMP agent will send trap if CPU > 80% for X seconds.
Is there built in windows possibility to do that , or do I have to write my own code?
Thank.

-- NA --6-Dec-03 3:35

6-Dec-03 3:35

I've got two WinXP Pro machines copying a few gigs of data over the network (100mbps, with switch), and it's going *incredibly* slowly... Cry | :((

Any tips for things that could be the problem? TIA Smile | :)

Paul

That demands capital punishment!! Death by a herd of marauding Bobs! - Ryan Binns

modified 18-Jul-18 11:59am.

-- NA --6-Dec-03 4:56

6-Dec-03 4:56

No more tears Big Grin | :-D

Paul

That demands capital punishment!! Death by a herd of marauding Bobs! - Ryan Binns

modified 18-Jul-18 11:59am.

Michael Martin7-Dec-03 5:05

Michael Martin

7-Dec-03 5:05

Paul van der Walt wrote:
No more tears Big Grin | :-D

I take it means you solved it. If so can you explain how.

My initial thoughts would have been that your NIC(s) were set to full duplex while your switch was set to half (or is that the other way around) which is causing huge amounts of collisions. Did you make a change on the switch or NIC?

Michael Martin
Australia

"I suspect I will be impressed though, I am easy."
- Paul Watson 21/09/2003

-- NA --7-Dec-03 5:43

7-Dec-03 5:43

A surprisingly low-tech solution actually: as it turns out, the WinMX fileshare client is rather heavy on network resources Suspicious | :suss:

Paul

That demands capital punishment!! Death by a herd of marauding Bobs! - Ryan Binns

modified 18-Jul-18 11:59am.

Alexander ^M.,6-Dec-03 5:15

Alexander ^M.,

6-Dec-03 5:15

wrong forum!

Don't try it, just do it! Wink | ;-)

-- NA --6-Dec-03 6:10

6-Dec-03 6:10

Wrong retort Hmmm | :|

Paul

That demands capital punishment!! Death by a herd of marauding Bobs! - Ryan Binns

modified 18-Jul-18 11:59am.

Matt Newman6-Dec-03 6:36

Matt Newman

6-Dec-03 6:36

This Alexander guy seems to have a problem with you

^Matt Newman

If you chose to continue this discussion, I am fully prepared to make you my bitch. I invite you to ask around, and you'll find out that I'm quite capable of doing so - John Simmons on Trolls

Alexander ^M.,6-Dec-03 13:27

Alexander ^M.,

6-Dec-03 13:27

i don't have problems with anyone...

Don't try it, just do it! Wink | ;-)

Roger Wright6-Dec-03 22:08

6-Dec-03 22:08

Alexander M. wrote:
i don't have problems with anyone...

I've been reviewing your posts in all the forums, and that seems to be true. You appear to have a problem with everyone, not anyone. I'd like to slam you for your inexcusably rude behavior here, but I can't - you have posted some really valuable stuff which has helped a lot of people, and that's what this site is all about. Good job!

I encourage you to continue your valuable contributions to this site - you're an asset to us, without a doubt. But keep in mind that there are many of us who are here to learn, and your childish attempts at humiliating people are not helpful to anyone. We don't want to lose your obvious expertise, but we can certainly do without your obnoxious posts that attack our long-time members.

Cool it, kid, and let yourself be assimilated. We're a nice bunch, and it wont hurt a bit...

"Your village called -
They're missing their idiot."

Matt Newman7-Dec-03 17:42

Matt Newman

7-Dec-03 17:42

Well said!

^Matt Newman

If you chose to continue this discussion, I am fully prepared to make you my bitch. I invite you to ask around, and you'll find out that I'm quite capable of doing so - John Simmons on Trolls

Roger Wright7-Dec-03 21:21

Windows Terminal Services

7-Dec-03 21:21

I guess that correspondence course in Tact was worth the effort... Blush | :O

"Your village called -
They're missing their idiot."

-- NA --6-Dec-03 1:18

6-Dec-03 1:18

I'm trying to set up my PC to be accessible from the internet, but haven't had any luck so far. On my router (NAT) I've got port tcp3389 forwarding to my computer, but when I try and connect from the outside I get a vague error. Are there any other ports that need forwarding too, or am I missing something else? Suggestions? TIA Big Grin | :-D

Paul

That demands capital punishment!! Death by a herd of marauding Bobs! - Ryan Binns

modified 18-Jul-18 11:59am.

Alexander ^M.,6-Dec-03 5:16

Alexander ^M.,

6-Dec-03 5:16

wrong forum again, please leave!

Don't try it, just do it! Wink | ;-)

-- NA --6-Dec-03 6:10

6-Dec-03 6:10

Where do you suggest I post a question about Terminal Services? To the best of my knowledge the SysAdmin is the best place to post a question about administering a terminal services server... or not?

Paul Wink | ;)

That demands capital punishment!! Death by a herd of marauding Bobs! - Ryan Binns

modified 18-Jul-18 11:59am.

Roger Wright6-Dec-03 6:56

6-Dec-03 6:56

Ignore it, Paul. This is the right forum for anything related to system issues, and the closest thing we've got to a general PC OS/hardware/networking forum. It's evolved over the years into a broader scope than I think Chris originally intended, but these things tend to have a life of their own.

BTW - What port is the outside computer using to contact yours? Http, Ftp, and Telnet all have default ports they use, and there may some additional mapping you need to do in your NAT device to enable the port used for TS from incoming packets. Some devices also need to be configured for specific traffic types - TCP, UDP, ICMP, etc.

"Your village called -
They're missing their idiot."

-- NA --6-Dec-03 7:09