Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Sql

Author  Topic 

Afari
Starting Member

1 Post

Posted - 2012-04-01 : 06:04:11
Please i Want to know how to connect my pc with Sql server 2005 management studio......

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-04-01 : 07:58:38
When you launch Management Studio, the dialog to connect to a database engine should come up. Type (local) (including the brackets) for Server Name, choose Windows Authentication and click connect.

If that does not work, change "(local)" to "(local)\SQLExpress" and try.

If that does not work, and if you set up SQL authentication while installing, change the Authetication method to SQL Server Authentication , enter the username and password and try.

If none of that works, make sure SQL Server is running - you can do that from the services window in the control panel.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-01 : 10:54:27
first question is are you trying to connect to local sql server instance or to a remote instance?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -