• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1400
  • Last Modified:

ODBC Connect to SQL Server 2005

Hello,

I hope someone can help me with my issue.  I am trying to make an ODBC connection from my client machine (Windows XP Professional Version 2002 SP 2) to an SQL Server 2005 database running on our in-house Windows Server 2003 R2 machine.
Here are the versions for SQL Server Management Studio:
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.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML  2.6 3.0 5.0 6.0
Microsoft Internet Explorer 6.0.3790.3959
Microsoft .NET Framework 2.0.50727.832
Operating System 5.2.3790

My objective is to connect to the SQL Server database using Business Objects Crystal Reports.  I've contacted Business Object tech support but they cannot help me unless I can confirm that I am able to connect to the SQL Server database.

I've attempted to connect to the database base by defining a System DSN and spcifying SQL Server as the data source but when I try to connect I encounter the following error message:

Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft[]ODBC SQL Server Driver][SQL Server]Login failed for user 'administrator'

0
Positive_Coaching_Alliance
Asked:
Positive_Coaching_Alliance
  • 4
  • 4
1 Solution
 
Positive_Coaching_AllianceAuthor Commented:
(Continued)

Can someone please tell me why I am unable to connect?  I am able to make a Remote Desktop Connection to the Windows Server 2003 and I am able to run a SQL Server query from the server but I am not able to connect from a client.  BTW, the SQL Server 2005 database is being accessed from a web application that our remote users are able to access.

Your help into this issue would be greatly appreciated.

Thank you,

Vince
0
 
jwphillips80Commented:
the password for the dba (SQL Server) isn't the same as the domain administrator pasword.  You need to recall what the password was set to when installing SQL Server.

Hope this helps.
0
 
jwphillips80Commented:
Basically someone entered the wrong database password for the ODBC to use to connect to the SQL database.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Positive_Coaching_AllianceAuthor Commented:
Hi,

Thank you for your response.

When you refer to the 'dba' do you mean the password for 'sa' and what was defined during the installation of SQL Server 2005  Authentication Mode?  For the Authentication Mode I specified Mixed Mode (Windows and SQL Server Authentication).  

Thank you
0
 
jwphillips80Commented:
yes, what you defined for SQL server Authentication is generally used to authenticate the ODBC connection.
0
 
Positive_Coaching_AllianceAuthor Commented:
Hello,

I resolved my issue with the ODBC connection from my Windows XP Pro client to SQL Server 2005.  Dell tech support determined that the settings for the database engine remote connection was not activated.

Navigate to the utility SQL server 2005 Surface Area Configuration and enabled Local and Remote connection using Both TCP/IP and Named Pipes.  After the server and database were  rebooted I was able to define a System DSN from my client and used SQL Server Authentication and logged in as 'sa'.  ODBC connection from the client was confirmed by running the Test Data Source in the MS SQL Server Setup window.

Thanks everyone for you assistance on this issue.

Regards,

Vince
0
 
jwphillips80Commented:
Glad you found your answer.  Next time, hopefully we'll beat out the Dell support folks.  :)
0
 
Positive_Coaching_AllianceAuthor Commented:
Resolved with Dell Corpl
0
 
Computer101Commented:
Closed, 500 points refunded.
Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now