Results 1 to 6 of 6

Thread: problem with SQL server 2008(sp1 applied.) in windows 7 pro

  1. #1
    Join Date
    Nov 2002
    Location
    Chicago
    Posts
    39

    problem with SQL server 2008(sp1 applied.) in windows 7 pro

    Hi:

    Do you have any problem with SQL server 2008(sp1 applied.) in windows 7 pro?

    I have following problems:

    1. Query sometimes ran forever and did not return error though the query is perfectly fine
    Ex:
    select * from sales.salesperson
    Which is in adventureworks db?

    2. Some of functions disabled in reporting service
    Ex: Row Groups and column group
    .
    3. Report server configuration failed

    I want to know if it is the edition problem (mine is sql server 2008 evaluation edition 180 days trial) or

    Windows 7 compatibility problem or something else.

    Your inputs are welcome.

    Theresa

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    1. set profiler trace to find out what's going on.
    3. what was the error?

  3. #3
    Join Date
    Nov 2002
    Location
    Chicago
    Posts
    39
    no error, i just killed it after it ran 5 minutes. There are only 17 rows in that table.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Which one are you talking about? I asked error message for third issue.

  5. #5
    Join Date
    Nov 2002
    Location
    Chicago
    Posts
    39
    Hi,

    In IE, type following url
    http://computer_name/reportserver$instance_name/

    then following error return:

    HTTP Error 404.0 - Not Found
    The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

    Thanks.

    Theresa

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Again. For 1st issue: check if there's blocking or so with profiler.
    For RS, ensure RS service is running and url is correct.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •