Question

davidj7573 on Wed, 02 Mar 2016 17:48:08


I have installed SSMS R2 on my computer but i dont know how to connect to a server name so i can attach a database ?

Please help i am at my wits end!


Sponsored



Replies

Navind on Wed, 02 Mar 2016 17:51:37


Refer Below link

http://msftdbprodsamples.codeplex.com/

http://msftdbprodsamples.codeplex.com/releases/view/93587


Navin.D http://dnavin.wordpress.com


Shanky_621 on Wed, 02 Mar 2016 18:42:21


I have installed SSMS R2 on my computer but i dont know how to connect to a server name so i can attach a database ?

Please help i am at my wits end!

So you have installed SSMS 2008 R2 but have you installed SQL Server 2008 r2 database engine feature. If database engine feature is not installed you cannot connect to anything. SSMS provides you medium to connect.

To connect to server open SSMS and in server name type SQL Server instance name or (.) dot if you are connecting to default instance. If you want to connect to express  instance it would be hostname\sqlexpress where hostname is windows server name