Earlier this week I was able to create User DSN's and Access ADP's using
MSDE 2000. Yesterday I started getting the error message "SQL Server does
not exist or access denied". I don't know why this is happening. I
uninstalled MSDE and installed the latest SQLExpress 2005 with .net framwork
2.0. I keep getting the identical message. I deleted my DSN's as well.
Interestingly, when I try to set up a user dsn it lists my machine 3 times
and "local" twice. Could this be part of the problem?
I did find the link:
But I'm not sure from this page what the problem is. Why would SQL Server
just stop working? I can connect using the SQL Server manager, which says
that SQLEXPRESS is running.
I am very new to SQL server, having more experience in Access. I think I have a named instance of the database. I am using Windows NT authentication and a trusted connection. I am completely stuck and don't know how to proceed.
Any help would be appreciated.