Cannot export to excel from report manager

I'm reposting this since no one has answered and I'm finding other forums
where people are asking the same question and no answers to be found,
including when I asked the question. It seems like if I'm not the only
person seeing this error, someone, somewhere should have it documented.
I have a windows server 2003 box running in production with SQL Reporting
services, not sure of the version.
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."
We only get this error on some machines. Other machines work just fine.
They are all running against the production server. We do not get the error
when it's run against the dev server.I've run into problems with Excel export with two different scenarios:
- some of the controls in the report did not have the same language setting
as the report
- I'd used special Norwegian characters (like æøå)
I don't think the second scenario applies to you. :) But you might want to
make sure all the controls are in the same language. Just a stab in the
dark: Do you use User!Language for any reports or controls? In that case the
reports might work out on computers with the same language setting as the
server, but not if you run a different language.
Do the computers with errors have the same security settings in the browser
as the ones without error?
Kaisa M. Lindahl Lervik
"Valleri_Collins" <ValleriCollins@.discussions.microsoft.com> wrote in
message news:3FF0AABE-DE24-4941-B5C2-D7AE390391FE@.microsoft.com...
> I'm reposting this since no one has answered and I'm finding other forums
> where people are asking the same question and no answers to be found,
> including when I asked the question. It seems like if I'm not the only
> person seeing this error, someone, somewhere should have it documented.
> I have a windows server 2003 box running in production with SQL Reporting
> services, not sure of the version.
> 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."
> We only get this error on some machines. Other machines work just fine.
> They are all running against the production server. We do not get the
> error
> when it's run against the dev server.
>|||Between the two computers we've been working with, they are identical except
for one is running Windows 2K SP4 and the other is Win XP SP 2. All the
other settings are the same. The other thing we've found is that on a
different XP machine using the same image as the one we have the problem on,
if the user is given local admin rights the problem doesn't occur. However,
granting local admin rights to the user experiencing the issue did not
resolve the issue on her machine.
"Kaisa M. Lindahl Lervik" wrote:
> I've run into problems with Excel export with two different scenarios:
> - some of the controls in the report did not have the same language setting
> as the report
> - I'd used special Norwegian characters (like æøå)
> I don't think the second scenario applies to you. :) But you might want to
> make sure all the controls are in the same language. Just a stab in the
> dark: Do you use User!Language for any reports or controls? In that case the
> reports might work out on computers with the same language setting as the
> server, but not if you run a different language.
> Do the computers with errors have the same security settings in the browser
> as the ones without error?
> Kaisa M. Lindahl Lervik
> "Valleri_Collins" <ValleriCollins@.discussions.microsoft.com> wrote in
> message news:3FF0AABE-DE24-4941-B5C2-D7AE390391FE@.microsoft.com...
> > I'm reposting this since no one has answered and I'm finding other forums
> > where people are asking the same question and no answers to be found,
> > including when I asked the question. It seems like if I'm not the only
> > person seeing this error, someone, somewhere should have it documented.
> >
> > I have a windows server 2003 box running in production with SQL Reporting
> > services, not sure of the version.
> > 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."
> >
> > We only get this error on some machines. Other machines work just fine.
> > They are all running against the production server. We do not get the
> > error
> > when it's run against the dev server.
> >
>
>

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.

cannot edit this cell

when I fetch recods via enterprise manager and try to insert new
record I get the following error
"cannot edit this cell" but when I use "query analyzer" using T-sql commands I can execute DML operations .

it seems that there is no problem in the permissions ,I can not understand what is the problem .

can any one please help me it is very urgent since the problem is in one
of our production databases.

note that I use sql server 2000Your description does not sound this complicated - but check out the following article:

article (http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q288969&)|||Maybe the cell in the column is defined as an Identity column?|||give the sp_help 'tablename' and see the owner of the table may be it is the owners name through whch ur not entering to the table .

cannot edit text cell

I am trying to edit a long text cell in Enterprise Manager but when I select
"<long text>" and try to delete it, I get an error saying "cannot edit this
cell".

Could anyone tell me how to edit this cell?

Thanks, AmandaHi

When your text column has more than 900 characters it will not allow you to
enter it via EM.

You can use Query Analyser (which is usually easier and safer IMO) to issue
an update statement, or for more complicated changes look up UPDATETEXT in
books online.

John

"Amanda H" <amanda2@.southwind.org> wrote in message
news:K58Pd.1784$VI1.215392@.twister.southeast.rr.co m...
>I am trying to edit a long text cell in Enterprise Manager but when I
>select
> "<long text>" and try to delete it, I get an error saying "cannot edit
> this
> cell".
> Could anyone tell me how to edit this cell?
> Thanks, Amanda|||"Amanda H" <amanda2@.southwind.org> wrote in message
news:K58Pd.1784$VI1.215392@.twister.southeast.rr.co m...
>I am trying to edit a long text cell in Enterprise Manager but when I
>select
> "<long text>" and try to delete it, I get an error saying "cannot edit
> this
> cell".
> Could anyone tell me how to edit this cell?
> Thanks, Amanda

Use an UPDATE statement in Query Analyzer is probably the best thing to do -
EM isn't really a data manipulation or development tool, and it has a number
of 'features'.

http://www.aspfaq.com/show.asp?id=2455

Simonsql

Cannot edit RS reports...!

You need the Manage reports task. You can get this on a default report server installation by having the Content Manager role.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
--Original Message--
From: Kerc
Posted At: Wednesday, October 05, 2005 10:32 AM
Posted To: microsoft.public.sqlserver.reportingsvcs
Conversation: Cannot edit RS reports...!!!
Subject: Cannot edit RS reports...!!!
I'm new at using RS, so please bear with me...
I need to make small changes to existing reports. I'm able to execute
the reports and view the report list through the Report Manager, but I
don't ge the "Edit" options for the reports.
What security options must I have to be able to edit the reports?
Also, are the RDLs stored in the Catalog table? I ask because I can't
find an RDL on the report server to save my life...
Thanks!I just verified and I do have the "Content Manager" role. So far my
experience with RS has been pretty frustrating...

cannot delete database

Hello:
I am trying to delete a database from Enterprise Manager 2000 SP4. I am
right-clicking on the database and choosing delete.
But, SQL does not delete the database. It freezes up, in fact.
How can I delete this database? Actually, there are about 15 in total that
I need to delete. This one that I cannot delete is the first of those 15. I
imagine that I will have this same problem with the others.
Thanks!
childofthe1980s
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:9DE05088-641D-42B4-AC3B-2687C3F7D7AA@.microsoft.com...
> Hello:
> I am trying to delete a database from Enterprise Manager 2000 SP4. I am
> right-clicking on the database and choosing delete.
> But, SQL does not delete the database. It freezes up, in fact.
> How can I delete this database? Actually, there are about 15 in total
> that
> I need to delete. This one that I cannot delete is the first of those 15.
> I
> imagine that I will have this same problem with the others.
> Thanks!
> childofthe1980s
Don't use the GUI.
Use Query Analyzer and use DROP DATABASE 'foo'.
It should return with either the database dropped or a message that it is in
use.
use SP_who to find out who is using it and disconnect the clients or KILL
the spids.
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com
|||Rather than writing a cursor for killing the processes, I would use the
ALTER DATABASE command setting the user Mode to SINGLE_USER (or using the
administrative mode, otherwise the users or the applications will login
again) and use the ROLLBACK IMMEDIATE switch to change the status of the
database immediately. Be aware that current transactions are rolled back
then. If you want to have another behaviour, you should use another switch
instead (see the BOL for more information about that). AFterwards use the
DROP DATABASE command to wipe out the database.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:%23J%23tFYDZHHA.1240@.TK2MSFTNGP04.phx.gbl...
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:9DE05088-641D-42B4-AC3B-2687C3F7D7AA@.microsoft.com...
>
> Don't use the GUI.
> Use Query Analyzer and use DROP DATABASE 'foo'.
> It should return with either the database dropped or a message that it is
> in use.
> use SP_who to find out who is using it and disconnect the clients or KILL
> the spids.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting
> Email: sql (at) greenms.com http://www.greenms.com
>
|||Hello,
While you drop a database using enterprise manager, it deletes all the
Backup and Restore history informations from MSDB database. This
will take a long time being this deleted inside a cursor. So it would be
better to drop the databse using the TSQL command
DROP DATABASE <DBNAME>
Thanks
Hari
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:9DE05088-641D-42B4-AC3B-2687C3F7D7AA@.microsoft.com...
> Hello:
> I am trying to delete a database from Enterprise Manager 2000 SP4. I am
> right-clicking on the database and choosing delete.
> But, SQL does not delete the database. It freezes up, in fact.
> How can I delete this database? Actually, there are about 15 in total
> that
> I need to delete. This one that I cannot delete is the first of those 15.
> I
> imagine that I will have this same problem with the others.
> Thanks!
> childofthe1980s
sql

cannot delete database

Hello:
I am trying to delete a database from Enterprise Manager 2000 SP4. I am
right-clicking on the database and choosing delete.
But, SQL does not delete the database. It freezes up, in fact.
How can I delete this database? Actually, there are about 15 in total that
I need to delete. This one that I cannot delete is the first of those 15. I
imagine that I will have this same problem with the others.
Thanks!
childofthe1980s"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:9DE05088-641D-42B4-AC3B-2687C3F7D7AA@.microsoft.com...
> Hello:
> I am trying to delete a database from Enterprise Manager 2000 SP4. I am
> right-clicking on the database and choosing delete.
> But, SQL does not delete the database. It freezes up, in fact.
> How can I delete this database? Actually, there are about 15 in total
> that
> I need to delete. This one that I cannot delete is the first of those 15.
> I
> imagine that I will have this same problem with the others.
> Thanks!
> childofthe1980s
Don't use the GUI.
Use Query Analyzer and use DROP DATABASE 'foo'.
It should return with either the database dropped or a message that it is in
use.
use SP_who to find out who is using it and disconnect the clients or KILL
the spids.
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||Rather than writing a cursor for killing the processes, I would use the
ALTER DATABASE command setting the user Mode to SINGLE_USER (or using the
administrative mode, otherwise the users or the applications will login
again) and use the ROLLBACK IMMEDIATE switch to change the status of the
database immediately. Be aware that current transactions are rolled back
then. If you want to have another behaviour, you should use another switch
instead (see the BOL for more information about that). AFterwards use the
DROP DATABASE command to wipe out the database.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:%23J%23tFYDZHHA.1240@.TK2MSFTNGP04.phx.gbl...
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:9DE05088-641D-42B4-AC3B-2687C3F7D7AA@.microsoft.com...
>> Hello:
>> I am trying to delete a database from Enterprise Manager 2000 SP4. I am
>> right-clicking on the database and choosing delete.
>> But, SQL does not delete the database. It freezes up, in fact.
>> How can I delete this database? Actually, there are about 15 in total
>> that
>> I need to delete. This one that I cannot delete is the first of those
>> 15. I
>> imagine that I will have this same problem with the others.
>> Thanks!
>> childofthe1980s
>
> Don't use the GUI.
> Use Query Analyzer and use DROP DATABASE 'foo'.
> It should return with either the database dropped or a message that it is
> in use.
> use SP_who to find out who is using it and disconnect the clients or KILL
> the spids.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting
> Email: sql (at) greenms.com http://www.greenms.com
>|||Hello,
While you drop a database using enterprise manager, it deletes all the
Backup and Restore history informations from MSDB database. This
will take a long time being this deleted inside a cursor. So it would be
better to drop the databse using the TSQL command
DROP DATABASE <DBNAME>
Thanks
Hari
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:9DE05088-641D-42B4-AC3B-2687C3F7D7AA@.microsoft.com...
> Hello:
> I am trying to delete a database from Enterprise Manager 2000 SP4. I am
> right-clicking on the database and choosing delete.
> But, SQL does not delete the database. It freezes up, in fact.
> How can I delete this database? Actually, there are about 15 in total
> that
> I need to delete. This one that I cannot delete is the first of those 15.
> I
> imagine that I will have this same problem with the others.
> Thanks!
> childofthe1980s

cannot delete database

Hello:
I am trying to delete a database from Enterprise Manager 2000 SP4. I am
right-clicking on the database and choosing delete.
But, SQL does not delete the database. It freezes up, in fact.
How can I delete this database? Actually, there are about 15 in total that
I need to delete. This one that I cannot delete is the first of those 15.
I
imagine that I will have this same problem with the others.
Thanks!
childofthe1980s"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:9DE05088-641D-42B4-AC3B-2687C3F7D7AA@.microsoft.com...
> Hello:
> I am trying to delete a database from Enterprise Manager 2000 SP4. I am
> right-clicking on the database and choosing delete.
> But, SQL does not delete the database. It freezes up, in fact.
> How can I delete this database? Actually, there are about 15 in total
> that
> I need to delete. This one that I cannot delete is the first of those 15.
> I
> imagine that I will have this same problem with the others.
> Thanks!
> childofthe1980s
Don't use the GUI.
Use Query Analyzer and use DROP DATABASE 'foo'.
It should return with either the database dropped or a message that it is in
use.
use SP_who to find out who is using it and disconnect the clients or KILL
the spids.
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||Rather than writing a cursor for killing the processes, I would use the
ALTER DATABASE command setting the user Mode to SINGLE_USER (or using the
administrative mode, otherwise the users or the applications will login
again) and use the ROLLBACK IMMEDIATE switch to change the status of the
database immediately. Be aware that current transactions are rolled back
then. If you want to have another behaviour, you should use another switch
instead (see the BOL for more information about that). AFterwards use the
DROP DATABASE command to wipe out the database.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:%23J%23tFYDZHHA.1240@.TK2MSFTNGP04.phx.gbl...
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:9DE05088-641D-42B4-AC3B-2687C3F7D7AA@.microsoft.com...
>
> Don't use the GUI.
> Use Query Analyzer and use DROP DATABASE 'foo'.
> It should return with either the database dropped or a message that it is
> in use.
> use SP_who to find out who is using it and disconnect the clients or KILL
> the spids.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting
> Email: sql (at) greenms.com http://www.greenms.com
>|||Hello,
While you drop a database using enterprise manager, it deletes all the
Backup and Restore history informations from MSDB database. This
will take a long time being this deleted inside a cursor. So it would be
better to drop the databse using the TSQL command
DROP DATABASE <DBNAME>
Thanks
Hari
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:9DE05088-641D-42B4-AC3B-2687C3F7D7AA@.microsoft.com...
> Hello:
> I am trying to delete a database from Enterprise Manager 2000 SP4. I am
> right-clicking on the database and choosing delete.
> But, SQL does not delete the database. It freezes up, in fact.
> How can I delete this database? Actually, there are about 15 in total
> that
> I need to delete. This one that I cannot delete is the first of those 15.
> I
> imagine that I will have this same problem with the others.
> Thanks!
> childofthe1980s

Cannot create table: SSMS Hangs

I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
My machine is:
2.6 GH with 512 of RAM.
Win XP proffessional
SQL Server 2005 Developer edition
..Net 2.0 & VS.NET 2005 proffesional edition.
I have been using it for about a months without problems (except that it's
slow). Here are the steps that I took:
Opened SSMS
Created a new database called test
Clicked on new table and got the Design view of the new table
Added the first column, "ID" of type int
Click Save
I got prompted to enter the table name
I selected the default table name Table_1
then it hangs.
I have no idea why this is happeneing, nothing upnormal in the application
log...I got plenty of disk space... don't know why this is happening.
thanks,
Tamer
I was able to create the table remotly from another SSMS on another machine
on the network. I guess I will have to reinstall SSMS.
thanks,
Tamer
"Tamer Yousef" wrote:

> I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
> watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
> My machine is:
> 2.6 GH with 512 of RAM.
> Win XP proffessional
> SQL Server 2005 Developer edition
> .Net 2.0 & VS.NET 2005 proffesional edition.
> I have been using it for about a months without problems (except that it's
> slow). Here are the steps that I took:
> Opened SSMS
> Created a new database called test
> Clicked on new table and got the Design view of the new table
> Added the first column, "ID" of type int
> Click Save
> I got prompted to enter the table name
> I selected the default table name Table_1
> then it hangs.
> I have no idea why this is happeneing, nothing upnormal in the application
> log...I got plenty of disk space... don't know why this is happening.
> thanks,
> Tamer

Cannot create table: SSMS Hangs

I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
My machine is:
2.6 GH with 512 of RAM.
Win XP proffessional
SQL Server 2005 Developer edition
.Net 2.0 & VS.NET 2005 proffesional edition.
I have been using it for about a months without problems (except that it's
slow). Here are the steps that I took:
Opened SSMS
Created a new database called test
Clicked on new table and got the Design view of the new table
Added the first column, "ID" of type int
Click Save
I got prompted to enter the table name
I selected the default table name Table_1
then it hangs.
I have no idea why this is happeneing, nothing upnormal in the application
log...I got plenty of disk space... don't know why this is happening.
thanks,
TamerI was able to create the table remotly from another SSMS on another machine
on the network. I guess I will have to reinstall SSMS.
thanks,
Tamer
"Tamer Yousef" wrote:

> I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
> watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU
.
> My machine is:
> 2.6 GH with 512 of RAM.
> Win XP proffessional
> SQL Server 2005 Developer edition
> .Net 2.0 & VS.NET 2005 proffesional edition.
> I have been using it for about a months without problems (except that it's
> slow). Here are the steps that I took:
> Opened SSMS
> Created a new database called test
> Clicked on new table and got the Design view of the new table
> Added the first column, "ID" of type int
> Click Save
> I got prompted to enter the table name
> I selected the default table name Table_1
> then it hangs.
> I have no idea why this is happeneing, nothing upnormal in the application
> log...I got plenty of disk space... don't know why this is happening.
> thanks,
> Tamersql

Cannot create table: SSMS Hangs

I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
My machine is:
2.6 GH with 512 of RAM.
Win XP proffessional
SQL Server 2005 Developer edition
.Net 2.0 & VS.NET 2005 proffesional edition.
I have been using it for about a months without problems (except that it's
slow). Here are the steps that I took:
Opened SSMS
Created a new database called test
Clicked on new table and got the Design view of the new table
Added the first column, "ID" of type int
Click Save
I got prompted to enter the table name
I selected the default table name Table_1
then it hangs.
I have no idea why this is happeneing, nothing upnormal in the application
log...I got plenty of disk space... don't know why this is happening.
thanks,
TamerI was able to create the table remotly from another SSMS on another machine
on the network. I guess I will have to reinstall SSMS.
thanks,
Tamer
"Tamer Yousef" wrote:
> I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
> watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
> My machine is:
> 2.6 GH with 512 of RAM.
> Win XP proffessional
> SQL Server 2005 Developer edition
> .Net 2.0 & VS.NET 2005 proffesional edition.
> I have been using it for about a months without problems (except that it's
> slow). Here are the steps that I took:
> Opened SSMS
> Created a new database called test
> Clicked on new table and got the Design view of the new table
> Added the first column, "ID" of type int
> Click Save
> I got prompted to enter the table name
> I selected the default table name Table_1
> then it hangs.
> I have no idea why this is happeneing, nothing upnormal in the application
> log...I got plenty of disk space... don't know why this is happening.
> thanks,
> Tamer

Cannot create subscription in with Report Manager

While on the Report Delivery Options page if I click "Select Schedule" or
"OK" nothing happens; no error message, no postback, nothing in the logs,
nothing in a SQL Trace. I cannot create a File Share nor an e-mail
subcription.
I am able to programmaticaly (using ReportServer WebService and
ASP.NET/VB.NET) create a subscription but not with the Report Manager. Any
ideas?have you checked who you are logged into report manager as. What user. do
they have permissions to create a schedule?
"mbianco21" wrote:
> While on the Report Delivery Options page if I click "Select Schedule" or
> "OK" nothing happens; no error message, no postback, nothing in the logs,
> nothing in a SQL Trace. I cannot create a File Share nor an e-mail
> subcription.
> I am able to programmaticaly (using ReportServer WebService and
> ASP.NET/VB.NET) create a subscription but not with the Report Manager. Any
> ideas?sql

Cannot create new roles for users or groups as well as folders

Good afternoon,
I cannot seem to create or modify both roles and folders in Report Manager.
When I click on OK in the form to create or modify existing items nothing
happens. Am I forgetting something?
I had an issue during the installation or RS that may weigh in... the
installation of RS would fail at the final phase and give me an error (25619
- KB Article 867872). There is a knowledgebase article for this. It details
using a parameter to not create the virtual folders for Reports and
ReportServer and how to create the virtual folders and it's permissions
afterwards. This completed the installation and everything else, aside from
this issue, appears to be operatin normally.
Specs:
Windows Server 2003
SQL Server 2000 w/ SP3
SQL RS w/ SP1Disregard... another thread gave me the answer:
on the server run:
aspnet_regiis -c
from the .Net framwork dir.
"Peter Capazzi" wrote:
> Good afternoon,
> I cannot seem to create or modify both roles and folders in Report Manager.
> When I click on OK in the form to create or modify existing items nothing
> happens. Am I forgetting something?
> I had an issue during the installation or RS that may weigh in... the
> installation of RS would fail at the final phase and give me an error (25619
> - KB Article 867872). There is a knowledgebase article for this. It details
> using a parameter to not create the virtual folders for Reports and
> ReportServer and how to create the virtual folders and it's permissions
> afterwards. This completed the installation and everything else, aside from
> this issue, appears to be operatin normally.
> Specs:
> Windows Server 2003
> SQL Server 2000 w/ SP3
> SQL RS w/ SP1
>

Cannot create linked server

I cannot create a linked to a MySql database in Enterprise Manager. Here is the relevant info:

Trying to create a linked server on a SQL Server 2000 Standard Edition Service Pack 4 running on a Windows 2000 Standard Edition server.

The MySQL server is running on Red Hat - not sure of the DB or OS version. However the DSN I created connects to the server correctly. I can connect using any of the MySQL tools.

I am using the latest ODBC MySQL drive 3.51...Here is the Provider string I am using...

DRIVER={MySQL ODBC 3.51 Driver} ;SERVER=192.168.1.99;DATABASE=bug_tracker; USER=UserID; PASSWORD=Password; OPTION=3

I have also tried using a System DSN to connect with, but that does not work either. It appears to create the linked server correctly each time, but I cannot access any of the tables. Here is the error message I get each time:

Error 7399: OLE DB Provider 'MSDASQL' reported an error. Datasource name not found and no default driver specified] OLD DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ]

Sure could use a little help!

Thanks!!!!

Brad Feaker

Please reply to forum only! Thanks!

Try:

EXEC sp_addlinkedserver 'mysql', '', 'MSDASQL', 'your_system_dsn'

EXEC sp_addlinkedsrvlogin 'mysql', 'false', null, 'userid', 'pwd'|||Sorry - have already tried that too. Same error message.

Thanks for your help!

Brad
Ex Nihilo, Nihil Fit|||

There are two possibilities:

1. Incorrect provider-string
2. Incorrect linked server setup

To isolate the issue, try to use the provider string with OPENROWSET syntax. If this works, then try to create a new linked server definition with appropriate login mappings.

|||

Brad,

Sorry, I do not use mySQL so cannot be of much help as far as the correct provider/library.

However, this KB looks like a solution to your problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;814398

Cannot create linked server

I cannot create a linked to a MySql database in Enterprise Manager. Here is the relevant info:

Trying to create a linked server on a SQL Server 2000 Standard Edition Service Pack 4 running on a Windows 2000 Standard Edition server.

The MySQL server is running on Red Hat - not sure of the DB or OS version. However the DSN I created connects to the server correctly. I can connect using any of the MySQL tools.

I am using the latest ODBC MySQL drive 3.51...Here is the Provider string I am using...

DRIVER={MySQL ODBC 3.51 Driver} ;SERVER=192.168.1.99;DATABASE=bug_tracker; USER=UserID; PASSWORD=Password; OPTION=3

I have also tried using a System DSN to connect with, but that does not work either. It appears to create the linked server correctly each time, but I cannot access any of the tables. Here is the error message I get each time:

Error 7399: OLE DB Provider 'MSDASQL' reported an error. Datasource name not found and no default driver specified] OLD DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ]

Sure could use a little help!

Thanks!!!!

Brad Feaker

Please reply to forum only! Thanks!

Try:

EXEC sp_addlinkedserver 'mysql', '', 'MSDASQL', 'your_system_dsn'

EXEC sp_addlinkedsrvlogin 'mysql', 'false', null, 'userid', 'pwd'|||Sorry - have already tried that too. Same error message.

Thanks for your help!

Brad
Ex Nihilo, Nihil Fit
|||

There are two possibilities:

1. Incorrect provider-string
2. Incorrect linked server setup

To isolate the issue, try to use the provider string with OPENROWSET syntax. If this works, then try to create a new linked server definition with appropriate login mappings.

|||

Brad,

Sorry, I do not use mySQL so cannot be of much help as far as the correct provider/library.

However, this KB looks like a solution to your problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;814398

Cannot create linked server

I posted this in the Data Access forum already - may have been the wrong place...

I cannot create a linked to a MySql database in Enterprise Manager. Here is the relevant info:

Trying to create a linked server on a SQL Server 2000 Standard Edition Service Pack 4 running on a Windows 2000 Standard Edition server.

The MySQL server is running on Red Hat - not sure of the DB or OS version. However the DSN I created connects to the server correctly. I can connect using any of the MySQL tools.

I am using the latest ODBC MySQL drive 3.51...Here is the Provider string I am using...

DRIVER={MySQL ODBC 3.51 Driver} ;SERVER=192.168.1.99;DATABASE=bug_tracker; USER=UserID; PASSWORD=Password; OPTION=3

I have also tried using a System DSN to connect with, but that does not work either. It appears to create the linked server correctly each time, but I cannot access any of the tables. Here is the error message I get each time:

Error 7399: OLE DB Provider 'MSDASQL' reported an error. Datasource name not found and no default driver specified] OLD DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ]

Sure could use a little help!

Thanks!!!!

Brad Feaker

Please reply to forum only! Thanks!

Seems like no one else knows jack about this either!
|||

try this

Go to security/Linked Servers
Right Click on Linked Servers--> New Linked Server

Go to security/Linked Servers
Right Click on Linked Servers--> New Linked Server

Use Microsoft OLE DB Provider for ODBC Drivers

Use the Connection String
DRIVER={MySQL ODBC 3.51
Driver};SERVER=myserver.com;DATABASE=database;USER
=user;PASSWORD=password;OPTION=3

And in Provider Options select:

level zero only
Non-transacted updates (something)
Allow InProcess

let me know if you still get an error

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Still getting the same error :-( BTW - I bookmarked your blog. You have some good stuff there. Thanks for the effort. I will keep trying - Almost no experience with MySQL...

Brad
Ex Nihilo, Nihil Fit
|||

Do you have the MySQL Connector/ODBC 3.51 installed?

get it here-->http://dev.mysql.com/downloads/connector/odbc/3.51.html

also from a query window, does this work for you?

SELECT a.*
FROM OPENROWSET('MSDASQL',
'DRIVER={MySQL ODBC 3.51 Driver};SERVER=192.168.1.99;DATABASE=bug_tracker;user=UserID;PASSWORD=Password;OPTION=3',
TestDB ) AS a

change TestDB to your table name

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Yes - I have the latest driver installed - the OPENROWSET query give me the same error message as the linked server. I can open the MySQL Query Browser, connect and run queries with no problem. I just cannot seem to get a linked server to work with SQL Server 2000. This is really frustrating. If I can't get this set up, I am going to have to use DTS and write some real heavy-duty scripts as these tables are going to feed a data warehouse in Analysis Services. It also makes me feel pretty stupid because I cannot get it to work. Back to the drawing board and thanks for your help.

Brad
Ex Nihilo, Nihil Fit
|||

The driver is installed on the SQL server box right?

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Got it fixed finally...Thanks for everyone's help!
|||

I am having a similar problem with SSIS pulling data from MySQL

How did you get it fixed?

Thanks

-Raghu Raman

|||

Hi everybody, I have the same problem that has been treated here, but none of the solutions offered has been good for me.

Does anybody have any help respect to the problem with the linked server?

Thanks, blessings.

Cannot create linked server

I posted this in the Data Access forum already - may have been the wrong place...

I cannot create a linked to a MySql database in Enterprise Manager. Here is the relevant info:

Trying to create a linked server on a SQL Server 2000 Standard

Edition Service Pack 4 running on a Windows 2000 Standard Edition

server.

The MySQL server is running on Red Hat - not sure of the DB or OS

version. However the DSN I created connects to the server correctly.

I can connect using any of the MySQL tools.

I am using the latest ODBC MySQL drive 3.51...Here is the Provider string I am using...

DRIVER={MySQL ODBC 3.51 Driver} ;SERVER=192.168.1.99;DATABASE=bug_tracker; USER=UserID; PASSWORD=Password; OPTION=3

I have also tried using a System DSN to connect with, but that does

not work either. It appears to create the linked server correctly each

time, but I cannot access any of the tables. Here is the error

message I get each time:

Error 7399: OLE DB Provider 'MSDASQL' reported an error. Datasource

name not found and no default driver specified] OLD DB error trace

[OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned

0x80004005: ]

Sure could use a little help!

Thanks!!!!

Brad Feaker

Please reply to forum only! Thanks!

Seems like no one else knows jack about this either!|||

try this

Go to security/Linked Servers
Right Click on Linked Servers--> New Linked Server

Go to security/Linked Servers
Right Click on Linked Servers--> New Linked Server

Use Microsoft OLE DB Provider for ODBC Drivers

Use the Connection String
DRIVER={MySQL ODBC 3.51
Driver};SERVER=myserver.com;DATABASE=database;USER
=user;PASSWORD=password;OPTION=3

And in Provider Options select:

level zero only
Non-transacted updates (something)
Allow InProcess

let me know if you still get an error

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Still getting the same error :-( BTW - I bookmarked your blog. You have some good stuff there. Thanks for the effort. I will keep trying - Almost no experience with MySQL...

Brad
Ex Nihilo, Nihil Fit|||

Do you have the MySQL Connector/ODBC 3.51 installed?

get it here-->http://dev.mysql.com/downloads/connector/odbc/3.51.html

also from a query window, does this work for you?

SELECT a.*
FROM OPENROWSET('MSDASQL',
'DRIVER={MySQL ODBC 3.51 Driver};SERVER=192.168.1.99;DATABASE=bug_tracker;user=UserID;PASSWORD=Password;OPTION=3',
TestDB ) AS a

change TestDB to your table name

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Yes - I have the latest driver installed - the OPENROWSET query give me the same error message as the linked server. I can open the MySQL Query Browser, connect and run queries with no problem. I just cannot seem to get a linked server to work with SQL Server 2000. This is really frustrating. If I can't get this set up, I am going to have to use DTS and write some real heavy-duty scripts as these tables are going to feed a data warehouse in Analysis Services. It also makes me feel pretty stupid because I cannot get it to work. Back to the drawing board and thanks for your help.

Brad
Ex Nihilo, Nihil Fit|||

The driver is installed on the SQL server box right?

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Got it fixed finally...Thanks for everyone's help!|||

I am having a similar problem with SSIS pulling data from MySQL

How did you get it fixed?

Thanks

-Raghu Raman

|||

Hi everybody, I have the same problem that has been treated here, but none of the solutions offered has been good for me.

Does anybody have any help respect to the problem with the linked server?

Thanks, blessings.

Cannot create a connection to data source 'myservername'.

No matter how many times I redeploy my report and data sources from my
project to Report Manager, I keep getting this error when trying to run
the report from Reprt manager. It runs fine in VS 2005 though. I
don't know what else to do. I see no way to delete the report from
Report Manager in attempts to try to redeploy it from scratch either.
"An error has occurred during report processing.
Cannot create a connection to data source 'myservername'.
For more information about this error navigate to the report server on
the local server machine, or enable remote errors "In report manager on the datasource properties, credentials tab and set the
credentials to be used. Then when deploying do not overwirte the datasource
(this is the default behavior, to not overwrite the source).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dba123" <d_schinkel@.hotmail.com> wrote in message
news:1141683199.061931.270510@.u72g2000cwu.googlegroups.com...
> No matter how many times I redeploy my report and data sources from my
> project to Report Manager, I keep getting this error when trying to run
> the report from Reprt manager. It runs fine in VS 2005 though. I
> don't know what else to do. I see no way to delete the report from
> Report Manager in attempts to try to redeploy it from scratch either.
>
> "An error has occurred during report processing.
> Cannot create a connection to data source 'myservername'.
> For more information about this error navigate to the report server on
> the local server machine, or enable remote errors "
>

Cannot create a connection to data source 'mydatasourcename'.

No matter how many times I redeploy my report and data sources from my project to Report Manager, I keep getting this error when trying to run the report from Reprt manager. It runs fine in VS 2005 though. I don't know what else to do. I see no way to delete the report from Report Manager in attempts to try to redeploy it from scratch either.

An error has occurred during report processing.

Cannot create a connection to data source 'myservername'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Report manager has an icon in the toolbar to toggle between list view (default view) and detail view. In the detail view, you can select a report and delete it.

One reason why the connection could fail is that you are using Windows Integrated Security, but Kerberos is not set up for delegation.

-- Robert

|||I'm having the same problem. But how do I fix it without deleting my reports?|||

If your report server and the database used to get report data are not on the same machine,

1. Enable Kerberos protocol so that credentials can be delegated to other computers without limit.

2. If enabling Kerberos is not an option, consider using either stored credentials or a combination of Windows Authentication and database authentication. For example, you can use Windows Authentication to connect a client to a report server, and then configure the report to use database authentication to access an external data source. For this use a specific username and password in the credentials tab of data source designer. The report server will use the specific credential to access the database server.

Another option is to locate the report data sources on the same computer that hosts the report server.

Cannot create a connection to data source 'mydatasourcename'.

No matter how many times I redeploy my report and data sources from my project to Report Manager, I keep getting this error when trying to run the report from Reprt manager. It runs fine in VS 2005 though. I don't know what else to do. I see no way to delete the report from Report Manager in attempts to try to redeploy it from scratch either.

An error has occurred during report processing.

Cannot create a connection to data source 'myservername'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Report manager has an icon in the toolbar to toggle between list view (default view) and detail view. In the detail view, you can select a report and delete it.

One reason why the connection could fail is that you are using Windows Integrated Security, but Kerberos is not set up for delegation.

-- Robert

|||I'm having the same problem. But how do I fix it without deleting my reports?|||

If your report server and the database used to get report data are not on the same machine,

1. Enable Kerberos protocol so that credentials can be delegated to other computers without limit.

2. If enabling Kerberos is not an option, consider using either stored credentials or a combination of Windows Authentication and database authentication. For example, you can use Windows Authentication to connect a client to a report server, and then configure the report to use database authentication to access an external data source. For this use a specific username and password in the credentials tab of data source designer. The report server will use the specific credential to access the database server.

Another option is to locate the report data sources on the same computer that hosts the report server.