Hey hey

I'm a bit confused here, I've uploaded my site to the hosting server, created my database and uploaded the contents. I am using the standard ASPNETDB.MDF database for logins and have simply added a new table for some dynamic content, which works fine.  Trouble is, I can't lgin in, even though the user is in the database!

 
The error is:

An error has occurred while establishing a connection to the server.  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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

and my connection string is:

<add name="ConnectionString" connectionString="Data Source=mssql.designpunk.co.uk;Initial Catalog=royalel_ephant_content;User Id=xx;Password=xxxxxx; Trusted_Connection=False" providerName="System.Data.SqlClient " />

Any one any ideas?

 Thanks
 

Go to Program files Microsoft SQL Server 2005 configuration Tools SQL Server Surface Area configuration on this window select the link Surface Area Configuration for Features on this window on the Left Menu. Select the appropriate Database Engine Select Remote Connections and do this. Select Loacl and remote connections radio button and Using both TCP/IP and named pipes. Hope this works :)

Go to ->
Program files ->
Microsoft SQL Server 2005 ->
configuration Tools ->
SQL Server Surface Area configuration  ->

on this window select the link
Surface Area Configuration for Features ->

on this window on the Left Menu.
Select the appropriate Database Engine ->

Select Remote Connections and do this. ->

Select Loacl and remote connections radio button and Using both TCP/IP and named pipes

Thanks, I'll try this. Should this fix the problem on the remote server then? Also, do I need to upload anything to the server, a new web config or anything? Thanks Mark

Hi again I tried that but couldn't find the option for remote connections. I went into the features bit as you suggested then got faced with this:

OOPs even my machine is also changed like this after installing MS Accounting 2008.

I think u need to select the checkbox for "Enable OPENROWSET and OPENDATASOURCE support"

Hi there, even when I select this box and click "Apply" or "Ok" I still have the same options. I'm not seeing anything to do with Remote Connections, no matter where I click.

I may be missing something?
 

Hi,

I don't think SQL 2005 EXPRESS allows remoted connections.  If it did you wouldn't have to buy a full version?

 hth

Hi guys

Just got back from hol, hence the late reply.

I'm not sure it's anything as complicated as this ya know. Just to reiterate, I have a local login / membership provider and an extra table for my dynamic content in the local AspNetDB inside Web Developer Express.  I've created a MSSQL database on my remote server (note it's shared hosting so i don't have access to IIS, but this wasn't a problem on the other sites I've deployed there) and what is happening is:

• The login fails as it appears that the membership application is still looking for my local service provider, even though I've changed the connection string to point toward the remote server db.
• The table with the dynamic content however is actually working fine, i.e. looking at the remote database for the content.

Based on this, it would appear that the connection string etc isn't the problem. Maybe the service provider?

Now, when I head to the site config in VWDE 08, and look under security settings, even though I have a remote connection string, it is still looking at the local server fofr membership. In every other site I've deployed remotely, when I launch the site config tool, it looks at the remote site as it should using the connection string, allowing me to add users etc to the remote app.

Any thoughts are massively appreciated!

Thanks
Mark