SQL connection problem

[evgeny]

C#

jeg får altså denne erroren når jeg kobler mot min SQL base

Jeg kjører MS SQL 2008 server og har følgende connection metode

 

SqlConnection myConnection = new SqlConnection();
		myConnection.ConnectionString = "Data Source=localhost;Initial Catalog=Test;User Id=sa;Password=promp";


		try
		{
			myConnection.Open();
			return true;
		}
		catch (Exception e)
		{
			String error = e.ToString();
			//Console.WriteLine(e.ToString());
			return false;
		}

 

 

 

Kan noen se noe feil her?

 

 

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

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

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.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

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 WebService1.Service1.Login(String username, String password) in C:\dev\WebService1\WebService1\Service1.asmx.cs:line 48

[j000rn]

* Start cliconfg.exe, pass på at tcp/ip er aktivert og sett tcp/ip øverst.

 

* Verifiser at du prøver å koble deg mot riktig instans.

Start... cmd.exe... net start | find "SQL Server"

Instansnavnet står i parantes.

Om det er Express versjonen av SQL Server du har installert vil instansnavnet som default være "SQLEXPRESS".

 

* Bruk denne connectionstring'n:

"Server=maskin\instans;Database=Test;User Id=sa;Password=promp"

Du kan også bruke andre porter enn standard (1433):

"Server=maskin\instans,666;Database=Test;User Id=sa;Password=promp"

Endret 30. august 2008 av jorn79

[Manfred]

Så tror jeg også du skal lete lenge etter noen som anbefaler deg å bruke sa-brukeren til noe som helst.

[evgeny]

* Start cliconfg.exe, pass på at tcp/ip er aktivert og sett tcp/ip øverst.

 

* Verifiser at du prøver å koble deg mot riktig instans.

Start... cmd.exe... net start | find "SQL Server"

Instansnavnet står i parantes.

Om det er Express versjonen av SQL Server du har installert vil instansnavnet som default være "SQLEXPRESS".

 

* Bruk denne connectionstring'n:

"Server=maskin\instans;Database=Test;User Id=sa;Password=promp"

Du kan også bruke andre porter enn standard (1433):

"Server=maskin\instans,666;Database=Test;User Id=sa;Password=promp"

 

Tusen takk dette funka. Helt utrolig hva man må gjøre noen ganger for å få ting til å funke