Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Windows 7 Connection Issue to SQL Express

Author  Topic 

Kech
Starting Member

2 Posts

Posted - 2014-09-16 : 09:50:27
Hi all, first time poster and new to the forum. My configuration is a server running Windows 2008 Server r2 with SQL Express installed. The problem I'm having is I'm unable to connect to a SQL Express database from a Windows 7 workstation (any version), but all Windows XP workstations have no problems. We're using "Named Pipe" as a connection method. Why XP, but not 7? Thank you in advance...

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-09-16 : 10:50:05
Here are couple of articles which guide you step by step on how to diagnose the problem. The articles discuss both server side and client side. In your case since you are able to connect from other machines, I would concentrate on the client side steps.

http://blogs.msdn.com/b/sql_protocols/archive/2006/09/30/sql-server-2005-remote-connectivity-issue-troubleshooting.aspx
http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx

I usually go to the first article when I have this type of problems. The second one seemed good, but I have not read through it carefully.

Also, before you do all of those things, try logging on to the Windows 7 workstation using an account that has local admin privileges, and then launch SQL Server Management Studio AS ADMINISTRATOR and try to connect (or cmd window as administrator and query using SQLCMD etc.). This is to rule out the possibility that UAC is messing with your mind.
Go to Top of Page

Kech
Starting Member

2 Posts

Posted - 2014-09-16 : 10:52:59
Will do and thanks so much for your help!!
Go to Top of Page
   

- Advertisement -