help for starting SQL Express Manager 2005

Can anyone advise how I access SQL Express Manager ?

After starting Express Manager (preview 1) and selecting "Windows Authentication" I am asked for "Server Instance" What is meant by server Instance ?
Or with "SQL Server authentication" option selected I'm asked for name and passsword as well.

Is this something I ovelooked setting up when installing SQL 2005 Express ? I dont remember setting any passwords.

WHich option should I be going for ?

Have read accompanying documentation and looked on web but have not found a guide on this.

RECEIVED THIS REPLY TO MY QUERY ON ANOTHER THREAD

Hi,

SQL Server Express default instance which is the instance that gets created when you do not specify a name is installed as SQLExpress.

In Windows Authentication the current interactive Windows User is used for logging on so you just need to supply the instance name as .\SQLExpress or
MachineName\SQLExpress.

SQL Express also supports SQL Authentication. In case you want to take that route please go through the following post:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=62998
(Scrolll down to see the thread where I have provided the steps.)

Regards,
Vikram

.\SQLExpress - worked for me for the Windows Authentication - 0oseven

Help - Error when modifying dataset

I keep getting this error when I go to Preview the report. I have changed
the code for the report. then I pasted my new code in and adjusted all the
fields in the layout to respond to the new fields. But I can't get it to
Preview - I keep getting this error message.
The SortExpresssion expression for the table â'table1â' refers to the field
â'projectâ'. Report item expressions can only refer to fields within the
current data set scope or, if inside an aggregate, the specified data set
scope
Can anyone tell me how to correct this information to use my new code?
Thank you
Normad"NormaD" wrote:
> I keep getting this error when I go to Preview the report. I have changed
> the code for the report. then I pasted my new code in and adjusted all the
> fields in the layout to respond to the new fields. But I can't get it to
> Preview - I keep getting this error message.
> The SortExpresssion expression for the table â'table1â' refers to the field
> â'projectâ'. Report item expressions can only refer to fields within the
> current data set scope or, if inside an aggregate, the specified data set
> scope
> Can anyone tell me how to correct this information to use my new code?
> Thank you
> Normad
Thanks to any of you who were reading this to respond. I went into the XML
and did the changes.
normad