SQL 2005 Express connection with Crystal XI

Question

SQL 2005 Express connection with Crystal XI

Charlie-120533

SSCrazy

Points: 2187
More actions
October 12, 2007 at 8:41 am

#182711

Hello folks - I need a little help with SQL 2005 Express and Crystal Reports XI. I have installed SQl and three databases on my desktop, and I have set myself up as DB owner in all databases. I can access everything through Management Studio Express, but when I try to make a new connection in Crystal, I get the following error using Integrated Security:
Failed to open the connection.
Details: ADO Error Code 0x80004005
Source: Microsoft OLE DB Provider for SQL Server
Description: Cannot open database 'CMS1'requested by the login. The login failed.
SQL State: 42000
Native Error: 4060 [Database Vendor Code:4060]
Using User ID and Password, the error is:
Logon Failed
Details: ADO Error Code 0x80004005
Source: Microsoft OLE DB Provider for SQL Server
Description: Login failed for user 'xyz\charlie'. The user is not associated with a trusted SQL Server connection
SQL State: 42000
Native Error:18452 [Database Vendor Code:18452 ]
Now, the odd part is that I can connect to ALL of the System databases (master, model, msdb, and tempdb) using the same connections through Crystal. Also, I can access these databases using Access without a problem.
I am running a Dell Optiplex 745 dual core, two gigs memory, XP Pro with SP2. The SQL 2005 is loaded on my desktop as is Crystal.
I'm sure it has to be a security setting somewhere, but I cannot seem to find it. I have looked through SSC but I can't find this particular problem.
Any help is appreciated.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Charlie-120533 SSCrazy Points: 2187 More actions · Answer 1

Hello, again. I figured out the problem and feel like a rookie! When I put in the server name, it needs the fully qualified name. Once I did that, everything else fell into place.

Thanks,

jdomit Newbie Points: 9 More actions · Answer 2

Hi. Charlie.

I have a problem that may be connected with your, but, I could not solve it.

The fact is, when the \sqlexpress server is installed in another computer of a win network, the client station (CR XI) cannot connect to it "unless" I install the sqlexpress on client's machine.

Have you an idea about which set of DLLs fault do do this connection normally?

The worst is that VB6 connect to it without a problem and access all data very fast. Problem shows only on running the crystal report itself or via vb6 call.

Thanks in advance.

sinker.simon SSC Enthusiast Points: 142 More actions · Answer 3

Hi there,

I'm getting exactly the same problem and I don't know how to solve it. I've tried a variety of different styles for the database e.g. "YOUR-56C1234567" and "YOUR-56C1234567\SQLEXPRESS". I've also tried my username "Simon" and "YOUR-56C1234567\Simon". What do you mean when you said you used the "fully qualified name"?

Regards,

Simon

sinker.simon SSC Enthusiast Points: 142 More actions · Answer 4

Hi Everyone,

Just to let you know I've solved the problem (with a spot of help!). Final solution was to use the full database name of "YOUR-56C1234567\SQLEXPRESS". I then clicked the tickbox for integrated security which meant I didn't need username and password. Finally I entered the database name in simple form e.g. "Customers" and that was it.

Hope this is helpful to someone out there.

Best wishes,

Simon