[Hussein39]

Hi there
i use Vitual stadio 2008 and i made a database using add items and then i selected Service based database that its extension is .mdf . my database name is db.mdf. so now i want to make a report using Crystal report. i selected crystal report from add items then i choose the using the report wizard and then standard and click ok. and in standard report creation wizard i was expanding OLE DB (ADO)and in OLE DB (ADO) Box i choose Microsoft OLE DB Provider for sql server not in connection information box. i wrote .\sqlexpress and chose integrated security and in front of Database i wrote DB.mdf and when i click finish its message that
Logon Failed.
Details: Ado error code: 0x
source: Microsoft OLE DB Provider for sql server
Description: Can not open database "DB.mdf" requested by the login. The login failed.
sql state: 42000
Native error.
thank you

[Sergio Tapia]

I'm not familiar with Crystal Reports, I've never used it for more than a little test.

Please post a screenshot of where you're choosing your credentials and setting the SQL Instance name. (Where you type in .\SQLEXPRESS)

You can also try typing in .\SQLEXPRESS instead of .\sqlexpress - I'm not sure if it's case sensitive.

Then there's something else you can do.

Go to the services window, and check what name your SQL server instance has. Maybe you put something else during installation and it's not the default SQLEXPRESS.

How to find your instance name?

[Hussein39]

Thank you my friend i could find the problem. i should have to attach my database but i didn't.

[Ionut]

If you connect to SQL Server with SqlServerManagementStudio using Windows Authentification, do you have access to your database(if it is attached)?

EDIT: ah..doesn't matter. Glad you figured it out

This post has been edited by Ionut: 04 May 2011 - 02:08 PM