I recently installed SQL 2005 on my SBA server 2003. I have attached a number of DB’s to it, and have since been running it without problems for 5 months now. I recently was tasked to install new software which is requiring sa user admin password. I never set one, thus in theory it should be blank by default. I tried CMD prompt to test and used osql -U sa
password:
received the following error:
“[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).”
Looking into it, I think I may have an instance issue? I am puzzled at this point since my other programs can see SQL running and can connect to it. Ideas?
