Solved

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

Posted on 2014-04-25
4
898 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 142

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

920 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now