Can no longer connect with MS SQL Express advanced

[rakkar3]

Vault was working before.

I then did this:
http://www.fogcreek.com/FogBugz/KB/dbse ... xpres.html
up to step 3, including downloading SQL Server 2005 Express Edition with Advanced Services.

I installed that.

Now Vault no longer works over the internet. I can still connect to localhost.

Nothing else has changed.

Version is 3.5.0 (4741)

This works:
http://localhost:52531/VaultService/serverInstall.html

This does not
http://rakkarsoft.dnsalias.com:52531/Va ... stall.html

The URL is correct and is what I always use.

My guess is this is the problem:
" The user that Vault is connecting with does not have access to the SQL Server, or to the sgvault database. "

Maybe the users got changed or something when I installed the additional components for SQL Express. However, I don't know how to check, or how to fix the problem if that is indeed the case.

Ideas?

[lbauer]

My guess is this is the problem:
" The user that Vault is connecting with does not have access to the SQL Server, or to the sgvault database. "

If this were the case, you would not be able to successfully login to Vault at all, even locally.

It's more likely that SQL Server 2005 is not configured for remote connections. Here's a link with troubleshooting steps:
http://support.microsoft.com/kb/555585

Another possible cause of the problem you are experiencing:

http://support.microsoft.com/kb/896613

[jclausius]

Also note, SQL Server Express 2005 will default to a named instance installation of (local)\SQLEXPRESS.