RE: Server Explorer failling to log in to (local) DB

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Kevin,

Your problem doesn't ring a bell. Server Explorer shouldn't be persisting data about what database it was last connected to. When ever I try to expand the MSDE Node on the local machine
the Server Explored doesn't navigate past the server leaf. Maybe I am missing something so if you could provide more detail about how you are navigating to MSDE via SE that would be
helpful.

<My Machine>
|_ SQL Servers
|_<My Machine>

If we are storing the DB name it is probably in the registry. Try searching the registry for the DB Name and see if it comes up. Let me know what you find.

Cameron Slade
Test Manager Visual Studio Data
--------------------
>Thread-Topic: Server Explorer failling to log in to (local) DB
>thread-index: AcWc5/uMWQWDLeljQNqzN/TB7UTJDg==
>X-WBNR-Posting-Host: 216.248.43.135
>From: "=?Utf-8?B?a2V2aW4=?=" <kevin@xxxxxxxxxxxxxxxxxxxxxxxxx>
>References: <60FD7EF4-2083-43AA-AA9B-5C056F524A2B@xxxxxxxxxxxxx> <AF0274F9-2987-4719-9DBE-FE2DF6045832@xxxxxxxxxxxxx>
>Subject: RE: Server Explorer failling to log in to (local) DB
>Date: Tue, 9 Aug 2005 06:41:02 -0700
>Lines: 27
>Message-ID: <1FA703A7-87B7-4428-8350-890F01144A3B@xxxxxxxxxxxxx>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.vsnet.enterprise.tools
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.vsnet.enterprise.tools:1279
>X-Tomcat-NG: microsoft.public.vsnet.enterprise.tools
>
>Patrick,
>
>Yeah... I... um...tried...that :)
>
>The problem is the VS seems to remember the first database that I made a
>connection and continues to try and find that database.
>
>"patrick" wrote:
>
>> Why not change the login to a database that does exist? I am not sure whether
>> MSDE has any databases installed automatically or not, but I presume it has
>> the same ones that ship with the full thing. I don't have much experience
>> installing SQL server database apps on other machines, yet, sorry.
>>
>> "kevin" wrote:
>>
>> > using VS.NET 2003
>> > server explorer gives me "Cannot connect to database MyDB" error when I
>> > expand the Server node representing my local machine.
>> >
>> > The problem is that the DB it is trying to login to has been deleted. How
>> > do I change the default DB that VS.NET is looking for. Creating a new DB in
>> > Enterprise Manager with the name MyDB is a workaround for now but not a
>> > solution.
>> >
>> > What about developers who only have MSDE?
>> >
>

Cameron Slade
Microsoft VSData Team
http://blogs.msdn.com/vsdata
--

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.

.

Relevant Pages