Solved

Connect to SQL 2008 R2 with ASP/VBScript

Posted on 2010-11-19
3
1,684 Views
Last Modified: 2012-06-27
Hi experts,

we have a classic ASP page where we want to connect to a sql 2008 R2 server.
The connection string so far to connect to sql 2005 was:
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = database; User Id = userABC; Password=abcd"
this worked perfectly. But now with sql2008 it doesn't work any more and throws the following error:

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user 'userABC'.

/web/db.asp, line 11

Please help
Thanks a lot
Best regards
arthrex


0
Comment
Question by:arthrex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 3

Expert Comment

by:FreakyEddie
ID: 34174051
Connection string for win2k8 is the same.

Did you add the user? Is the Pass correct?
0
 
LVL 3

Accepted Solution

by:
FreakyEddie earned 500 total points
ID: 34174115
Doublechecked it...

Hereby the correct connection string.Else you can always consult www.connectionstrings.com

Driver={SQL Server};Server=(local);Database=dbname;uid=username;pwd=password;Trusted_Connection=no;
0
 

Author Closing Comment

by:arthrex
ID: 34196225
Thanks that helped a lot
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query 5 57
comparsion of two excel and get the result in another sheet using macro/VBA 3 65
Complex SQL Server WHERE CLause 9 39
Search Text in Views 2 27
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question