Cannot access Sql Db (Northwind) from Server Explorer in VB.NET

• Previous message: Andrew J. Kelly: "Re: SQL slowness - cant find my original thread... added info"
• Messages sorted by: [ date ] [ thread ]

Date: Fri, 31 Dec 2004 17:47:02 -0800

I'm hoping someone can help me with this problem.
I just installed Sql 2000 Developer Edition and chose the default instance
installation. I also upgraded it to SP3.

I have two problems I have encountered:
1) Unless I check the option to logon as "Local System Account..." in the
logon section (of the MSSQLSERVER properties dialog) I cannot start the
service using the "This account" option using my local machine's user name.
I presently am not using a password for my administrator settings since I'm
the only one using the machine. During the installation it automatically
filled in my machine name and left the password field empty (which makes
sense since I don't have a user password). After installation completed I
was unable to start the service and received error 1069, unable to logon to
the server. I located Q282254 which explained this error, but following its
instructions did not resolve the issue. I was forced to switch to "Use local
system..." instead and then the service successfully started. I would like
to know why I couldn't start the service using the default method?

2) With the service running, I went into Enterprise Manager and registered
my machine with the server. Once I did that all the development databases
appeared, such as Northwind and pubs. Next I started Visual Studio (2003).
I created a new windows program and opened up server explorer. It opened up
the datalink dialog. I selected localhost, use Win NT integrated security.
I selected Northwind from the dropdown box and then hit "Test Connection".
The test passed successfully! Next I clicked OK to close the datalink dialog
and then I received an error message telling me that this version of Visual
Studio can only open Sql Desktop (MSDE) or Access databases. At that point I
clicked OK and the link to Northwind failed to appear in server explorer.
Lastly, in server explorer, if I right-click on create new database
connection, the option to create a new SQL database is greyed out, indicating
that I can't create a new database in SQL.

I'm hopinig someone can tell me why I'm receiving these errors, and what do
I need to do to fix them? I'm mostly concerned with resolving issue #2
above, but would appreciate an answer to issue #1 if possible.

Thanks for your help with this!!

Stephen P.

• Previous message: Andrew J. Kelly: "Re: SQL slowness - cant find my original thread... added info"
• Messages sorted by: [ date ] [ thread ]