Connection

Connection

Post by QXJhbnR6Y » Wed, 21 Jun 2006 19:56:02


Hello
I don't have very much idea about data bases, but I need one to install wsus.
I've installed MSDE and I have created an instance called WSUS.
The problem is that it doesn't work. It doesn't connect.
I have the service running (called MSSQL$WSUS).
I have seen in the errorlog that the server is listening in shared memory
but not in tcp
Values in registry show that msde doesn't recognice the instance.
What can I do???????
I'm really tired. I'm trying everything I read but it doesn't work. Please!
Thank you

Arantza
 
 
 

Connection

Post by Andrea Mon » Wed, 21 Jun 2006 23:02:54

hi,


if you nead the named instance listen on network protocols other then shared
memory, you have to enable them.. run the Server Network Utility
(svrnetcn.exe) and enable the desired protocol..

sorry but I do not understand your problem, here... just a note, as you
installed a "named instance", the relative name will be "ComputerName\WSUS"
and not "WSUS" only.. perhaps that can help..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.yqcomputer.com/ http://www.yqcomputer.com/
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply

 
 
 

Connection

Post by QXJhbnR6Y » Thu, 22 Jun 2006 15:57:02

Thank you very much. I had executed cliconfg and I had enabled the protocols
there. I didn't know anything about that utility.

About the registry, I'm not sure what I was watching but now, I have it
right. I mean, under HKEY_LOCAL_MACHINE - SOFTWARE - Microsoft - Microsoft
SQL Server I had just I key called client but now, I ha 3 keys, 80, Component
set and WSUS so it's ok.

Thank you very much
 
 
 

Connection

Post by Um9tYW » Fri, 07 Jul 2006 21:49:02

HI



I have the some problem.
I install WSUS and enabled TCP protocol in svrnetcn.exe and cliconfg.exe,
but in errorlog contains:
SQL server listening on Shared Memory.
SQL Server is ready for client connections

On other Server I first install MSDE and then install WSUS and network
connection works.
Why does not work on the first server?
 
 
 

Connection

Post by Andrea Mon » Sat, 08 Jul 2006 00:49:37

hi Roman,


did you restart the service?
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.yqcomputer.com/ http://www.yqcomputer.com/
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply
 
 
 

Connection

Post by Um9tYW » Wed, 12 Jul 2006 15:17:01

of course restart