Re: MSDE connection problems (I'm still a student!)

Use the Server Manager (the SQL Server icon in the lower right corner).

Double click on it, select the SQL Server Service, and click on the green
Start arrow. After it starts up, you 'should' be ok.

--
Arnie Rowland
"To be successful, your heart must accompany your knowledge."



"Parasyke" <kress1963nov22@xxxxxxxxx> wrote in message
news:1153168987.970860.200160@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am using a 2003 book by Dan Maharry called "Beginning VB .NET 1.1
Databases: from Novice to Pofessional" ISBN 1-59059-358-8. I'm simply
trying to view my MS-Access database tables and stored procedures from
my Visual Studio .NET 2003 Standard Edition (VB).

I downloaded the file: MSDE2000A.exe from Microsoft
I ran it to be stored in C:\MSDE2000A.exe
I opened a black Command Window, did a cd to get the C:\MSDERelA>
prompt then typed
setup instancename- "netdsk" sapwd="password"
So far so good, no errors here in my Command Window.
I run net start mssql$netsdk and the message "MSSQL$NETSDK service is
starting" appears.
So far so good, no errors here in my Command Window.
I reboot and my SQL Server icon appears in my tray icon in the lower
right corner of my screen shows: Not Connected - \\ (is this a
problem?) A note in the book says to make sure MSSQL$NETSDK service is
started.
I then proceed to install the sample database with my download of
SQL2000SampleDb.msi
In my black Command Window I type osql -E -S (local)\netsdk -i
instnwnd.sql
instead of the expected:
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
etc.....


I get just a lot of definitions of various -i's & -p's etc.
I try to go into visual studio to connect and the connection window
gives an error.
I tried also to go to the folder C:\SQL Server 2000 Sample Databases to

run the file: instnwnd.sql
but all I got was a launching of visual studio and what looked to be
some downloads of the database (I don't know), but I still can't
connect to the database in my server explorer through the datalink
properties window.


Any clues, the crazy thing is about a year ago this worked for me and I

followed the directions just as above. By the way, I'm using WinXP Pro.



Thanks!



.

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
Loading