Windows 7 SQL Server Management Studio cannot connect to SQL Server 2005 - SOLVED



  • 1. Row and Table Level Locking
    When we do Insert or Update How SQL optimizer when optimizer lock the table and when optimizer lock the row? I know we can force these using Hints. TIA
  • 2. storing data in arabic
    Client: WinXP arabic Server: win2k server and SQL Server 2000 when i enter the data in the client it is showing perfect in arabic, once if i stored in the database server and retrieve again, it is showing garbage character. How to store the data in arabic on the sql server.
  • 3. SQL Server 2000 Client Tool License
    Hi, We have a number of developers who write applications that connect to our SQL Server databases. They wanted to install the SQL Sever client tools (Enterprise Manager, SQL Analyzer, etc...). Does anyone know if I need to purchase separate licenses to install these tools on multiple workstations? We currently have 6 SQL Server 2000 standard licenses (per processor) on six different servers and 1 Enterprise version on a cluster. Any feedback is greatly appreciated. Thank you, Eric
  • 4. set password on backup file
    How can I set the password on my database backup file.. I don't wanna use zip options... Any idea about encryption? Thanks NOOR

Windows 7 SQL Server Management Studio cannot connect to SQL Server 2005 - SOLVED

Postby Tom von Alten » Fri, 26 Mar 2010 03:21:42 GMT

Searching for help on this problem, I found a lot of stuff having to
do with server configuration, and other distractions, and having
figured out the solution (at the end of at least 4 hours of
thrashing), I wanted to share it for the benefit of others.

PROBLEM: A Windows 7 machine with SQL Server Management Studio 2005
can connect to the localhost SQL Server 2005 instance, a "regular"
remote SQL Server 2005 setup (CrystalTech's web hosting), and a SQL
Server 2000 instance on a server with a VPN connection.

I could NOT connect to the SQL Server 2005 instance on the VPN, UNLESS
I turned off the firewall for the "Public" profile..

The win7 firewall configuration had 2 pair of inbound rules for SQL
Server Management Studio, allowing any UDP and any TCP ports, for the
"Private" and "Domain" profiles. None of these was enabled.

I changed one pair to serve for all three profiles, enabled the pair
of rules, and I was able to connect.

Re: Windows 7 SQL Server Management Studio cannot connect to SQL Server 2005 - SOLVED

Postby Uri Dimant » Fri, 26 Mar 2010 16:58:46 GMT

Thank you for sharing that Tom von Alten

Similar Threads:

1.Connecting to SQL Server 7 using SQL Server 2005 Management Studio

Is there a way to connect to SQL Server 7 using the new Management Studio?


2.How to connect to remote server using Sql server 2005 management studio

In 2000 Enterprise manager I could simply use the IP address of the site 
where the server was located and NAT port 1433 at the site to the SQL 
server. That let me control the database via the internet.
I have the same setup still at the remote site (Natting 1433 to the sql 
server) but I can't find out how to register that server's IP address in the 
management studio.

Can anyone give me a clue on how to do this in the 2005 software?

Thanks for any help

3.Cannot connect with SQL Server Management Studio to SQL2K5


we are using SQL 2005 SP2 cluster with 3 instances. We are trying to connect 
with SQL Server Management Studio thrue a Firewall that have only port 
1433/TCP open. This has worked with SQL Auth and SQL 2000 perfectly. I also 
tried to add 1433/UDP, 1434/TCP and 1434/UDP, but haven't had any success.

On the machines themself the connection is working well... i'm connecting to 
the instances with server name "CLU1INS1\Instance1",  "CLU1INS2\Instance2" 
and  "CLU1INS3\Instance3" and SQL Auth, but from remote it is not working.

What could be wrong here and how are we able to solve this problem?


4.SQL Server 2005 Management Studio with SQL Server 2005 Express

If you mean you want to install an instance of SQL Server 2005 Express 
Edition then yes of course you can. However, if it's Express Edition with 
Advanced Services version, then you can't install SQL Server Management 
Studio Express.

Ekrem soy

"Jerry" < XXXX@XXXXX.COM > wrote in message 
news: XXXX@XXXXX.COM ...
>I have the full management studio installed on my desktop to access
> databases on other servers. Can I install SQL Server 2005 Express on
> my desktop also?
> --
> Jerry 

5.After installed SQL server 2005, can't work SQL server management studio

I have the SQL sever 2005 enterrpise version installed, then after
start from management studio, i am not able to connect to any local
database, even i run create sample database, but seems i can't find it
from local server. did i miss something?

also, do the enterrpise version includes Reporting services? if no, how
can i get this software

thanks for the help


6. SQL Server Management Studio don't see local SQL Server 2005 Devel

7. SQL Server Management Studio don't see local SQL Server 2005 D

8. Where to get sql server 2005 management studio with sql server agent



Who is online

Users browsing this forum: No registered users and 90 guest