Personal Site Starter Kit

Re: problems connecting to SQL Server 2005

shahu — Wed, 10 Jun 2009 10:52:51 GMT

ya its work properly.but still my probleam remain same...i.e

System.Data.SqlClient.SqlException: 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 connectio

here my connection string as follow.

Re: problems connecting to SQL Server 2005

jeremyh — Tue, 15 Jul 2008 17:29:45 GMT

Hello,

Great news that you got a connectionstring working. I have to say I have never seen that first error before
Have you tried to run the script again?
Did you check to see if you have a Photos table in the database?
Also check to see if the stored procedure is in the database?

Let me know what you find and I will try to help more.

Re: problems connecting to SQL Server 2005

markcus2117 — Tue, 15 Jul 2008 16:37:52 GMT

Hi Jeremy, - I follow the instruction and it all started to work after my provider eventually let the server know my username and password. I then had to play around with my Web.config a few times but eventually go that to work but when publishing the database "personal" i get an error as follows.

Database Publishing Progress

- Gathering list of objects to script (Success)

- Connecting to web service (Success)

- Scripting objects (Success)

- Creating table dbo.Photos (Error)
 Messages
 * Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
 The request failed with the error message:
 --
 <?xml version="1.0" ?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml" >
 <head>
 <title>Server Unavailable
 </title>
 </head>
 <body>
 <h1>Server Application Unavailable
 </h1>
 
 
 The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
 
 
 Administrator Note:
 An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
 
 </body>
 </html>

 --. (System.Web.Services)


and on the website the error

Could not find stored procedure 'GetNonEmptyAlbums'.

Line 196:				connection.Open()
Line 197:				Dim list As New Generic.List(Of Album)()
Line 198:				Using reader As SqlDataReader = command.ExecuteReader
Line 199:					Do While reader.Read
Line 200:						Dim temp As New Album(CType(reader("AlbumID"), Integer), 0, "", False)

Source File: \\WEBSHARE4\Webshare4\Users\markeu\webroot\App_Code\PhotoManager.vb Line: 198

Re: problems connecting to SQL Server 2005

jeremyh — Fri, 04 Jul 2008 12:12:06 GMT

Ok what you need todo is add the membership tables to your new database at your hosting site, If you have remote access to your sql server then you can use aspnet_regsql.exe which is covered in the link I gave you before, but if you do not have access to the sql server from your pc then follow the steps in this http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx

Hope it helps, if you need more ask.

Re: problems connecting to SQL Server 2005

markcus2117 — Fri, 04 Jul 2008 11:51:43 GMT

Hi Jeremy.

This shows how new I am to this - so yes I uploaded the files to my host - but moved the database ? I did not see that in any documentation! so I guess I have not done this

The mysqlservers.xs4all.nl is the address for the server I recieved from my provider.

Database type:	mssql
Database naam:	markeu_mark
Database hostnaam:	markeu.mssqlservers.xs4all.nl
Database admin loginnaam:	markeu_marka
Database read-write loginnaam:	markeu_markw

Re: problems connecting to SQL Server 2005

jeremyh — Fri, 04 Jul 2008 11:29:39 GMT

Hello Markus,

You do not tell us how you are running your site? So have you uploaded the files to your host and the moved the datbase from a local mdf to the host sql server?

If you have did you add the membership schema to the database? Take a read of http://aspnet.4guysfromrolla.com/articles/040506-1.aspx for more info.

And my last question this is a MS sql server "mysqlservers.xs4all.nl" and not a mysql one?

let me know and I will try to help you more.

Re: problems connecting to SQL Server 2005

markcus2117 — Fri, 04 Jul 2008 10:38:13 GMT

Hi I used the post to try and solve a similiar problem of my own but it then through another error.

the first error after uploading to my provider was this

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

ine 5:  	Sub Application_Start(ByVal sender As [Object], ByVal e As EventArgs)
Line 6:  		AddHandler SiteMap.SiteMapResolve, AddressOf Me.AppendQueryString
Line 7:  		If (Roles.RoleExists("Administrators") = False) Then
Line 8:  			Roles.CreateRole("Administrators")
Line 9:  		End If

I read through the posts and found one related to database names in the Web.config so I changed it from this

to This

I know the database name is "Mark" as i created the name and I know the username for Admin is Markeu_marka and for write access is markeu_markw both with different passwords.

Now the error I get is this

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:

Line 194:			Using command As New SqlCommand("GetNonEmptyAlbums", connection)
Line 195:				command.CommandType = CommandType.StoredProcedure
Line 196:				connection.Open()
Line 197:				Dim list As New Generic.List(Of Album)()
Line 198:				Using reader As SqlDataReader = command.ExecuteReader

Can anyone help me?

Re: problems connecting to SQL Server 2005

trevorkeast — Mon, 30 Jun 2008 13:25:16 GMT

It still looks as though your connection string is not correct. What server are you connecting to? Is it just running on your local machine or are you trying to connect to a hosted server?

Trevor

Re: problems connecting to SQL Server 2005

shailesh_thapa — Mon, 30 Jun 2008 04:24:31 GMT

hi, thanks for ur reply but now it is showing this 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)

so what is the solution ,please?

Re: problems connecting to SQL Server 2005

epasho — Sun, 29 Jun 2008 13:39:22 GMT

u need to change the connectionString to the point to your database server and change the name attribute to whatever your are using....see previous posts. also the usename and the passwrod

endrit

Re: problems connecting to SQL Server 2005

shailesh_thapa — Sun, 29 Jun 2008 09:26:47 GMT

hi Trevor Keast,

i am creating my first website and i have a database connecion in my Default.aspx for gridview which connection is stored in web.config ,but when i access my site it shows the error.

my web.config connections are

<add name="ASPNETDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True;Connection Timeout=120"