• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1384
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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