Error: SQL Server does not exist or access denied

[Ben]

Hi

I am updating a project from Access to run on our SQL Server DB. Currently
I am struggling to connect to the database. I have this code which is
throwing this error: SQL Server does not exist or access denied.

Dim mydataadapter As New SqlDataAdapter
mydataadapter.SelectCommand = New SqlCommand(strSQL)

mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=servername\databasename;User ID=domain\username")

mydataadapter.Fill(myDataSet, "tblClient.Client_ID")

myDataGrid.DataSource = myDataSet.Table("tblClient.Client_ID")

myDataGrid.DataBind()

Any ideas

Thanks B

[Patrice]

See a site such as http://www.connectionstrings.com/ for valid strings.
Basically :
Data Source is the server name, the database name goes in Initial Catalog.

AFAIK when using a Windows account, you just turn "intergrated security" on.
You can only connect using the currently used Windows account...

Patrice

--

"Ben" <Be*@NoSpam.com> a écrit dans le message de
news:uH**************@TK2MSFTNGP10.phx.gbl...

Hi

I am updating a project from Access to run on our SQL Server DB. Currently I am struggling to connect to the database. I have this code which is
throwing this error: SQL Server does not exist or access denied.

Dim mydataadapter As New SqlDataAdapter
mydataadapter.SelectCommand = New SqlCommand(strSQL)

mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=servername\databasename;User ID=domain\username")

mydataadapter.Fill(myDataSet, "tblClient.Client_ID")

myDataGrid.DataSource = myDataSet.Table("tblClient.Client_ID")

myDataGrid.DataBind()

Any ideas

Thanks B

[Ben]

Hi

I was origionally using this connection string:

mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=server;Initial Catalog=database;Integrated Security=SSPI;")

Which throws this error - Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.
"Patrice" <no****@nowhere.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

See a site such as http://www.connectionstrings.com/ for valid strings.
Basically :
Data Source is the server name, the database name goes in Initial Catalog.

AFAIK when using a Windows account, you just turn "intergrated security" on. You can only connect using the currently used Windows account...

Patrice

--

"Ben" <Be*@NoSpam.com> a écrit dans le message de
news:uH**************@TK2MSFTNGP10.phx.gbl...

Hi

I am updating a project from Access to run on our SQL Server DB.

Currently

I am struggling to connect to the database. I have this code which is
throwing this error: SQL Server does not exist or access denied.

Dim mydataadapter As New SqlDataAdapter
mydataadapter.SelectCommand = New SqlCommand(strSQL)

mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=servername\databasename;User ID=domain\username")

mydataadapter.Fill(myDataSet, "tblClient.Client_ID")

myDataGrid.DataSource = myDataSet.Table("tblClient.Client_ID")

myDataGrid.DataBind()

Any ideas

Thanks B

[Patrice]

See :
http://support.microsoft.com/default...b;EN-US;316989

(AFAIK the account is ASPNET not APSNET_WP a stated in this KB article)

Patrice

--

"Ben" <Be*@NoSpam.com> a écrit dans le message de
news:uR**************@TK2MSFTNGP11.phx.gbl...

Hi

I was origionally using this connection string:

mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=server;Initial Catalog=database;Integrated Security=SSPI;")

Which throws this error - Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.
"Patrice" <no****@nowhere.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

See a site such as http://www.connectionstrings.com/ for valid strings.
Basically :
Data Source is the server name, the database name goes in Initial Catalog.
AFAIK when using a Windows account, you just turn "intergrated security"

on.

You can only connect using the currently used Windows account...

Patrice

--

"Ben" <Be*@NoSpam.com> a écrit dans le message de
news:uH**************@TK2MSFTNGP10.phx.gbl...

Hi

I am updating a project from Access to run on our SQL Server DB.

Currently

I am struggling to connect to the database. I have this code which is
throwing this error: SQL Server does not exist or access denied.

Dim mydataadapter As New SqlDataAdapter
mydataadapter.SelectCommand = New SqlCommand(strSQL)

mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=servername\databasename;User ID=domain\username")

mydataadapter.Fill(myDataSet, "tblClient.Client_ID")

myDataGrid.DataSource = myDataSet.Table("tblClient.Client_ID")

myDataGrid.DataBind()

Any ideas

Thanks B

[Kevin Spencer]

Did you check out http://www.connectionstrings.com as recommended?

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Ben" <Be*@NoSpam.com> wrote in message
news:uR**************@TK2MSFTNGP11.phx.gbl...

Hi

I was origionally using this connection string:

mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=server;Initial Catalog=database;Integrated Security=SSPI;")

Which throws this error - Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.
"Patrice" <no****@nowhere.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

See a site such as http://www.connectionstrings.com/ for valid strings.
Basically :
Data Source is the server name, the database name goes in Initial Catalog.
AFAIK when using a Windows account, you just turn "intergrated security"

on.

You can only connect using the currently used Windows account...

Patrice

--

"Ben" <Be*@NoSpam.com> a écrit dans le message de
news:uH**************@TK2MSFTNGP10.phx.gbl...

Hi

I am updating a project from Access to run on our SQL Server DB.

Currently

I am struggling to connect to the database. I have this code which is
throwing this error: SQL Server does not exist or access denied.

Dim mydataadapter As New SqlDataAdapter
mydataadapter.SelectCommand = New SqlCommand(strSQL)

mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=servername\databasename;User ID=domain\username")

mydataadapter.Fill(myDataSet, "tblClient.Client_ID")

myDataGrid.DataSource = myDataSet.Table("tblClient.Client_ID")

myDataGrid.DataBind()

Any ideas

Thanks B

[Ben]

All sorted now - re this link
http://idunno.org/dotNet/trustedConnections.aspx

Thanks B

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ez**************@TK2MSFTNGP10.phx.gbl...

Did you check out http://www.connectionstrings.com as recommended?

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Ben" <Be*@NoSpam.com> wrote in message
news:uR**************@TK2MSFTNGP11.phx.gbl...

Hi

I was origionally using this connection string:

mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=server;Initial Catalog=database;Integrated Security=SSPI;")

Which throws this error - Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.
"Patrice" <no****@nowhere.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

See a site such as http://www.connectionstrings.com/ for valid strings. Basically :
Data Source is the server name, the database name goes in Initial Catalog.
AFAIK when using a Windows account, you just turn "intergrated security"

on.

You can only connect using the currently used Windows account...

Patrice

--

"Ben" <Be*@NoSpam.com> a écrit dans le message de
news:uH**************@TK2MSFTNGP10.phx.gbl...
> Hi
>
> I am updating a project from Access to run on our SQL Server DB.
Currently
> I am struggling to connect to the database. I have this code which

is > throwing this error: SQL Server does not exist or access denied.
>
> Dim mydataadapter As New SqlDataAdapter
> mydataadapter.SelectCommand = New SqlCommand(strSQL)
>
> mydataadapter.SelectCommand.Connection = New SqlConnection("Data
> Source=servername\databasename;User ID=domain\username")
>
> mydataadapter.Fill(myDataSet, "tblClient.Client_ID")
>
> myDataGrid.DataSource = myDataSet.Table("tblClient.Client_ID")
>
> myDataGrid.DataBind()
>
> Any ideas
>
> Thanks B
>
>