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.
| 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.aspxhttp://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspxI 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. |
 |
|
|
Kech
Starting Member
2 Posts |
Posted - 2014-09-16 : 10:52:59
|
| Will do and thanks so much for your help!! |
|
|
|
|
|
|
Windows 7 Connection Issue to SQL Express