Help opening .MDF file

I'm trying to follow the article

http://aspnet.4guysfromrolla.com/articles/031506-1.aspx. It gives a sample to download at the bottom which I did. I'm trying to take a look at the Stored Proc that were created in the PagingData.mdf. The only thing included in the App_Data folder is PagingData.mdf file. How can I open the DB or attach it to my SQL2005 server? There is no .ldf file included in thesample so the attaching is failing.

You have two possible options connect the MDF to Management Studio and see if you can access everything or Backup and Restore the database SQL Server will receate everything including stored procs and LDF. Hope this helps.

http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx

|||

You can attach the MDF file to the SQL Server 2005 by using the simple command

SP_ATTACH_DB <Give your DB Name, any name is fine>,<Location of the DB file>

and programatically you can connect to the MDF file using code as described in

http://ambarishganguly.blogspot.com/2006/10/sql-server-express-xcopy.html

Hope this helps.

Thanks

Ambarish

sql

Help needed for accessing Report server from an ASP.Net application

Hi experts,
I have an ASP.Net application by which we are calling our remote
report server.
Till then it is fine but when i am clicking on any report then a pop
up window comes and it is
asking for username and password to logon on report server.
I want to remove this popup login screen,
I have tried to pass the credentials both default and network but it
is still asking for
username and password.
I think one method which is in Web service 2005 is BeginLogon() or
Logon() will work if i will pass them
from my application
But i dont know how to implement them in my application.
Can any body send me some code for implementing them
or suggest anything which can help me to solve this issue.
Regards
DineshOn Mar 27, 2:46 am, "Dinesh" <dinesh...@.gmail.com> wrote:
> Hi experts,
> I have an ASP.Net application by which we are calling our remote
> report server.
> Till then it is fine but when i am clicking on any report then a pop
> up window comes and it is
> asking for username and password to logon on report server.
> I want to remove this popup login screen,
> I have tried to pass the credentials both default and network but it
> is still asking for
> username and password.
> I think one method which is in Web service 2005 is BeginLogon() or
> Logon() will work if i will pass them
> from my application
> But i dont know how to implement them in my application.
> Can any body send me some code for implementing them
> or suggest anything which can help me to solve this issue.
> Regards
> Dinesh
Just a couple of thoughts. I usually experience the authentication
window whenever I'm using a browser other than IE as my default
(namely, Firefox/Mozilla). Is this the case? Also, have you tried
setting the 'Windows integrated security' or 'Credentials stored
securely in the report server' and 'Use as Windows credentials when
connecting to the datasource' options in the Properties tab of the
particular report(s) in Report Manager?
Regards,
Enrique Martinez
Sr. Software Consultant|||Is the logon screen for your report server or your web server hosting
your application?|||On Apr 6, 11:38 pm, "Lynn" <linqian...@.gmail.com> wrote:
> Is the logon screen for your report server or your web server hosting
> your application?
Log on screen for my report server.
We are giving report viewer url in application. when it is calling the
report server then it is showing the log in scree and i want to remove
that so that after clicking on any report name it will directly
redirect to report server withous asking any user name and password.
Regards
Dinesh