I am trying to write event log through "CLR Stored Proceudre " but it is throwing the follwing exception.
View Complete Post
I had been using SQL server 2005 without any problem but a few days back I started having some problem with my Windows XP Professional sp2 that my pc used to go off after 5-7 mins everytime i started it. So I repaired the OS. Since then,when i
opened SQL Server and tried to connect am getting this error---
TITLE: Connect to Server
Cannot connect to POONAM-C586A95C\SQLEXPRESS.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider:
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
I checked the state of sql serverand it is stopped. What should I do to bring it to running state?
I even added sqlservr exe file to the exceptions in the firewall but i dont think that could hav been a problem b'coz it was working perfectly without any changes in the firewall setting.
Why am I getting this error and how can I remove it?