sql 2005 express | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql 2005 express

hi ,
my SQL 2005 Express is generating a lot of these messages:
The description for Event ID ( 2803 ) in Source ( MSSQL$SQLEXPRESS05 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 2, Bound Trees. AKTHAR
What is the account used to start SQL Server services?
Does that account has relevant admin privileges on that server? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
local system acc AKTHAR
Use a local account in this case with ADMIN privileges that registry entries will be suppressed, if your server is accessing any network files then ensure to use a domain account with similar privileges. http://sqlserver-qa.net/blogs/tools…r-domain-account-for-sql-server-services.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
i have already allocated a local account with all rights, i still have the messages AKTHAR
Do you have any network activity using this SQL instance>? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
the server is a backend for an intranet site. There is no network activity using this instance AKTHAR
Check what times these messages are logged, also confirm the service pack level on SQL. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>