Hi,
I installed sql server 2000 enterprise edition on windows 2000 advanced server 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 also it is showing that the sql server is running in single user mode. Also when 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 closing the entire enterprise manager window. Except for the regiser sql server wizard, all the other wizards are working fine, i am able to setup replication etc.
I would hate to uninstall and reinstall, is their any way to correct the installtion?
Also, the domain a/c that is used by sql server will not allow me to do a remote 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