how to set password when installing MSDE (was "Newbie to SQL")

Hi Guys,

I am Access user of both BE and FE. I would like to set my BE with SQL

Therefore, as trial I just downloaded MSDE2000A.Exe a Desktop SQL Engine from Microsoft. I need to install it. But due to some technical aspect (which I might not understand) I could not install it. Bcz whenever I am trying to install its setup file, it ask me a strong password. How to set it ? or how to supply it I dont know...

Any help.

Regards,
AshfaqueThis (http://support.microsoft.com/default.aspx?scid=kb;en-us;814463) is what you need (in English).

-PatP|||Thanks Pat,

I installed it successfully. The information page is good. Thanks.

Do you have any other referece web page that would show me how to transfer my Access table data over to this installed SQL server and allow my FE to be still in MS ACCESS.bcz I desined my beautiful forms and its code after a lot of excesize. What are the initial steps I must follow?

With kind regards,
Ashfafque|||I'd suggest using the Access Upsizing Wizard as a start. It isn't a complete solution, but it gives you one heck of a head start! Microsoft has a great "How to (http://support.microsoft.com/default.aspx?scid=kb;en-us;237980)", and there are versions for 2000 (http://support.microsoft.com/default.aspx?scid=kb;en-us;325017) and 2002 (http://support.microsoft.com/default.aspx?scid=kb;en-us;330468).

-PatP|||Again thanks Pat,

Article is very usefule. I will be back if face any problem.

With kind regards,
Ashfaque

How to set connection, Send Parameter and Filter data

Dear all .Netter,

I'm newbie in Reporting Services. I'm able to creating raw Reporting Services reports.

I have these questions to you all :

1. How to change connection to server and database when running in ASP.Net form. Currently in development PC, the server name is ServerA and the Database name is DatabaseA. After i copy to production server, the server name is ServerB and the database name is DatabaseB.

2. How to send parameter to Reporting Services report. I want to show name of user that print the report.

3. How to filter data that will be showed in the Reporting Services. I want to print Invoice with no : INV-2007-0001 and next INV-2007-0002

Sorry, if I'm lazy, but i'm running with time to replace Crystal Reports with Reporting Services.

Thanks and Regards,

Kusno.

These are some great links that will give you any answer you want

http://www.codeproject.com/sqlrs/AHCreatRepsAspNet.asp
http://msdn2.microsoft.com/en-us/library/ms170246.aspx
http://www.codeproject.com/sqlrs/ReportViewer2005.asp

Have Fun