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

Farukh Mujawar

14y4.7k

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

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pravin Ghadge14y ago
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.
0
Farukh Mujawar14y ago
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.
0
Pravin Ghadge14y ago
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.
0
Farukh Mujawar14y ago
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
0
Pravin Ghadge14y ago
Hi Farukh,
ur method is not wrong. But had u attached that .mdf &.ldf in another PC.
0
Farukh Mujawar14y ago
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.
0
Pravin Ghadge14y ago
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.
0
Farukh Mujawar14y ago
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?
0
Pravin Ghadge14y ago
Hi Farukh,

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