how to change the setting in sql server 2005 embedded edition
Posted on 2009-04-19
I have a website on pc A which is only installed wss3.0 ,just has sql server 2005 embedded edition combined with wss3.0
Now I want to move the whole website and database to pc B which is installed wss3.0 and sql server2005. I opened sql server management studio and tried to connect pc A database, it said
when connecting to SQL server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections
I think the sql server in pc A may not allow remote connection, but it's an embedded edition, there is no configuration tools I can change the setting.
Does anyone know how to change the remote connetion setting in sql server 2005 embedded edition?