Re: Not able to login in Sharepoint 3.0



Hi,
are you using MySQL?

In Microsoft SQL Server 2000 SP4 or SQL 2005 you must allow remote connections to SQL for form based authentication to work.

/Daniel Bugday

"Gaurav" <gkpruthi@xxxxxxxxx> wrote in message news:1180618903.202214.95070@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I am facing problem while login into Sharepoint 3.0. I am using forms
based authentication. I have SQL Server 2000 SP4. Below is the error
persisting. I can see user added into mysql server. Please help in
resolving this issue.

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) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean&
useFailoverPartner, Boolean& failoverDemandDone, String host, String
failoverPartner, String protocol, SqlInternalConnectionTds
connHandler, Int64 timerExpire, Boolean encrypt, Boolean
trustServerCert, Boolean integratedSecurity, SqlConnection
owningObject, Boolean aliasLookup)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String
newPassword, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean
redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Web.Management.SqlServices.GetSqlConnection(String
server, String user, String password, Boolean trusted, String
connectionString)



Gaurav Pruthi


.



Relevant Pages

  • Re: Unable to Locate Server
    ... When connecting to SQL Server 2005, ... >>> encrypt, Boolean trustServerCert, Boolean integratedSecurity, ... >>> owningObject, SqlConnectionString connectionOptions, String newPassword, ...
    (microsoft.public.sqlserver.setup)
  • Re: Custom membership provider problem
    ... SQL server 2005 does not install with the TCP/IP protocol turned on. ... >An error has occurred while establishing a connection to the server. ... 25 - Connection string is not valid) ... >Boolean& failoverDemandDone, String host, String failoverPartner, String ...
    (microsoft.public.dotnet.framework.aspnet)
  • Help setting up SQL Express as Membership Provider (ASP.NET 2.0 beta 2)
    ... Unable to connect to SQL Server database. ... Boolean& failoverDemandDone, String host, String failoverPartner, String ... encrypt, Boolean integratedSecurity, SqlConnection owningObject, Boolean ...
    (microsoft.public.dotnet.framework.aspnet)
  • Login failed for user NT AUTHORITYNETWORK SERVICE.
    ... The login page comes up (using Membership with a db on Sql Server) and then ... Boolean redirectedUserInstance) +628 ... identity, SqlConnectionString connectionOptions, Object providerInfo, String ... newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: VS 2003 to VS 2005 problems
    ... When connecting to SQL Server 2005, this failure may be caused by ... useFailoverPartner, Boolean& failoverDemandDone, String host, String ... owningObject, SqlConnectionString connectionOptions, String newPassword, ...
    (microsoft.public.dotnet.languages.csharp)