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 ....
Thanks and Regards
Farukh
Pravin GhadgePosted Feb 8, 2012, 3:27 AM
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.
Farukh MujawarPosted Feb 7, 2012, 11:43 PM
Pravin GhadgePosted Feb 7, 2012, 10:11 AM
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.
Farukh MujawarPosted Feb 6, 2012, 11:32 PM
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
Pravin GhadgePosted Feb 6, 2012, 5:43 AM
ur method is not wrong. But had u attached that .mdf &.ldf in another PC.
Farukh MujawarPosted Feb 6, 2012, 5:36 AM
Pravin GhadgePosted Feb 4, 2012, 9:25 AM
this is not possible. do u had attached that .mdf & .ldf in another pc.
or u have done any other process.
Plz elaborate.
Farukh MujawarPosted Feb 4, 2012, 1:55 AM
So what should i do now?
Pravin GhadgePosted Feb 2, 2012, 6:50 AM
Just copy the .mdf & .ldf of ur database from Program files.
It is same as ur backup of database.