'SQL Server does not exist or access denied'

[Graham Hurst]

Hi all,

A very frustrating problems - searches on the net haven't
found much of relevance.

I have two SQL databases - a TEST and a LIVE. My asp.net
application, with C# codebehind, uses the SqlConnection
class to connect.

When I connect to my LIVE database, everything works fine.
But when I try to connection to the TEST database I get
the following error message:

"SQL Server does not exist or access denied"

I can connect to the datasource using the same connection
string and methods in a Windows Forms Application...

Please can anyone help?
Thanks
Chris

['[] WiRaN]

maybe your connection is bad.
"Graham Hurst" <gh****@radacall.co.uk> escreveu na mensagem
news:57****************************@phx.gbl...

Hi all,

A very frustrating problems - searches on the net haven't
found much of relevance.

I have two SQL databases - a TEST and a LIVE. My asp.net
application, with C# codebehind, uses the SqlConnection
class to connect.

When I connect to my LIVE database, everything works fine.
But when I try to connection to the TEST database I get
the following error message:

"SQL Server does not exist or access denied"

I can connect to the datasource using the same connection
string and methods in a Windows Forms Application...

Please can anyone help?
Thanks
Chris

There is no problem with the connect string as far as I
can see - I use the same for both my ASP.net application
and also a Windows Forms application.

-----Original Message-----
maybe your connection is bad.
"Graham Hurst" <gh****@radacall.co.uk> escreveu na mensagemnews:57****************************@phx.gbl...

Hi all,

A very frustrating problems - searches on the net haven't found much of relevance.

I have two SQL databases - a TEST and a LIVE. My asp.net
application, with C# codebehind, uses the SqlConnection
class to connect.

When I connect to my LIVE database, everything works fine. But when I try to connection to the TEST database I get
the following error message:

"SQL Server does not exist or access denied"

I can connect to the datasource using the same connection string and methods in a Windows Forms Application...

Please can anyone help?
Thanks
Chris

.

[Cowboy \(Gregory A. Beamer\)]

What is the connstring. If you are not using (local) or localhost, you do
not have the correct string on one or the other.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"Graham Hurst" <gh****@radacall.co.uk> wrote in message
news:57****************************@phx.gbl...

Hi all,

A very frustrating problems - searches on the net haven't
found much of relevance.

I have two SQL databases - a TEST and a LIVE. My asp.net
application, with C# codebehind, uses the SqlConnection
class to connect.

When I connect to my LIVE database, everything works fine.
But when I try to connection to the TEST database I get
the following error message:

"SQL Server does not exist or access denied"

I can connect to the datasource using the same connection
string and methods in a Windows Forms Application...

Please can anyone help?
Thanks
Chris

[Adil Bohoudi]

Hi Graham,

Check if the user, specified in the connections string in your web.config,
enought rights has to acces your LIVE database!!!

Kind Regards,
Adil

"Graham Hurst" <gh****@radacall.co.uk> wrote in message
news:57****************************@phx.gbl...

Hi all,

A very frustrating problems - searches on the net haven't
found much of relevance.

I have two SQL databases - a TEST and a LIVE. My asp.net
application, with C# codebehind, uses the SqlConnection
class to connect.

When I connect to my LIVE database, everything works fine.
But when I try to connection to the TEST database I get
the following error message:

"SQL Server does not exist or access denied"

I can connect to the datasource using the same connection
string and methods in a Windows Forms Application...

Please can anyone help?
Thanks
Chris