Showing posts with label download. Show all posts
Showing posts with label download. Show all posts

Thursday, March 29, 2012

Cannot export to Excel from Report Manager

When attempting to export to Excel from report manager we get the error
"Internet Explorer cannot download Format=Ecels from reports.server"
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or cannot be found. Please try again later."
This only happens when the person accessing reports manager is not a local
administrator. Local administrator privileges make the problem go away.
What is report manager trying to access that I need to give my user access
to? I cannot make the user a local admin.The problem does not just occur if exporting to excel. It's all file types.
Any file type we try to export to from report manager kicks back essentially
the same error we were getting when trying to export to excel. Oddly enough,
the development server which uses 2k3 server doesn't do this. The production
server that is running Server 2K does.
"Valleri_Collins" wrote:
> When attempting to export to Excel from report manager we get the error
> "Internet Explorer cannot download Format=Excel from reports.server"
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or cannot be found. Please try again later."
> This only happens when the person accessing reports manager is not a local
> administrator. Local administrator privileges make the problem go away.
> What is report manager trying to access that I need to give my user access
> to? I cannot make the user a local admin.

Wednesday, March 7, 2012

cannot connect with JDBC to express 2005

Hi all,

I try to connect with a java application to a freshly download SQL server express 2005, but I cannot anything I do.

If I try with the following string "10.0.0.82:1433;databaseName=flavio;user=f.palumbo;" I get this message :

java.sql.SQLException: Impossibile eseguire l'accesso per l'utente 'f.palumbo'. L'utente non è associato a una connessione SQL Server trusted.

If I try with this string "localhost:1433/flavio" I get this message :

com.microsoft.sqlserver.jdbc.SQLServerException: Il numero di porta 1433/flavio non è valido.

So I'm getting crazy to find out a solution ... can somebody help me?

Thanks a lot

Flavio

The first error says that f.palumbo user is not associated with a trusted user. Are you sure you have added the user using the sql express surface administrator to the server. The second syntax you are using is invalid. You cant do localhost:1433/flavio to get to the database flavio.

|||

Also, to troubleshoot express issues you may look at here:

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

|||

Hi thanks for your reply,

but about your "Are you sure you have added the user using the sql express surface administrator to the server" the answer is "no I'm not sure at all".

Sorry, I'm sure a newbie, but I cannot find a user administration tool in the place you say ; can you please give a more detailed path to do this work ?

Thanks a lot

Flavio

cannot connect with JDBC to express 2005

Hi all,

I try to connect with a java application to a freshly download SQL server express 2005, but I cannot anything I do.

If I try with the following string "10.0.0.82:1433;databaseName=flavio;user=f.palumbo;" I get this message :

java.sql.SQLException: Impossibile eseguire l'accesso per l'utente 'f.palumbo'. L'utente non è associato a una connessione SQL Server trusted.

If I try with this string "localhost:1433/flavio" I get this message :

com.microsoft.sqlserver.jdbc.SQLServerException: Il numero di porta 1433/flavio non è valido.

So I'm getting crazy to find out a solution ... can somebody help me?

Thanks a lot

Flavio

The first error says that f.palumbo user is not associated with a trusted user. Are you sure you have added the user using the sql express surface administrator to the server. The second syntax you are using is invalid. You cant do localhost:1433/flavio to get to the database flavio.

|||

Also, to troubleshoot express issues you may look at here:

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

|||

Hi thanks for your reply,

but about your "Are you sure you have added the user using the sql express surface administrator to the server" the answer is "no I'm not sure at all".

Sorry, I'm sure a newbie, but I cannot find a user administration tool in the place you say ; can you please give a more detailed path to do this work ?

Thanks a lot

Flavio