mssql server 2000

Posted on 2009-02-09
Medium Priority
Last Modified: 2012-05-06
when i start mssqlserver service, i get the following error
"sql server could not fild the default instance - please specify the name of an existing instance on the invocation of sqlservr.exe".
Question by:skyjumperdude
LVL 35

Expert Comment

ID: 23595030
go to  Administrative Tools -> Services
you installed a named instance you should see something like MSSQL$InstanceName

LVL 26

Accepted Solution

tigin44 earned 1000 total points
ID: 23595389
open the properties page of your sqlserver service. there will be an entry named like "path to the executeable" which should look like the one below.

c:\Program Files\Microsoft SQL Server\MSSQL$MRKSQL\Binn\sqlservr.exe -sMRKSQL

Find out the instance name of your sql server and if the string do not contain then add it to the run parameters section i.e.
  -sSQLSERVER here I assume that your instance name is SQLSERVER

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question