Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Re-starting SQL Server using Default Options
Message
De
13/01/1999 08:39:07
 
 
À
13/01/1999 03:23:06
Man Wai Chang
Hang Hing Metal Manufacturer
Hung Hom, Hong Kong
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00175354
Message ID:
00175396
Vues:
24
>I tried using "-f" in startup parameters of SQL Setup,
>SQL Server could be started, but I could not login.

When you start SQL Server using the -f parameters, not only does it start SQL Server in minimal configuration mode, it also starts SQL Server in single user mode. Sometimes (or usually) SQLAgent (or SQLExecutive for 6.5) will jump onto the only connection. Try stoping SQLAgent and then logging in.

>BTW, is there a way to edit the configurable parameters
>directly without going through the GUI or Enterprise
>Manager?

To edit server parameters you must use the sp_configure system stored procedure. You'll have to follow the call to sp_configure with the RECONFIGURE statement to write the new settings to the configuration block in the master device.

HTH

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform