Problem with Trusted SQL Server connection

[jasonray]

Hi,

I keep getting the following error:

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

Username is not the true login. =)

Anyways, I had my page running just fine on my local machine, then I set the link the my boss and he gets the above error message. I've tried just about everything but nothing seems to work. I've changed the security settings to Mixed login and everything.

Also here is my ADO connection statement:
Dim RSmain
Dim RSmain_numRows

Set RSmain = Server.CreateObject("ADODB.Recordset&quot
RSmain.ActiveConnection = MM_sysdev4_STRING
RSmain.Source = "SQL Statement"
RSmain.CursorType = 0
RSmain.CursorLocation = 2
RSmain.LockType = 1
RSmain.Open()

RSmain_numRows = 0

Connection statement:
Dim MM_sysdev4_STRING
MM_sysdev4_STRING = "Provider=SQLOLEDB; Data Source=DBServerName;Initial Catalog=DBName;User ID=UserName;Password=password"

Please let me know if you need anymore information.

I am using Dreamweaver MX 2004 and SQL Server 2000.

Thank you,

Jason

 

[lebisol]

are u sure of:
Data Source= ??????
UserName=????
on the production server?

http://www.able-consulting.com/ADO_Conn.htm

All the best!

> need more info?
:: don't click HERE ::