Error in database connection

apurva · April 3rd, 2009, 05:59 AM

I have created the user form with the help of createnewuser control in Asp.net c#. In the same form I have added one more form to collect the user contact details and I have created the table for that in .mdf file.

In the .cs file I have written below mentioned code to gather the user data, but it works fine in local server and remote server it gives error.

The code :

protectedvoid CreateUserWizard1_CreatedUser(object sender, EventArgs e)
{
TextBox UserNameTextBox =
(TextBox)CreateUserWizardStep2.ContentTemplateContainer.Fi ndControl("UserName");
SqlDataSource DataSource =
(SqlDataSource)CreateUserWizardStep2.ContentTemplateContainer.Fi ndControl("InsertExtraInfo");
MembershipUser User = Membership.GetUser(UserNameTextBox.Text);
object UserGUID = User.ProviderUserKey;
DataSource.InsertParameters.Add("UserId", UserGUID.ToString());
DataSource.Insert();

The error what I am getting is:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I have the SQL server IP address, port no. username and password.

Pl. let me know how to fix this error.
Apurva

Imar · April 5th, 2009, 08:12 AM

Are you working with the built-in Membership provider or is this your own database?

The providers by default will look for a database on .\SqlExpress unless you tell it look elsewhere....

Hope this helps,

Imar

apurva · April 6th, 2009, 12:06 AM

Yes, I am working with the built-in Membership provider.

I hope I have to write some code in Create user button, please let me know how it is to be written and in the web.config file I have mentioned the sql details in below mentioned way. Let me know whether it is correct.

<addname="ASPNETDBConnectionString"connectionString="Data Source=208.115.36.160;Initial Catalog=ASPNETDB.MDF;uid=aspnetdb;pwd=vviu39c734dx"
providerName="System.Data.SqlClient" />

early waiting for reply.

Thanking you,
Apurva

Imar · April 6th, 2009, 02:25 PM

Hi there,

You can take a look here: http://weblogs.asp.net/scottgu/archi...25/423703.aspx to learn how to reconfigure the providers to work with your own database.

Cheers,

Imar

linglom · April 11th, 2009, 06:35 AM

If you're using SQL Server Express Edition, the remote connection to the SQL server are blocked by default so you must to enable it. Follow the link below for detail steps.

Enable remote connection to SQL Server 2005 Express