Results 1 to 2 of 2

Thread: Cant connect to SQL Server

  1. #1

    Thread Starter
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    The mystic land of Geordies

    Cant connect to SQL Server

    Not sure if this is the right forum but I am having a problem.

    In VS 2013 I can see my sql server in SQL Server object explorer. It appears as :

    MY-PC (SQL Server 10.0.4000 - sa)
    MY-PC (SQL Server 10.0.4000 - MY-PC\Me)

    There are other SQL Servers listed as well.

    The problem I am having is that when I try to create an entity data model I have to enter a new connection. I choose Microsoft SQL Server as my datasource then from the Server name drop down I can only see "MY-PC\SQL Express".

    It's been a while since I have touched VS or done coding so forgive me for being rusty.
    Any ideas what is happening?


  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002

    Re: Cant connect to SQL Server

    Which edition of VS are you using?

    If I remember right, Express will only show local instances by default. Not sure about Community version.
    Also you should be able to override it and enter the server/instance names directly. I'm not sure it does a network scan to list available servers or not (I'm hoping not, because on our network that would be in the thousands! Well a couple hundred for sure at least.)

    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts


Click Here to Expand Forum to Full Width