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 do
ne 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 ch
anged 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 n
ext week.
My application connects via the servername? I found a thread in the SQL Serv
er Security group where someone states that after changing some security iss
ue of SQL Server he could connect only via IP-address. I will try this, too
and take you informed. Than
ks - 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 a
re
> 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...
> 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-serv
er
> and windows' The change was done from enterprise manager on the server
> running the service, the server was rebooted. The operating system is Smal
l
> Business Server 2000.
>
>
Tuesday, March 20, 2012
Changing startup-account from admin- to system account
Labels:
admin-,
admin-account,
changing,
connect,
database,
microsoft,
mysql,
oracle,
server,
service,
service-startup-account,
sql,
starts,
startup-account,
system,
system-account,
users
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment