error:26 when connecting to sql server express...

I've got an ASP.net 2.0 application that I published and moved to a publicly available server. From my machine it works fine, but not from the production machine.

I'm attempting to connect to a machine that has sql server express installed.

The message in the browser:

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, I went by the kb article and made sure tcpip is enabled. This uses port 3288. server browser is enabled and the machine accepts remote connections.My connection string is (minus the ip & user/pwd):

<add name="IRRMAConnectionString" connectionString="Data Source=<ip_address>\SQLEXPRESS,3288;Initial Catalog=IRRMA;User ID=<user>;password=<pwd>" providerName="System.Data.SqlClient"/>

I can ping the db server from my app server. On my dev machine it connects. Windows firewall is turned off on the db server.

This seems to be an issue with a firewall, I think?

Any direction would be appreciated.

Thanks,

Scott Jones

Scott@.fourindianajones.com

You should check this out and go from there.

http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

I would say it has to do with the UDP 1434 or the sqlbrowser.exe in the exceptions. But once you follow all the steps you should get closer to the resolution.

error:26 when connecting to sql server express...

I've got an ASP.net 2.0 application that I published and moved to a publicly available server. From my machine it works fine, but not from the production machine.

I'm attempting to connect to a machine that has sql server express installed.

The message in the browser:

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, I went by the kb article and made sure tcpip is enabled. This uses port 3288. server browser is enabled and the machine accepts remote connections.My connection string is (minus the ip & user/pwd):

<add name="IRRMAConnectionString" connectionString="Data Source=<ip_address>\SQLEXPRESS,3288;Initial Catalog=IRRMA;User ID=<user>;password=<pwd>" providerName="System.Data.SqlClient"/>

I can ping the db server from my app server. On my dev machine it connects. Windows firewall is turned off on the db server.

This seems to be an issue with a firewall, I think?

Any direction would be appreciated.

Thanks,

Scott Jones

Scott@.fourindianajones.com

You should check this out and go from there.

http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

I would say it has to do with the UDP 1434 or the sqlbrowser.exe in the exceptions. But once you follow all the steps you should get closer to the resolution.

Error: StringStartsWith can't accept null parameters

Hi,
I wish to edit security on a certain report that has been published on my report
server. I visit the "Properties" tab in Report Manager, then click on "Security".
I click on "Edit Item Security" and click through the javascript popup about
inheritance. Then I get a page which says simply, "Error - StringStartsWith can't
accept null parameters".
Has anyone encountered this error? I have no clue how to proceed with debugging,
since I can't even find the code that's throwing this error, nor do I know to
which parameter it's trying to apply StringStartsWith.
Any help would be appreciated.
--Adam BlissPlease, tell us which version of Reporting Service you are using. Also
please provide stack trace for this failure. You should be able to locate it
in one of the log files. Log files are located in the LogFiles directory in
Reporting Services. Look at ones like
ReportServer__07_08_2004_##_##_##.log
and
ReportServerWebApp__07_08_2004_##_##_##.log
Look inside appropriate files and search for string 'StringStartsWith'.
Attach about 50 lines around it.
Thank you.
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Adam Bliss" <abliss@.gmail.com> wrote in message
news:c52bcaf.0407081034.6f9bd2a2@.posting.google.com...
> Hi,
> I wish to edit security on a certain report that has been published on my
report
> server. I visit the "Properties" tab in Report Manager, then click on
"Security".
> I click on "Edit Item Security" and click through the javascript popup
about
> inheritance. Then I get a page which says simply, "Error -
StringStartsWith can't
> accept null parameters".
> Has anyone encountered this error? I have no clue how to proceed with
debugging,
> since I can't even find the code that's throwing this error, nor do I know
to
> which parameter it's trying to apply StringStartsWith.
> Any help would be appreciated.
> --Adam Bliss|||Has anyone solved this?
I am hitting this error when using the Sample Security Extension supplied by M$. Eventviewer tells me that Report server could not load the forms extension.
w3wp!ui!1!9/6/2006-09:09:40:: e ERROR: StringStartsWith can't accept null parameters
w3wp!ui!1!9/6/2006-09:09:40:: e ERROR: HTTP status code --> 500
--Details--
System.ArgumentException: StringStartsWith can't accept null parameters
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!9/6/2006-09:09:41:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
Thanks,
Zac
From http://www.developmentnow.com/g/115_2004_7_0_0_448611/Error-StringStartsWith-cant-accept-null-parameters.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Did you get this resolved? I'm getting exactly the same error message in different circumstances..
From http://www.developmentnow.com/g/115_2004_7_0_0_448611/Error-StringStartsWith-cant-accept-null-parameters.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Got this error when trying to make RS work with forms authentication overr SSL. Though i can browse ReportServer folder, trying to access Reports virtual directory brings this error up.
Anyone has solved this issue
From http://developmentnow.com/g/115_2004_7_0_0_448611/Error-StringStartsWith-cant-accept-null-parameters.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Hi
I'm also getting a very similar error. Any solutions for the same?
Any help would be appreciated
From http://www.developmentnow.com/g/115_2004_7_0_0_448611/Error-StringStartsWith-cant-accept-null-parameters.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com