trying to connect to SQL DB

[Newbie19]

I am trying to connect to a SQL DB and I have owner access, but I am unable to connect.

Here is my connectionstring:



Dim connectionString As String = _
"Data Source=db server name" & _
"Initial Catalog=name;Integrated Security=true"
Dim theDatabase As New SqlClient.SqlConnection(connectionString)



theDatabase.Open()


and the error I get is:

(Priovider: Named Pipes Provider, Error: 40 - could not open a connection to SQL server)
the details state that under default settings SQL server does not allow remote connection.

I've tried everything I can think of...any ideas?

thanks.

[jasperz01]

I am trying to connect to a SQL DB and I have owner access, but I am unable to connect.

Here is my connectionstring:

 
        Dim connectionString As String = _
            "Data Source=db server name" & _
            "Initial Catalog=name;Integrated Security=true"
        Dim theDatabase As New SqlClient.SqlConnection(connectionString)
 
 
 
        theDatabase.Open()
 

and the error I get is:

(Priovider: Named Pipes Provider, Error: 40 - could not open a connection to SQL server)
the details state that under default settings SQL server does not allow remote connection.

I've tried everything I can think of...any ideas?

thanks.

Tried putting a space or semicolon behind the "Data Source=db server name" just before the last " ? Or is this just a typo..

Might be a stupid guess but i've done worse.

Jasper

[Newbie19]

I did the semi colon like this:

Dim connectionString As String = _
"Data Source=san-sql.corp.advertising.com" & _
"Initial Catalog=Ontimetesting;Integrated Security=true;"
Dim theDatabase As New SqlClient.SqlConnection(connectionString)

but I still get the error. Could there be a line that I need in the App.config file to verify the connection is trusted or something? I know in an ASP/SQL site I made once that all I need was a line that stated idenity impersonator = true or something..I'm not too familiar with connecting an application in VB to a database (first time).

Thanks.

[jasperz01]

I did the semi colon like this:

Dim connectionString As String = _
"Data Source=san-sql.corp.advertising.com" & _
"Initial Catalog=Ontimetesting;Integrated Security=true;"
Dim theDatabase As New SqlClient.SqlConnection(connectionString)

but I still get the error. Could there be a line that I need in the App.config file to verify the connection is trusted or something? I know in an ASP/SQL site I made once that all I need was a line that stated idenity impersonator = true or something..I'm not too familiar with connecting an application in VB to a database (first time).

Thanks.

I think you're just bothered by a typo. Your string (without line breaks _ ) would now look like
"Data Source=san-sql.corp.advertising.comInitial Catalog=Ontimetesting;Integrated Security=true;"

I'm guessing a space between the advertising.com and Initial Catalog would do the trick. If that isn't the prob, I don't know much of connecting to DB's either, so I can't help you any further... Maybe someone else?

[Newbie19]

Thanks for the help anyway, I did catch on typo, but still no luck.

[Newbie19]

I don't know if this is any help to you all out there, but I ran a debug and found this:

Error for : theDatabase.Open()



EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'

[Newbie19]

okay I added the Imports System.Data.SqlClient.SqlException and get this error
: Line 1: Incorrect syntax near '.'.

Here is the start of my code (connection wise)...I'm new to this type of VB application:

Imports System.Data.SqlClient
Imports System.Data
Imports System.Data.Sql
Imports System.Data.SqlClient.SqlException



Public Class Form1


Private Sub adddefectbutton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles adddefectbutton.Click
'When Clicked the Data will be insterted into the database.

'-------Connect to the Database

Dim connectionString As String = "Data Source=san-sql.corp.advertising.com;Initial Catalog=Ontimetesting;Integrated Security=true;"

Dim theDatabase As New SqlClient.SqlConnection(connectionString)



theDatabase.Open()

[pureenhanoi]

I am trying to connect to a SQL DB and I have owner access, but I am unable to connect.

Here is my connectionstring:



Dim connectionString As String = _
"Data Source=db server name" & _
"Initial Catalog=name;Integrated Security=true"
Dim theDatabase As New SqlClient.SqlConnection(connectionString)



theDatabase.Open()


and the error I get is:

(Priovider: Named Pipes Provider, Error: 40 - could not open a connection to SQL server)
the details state that under default settings SQL server does not allow remote connection.

I've tried everything I can think of...any ideas?

thanks.

you are trying connect to remote SQL-Server and receive error that SQL-Server does not allow remote connection. I think thats the security of this server does not allow u connect to (at least through remote way). If u trusted about this server, so re-config it to allow remote access.

[Newbie19]

you are trying connect to remote SQL-Server and receive error that SQL-Server does not allow remote connection. I think thats the security of this server does not allow u connect to (at least through remote way). If u trusted about this server, so re-config it to allow remote access.

Make sense, actually I was informed yesterday that the security level on that one SQL Server is extremely high.

Thanks.