Hi,
I installed sql server 2000 enterprise edition on Windows 2000 advanced serv
er undera domain account that had the sys admin privileges. However i logged
in with my domain account and installed the sql server on a remote machine.
The installation completed
successfully. i have also set the 'sa' p/w. Now when i go into the log lifes
for sqlserveragent, i see an error like 'data area is less than...' and al
so it is showing that the sql server is running in single user mode. Also wh
en i opened the enterprise
manager i am able to see the <local> server but when i try to register a new
server, the wizard after the initial screen is getting disabled and is clos
ing the entire enterprise manager window. Except for the regiser sql server
wizard, all the other wizar
ds are working fine, i am able to setup replication etc.
I would hate to uninstall and reinstall, is their any way to correct the ins
talltion?
Also, the domain a/c that is used by sql server will not allow me to do a re
mote destop connection(some corporate agreement), hence i have to login with
my own domain a/c. Also i have done the default 1433 port installation.1. Please check the sqlstp.log to make sure that sql server was properly
installed. You'll find this file in your WinNT folder.
2. About uninstalling SQL Server, the best would be trhough Control panel,
Add-Remove Programs. Should that fail, please refer to
290991 HOW TO: Manually remove SQL Server 2000 default, named, or virtual
http://support.microsoft.com/?id=290991
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment