2
votes
1answer
77 views

MSSQL 2008 Service Account

Background: We are a smallish company that prefers to keep things simple and not have to manage our Active Directory very much. My company uses a single administrator account to setup and do all the ...
0
votes
1answer
144 views

SQL Server reporting services shutting down without log info

Using SQL Server 2008 Reporting services. Finding that the service is shutdown without anything in the windows event log or in SQL Server events. I see the log entry for the service starting when I ...
1
vote
3answers
552 views

Login failed when SQL Server starts

I've got a windows service that needs to connect to SQL Server databases (SQL Server 2008 R2, Windows Server 2008 R2). This service depends on SQL Server. The problem is when the SQL Server service ...
2
votes
1answer
66 views

What are minimum number of services I need to start to have w working sql server?

I'm looking to start the very minimum number of services to have a fully working version of SQL Server running that will enable external connections. I know MSSQLSERVER is required but do I need to ...
0
votes
1answer
3k views

MSSQLSERVER Will Not Start - Event ID 913 and 1814

I need some serious help. I have a major database server down and am scratching my head at how to fix it. The server was hit by rolling black outs last week in Dallas and sense then, Microsoft SQL ...
5
votes
3answers
4k views

Recommended service account setup for MS SQL Server 2005/2008

We have a number of MS SQL servers in our environment running either SQL Server 2005 standard/enterprise or SQL server 2008 enterprise. Currently the SQL services are running as local service or ...
0
votes
2answers
2k views

Running a Windows service under a domain account from a non-member server

I've got a standalone Windows Server 2003 running SQL Server 2005 and a Windows Server 2003 Active Directory domain controller. Using maintenance plans/SQL Server Agent, I'm trying to write the ...
3
votes
6answers
10k views

Auto-start the SQL Server Agent after a computer restart

I am using the SQL Server Agent to run some jobs every day, but the problem is that whenever the server (the machine itself) is restarted, the SQL Server Agent doesn't automatically start when the ...
0
votes
1answer
532 views

SQL Server 2005 on 2008 DC - Cannot change service user

I cannot start SQL Server 2005 transactional replication after I promoted my 2008 Server to a DC. A required privilege is not held by the client. This site suggests that I need to change the ...
0
votes
4answers
370 views

Why some XP installs don’t automatically Start SQL2005 Service (Instance)

I have a number of XP machines that have a SQL 2005 Instance running on them, and they are set to start automaticly in Service Control Manager. On 1 or 2 of these machines when you reboot, the SQL ...