Changing startup-account from admin- to system account

Hi, after changing the service-startup-account from an admin-account to the system-account the service starts fine but users cannot longer connect. They use a SQL-server login to connect. Authentication is set to 'sql-server and windows' The change was done from enterprise manager on the server running the service, the server was rebooted. The operating system is Small Business Server 2000.
Any help appreciated.
Toni SantaWhat error do the users get? What is your AuditLevel setting? You might
want to set it to "3",. so all attempts regardless of success or failure are
logged. Can you connect via say Query Analyzer when you are logged on
locally? Can you see the SQL Server box on the network?
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Toni Santa" <Toni Santa@.discussions.microsoft.com> wrote in message
news:B07674C0-EC3A-40B5-81B5-5F313147DF49@.microsoft.com...
> Hi, after changing the service-startup-account from an admin-account to
the system-account the service starts fine but users cannot longer connect.
They use a SQL-server login to connect. Authentication is set to 'sql-server
and windows' The change was done from enterprise manager on the server
running the service, the server was rebooted. The operating system is Small
Business Server 2000.
> Any help appreciated.
> Toni Santa|||Hi Gregory, for now I don't know this. The service-start-account has been changed by the customer. For know it has been reset to an admin-account and so he is able to work. I will check this when I pass in his office, could be next week.
My application connects via the servername? I found a thread in the SQL Server Security group where someone states that after changing some security issue of SQL Server he could connect only via IP-address. I will try this, too and take you informed. Thanks - Toni Santa
"Gregory A. Larsen" wrote:
> What error do the users get? What is your AuditLevel setting? You might
> want to set it to "3",. so all attempts regardless of success or failure are
> logged. Can you connect via say Query Analyzer when you are logged on
> locally? Can you see the SQL Server box on the network?
> --
> ----
> ----
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Toni Santa" <Toni Santa@.discussions.microsoft.com> wrote in message
> news:B07674C0-EC3A-40B5-81B5-5F313147DF49@.microsoft.com...
> > Hi, after changing the service-startup-account from an admin-account to
> the system-account the service starts fine but users cannot longer connect.
> They use a SQL-server login to connect. Authentication is set to 'sql-server
> and windows' The change was done from enterprise manager on the server
> running the service, the server was rebooted. The operating system is Small
> Business Server 2000.
> > Any help appreciated.
> > Toni Santa
>
>