SQL server 2005 - No windows connections
I instaled an sql server 2005 on windows 2003 R2 entreprise (8 Go Ram).
unfortunetely, this new sql server don't accept any windows connection (only accept local connection or windows connection from development computer i.E. with VS 2005 installed). However SQL native connection work well.
When I launch SSMS, I can see that the last line of object explorer is
"SQL server AGENT (Xps Agent desactivated)" and I see that the SQL Server agent is down.
Wen I want to start this SAD agent, i obtained the following message : "Agent started but stoped just after" and no anymore.
Have Somebody an Idea to allow windows connections on this server ?
Of course the authentification méthode is "Mixt Sql server and windows"
PS. AWE is activated
By rperez in forum Database
Last Post: 01-02-2009, 05:14 PM
By bgibson in forum Database
Last Post: 01-14-2008, 01:45 PM
By Aditya Sanghi in forum VB Classic
Last Post: 04-29-2002, 08:43 AM
By Beginner-Brad in forum Database
Last Post: 12-31-2000, 02:03 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL