Sql server service has stopped and when i try to restart it give me error.

Dear All,
           I am using Microsoft sql server 2005 its working properly but  now i am facing one problem to connect with server. When i click on connect button it gives me this error msg "Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "

         I searched on google i find some suggestion but its not working , then i check in
configuration tool -> sql server configuration manager ->  sql server (sqlexpress)
here services of sql has stopped  when i try to start services of sql server it gives me another error ....  "Request failed and service did not start in timely fashion. Consult the event log or applicable error logs for details."

Please help me ..... Because i didnt take any backup of my database.

Thanks and Regards
  Farukh

Hi Farukh,

Just copy the .mdf & .ldf of ur database from Program files.
It is same as ur backup of database.

Thanks for your reply ....i copied database from C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder and paste to another machine it creates all the tables of my database but the data which was entered in that database not there.
So what should i do  now?

Hi Farukh,

this is not possible. do u had attached that .mdf & .ldf in  another pc.
or u have done any other process.
Plz elaborate.

I copy and paste both files from data folder to another pc data folder and open my database.If this method is wrong then please let me know from where i get the both files and how to open this two files in another pc.

Hi Farukh,
ur method is not wrong. But had u attached that .mdf &.ldf in another PC.

Hi Pravin ,
             How can i attached .mdf & .ldf file . I just copy and paste both files from one computer to another. Please let me know the procedure to attached .mdf & .ldf files to another computer. 
               Please find attached zip file of my both mdf and ldf file.
Thanks and Regards
 Farukh

1)Open Sql Server Management Studio
2)Login the server(use Windows or sql authentication)
3) Right  click on Database there is Attach open option
4)Give the path of ur .mdf file.

My problem is i am not able to login my sqlserver management that is the mail problem otherwise there is no need to take backup of this files. Please read my question carefully . I think u didnt get my problem.

I had understood ur problem.


In ur 2nd reply u had mentioned that u had copied that .mdf & .ldf in another pc.

so Plz do this steps in another pc which has sql server installed.