• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

How to connect to SQL Server 2005 express?

How would I connect to the local SQL server DB if there is no SQL server management studio installed? The size of the install is just 216 MB . . . I need to connect to an the DB of the running application but am finding it impossible. Any suggestions are greatly appreciated. Thank you.
0
fstinc
Asked:
fstinc
  • 3
  • 2
3 Solutions
 
cantorisCommented:
Can you not download the Enterprise Manager separately (to the same PC) and then connect?  I think it uses Named Pipes locally.

http://www.microsoft.com/download/en/details.aspx?id=7011
0
 
QPRCommented:
0
 
fstincAuthor Commented:
Where would I find out what it uses . . . Named pipes etc. . . . ?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
fstincAuthor Commented:
and the name . . . .
0
 
QPRCommented:
Just do a default install to the pc and then connect using "." (without quotes) to connect to the db on the same machine. No need to touch protocols
0
 
fstincAuthor Commented:
Thanks guys!!!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now