Have u tried the SSMS Export and Import wizard?

and plz verify that the Browser Service is started on ur server..

Regards,

Farhan.

Have you set-up windows authentication?

Is it a named instance?

Did you give yourself administrator permission?

Try logging in with . as the servername. (the dot represents localhost)

These are the things i have...

I just tried to connect and the Event Log reported these four Errors:

1. TDSSNIClient initialization failed with error 0x80090008, status code 0x80. Reason: Unable to initialize SSL support. Invalid algorithm...

yes its running on my local machine..

am trying to connect using SSMS to my instance with my domain login and password..

i have tried couple of things related to named pipes,...

Instance name is correct but when i try to start the service for the instance, it never starts..