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

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?
liekaAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>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
 
Neil RussellConnect With a Mentor Technical Development LeadCommented:
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
 
liekaAuthor Commented:
Thanks alot gentlemen. Both helped. It was a firewall-problem and not a "express edition"-problem.

Regards
Kai
0
 
Jacques Bourgeois (James Burger)PresidentCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.