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:
SQL Server Error: 18456
[MicrosoftODBC SQL Server Driver][SQL Server]Login failed for user 'administrator'