Results 1 to 2 of 2

Thread: Cant connect to SQL Server

  1. Jan 14th, 2015, 07:54 AM #1
    venerable bede
    venerable bede is offline

    Thread Starter
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018

    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?

    Parksie
    Reply With Quote Reply With Quote
  2. Jan 14th, 2015, 08:12 AM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    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.)

    -tg
    * 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??? *
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width