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.. SOLUTION: 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.
Windows 7 SQL Server Management Studio cannot connect to SQL Server 2005 - SOLVED
2 posts
• Page 1 of 1
- IIS
- lisp
- IBM PC
- Win32 Programming
- Windows
- dotnet framework
- Exchange 2000
- Exchange 2000
- Visual Basic
- policy
Jump to:
- 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
Next
Windows 7 SQL Server Management Studio cannot connect to SQL Server 2005 - SOLVED
by Tom von Alten » Fri, 26 Mar 2010 03:21:42 GMT
Re: Windows 7 SQL Server Management Studio cannot connect to SQL Server 2005 - SOLVED
by 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? /Axel
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 Bob
3.Cannot connect with SQL Server Management Studio to SQL2K5
Hi 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? Regards Marc
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 Wang
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
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 90 guest