Can't add a SQL Database (2005 Express Edition) to a C# Project over RDP

Good Afternoon.

I installed C# with SQL Server 2005 Express Edition. Everything works fine on the account I installed it on, on the local machine. However.

1) I can't connect using RDP to that same account and use SQL. It times out.
2) Other users on that computer cannot make user of SQL. Also times out.

I couldn't find documentation on these issues.

Thanks,

Philski

When you first set up the SQL Express edition the system installs with the networking systems turned off. You will need to activate the remote connections on the sql server express system by using the SQL Server Configuration Manager tools. (These should have also been installed when you installed the sql express system)

|||Didn't work.

Not sure why i should need to open TCP or memory pipes anyways, since RDP is just a reflection of the desktop, and local users do not need a network connection.

I get the same error message when I try to add a database to my C# project, "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed"

Thanks,

Philski|||

Phil, here is a thread from the DB Engine forum that seems to address this issue. Were you logged into the box through TS or on the box locally?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=116459&SiteID=1

Thanks,
Sam Lester (MSFT)

sql