Sunday, February 19, 2012

cannot setup SQL server 2000 service account during installation

Hi, i tried to install MS SQL server 2000 in my XP system but during the setup service account installation, i tried to use a domain user account but it cannot validate my user name and password. I used my windows administrator logon account and password. Please help..thank you.

Thanks : :confused:If you successfully installed SQL Server 2000, now you may change the user of the service accounts in the services (My Computer->Services and Applications->Services).

Paulo|||Thank you for your reply but this happened during the installation and i do not wish to install SQL server using the local system account for the service account as i need it to work over the network, SQL mail, backup and etc.

Thanks|||Thank you for your reply but this happened during the installation and i do not wish to install SQL server using the local system account for the service account as i need it to work over the network, SQL mail, backup and etc.

Thanks

The use of the Local System Account for the service account makes sure that no matter what, the SQL Server will be running. Even if the Domain/AD/Network is down the SQL server will be running.

Using the Local System Account for the system account does/should not affect whether or not the server is visable over the network. Enable TCP/IP, named pipes, etc. as a server communication protocol and it will be visable and then determine how you want people to authenticate to the server(Windows or SQL Server authentication)

Have Fun...

No comments:

Post a Comment