Hi Diana..

Glad to know that it worked fine on your remote server..since you are running with windows authentication on your local server then try to remove the credentials from the query..and then run it..

As far as prompting the parameter is concerned..it should not ask it everytime..try to see your local settings..

Regards..

Samar