-ssadd is invalid when setting up Sessions on SQL Server 2005
- by P.Brian.Mackey
I have a dev and QA environment with SQL 2005 EE on dev and SQL 2000 on QA.
On QA I run aspnet_regsql –ssadd –sstype t -E in command line and it works fine. I run the same command on dev and it returns "'-ssadd' is invalid". The working directory for both is C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727.
I found some info on MSDN that said that SQL Express Edit. required a script to run before -ssadd will work, but this script didn't help me. I'm not sure where to go from here.