Hello all,
For development purposes I recently installed ArcSDE workgroup 10 on my machine, running on SQLServer Express. This worked, and I could connect to my database server fine through ArcCatalog, I had one geodatabase in this instance which I could use without issues.
Recently I added a database to the SQLExpress instance through SQLServer Management Studio, as I want to use the SQLExpress instance for other (non-SDE) databases as well. Since then (or it seems since then) I can't connect to my SQLExpress instance through Catalog anymore. It says "Cannot connect to the database server, Failed to connect to database server" when I try.
All I really did was create a new database and set some access rights on it. This should apply to the individual database and not the instance, so I don't understand why I can't use the instance over SDE anymore.
I can't work out if it's something I did through SQLServer Management Studio (something user/authentication-related), or if I'm completely on the wrong track here. Any suggestions as to what I might check or try out?