ASP SQL 2005 Login failed for user - error '80040e4d'

[manfree]

Hi guys,

I am a newbie in SQL 2005. Actually, I just want to get connect to SQL 2005 via ASP.... but it comes up the following error ...

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'manfree'. The user is not associated with a trusted SQL Server connection

My Source Code is:

set adocon = server.CreateObject("ADODB.Connection")
adocon.open "Driver={SQL Server};Server=10.0.0.254;Database=myDatabase;Uid=manfree;Pwd=manfree;"

I think I didn't configure it well ... (on permission settings and others ...)
Is there any people who can give me a step by step configuration
Or URLs are also welcome ~~

By the way, the Platform is windows 2003, IIS6, SQL 2005

Thanks ~

[russell]

your connection string should look like this

"Provider=SQLOLEDB.1;Password=pwd;Persist Security Info=True;User ID=user;Initial Catalog=[dbname];Data Source=servernameOrIP"

[manfree]

arr ... then it comes up with the following error ...

Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'manfree'. The user is not associated with a trusted SQL Server connection

I have tried the following connection string as well ... but the outcome is still the same ...
adocon.open "Provider=SQLNCLI;Server=10.0.0.254;Database=myDatabase;Uid=manfree;Pwd=manfree"

[russell]

need to check that remote connections are enabled in sql server 2005 surface area configuration tool.

[russell]

also make sure sql server browser service is running on sql server.

[manfree]

- The remote connections are enabled
- SQL server browser service is running

Do you think I made the incorrect permission setting ??

[russell]

looks like. do u have admin authority over sql server? what version of sl2k5? express? enterprise?

[manfree]

yes, i have. (the admin auth)

Here are the info from the SQL 2005 Enterprise

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

And I still keep searching the solution in GOOGLE ~~ arr ~~~ headache ~ ha ha

[russell]

checked user "manfree" is a valid db user ?

[manfree]

that's why i need to search for step by step premission setting ...
I have no idea on which part of setting I've missed ...
Do you have any related URLs for that ?
Thank you

[russell]

see here for creating user accounts in sql 2k5. also see this article

also, in management studio, under security, you can see all valid db users. right-click user to see what permissions/roles they have in database

[russell]

might want to look at this one too