Connection string Please

[Raghu Raman]

Hi,

*
I used sql server7.0 with sqlserver authentcation.Now we are migrated to
sqlserver2000. We are using windows2000.
we go into the sqlserver2000 by windows authentication.

I tried to develop an application in vb.net by having the connection
string from the oledbconnection object which is dragged from the
toolbox.I copied that con..string and i used it from my coding.

It worked nice.

**
I opened the web application and used the same connection string to
connect to the sqlserver.But it turned down to connect.

Could you please tell me what was the mistake i had done in the
connection string.Or have i to change / Do any work in my web.config
file.

It would be helpful to me if u supply the connection string for the
sqlserver2000 via windows authentication.

my servername = server01
windows2000 server
my node name = node-01
With thanks
Raghuraman
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

[Scott Allen]

Hi Rahu,

When you connect from the vb.net application on your desktop, you
connect to SQL Server with your Windows credentials.

The same connection string in ASP.NET means the ASPNET account tries
to connect to SQL, but doesn't have permission.

There are several ways to solve the problem, see:

PRB: "Login Failed" Error Message When You Create a Trusted Data
Connection from ASP.NET to SQL Server
http://support.microsoft.com/default.aspx?kbid=316989

HTH,

--
Scott
http://www.OdeToCode.com

On Fri, 09 Jul 2004 07:43:12 -0700, Raghu Raman
<ra************@rediffmail.com> wrote:

Hi,

*
I used sql server7.0 with sqlserver authentcation.Now we are migrated to
sqlserver2000. We are using windows2000.
we go into the sqlserver2000 by windows authentication.

I tried to develop an application in vb.net by having the connection
string from the oledbconnection object which is dragged from the
toolbox.I copied that con..string and i used it from my coding.

It worked nice.

**
I opened the web application and used the same connection string to
connect to the sqlserver.But it turned down to connect.

Could you please tell me what was the mistake i had done in the
connection string.Or have i to change / Do any work in my web.config
file.

It would be helpful to me if u supply the connection string for the
sqlserver2000 via windows authentication.

my servername = server01
windows2000 server
my node name = node-01
With thanks
Raghuraman
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

[Mythran]

Information about connection strings :)

http://www.connectionstrings.com

Hope this helps some :)

Mythran
"Raghu Raman" <ra************@rediffmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Hi,

*
I used sql server7.0 with sqlserver authentcation.Now we are migrated to
sqlserver2000. We are using windows2000.
we go into the sqlserver2000 by windows authentication.

I tried to develop an application in vb.net by having the connection
string from the oledbconnection object which is dragged from the
toolbox.I copied that con..string and i used it from my coding.

It worked nice.

**
I opened the web application and used the same connection string to
connect to the sqlserver.But it turned down to connect.

Could you please tell me what was the mistake i had done in the
connection string.Or have i to change / Do any work in my web.config
file.

It would be helpful to me if u supply the connection string for the
sqlserver2000 via windows authentication.

my servername = server01
windows2000 server
my node name = node-01
With thanks
Raghuraman
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!