Login Failure from ASP Page Win2k/Sql2k

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-13 : 08:08:39

David Cunningham writes "In my ASP page I get this error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''Administrator''. Reason: Not associated with a trusted SQL Server connection.

*****************************
ASP Code:

'Dim cnnStr As String
cnnStr="Driver={SQL Server};Server=cx2069685-b;Database=LifeLine;UID='Administrator';PWD=;"

'Create a new connection object
Set cnn = Server.CreateObject("ADODB.Connection")

'Open the connection to the Sql db
cnn.Open cnnStr
*****************************

I have adjusted the security properties to SQL/Win NT, stopped and restarted the service and still no go.

OS Win2k Adv Srv / Sql 2k - all latest SPks installed"

bcollinson
Starting Member

9 Posts

Posted - 2002-02-13 : 08:19:38

Do you have a SQL Server login called 'Administrator', with no password (assigned to the database 'LifeLine') ?

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-02-13 : 14:00:02

quote:

Do you have a SQL Server login called 'Administrator', with no password (assigned to the database 'LifeLine') ?

Boy, I hope not! First, I wouldn't ever have a user ID with no password. Second, Administrator sounds more like a NT/2K login (which by default would have permissions in SQL if part of the Administrators group) not a SQL-specific login. If you're meaning the SA login, thankfully SQL 2000 now warns you to be sure to put a password on SA when you set the server into mixed SQL/NT authentication.

I would suggest you create a SQL login specifically for your web pages to use, and severely restrict it's permissions. We allow our web login to SELECT data and EXECUTE stored procedures, and THAT'S IT!

------------------------
GENERAL-ly speaking...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources