473,800 Members | 2,647 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS SQL Server Service Manager does not find instance

I am running Win XP SP2 and MSDE 2000 SP3a. The user is logging on as
a POWERUSER. When the user logs on the MSSQLSERVER service starts but
the SQL Server Service Manager, that runs in the system tray, shows
that the instance has not started. The field that displays the
instance name is blank and it is not listed in the drop down list.
The MSSQLSERVER service is set to start with a Windows domain
administrator account. The SQL server can be accessed by a remote
computer through Enterprise Manager. The local programs cannont
interact with the server though.

Does anyone know if I could grant some user access rights to allow MSDE
to work under a POWERUSER login?

Jul 23 '05 #1
2 13971

<mi************ **@gmail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
I am running Win XP SP2 and MSDE 2000 SP3a. The user is logging on as
a POWERUSER. When the user logs on the MSSQLSERVER service starts but
the SQL Server Service Manager, that runs in the system tray, shows
that the instance has not started. The field that displays the
instance name is blank and it is not listed in the drop down list.
The MSSQLSERVER service is set to start with a Windows domain
administrator account. The SQL server can be accessed by a remote
computer through Enterprise Manager. The local programs cannont
interact with the server though.

Does anyone know if I could grant some user access rights to allow MSDE
to work under a POWERUSER login?


If I understand correctly, you can connect to MSDE from another machine on
the network, but you can't connect to it locally on the MSDE box itself? How
are you trying to make the connection, and what error do you get? Are you
using SQL authentication or Windows authentication for the connection? You
might also check this KB article:

http://support.microsoft.com/default...06&Product=sql

Simon
Jul 23 '05 #2
jacquesm
1 New Member
Try this

1. Go to "Start | Run" from windows
2. Type "SVRNETCN.e xe" (without quotes)
3. Enable "Named Pipes" and "TCP/IP".

Regards,
Jacques
Sep 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
8191
by: KO | last post by:
SQL Server Enterprise Manager could not start the service 'MSDTC' on server 'NTAS21'. 1722 - (The RPC server is unavailable) I Setup A publication on a server called NTAS4D, then Pushed The Subscription to another server called NTAS21. If I configure so that the changes at the subscriber are not replicated to the publisher, all works ok, I make a change at the publisher, it is replicated to the subscriber.
2
7812
by: Maurizio Amoroso | last post by:
.... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: Cannot open file e:\private.dbc. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: ...
2
2357
by: PF | last post by:
On one of our machines, all of the SQL Server 2000 components except for the main Server component (SQL Server core) itself were installed (Management tools, etc) a while ago and everything was running fine. Now I go and add/install the Server component and then Service Pack 3a. It seems that Service Manager won't start up (I get an hourglass cursor) and now I find that Enterprise Manager won't run as well. No error messages appeared...
2
3248
by: R Bolling | last post by:
ver: SQL-DMO Version: 8.00.760 I have the option to automatically start SQL Server on startup, but when it does start up, the SQL Server Service Manager does not have the green arrow indicating that it is active. When I double-click it to display the SQL Server Service Manager, it shows the name of the server, but no services in the drop-down box. When I start Enterprise Manager I see an instance of MSDE where someone installed an...
0
535
by: bill.duncan | last post by:
Hi, I have created a windows service in VB.net using VS .Net (v. 1.1, ..Net Framework 1.1). The problem I have is that after I create a setup project for my service, and then install the service, the service does not show up in my service manager. For this to happen I have to use installutil.exe. I have a project installer in my service project, and I have created services in C# without encountering this problem. Is there some subtle ...
0
879
by: SAVAGE | last post by:
Hi, I have writen IMAP4 server in VB.NET who act like Windows Serevice. I wrote .exe IMAP4 server service manager ( for my service ) that can start, pause and stop this IMAP4 server service. IMAP4 server-service stores current users loged on and they last commands in memory. How can i get all that users and they last commands from IMAP4 server service to IMAP4 server service manager?
2
2045
by: msg | last post by:
I opened up Terminal Service Manager on my SQL Server to close out some ghost connections. Then I minimized the application. After working on some other issues. I right clicked on the minimized icon of Terminal Service Manager on my tool bar and closed it. Now when I go to Start/Admin Tools/Terminal Service Manager, it opens up minimized and I can't get it to maximize to close out ghost connections. The only way I can close it is to...
0
1220
by: Roland Riess | last post by:
Hi all, maybe somebody can help me with a service installation problem in VS 2003, C#. First, I added an installer project to a solution with a program that shall run as a service. So far, so good, the program installs ok with the resulting msi file, is obviously registered as service and visible in the service manager.
2
2851
by: Robert | last post by:
I'm a newbie trying to find the SQL Server Enterprise Manager so I can create a database. I have installed SQL Server 2005 Express and SQL Server Management Studio Express. On the SQL Server menu I see (1) Configuration Tools and (2) SQL Server Management Studio Express. The SQL Server Management Studio Express menu has 3 items on it. Where do I find the Enterprise Manager? Robert
0
9553
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10509
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10281
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10039
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7584
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6824
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5477
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5612
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4152
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.