Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Microsoft SQL Server 2008 Management Studio Express - connect to database on server

Posted on 2014-04-25
4
907 Views
Last Modified: 2014-04-25
Hi,

I am using Microsoft SQL Server 2008 Management Studio Express to develop a database application with the development database on sqlserver express database on my dektop computer. The database has now been copied and attached to the test server which runs SQL server 2008 R2. However i am not able to connect to the SQL server using Microsoft SQL Server 2008 Management Studio Express. I am able to access and manage the database on the server via Remote desktop so my user rights seems to be ok. My question is: Is the functionality of the "Microsoft SQL Server 2008 Management Studio Express" restricted in a manner such that it can only be used to connect to the "localhost" SQL server express on my desktop?
0
Comment
Question by:lieka
4 Comments
 
LVL 37

Assisted Solution

by:Neil Russell
Neil Russell earned 250 total points
ID: 40022050
First i would check that BOTH machines have a firewall that will allow the connections in and out.
Secondly, has the SQL server got the allow remote connection configured?  See Here.
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 40022099
>My question is: Is the functionality of the "Microsoft SQL Server 2008 Management Studio Express" restricted in a manner such that it can only be used to connect to the "localhost" SQL server express on my desktop?

the answer to that is: NO, it's not restricted.

so, what is the exact problem, including error message(s) that you run into?
see this article to start troubleshooting:
http://www.experts-exchange.com/Database/MS-SQL-Server/A_1881-Connect-to-your-SQL-Server.html
0
 

Author Closing Comment

by:lieka
ID: 40022222
Thanks alot gentlemen. Both helped. It was a firewall-problem and not a "express edition"-problem.

Regards
Kai
0
 
LVL 40
ID: 40022227
The credentials used to connect through Remote Desktop can be different than those used to log on your computer, so the user rights you get might also be different.

Since you can access Management studio on the server, where you probably have the full edition of Management Studio, why do you want to use the Express edition?
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question