Sunday, February 28, 2010

Error in SQL Server 2005 :: Cannot connect to ComputerName in Windows Vista

Hi,
Since 3 months i was suffering with this error at the last i find solution :
1. My SQL Express was working finely but when i was supposed to created Table it was not allowing me to create that.
2. My Main account of SQL Server 2005 was also not working, it was showing the same error ''Cannot connect to ComputerName'' with error number 18456.

Today finally check lots of posts but i find one post where i find solution.
Solution is very simple run SQL Server 2005 with Administrator account.
ie., Click on Start button then goto SQL Server 2005 and goto SQL Server Management Studio and Right Click there and goto Run As Administor.
That is it.

Thank You!.

No comments:

Post a Comment