Neudesic Blogs

hey pete, i've encountered the same problem and found your blog helpful...but...the solution is still a bit complex and can be a drag...i wonder why MS didn't make webparts work for Access.

but anyway, thanx for your effort!

Thanks Will for the feedback will. I agree that the solution is a bit complicated and the formatting doesn't really help. Hopefully, I'll find some time to clean it up a bit.

Pete

good..it solved my problem..thanx a lot

Suresh,

I'm glad this helped you out.

Pete Orologas

Thanks. Actually did help quite a bit. All I had seen was a MS video that completely skipped the database setup stuff. Without that, it's pretty dang useless.

Thanks for the feedback Jeff, glad I could help.

VERY helpful and straightforward

you rock!!!

Thanks a lot. I spent many hours combing many different sites but your solution was easy and it worked.

Thanks a lot!
Finally it works overhere!!

I have been tring to get it fixed for a couple hours, and you got me up in 5 minutes!  Thanks!

Glad I could help

Very useful thank you. I'm now stuck with another error though.

"The specified display mode is currently disabled on this page. Make sure personalization is enabled for the current user.
Parameter name: value"

I have  Personalization-Enabled="true" and just for time being added ISUR/ASPNET/Network service as owners of the DB to rule out sql permision problems.

The server is II6 on w2k3, sql 2005 std, the server is on a virtual machince on my PC but in a seperate domin if this is some kind of intergrated authentication issue.

Anyone else getting a similar problem?

That was really helpful...
cheers man :D

Take care

you 'da man!

Huy gracias, que ayuda.... hay alguna forma de seleccioanr esto como predeterminado para que no utilize el SQLExpress sino la conexión a SQL Server 2005 ? :D

I tried this and other fixes for my error, but appears to keep recurring.  I'm running SQL Server 2005, on Windows Server 2003, and my web.config file looks like such:

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="DBConnect" connectionString="Data Source=.\SQLNCLI;AttachDbFilename=|DataDirectory|\Customers.mdf;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=aspnetdb;"
providerName="System.Data.SqlClient" />
    </connectionStrings>
<system.web>
<webParts>
<personalization defaultProvider="AspNetSqlMembershipProvider">
<providers>
<remove name="AspNetSqlPersonalizationProvider" />
<add name="AspNetPersonalizationProvider"
type="System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider"
connectionStringName="DBConnect"
applicationName="/" />
</providers>
</personalization>
</webParts>
<roleManager>
<providers>
<remove name="AspNetSqlRoleProvider" />
<add name="AspNetSqlRoleProvider"
connectionStringName="DBConnect"
applicationName="/"
type="System.Web.Security.SqlRoleProvider,
System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a4a" />
</providers>
</roleManager>

I've also double checked permissions and such.

Chris,

   From what I can tell your web.config looks fine.  I'm not sure about your connection string.  I would recommend this.

Create a notepad file on your desktop.
Change the txt extension to udl (this will change the icon)
Double click the UDL and chose the proper provider and enter in the proper connection string information.
Click the test connection and make sure that your connection works.
Once you have verified that your connection works, right click the the udl file and open it with notepad.  Inside you'll find your connection string.  Use this conncetion string instead of the one above.  If that doesn't work look at at this.,





http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

Here is the part you are interested in.

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)

1) You might have named pipe or tcp enabled and connect to a named instance, but SQL Browser service was not started or enabled. To enable browser, First, Use net start or go to sql configuration manager(SSCM), check whether sqlbrowser service is running, if not, start it; Secondly,You still need to make sure SqlBrowser is active. Go to SSCM, click properties of sqlbrowser service -> Advanced-> Active “Yes” or “No”, if sqlbrowser is running but is not active, the service would not serve you correct pipe name and Tcp port info on which your connection depends.


Hope this helps

Pete Orologas

I followed your advice and did the instructions, and everything worked great, with the exception of one thing.  I built and tested the connection string as you said to, and I verified that everything worked, but when I put it in my code for my web app, there is an SQL exception that says:

Keyword not supported:  'provider'

Any suggestions?

Chris,

    Your connection string should look this

<add name="DBConn" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=aspnetdb;Data Source=DBServer" providerName="System.Data.SqlClient" />

Notice that the provider has been removed from the connectionString and is set as a attribute of the node(providerName="System.Data.SqlClient" ).

Pete

Sorry to ask so many questions...I'm very confused by all of this.
The CS that the .udl gave me is:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Customers;Data Source=128.8.46.53

I was originally just trying to put this as a string variable in my C# code for my code-behind file.  I instead have now placed it in the web.config file, as I think you were suggesting, but I have no idea how to reference it in the code-behind file.

The line added to my web.config file is:
<add name="DBConn" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Customers;Data Source=128.8.46.53"
providerName="SQLOLEDB.1" />

If this is all right, all I need to do now is reference that when I need to actually get my connection string in the code, but the examples I found of how to do that on MSDN all come up with compilation errors.

Sorry...I've fixed it, and it gets the proper connection string from the web.config file, which is the same as listed above, but I still get the Network Interfaces error 26.

I checked, and SQL Browser is running.  I also checked the blogs URL you posted, and those conditions don't seem to apply to this case.  I tried changing the IP to the machine name in the data source portion, but it didn't fix the error.

Works fine for me..... Thanks bro.

Hey Peter,

Thanks ! Its up. Your stuff really helped me to get out of this problem.
Thanks once again.

This Helped a Lot. I have struck with this problem from past two days. Now I have solved this. Thanks for the Idea.

Works, Thanks !!

Thanks a Lot :)
Its nice and solved my problem.

I am using VS 2005 and SQL Server 2000. When I try to edit webparts I got following error

The specified display mode is currently disabled on this page. Make sure personalization is enabled for the current user.
Parameter name: value

Does I need to follow all these steps????

Regards
Jitender

Jitender,

   Yes, you will have to implement the entire solution.  If you read the rest of the article you will se that the issue is due to the fact that the webpartmanager is looking for SQL express by default and you are running SQL 2005.  

Pete

very helpful! thank you very much!

Really Thanks for solution

Hi Pete

I need to install MS SQL Express Edition 2005 on my server. Im using Windows Server 2000 and have dot net framework 1.0,1.5 and 2.0 already installed on server. Im runnig 32 bits processor.
Before i installed MS SQL Express Edition im curious to get enuff information to be on the save side. Please guide me what is the best way to install MS SQL EE 2005 to make it work properly on the server without VS.Net installed on it

Thank you very much......
Keep doing the good work of helping developers like us :):)

Shaukat,

    Vs.Net is not a prerequisite for installing MS SQL Express Edition 2005.  However, if you are installing on a 2000 server box you'll need to have SP4 installed.  Here is a link to the prerequisites need to install MSSQL Express.

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

Pete

Hi,

My setup is: I have a ASP.NET 2.0 web app running on SERVER A, and SQL Server 2005 running on SERVER B. And I'm getting...

"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)"

I have practically followed almost every tip here, and I still can't fix it. I've checked the connection for my SQL Server DB in SERVER B, and TCP/IP is enabled, SQL Browser is active and running. I can access the database using SQL Analyzer from my laptop, but when accessing using the web application, I can't access it.

I am not using the membership functions, but simply connecting to an existing database. Is there a way to solve this? Thanks.

If I may add,

SERVER A (where the web app is located) is on a DMZ network...

Rob,

   I have some questions.  First lets take Asp.Net out of the equation.  Can you connect to the DB Server from "Server B" directly?  One way to test this is to do this.

Create a notepad file on your desktop.
Change the txt extension to udl (this will change the icon)
Double click the UDL and chose the proper provider (Microsoft OLE DB Provider for SQL Server) and enter in the proper connection string information.
Click the test connection and make sure that your connection works.

Also make sure that you've set up remote connections.

   Have you set up MS SQL to accept remote connections?  If not do this
Open SQL Server Configuration Manager. Select "SQL Server 2005 Network Configuration | Protocols for MSSQLSERVER" then enable the protocols you need. (I would recommend both TCP\IP and NamedPipes)

Once you've done this let me know what the results are and we can move forward from there.  I'll check keep checking to see what the outcome is.

Pete Orologas

Very helpful. I  have a different issue though:  When I create a web part project and run it, I get the web part control displayed as simple web control (i.e without the close and minimize options). could not find anything on google. Am I missing anything? Is integrated security a requirement?

I have the aspnetdb created on  SQL Server 2000 (ver 8.00.760 Service Pack 3) and VS 2005 has service pack 1 applied.

Thnx a milion.

Hi Peter, Thanx a lot!!!! Really helped me.

Well done! It's help me so much. Thanks

Hi Porologas,

I have a web application which using Sql Server 2005(instead of Express Edition).
I tried to create a simple web part page. The page can be displayed but does not have the "Minimize" and "Restore" link.

I had run aspnet_regsql on my database, then add the personalization provider in web.config, but still can't get the web part working.

Following is part of web.config and web part page (default2.aspx)
Web.config:
<connectionStrings>
<add name="SkywebConnStr" connectionString="Data Source=CHAW;Initial Catalog=Skyweb;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

<system.web>
<webParts>
<personalization defaultProvider="AspNetSqlPersonalizationProvider">
<providers>
<clear/>
<add name="AspNetSqlPersonalizationProvider" type="System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider"
connectionStringName="SkywebConnStr"
applicationName="/" />
</providers>
</personalization>
</webParts>
</system.web>


Default2.aspx:
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
   <title>Untitled Page</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
       <asp:WebPartManager ID="WebPartManager1" runat="server">
       </asp:WebPartManager>
   
   </div>
   <div>
       <asp:WebPartZone ID="WebPartZone1" runat="server">
           <ZoneTemplate>
               <asp:Calendar ID="Calendar1" runat="server"></asp:Calendar>
           </ZoneTemplate>
       </asp:WebPartZone>
    </div>
    <div>
       <asp:WebPartZone ID="WebPartZone2" runat="server">
           <ZoneTemplate>
               <asp:Calendar ID="Calendar2" runat="server"></asp:Calendar>
           </ZoneTemplate>
       </asp:WebPartZone>
      </div>
   </form>
</body>
</html>

Hope you can help.
Thanks.

Very helpful.

I am facing the same problem with the page being displayed but does not have the "Minimize" and "Restore" link.
Any help appreciated.

Your original posting and the subsequent answers you gave for other issues have helped me solve the problem.
Thanks!

Thanks a lot Pete, it completely solved my problem!!!!

Thanks a Ton Pete . I was stuck in this problem for a whole day .Your solution make it possible .Thanks again

Hi,,
Simply GR8888.....wat a relief it was to see web parts working .
PETE ur a GENIUS..

Keep it up

BEST Regards.
Pawan

Thanks Pete, that did the trick!

Login failed for user ''. The user is not associated with a trusted SQL Server connection.


I am getting this error.. knidly let me know hoe to rectify this. plz..

Hey dude.. its working fine now.. i have got all kind a errors.. i have fixed everythgn.. nice anyhow.. thnks ..

Thanks a lot for sharing this tip.

Nice Article. Thanks. Just one doubt. Can I give my connection string somewhere else apart from "web.config"?

It is realy great solution I was searching long time through the internet but I didnt' find simple solution like your code.but I need one thing from you which is how I can move the web parts in run time.
Best Regards

Thanks man. It worked for me.

error SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
me un instaled the sql 2005 and instaled  sql 2000 then i try to connect to database i got this error

Hi Pete,

  Thanks alot for your useful comments. Earlier i was facing problem with the SQL Database connection but after that I read your udl part & it worked. Thanks again.

Praveen

Hi there Porologas, ive got a problem aswell with the SQL SERVER 20005. the remote host where the database is on keeps on giving me an error when i try to save data to it. my web.config looks as such.
<?xml version="1.0"?>

<configuration>
 <connectionStrings>
   <remove name="LocalSqlServer"/>
   <add name="CreativeHeartDB" connectionString="Initial Catalog=CreativeHearts;Data Source=196.41.3.4; user id=; pwd=" providerName="System.Data.SqlClient"/>
 </connectionStrings>
 

 <system.web>
   <webParts>
     <personalization defaultProvider="AspNetSqlPersonalizationProvider">
       <providers>
         <remove name="AspNetSqlPersonalizationProvider"/>
         <add name="AspNetSqlPersonalizationProvider" type="System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider"
              connectionstringname="CreativeHeartDB" applicationname="/"/>
       </providers>
     </personalization>
   </webParts>
   <!--
           Set compilation debug="true" to insert debugging
           symbols into the compiled page. Because this
           affects performance, set this value to true only
           during development.
       -->
   <compilation debug="false" />
   <!--
           The <authentication> section enables configuration
           of the security authentication mode used by
           ASP.NET to identify an incoming user.
       -->
   <authentication mode="Forms" />
   <!--
           The <customErrors> section enables configuration
           of what to do if/when an unhandled error occurs
           during the execution of a request. Specifically,
           it enables developers to configure html error pages
           to be displayed in place of a error stack trace.

       <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
           <error statusCode="403" redirect="NoAccess.htm" />
           <error statusCode="404" redirect="FileNotFound.htm" />
       </customErrors>
       -->
   <customErrors mode="Off">
   </customErrors>

   

 </system.web>
</configuration>

i have a registerCV.aspx page and behind the Register button the code goes as such


Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
       Dim strCon As String
       strCon = ConfigurationManager.AppSettings("CreativeHeartDB")
       Dim sqlCon As New SqlClient.SqlConnection
       sqlCon.ConnectionString = strCon
       Dim sqlCommand As New SqlCommand("INSERT INTO cvInformation(title,gender,race,initials,name,surname,birthdate,id,province,citizenship,jobtitle,relocate,emmigrate,email,worktel,cell,hometel,education,field,startdate,enddate,company,positionheld,jobdescription,contactperson,contacttel,startdate2,enddate2,company2,positionheld2,jobdescription2,contactperson2,contacttel2,startdate3,enddate3,company3,positionheld3,jobdescription3,contactperson3,contacttel3)values('" & drpTitle.SelectedValue & "','" & drpGender.SelectedValue & "','" & drpRace.SelectedValue & "','" & txtInitials.Text & "','" & txtName.Text & "','" & txtSurname.Text & "','" & txtDateOfBirth.Text & "','" & txtID.Text & "','" & drpAddress.SelectedValue & "','" & drpCitizenship.SelectedValue & "','" & txtCurrentJob.Text & "','" & drpRelocate.SelectedValue & "','" & drpEmmigrate.SelectedValue & "','" & txtEmail.Text & "','" & txtWorkTel.Text & "','" & txtCell.Text & "','" & txtHomeTel.Text & "','" & drpEducation.SelectedValue & "','" & drpField.SelectedValue & "','" & txtStartDate.Text & "','" & txtEndDate.Text & "','" & txtCompany.Text & "','" & txtPositionHeld.Text & "','" & txtJobDescription.Text & "','" & txtContactPerson.Text & "','" & txtContactTel.Text & "','" & txtStartDate2.Text & "','" & txtEndDate2.Text & "','" & txtCompany2.Text & "','" & txtPositionHeld2.Text & "','" & txtJobDescription2.Text & "','" & txtContactPerson2.Text & "','" & txtContactTel2.Text & "','" & txtStartDate3.Text & "','" & txtEndDate3.Text & "','" & txtCompany3.Text & "','" & txtPositionHeld3.Text & "','" & txtJobDescription3.Text & "','" & txtContactPerson3.Text & "','" & txtContactTel3.Text & "')", sqlCon)
       Dim sqlCommandUsers As New SqlCommand("INSERT INTO LoginInformation(name,password)VALUES('" & txtUsername.Text & "','" & txtPassword.Text & "')", sqlCon)
       sqlCommand.Connection.Open()
       sqlCommand.ExecuteNonQuery()
       sqlCommandUsers.ExecuteNonQuery()
       sqlCommand.Connection.Close()
       Response.Redirect("cvregistersuccess.aspx")

is there a problem with this??? because it gives me the error

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)

The remote host says that SQL Browser is active and everything on there side is working
PLEASE HELP

Its helpful. thank you pete.

Bump up the trust level in web.config

i have a problem.
i have 2 forms on a page that have to post to 2 different places.
I have got them to post to each place successfully and i have had success in posting the two forms at the simultaneously with one button,

the problem is, the first form must go to a paypal situation where the details have to get received by the merchant and then apon payment success go to the successful landing page success.aspx.
the 2nd forms information must also go to success.aspx because when it comes back from the bank merchant there is no sent back info on the persons details so i had to send the 2nd form detials to the success.aspx page.

Now when i click the submit button the first form opens in a window and does its thing, the 2nd form info also opens on another page and shows me that the info has reached the page.

i want to the 1st form to go to the bank and the 2nd form to go to success.aspx but i dont want the 2nd forms page to pop up in a new window, it shouldnt pop up at all. jst the 1st forms page that must go to the bank confirmation because when the payment is successful it goes back to success.aspx anyway and the information must be lying there already.