sqlConnection problem

Question

visual studio 2005 here's my connection.. SqlConnection connect = new SqlConnection("Data Source=localhost; Integrated Security=SSPI;" + "Initial Catalog=dbname";); i don't if this is the problem or what. i just created a database inside this visual studio which is the ms sql server. the error says... an error has occurred while establishing a connection to the server. when connecting to Sql Server 2005, the 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) i even tried allowing local and remote connection in the settings but still it doesn't work. and i think, i don't need to do that because I'm not connecting remotely. i don't know that's how i understand it.. pls help me! tnx

Answer 1

This is the solution for ur problem

InitialCatalog=Testdb;DataSource=.\\sqlexpress;Pooling=True;User ID=sa;Password=sa

Answer 2

now im using this connection string... Data Source=.\\sqlexpress;Initial Catalog=mydb;Integrated Security=true the problem now is that it cannot open the database requested by the login. it's saying that login failed. it appears on my conn.Open();

Answer 3

Jut do the following on the load form event

Dim conTransit As SqlConnection
conTransit = New SqlConnection("Server=SERVER;Database=DATABSE;Integrated Security=SSPI")

'YOU COULD USE --- [User ID=USER;Password=PASSWORD] INSTEAD OF [Integrated Security=SSPI]if your sqlserver does
'not have windows default access

Try
'Try the SQL-SERVER connection
conTransit.Open()
'Additonal check statements
If conTransit.State = ConnectionState.Open Then
MessageBox.Show("Connection OK" & "" & conTransit.ConnectionString)
Else
MessageBox.Show("Could not open SQL database Connection : " & "" & conTransit.ConnectionString)
End If

' -----------------------Genrate error meaasge-------------------------------------

Catch er As System.Data.SqlClient.SqlException
MsgBox("You have Problem generating SQL Server Connection" & "--->" & er.Message, MsgBoxStyle.Critical, "MY SYSTEM ERROR!")
End Try

Enjoy................

Answer 4

Hello,

Do as follows
  
Under sql server 2005 go into configuration and select SQL Server surface and configuration.
Click the link for Surface Area Configuration for Services and Connections  
next for standard SQL conections expand Database Engine, then click Remote Connections.
There you will select local and remote connections and also select Using both TCP/IB and named pipes.

If you use SQLExpress expand and use the above sitings here also.

any questions
http://www.terranettech.net