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.
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:
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.