Windows 2003 Server and ASP

[CosmicLeap]

Hi,
I am unable to connect to a database in my SQL 2000 Server installed on
a Windows 2003 Server machine from an asp page. It gives the the
following error:

Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.

I also sometimes get:
MSDataShape (0x80004005)
Data provider could not be initialized.

I can connect with the same connection string and parameters from a
visual basic 6 application.

I can also connect the web client with the same DB in SQL 2000 running
on Windows 2000/XP.

The authentication mode is mixed.

I believe it is something to do with security. Please advise me on what
to do. It is very urgent.

[shumaker]

You may be able to find something regarding this by searching the
dotnetnuke.com forums, as they have dealt with accessing SQL server
from asp a great deal.

[Mike Epprecht \(SQL MVP\)]

Hi

The SQL Server is setup to only accept NT Integrated Security. You can
change it to mixed mode, see BOL.

AND, do not use the sa account to connect your web site to your DB. You are
asking to get hacked, your data stolen and published on the internet. Use a
low privileged account for this. Look up security in SQL Server 2000 Books
Online

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<Co********@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Hi,
I am unable to connect to a database in my SQL 2000 Server installed on
a Windows 2003 Server machine from an asp page. It gives the the
following error:

Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.

I also sometimes get:
MSDataShape (0x80004005)
Data provider could not be initialized.

I can connect with the same connection string and parameters from a
visual basic 6 application.

I can also connect the web client with the same DB in SQL 2000 running
on Windows 2000/XP.

The authentication mode is mixed.

I believe it is something to do with security. Please advise me on what
to do. It is very urgent.

[Mike Epprecht \(SQL MVP\)]

Hi

The SQL Server is setup to only accept NT Integrated Security. You can
change it to mixed mode, see BOL.

AND, do not use the sa account to connect your web site to your DB. You are
asking to get hacked, your data stolen and published on the internet. Use a
low privileged account for this. Look up security in SQL Server 2000 Books
Online

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<Co********@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Hi,
I am unable to connect to a database in my SQL 2000 Server installed on
a Windows 2003 Server machine from an asp page. It gives the the
following error:

Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.

I also sometimes get:
MSDataShape (0x80004005)
Data provider could not be initialized.

I can connect with the same connection string and parameters from a
visual basic 6 application.

I can also connect the web client with the same DB in SQL 2000 running
on Windows 2000/XP.

The authentication mode is mixed.

I believe it is something to do with security. Please advise me on what
to do. It is very urgent.

[CosmicLeap]

Hi Mike,
Thanks for reply.
My authentication mode is already mixed.
I can connect with exactly the same string from a Visual Basic 6
application.
I will create a low privileged user once I am able to connect.

[CosmicLeap]

Hi Mike,
Thanks for reply.
My authentication mode is already mixed.
I can connect with exactly the same string from a Visual Basic 6
application.
I will create a low privileged user once I am able to connect.

[Stu]

" I can connect with exactly the same string from a Visual Basic 6
application."

That, to me, indicates that it has to be a setting for your ASP
application; is it running on the same box as your SQL Server? I know
that they changed some of the settings for asp in Windows 2003, but I'm
not sure what it was.

I hope you posted this to an asp.net forum, because they'll probably be
more help.

Good luck,
Stu

[Stu]

" I can connect with exactly the same string from a Visual Basic 6
application."

That, to me, indicates that it has to be a setting for your ASP
application; is it running on the same box as your SQL Server? I know
that they changed some of the settings for asp in Windows 2003, but I'm
not sure what it was.

I hope you posted this to an asp.net forum, because they'll probably be
more help.

Good luck,
Stu

[CosmicLeap]

Thanks Stu. I will post in the ASP site right away.

[CosmicLeap]

Thanks Stu. I will post in the ASP site right away.

[CosmicLeap]

Hi Shuma,
I have looked in the dotnetnuke forum but I cannot get a particular
post that deals with my issue. Most of the posts assume the user has
not set up mixed mode authentication and this is what they provide as a
solution.

[CosmicLeap]

Hi Shuma,
I have looked in the dotnetnuke forum but I cannot get a particular
post that deals with my issue. Most of the posts assume the user has
not set up mixed mode authentication and this is what they provide as a
solution.