During the install of the adnm, I am gettin an error when it gets to the DB creation portion. I know the name of the SQL Server is SQLSVR (real inventive huh), and I know the sa password. The install routine complains that it can not find the SQL Server. I know its running. The error says that there is no SQL Server found on SQLSVR. I have double checked the sa passwd.
Would the install log help?
Any ideas? Can the MSDE version be installed on a sever that already has a MSSQL Server running.
can you connect to the server with the same credentials e.g. from the Query Analyser? (or Enterprise Manager)
isn’t the server installed as a named instance? (you’d need to specify the instance name in the server name box then, like SERVER\INSTANCE)
Can the MSDE version be installed on a sever that already has a MSSQL Server running.
Yes, that should be possible, thanks to the fact that it uses a named instance (with the name AVAST which is quite unlikely to cause collisions with your previous install).