March 30, 2004 at 10:30 am
I have an application that installs a named instance of msde as part of its setup. I am able to access the msde database on the machine it was installed on, but can't access it from any other machine on the network. I want to use the svrnetcn tool to check the tcp/ip settings (the msde is installed with DISABLENETWORKPROTOCOLS=0), but when I try to open svrnetcn, a cmd window flashes and nothing happens. Any ideas why I can't open svrnetcn? MSDE is installed on a win 2k box and the service is started. I appreciate any help I can get. Thanks!!!
March 30, 2004 at 10:56 am
What happens if you drop down to a command prompt and run it from there? Does it show an error?
K. Brian Kelley
@kbriankelley
March 30, 2004 at 10:59 am
I tried that too, but I just get put back at the command prompt.
March 30, 2004 at 11:09 am
Anything in the application event log?
K. Brian Kelley
@kbriankelley
March 30, 2004 at 11:15 am
Nothing in the event log.
March 30, 2004 at 11:25 am
What if you navigate to the directory where svrnetcn is located and run it again? Anything?
K. Brian Kelley
@kbriankelley
March 30, 2004 at 11:30 am
A cmd window flashes and is gone. No entry in the event log, no error message, no window with a list of parameters. I can open cliconfg and edit those settings without a problem. But I need to verify that my msde instance is listening on tcp/ip. Thanks for any ideas!
March 30, 2004 at 11:38 am
So you're at a command prompt, sitting in the directory, run the program and a command window flashes and is gone. Very, very odd.
As a simple test you can stop the MSDE service. Wait a minute or two. Run a netstat -an from the command prompt. Make note of what ports the system is listening on. Restart MSDE. Run netstat -an again and see if any new ports are being listened on. If so, you've got a likely candidate.
K. Brian Kelley
@kbriankelley
March 30, 2004 at 11:52 am
I tried that and it looks like msde is not listening on tcp/ip. Which is what I was thinking was occurring. So how do I set msde up to listen on tcp/ip if not through svrnetcn?
I wonder if part of the (svrnetcn) problem comes from installing msde as a named instance...
Thanks for your help!
March 30, 2004 at 12:01 pm
Installing it as a named instance shouldn't have mattered too much, but it does sound like something went flaky with the install somewhere. Can you connect via named pipes? Especially locally?
K. Brian Kelley
@kbriankelley
March 30, 2004 at 12:25 pm
I can connect locally to the msde with no problem, but can't connect from another machine. I do need to be able to use tcp/ip though. Thanks!
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply