|
Home > Archive > MS SQL Server > March 2006 > SQL Server Manager won't connect
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server Manager won't connect
|
|
|
| Hi, I'm a SQL newbie - hoping someone here can help.
I installed MSDE SQL on a Windows 2000 Server SP4 in preparation to install
WSUS. Unfortunately I didn't include the instancename=WSUS switch the first
time around so I had to uninstall everything and start again. However when I
reinstalled MSDE subsequent times, the service manager won't connect now. I
can type the server name in the Server: field, but nothing appears in the
Services: field. And if I hit Refresh services button, still nothing happens.
I'm unable to choose start/continue, pause, or stop because I am given a
"This service control action cannot be completed as no service has been
selected." error. I can't select a service because there are none in the drop
down box. I have since tried uninstalling everything, rebooting, and
reinstalling again but it seems whatever is causing this has permenantly
saved the setting and I'm unable to fix it. Help!
Here is a tinypic.com link to the screen. Not sure if it will work or not,
tinypic is acting goofy..
http://i2.tinypic.com/r2uosz
| |
| Sue Hoegemeier 2006-03-12, 8:23 pm |
| Did you try typing the named instance for the server:
YourServer\WSUS
Also, make sure your MSDE instance is set to allow network
connection. Later versions disable network connections by
default. You will have to enable them using the
svrnetcn.exe. The ODBC driver used by SQL Server Service
Manager can't connect to instances where network connections
are disabled.
-Sue
On Fri, 10 Mar 2006 16:25:27 -0800, fdisk
<fdisk@discussions.microsoft.com> wrote:
>Hi, I'm a SQL newbie - hoping someone here can help.
>
>I installed MSDE SQL on a Windows 2000 Server SP4 in preparation to install
>WSUS. Unfortunately I didn't include the instancename=WSUS switch the first
>time around so I had to uninstall everything and start again. However when I
>reinstalled MSDE subsequent times, the service manager won't connect now. I
>can type the server name in the Server: field, but nothing appears in the
>Services: field. And if I hit Refresh services button, still nothing happens.
>I'm unable to choose start/continue, pause, or stop because I am given a
>"This service control action cannot be completed as no service has been
>selected." error. I can't select a service because there are none in the drop
>down box. I have since tried uninstalling everything, rebooting, and
>reinstalling again but it seems whatever is causing this has permenantly
>saved the setting and I'm unable to fix it. Help!
>
>Here is a tinypic.com link to the screen. Not sure if it will work or not,
>tinypic is acting goofy..
>
>http://i2.tinypic.com/r2uosz
| |
|
| Thank you very much Sue.. using artoo\WSUS worked.. not sure why I had to
specify the server though! I am on the artoo server. But it's working so I'm
just glad I don't have to start over again now. I also enabled TCP IP
networking through svrnetcn. Thanks for the tip!
Chris
"Sue Hoegemeier" wrote:
> Did you try typing the named instance for the server:
> YourServer\WSUS
> Also, make sure your MSDE instance is set to allow network
> connection. Later versions disable network connections by
> default. You will have to enable them using the
> svrnetcn.exe. The ODBC driver used by SQL Server Service
> Manager can't connect to instances where network connections
> are disabled.
>
> -Sue
>
> On Fri, 10 Mar 2006 16:25:27 -0800, fdisk
> <fdisk@discussions.microsoft.com> wrote:
>
>
>
|
|
|
|
|