CTP4 Problem

Hot Topic

Project Creation Wizard - error uploading documents to SharePoint
MDI-Parent, creation
Opening Form 2 with push of button on Form 1
Problem connecting to access db
protected override vs. event question
A bit of Help Please
Custom History Control
No permission to add work items
Schema Compare Problem #5
auto yes security alert

VS Team System

God I Feel ashamed....
Have I choose the right programming language for my project?
Encrypting the exe
Problem with RSS reader project
whick web hosting is support the asp.net 2.0 and SQL server 2005?
C# and .mdb
Delete team project and remove from SCE?
Compiler Warnings - Can I indicate I want the build to fail?
displaying the value of a particular database field
MDI-Parent, creation

CTP4 Problem

I just installed CTP 4 and attempted to create a new Database Project as follows:

  • I select File | New | Project
  • I expand 'Database Projects' and select Microsoft SQL Server
  • I select the SQL Server 2000 template
  • I enter the name and location etc.
  • I click the OK button and after a few minutes I get an error stating, "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error locating Server/Instance Specified).

I have both SQL 2000 and 2005 installed on my laptop. I don't know what server/instance its attempting to connect to because it doesn't tell me, nor does there appear to be a way for me to indicate what server/instance I want. Could someone tell me what I need to do to create a new Database Pro project



Answer this question

CTP4 Problem

  • Higgs Boson

    In my situation my SQL Express edition is a named instance and the trick was to not only go through Tools --> Options --> Database Connection but to also restart VS.

    Thanks for the very useful info.

    Shaun

  • DawnJ

    In our current source (not too removed from CTP4), I tried clearing the text in the textbox to indicate that my default instance should be used. I then added a database project and it used the default instance.

    Given that this worked for me - here are some ideas to try:

    * Right now, we only read the setting from the registry once, so, if you had a database project open and then changed the setting, that change will not be read until a new instance of devenv is started.

    * All the text does have to be cleared from the text box.

    * The default instance does have to be a Sql2005 version

    This is an area I would expect to be improved in future CTPs.



  • ksona

    You are almost there - try setting the instance name to just SqlServer2005.



  • 2lazydba

    Thank you J.D! This worked. I spent close to an hour last night trying all sorts of combinations and nothing worked.

  • Mohamed Sami

    BTW, I read in another thread that the problem might be solved by selecting Tools | Options menu option. Then select Database Tools and Data Connections. There you can enter a SQL Server Instance Name. I've done this by entering 'RMINDER-D820\SQLServer2005'. This is the instance name for my local SQL 2005 instance. However, this hasn't worked either. I still get the same error message.

  • VS2005_evaluator

    boy, i'm having a very similar problem... i can get the project to load on one machine, but all the other machines, when I try to load the project, it says it can't connect to the database. I've tried all possible combinations in the sql server instance (it's the default), to 'localhost', 'machinename', blank, and so on... not sure why it keeps failing.
  • CTP4 Problem
Answer this question