June 29, 2009 at 8:21 am
Hi masters,
i have SQL Server 2005 developer edition and SQl Server 2000 developer edition on the same box.
I installed the 2 softwares today
I'm having problems of windows authentication to the SQL Server 2000.
I try to connect to SQL Server trought management studio, but i receive this message:
......... Error 40 could not open a connection to SQl Server (microsoft sql server ,error:2)
Can someone help please?
thank you,
Pedro
June 29, 2009 at 8:30 am
Make sure SQL SERVER is up and the instance you try to connect is running.
Your system Firewall should not block SQL Server port.
Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration
Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433..
Use this link too http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
June 29, 2009 at 8:31 am
June 29, 2009 at 9:32 am
SQL Server 2000 is now resolved....
I installed SP4 on the box and it fixed.
(i had no SP)
But i still have a big problem.
I want to put the SQL Server 2005 services with a domain account, but when i try i receive an error.
My SQL server 2000 services are using that domain account with no problem....
can you help please?
thank you
June 29, 2009 at 10:00 am
Error message , error message from SQL server errorlog , please check whether all folder permissions granted for domain account and its added to MSSQLagentuser group and log on as a service , If memory greater than 8GB lock pages in memory also in security policy settings
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply