Contact to sql server from a seperate box

[martin]

Hi,

well, I guess this question has been asked before but all of the solutions
that I have gone with have failed so I am appealing for help.
I have two win2k3 servers.
Box A is hosting the webserver (IIS6)
Box B has MSDE on it.
I am trying to connect from an asp script on box A to the sql server db on
box B.
The connection string I am using is like so.
oConn.Open "Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"

I have created a sql authenticated login in the MSDE database on box B. This
works as I can connect to it via query analyser, and also by running a web
app from IIS on box B.

I changed the account used to run the website on box A to a domain account
(Instead of IUSR_MACHINE). I needed to do this because initially I was
getting an error saying "sql server not found or access denied" -- changing
to a domain user account solved this problem.

now I am getting an error saying that the sql account account is not a
trusted source. Noramally this would indicate to me that the error was cause
because I was trying to connect using windows authentication and this was
failing because the login was not there in windows, but this is not the
case. I am using SQL authentication and box B is definatly set for mixed
mode.

any help is appreciated.

cheers

martin.

[Chris Hohmann]

"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:e$6KgJQVDHA.2368@TK2MSFTNGP09.phx.gbl...

> If the two servers are in different domains, then you need to try

connecting

> by using the SQL Server's IP address.

Just to add my $.02, you can also created a trust relationship between
the two domains, if IP is not an option for security reasons.

[martin de vroom]

Thanks agin.

NTLM was turned on at a higher level in the directory structure and I guess
this was causing the page
to think it was using a trusted source when it was not one.

cheers

martin.




"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:e$6KgJQVDHA.2368@TK2MSFTNGP09.phx.gbl...

> martin wrote:

> > Hi,
> >
> > well, I guess this question has been asked before but all of the
> > solutions that I have gone with have failed so I am appealing for
> > help.
> > I have two win2k3 servers.
> > Box A is hosting the webserver (IIS6)
> > Box B has MSDE on it.

>
> Key piece of information needed: are they both in the same domain?
>
>

> > I am trying to connect from an asp script on box A to the sql server
> > db on box B.
> > The connection string I am using is like so.
> > oConn.Open "Provider=sqloledb;" & _
> > "Data Source=myServerName;" & _
> > "Initial Catalog=myDatabaseName;" & _
> > "User Id=myUsername;" & _
> > "Password=myPassword"
> >
> > I have created a sql authenticated login in the MSDE database on box
> > B. This works as I can connect to it via query analyser, and also by
> > running a web app from IIS on box B.
> >
> > I changed the account used to run the website on box A to a domain
> > account (Instead of IUSR_MACHINE). I needed to do this because
> > initially I was getting an error saying "sql server not found or
> > access denied" -- changing to a domain user account solved this
> > problem.
> >
> > now I am getting an error saying that the sql account account is not a
> > trusted source. Noramally this would indicate to me that the error
> > was cause because I was trying to connect using windows
> > authentication and this was failing because the login was not there
> > in windows, but this is not the case. I am using SQL authentication
> > and box B is definatly set for mixed mode.
> >

> If the two servers are in different domains, then you need to try

connecting

> by using the SQL Server's IP address.
>
> If they are in the same domain, can you ping Box B from Box A by name? It
> could be a WINS or DNS problem.
>
> HTH,
> Bob Barrows
>
>