Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    9

    Unanswered: MSDE Install problem

    I installed MSDE SP3A with sapwd=abc123 instancename=msde_1. I went to services and started mssql$msde_1 and sqlagent$msde_1. In the system tray, I clicked the sql service manager. I put msde_1 in the server name and hit refresh services, but I get an error stating "The Network Path was not found".

    Can someone give me a clue as to what I am doing wrong?

    I'm new to MSDE and would like to use it with MSACCESS Projects.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    This folder should exist and contain the log file if the MSDE Service actually could start at all: C:\Program Files\Microsoft SQL Server\LOG

    Now, if you don't have a service called MSSQL$msde_1, then the installation failed. Please review the installation log file.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Nov 2003
    Location
    Romania
    Posts
    70
    Unistall, the try this option
    create a file named "Settings.ini"

    [Options]
    SAPWD=YourPassword
    DISABLENETWORKPROTOCOLS=0
    SECURITYMODE=SQL
    DATADIR="C:\MSDE"
    TARGETDIR="C:\MSDE"

    then run this from command promt or create a .bat file

    setup.exe /settings Settings.ini /L*v C:/MSDELog.log

  4. #4
    Join Date
    Apr 2004
    Posts
    9
    I reinstalled with listed settings and Instancename= MSDE01. I do have a service called MSSQL$MSDE01 which I started. I have also started the service SQLAgent$MSDE01.

    The problem I am now getting is on trying to open a new project in MSACCESS. It pops up with a SQL Server logon screen. I have the Trusted Connection checked, and nothing appears in the Server Name dropdown list box. I have typed both MSSQL$MSDE01 and MSDE01 as the server name, but in both cases I get the following error:

    Connection failed:
    SQLState:'01000'
    SQL Server Error: 53
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
    Connection Failed:
    SQLState: '08001'
    SQL Server Error: 17
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

  5. #5
    Join Date
    Nov 2003
    Location
    Romania
    Posts
    70
    I don't speak very good english
    See the attached image.
    Attached Thumbnails Attached Thumbnails mdse.jpg  

Posting Permissions

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