Added SP2 now have linked server error

I added SP2 to my 2005 server and now I can't connect to a previously working
linked Oracle server. I get this:
TITLE: Microsoft SQL Server Management Studio
"The test connection to the linked server failed."
Cannot initialize the data source object of OLE DB provider "MSDAORA" for
linked server "ISRSREPLICATEDLINK".
OLE DB provider "MSDAORA" for linked server "ISRSREPLICATEDLINK" returned
message "Error while trying to retrieve text for error ORA-01019
". (Microsoft SQL Server, Error: 7303)
What could have changed? Testing the connection via the ODBC works but
inside of SQL MAnagement Studio it fails.
Also somewhere in troubleshooting this I saw an error about unable to
allocate user side memory.
"TLuebke" wrote:

> I added SP2 to my 2005 server and now I can't connect to a previously working
> linked Oracle server. I get this:
> TITLE: Microsoft SQL Server Management Studio
> --
> "The test connection to the linked server failed."
> Cannot initialize the data source object of OLE DB provider "MSDAORA" for
> linked server "ISRSREPLICATEDLINK".
> OLE DB provider "MSDAORA" for linked server "ISRSREPLICATEDLINK" returned
> message "Error while trying to retrieve text for error ORA-01019
> ". (Microsoft SQL Server, Error: 7303)
> What could have changed? Testing the connection via the ODBC works but
> inside of SQL MAnagement Studio it fails.
>
>
|||TLuebke,
Have you tried reinstalling your Oracle provider? I did some research, but
no clear indication of what your problem is. One interesting thing is that
http://technet.microsoft.com/en-us/library/bb332055.aspx suggests using the
Oracle provider for OLE DB (OraOLEDB.Oracle.1) rather than MSDAORA, in case
that is useful to you.
RLF
"TLuebke" <TLuebke@.discussions.microsoft.com> wrote in message
news:57778530-E08D-46F2-ADD9-0D7D31236C74@.microsoft.com...[vbcol=seagreen]
> Also somewhere in troubleshooting this I saw an error about unable to
> allocate user side memory.
> "TLuebke" wrote:

Added SP2 now have linked server error

I added SP2 to my 2005 server and now I can't connect to a previously working
linked Oracle server. I get this:
TITLE: Microsoft SQL Server Management Studio
--
"The test connection to the linked server failed."
Cannot initialize the data source object of OLE DB provider "MSDAORA" for
linked server "ISRSREPLICATEDLINK".
OLE DB provider "MSDAORA" for linked server "ISRSREPLICATEDLINK" returned
message "Error while trying to retrieve text for error ORA-01019
". (Microsoft SQL Server, Error: 7303)
What could have changed? Testing the connection via the ODBC works but
inside of SQL MAnagement Studio it fails.Also somewhere in troubleshooting this I saw an error about unable to
allocate user side memory.
"TLuebke" wrote:
> I added SP2 to my 2005 server and now I can't connect to a previously working
> linked Oracle server. I get this:
> TITLE: Microsoft SQL Server Management Studio
> --
> "The test connection to the linked server failed."
> Cannot initialize the data source object of OLE DB provider "MSDAORA" for
> linked server "ISRSREPLICATEDLINK".
> OLE DB provider "MSDAORA" for linked server "ISRSREPLICATEDLINK" returned
> message "Error while trying to retrieve text for error ORA-01019
> ". (Microsoft SQL Server, Error: 7303)
> What could have changed? Testing the connection via the ODBC works but
> inside of SQL MAnagement Studio it fails.
>
>|||TLuebke,
Have you tried reinstalling your Oracle provider? I did some research, but
no clear indication of what your problem is. One interesting thing is that
http://technet.microsoft.com/en-us/library/bb332055.aspx suggests using the
Oracle provider for OLE DB (OraOLEDB.Oracle.1) rather than MSDAORA, in case
that is useful to you.
RLF
"TLuebke" <TLuebke@.discussions.microsoft.com> wrote in message
news:57778530-E08D-46F2-ADD9-0D7D31236C74@.microsoft.com...
> Also somewhere in troubleshooting this I saw an error about unable to
> allocate user side memory.
> "TLuebke" wrote:
>> I added SP2 to my 2005 server and now I can't connect to a previously
>> working
>> linked Oracle server. I get this:
>> TITLE: Microsoft SQL Server Management Studio
>> --
>> "The test connection to the linked server failed."
>> Cannot initialize the data source object of OLE DB provider "MSDAORA" for
>> linked server "ISRSREPLICATEDLINK".
>> OLE DB provider "MSDAORA" for linked server "ISRSREPLICATEDLINK" returned
>> message "Error while trying to retrieve text for error ORA-01019
>> ". (Microsoft SQL Server, Error: 7303)
>> What could have changed? Testing the connection via the ODBC works but
>> inside of SQL MAnagement Studio it fails.
>>
>>

Add Reporting Services to Trusted Accounts

I installed SQL 2005 SP2 and RS add-in for Sharepoint to a WSS 3.0 site.

I get the error: 'A connection to the server cannot be established' when I try to use the sharepoint account set up for this purpose. It is in the farm administrators, and has the required permissions when I check the database. Are there any other recommended troubleshooting tips that I can do? Thanks.

Dan

FYI - I resolved the problem by adding the account to the local group WSS_RESTRICTED_WPG. This account needs to be in the Local Administrator's group, and the groups starting with WSS.

Add Interactivity in exported Excel:Web report

Hi,

Specs:

I am using SSAS 2005, Excel 2003 (Office 2003 professional with sp2)

I browse the cube in SSAS 2005 BI studio and then export it to Excel.

This excel file provides interactivity, meaning that I double-click on a expandable cell , then excel issues a mdx query and retrieves the values.

Issues:

1. When I save this excel file, it displays that it is a read-only version and still allows me to save the excel file in the following formats: excel, web page (html and mhtml), xml file. Also it displays a checkbox for "Add Interactivity".

The saved web page (html or mhtml) or xml files do not provide interractivity. the reports are not able to expand cells or issue mdx queries. they allow to write on cells, but no double click.

How can I provide this?

I would want to save them as web pages, and then publish them to the web server.

2. The excel olap report that I exported yesterday, (excel 2003 file). like I mentioned before , give interactivity. but after I checked the same report after a day.

They are displaying the following error on double clicking or clicking on a drop down:

"xml for analysis parser: The xxxxxxx session id cannot be found. Either the session does not exist or it has already expired."

and clicking on 'Ok' it displays this message:

"Errors in the oledb provider. An error occured while loading the connection dialog box for prompting."

3. Do these excel olap reports provide the actions implemented in the cube?

I have created some drillthrough actions in the cube. how can I invoke them from the exported excel olap report?

We are planning to move from proclarity due to many of its rigidness. I feel that a software tool must provide for as much as customization as possible. If customization is not built in then it must atleast provide libbraries to write custom code and add on or modify existing funtionality. something similar to sharepoint.

although sharepoint from the face front seems rigid, it provides a lot of customizations. and as a last resort, if does not provide a built in customization method for something, you can pretty much hack into it and define whatever you want.

for example, in proclarity I want to allow multi select in the dropdown? Not possible at all. If I want users to double click and perform a defined 'action' , Not possible, proclarity displays all actions of all cells in a tab! if there are 100 actions , then users must search and select!

If i want the contents of one dropdown to depend on another using mdx. Not possible in proclarity.

I have a list of inconsistencies, which might not be the general usage for everybody, but in the world of software, How much can you really generalize?

Please do help in the excel questions....

Regards

Vijay,

1&2. When you save excel file, you have to find there publish button, and not use Save button. I do not have Excel 2003 in front ofme, but in Excel 2000, from Menu you have to choose "Save As Webpage" then "Publish", select Pivot Table then you click on "Add Interactivity with :" and select "Pivot table functionality". This will give you interactivity and no issues with session

3. No actions are implemented by default in excel. Microsoft has a code on their pages that you have to use to make drilltrough work.

Vidas Matelis

Add Interactivity in exported Excel:Web report

Hi,

Specs:

I am using SSAS 2005, Excel 2003 (Office 2003 professional with sp2)

I browse the cube in SSAS 2005 BI studio and then export it to Excel.

This excel file provides interactivity, meaning that I double-click on a expandable cell , then excel issues a mdx query and retrieves the values.

Issues:

1. When I save this excel file, it displays that it is a read-only version and still allows me to save the excel file in the following formats: excel, web page (html and mhtml), xml file. Also it displays a checkbox for "Add Interactivity".

The saved web page (html or mhtml) or xml files do not provide interractivity. the reports are not able to expand cells or issue mdx queries. they allow to write on cells, but no double click.

How can I provide this?

I would want to save them as web pages, and then publish them to the web server.

2. The excel olap report that I exported yesterday, (excel 2003 file). like I mentioned before , give interactivity. but after I checked the same report after a day.

They are displaying the following error on double clicking or clicking on a drop down:

"xml for analysis parser: The xxxxxxx session id cannot be found. Either the session does not exist or it has already expired."

and clicking on 'Ok' it displays this message:

"Errors in the oledb provider. An error occured while loading the connection dialog box for prompting."

3. Do these excel olap reports provide the actions implemented in the cube?

I have created some drillthrough actions in the cube. how can I invoke them from the exported excel olap report?

We are planning to move from proclarity due to many of its rigidness. I feel that a software tool must provide for as much as customization as possible. If customization is not built in then it must atleast provide libbraries to write custom code and add on or modify existing funtionality. something similar to sharepoint.

although sharepoint from the face front seems rigid, it provides a lot of customizations. and as a last resort, if does not provide a built in customization method for something, you can pretty much hack into it and define whatever you want.

for example, in proclarity I want to allow multi select in the dropdown? Not possible at all. If I want users to double click and perform a defined 'action' , Not possible, proclarity displays all actions of all cells in a tab! if there are 100 actions , then users must search and select!

If i want the contents of one dropdown to depend on another using mdx. Not possible in proclarity.

I have a list of inconsistencies, which might not be the general usage for everybody, but in the world of software, How much can you really generalize?

Please do help in the excel questions....

Regards

Vijay,

1&2. When you save excel file, you have to find there publish button, and not use Save button. I do not have Excel 2003 in front ofme, but in Excel 2000, from Menu you have to choose "Save As Webpage" then "Publish", select Pivot Table then you click on "Add Interactivity with :" and select "Pivot table functionality". This will give you interactivity and no issues with session

3. No actions are implemented by default in excel. Microsoft has a code on their pages that you have to use to make drilltrough work.

Vidas Matelis

add domain login from management studio

We have a SQL Server 2005 SP2 server that also functions as a
secondary domain controller in active directory. Everything works
extremely well except for 1 bug that was found today. Currently
windows authentication is the only method. When creating a new sql
login either physically at the server or through a remote desktop
connection the user is found in the domain and works just fine.
However when trying to do the same process using management studio
from a desktop connecting to the sql instance as soon as you try to
find the user in the domain you get this error: "The program cannot
open the required dialog box because it cannot determine whether the
computer name "COMPNAME" is joined to a domain."
I have sysadmin privileges on the sql server and if I use my login
name on the server physically I am able to create logins.
Any help would be greatly appreciated.
Thanks
MattI've previously posted a bug to connect.microsoft.com about this. Please go
there
(https://connect.microsoft.com/SQLSe...=126
183) and let them know of your problem.
--
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"Matt Ziegler" wrote:

> We have a SQL Server 2005 SP2 server that also functions as a
> secondary domain controller in active directory. Everything works
> extremely well except for 1 bug that was found today. Currently
> windows authentication is the only method. When creating a new sql
> login either physically at the server or through a remote desktop
> connection the user is found in the domain and works just fine.
> However when trying to do the same process using management studio
> from a desktop connecting to the sql instance as soon as you try to
> find the user in the domain you get this error: "The program cannot
> open the required dialog box because it cannot determine whether the
> computer name "COMPNAME" is joined to a domain."
> I have sysadmin privileges on the sql server and if I use my login
> name on the server physically I am able to create logins.
> Any help would be greatly appreciated.
> Thanks
> Matt
>|||The problem that you are having is that when the SQL GUI opens the dialog to
select a user, it defaults to the local machine. Because the machine is
running as a domain controller it has no local accounts, and no local accoun
t
database.
Please go to connect.microsoft.com
(https://connect.microsoft.com/SQLSe...=126
183) and post additional information reguarding the issue.
--
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"Matt Ziegler" wrote:

> We have a SQL Server 2005 SP2 server that also functions as a
> secondary domain controller in active directory. Everything works
> extremely well except for 1 bug that was found today. Currently
> windows authentication is the only method. When creating a new sql
> login either physically at the server or through a remote desktop
> connection the user is found in the domain and works just fine.
> However when trying to do the same process using management studio
> from a desktop connecting to the sql instance as soon as you try to
> find the user in the domain you get this error: "The program cannot
> open the required dialog box because it cannot determine whether the
> computer name "COMPNAME" is joined to a domain."
> I have sysadmin privileges on the sql server and if I use my login
> name on the server physically I am able to create logins.
> Any help would be greatly appreciated.
> Thanks
> Matt
>

Add article to Merge Repl. Publication

I am running merge replication (SQL 2000 with SP2) with an anonymous pull subscription. The application vendor has come out with update that requires adding a table to a database. The vendor has created scripts that will add the table, as well as some stored procedures. If I apply the scripts to both servers and add the table as a new article to the publication, am I going to have to apply a snapshot of the entire database (which is very large)?

Your help is greatly appreciated.

GaryHi, don't add the table to both sides. Just add the table at the publisher and include it in the publication using the ARTICLES tab of Replication-Properties in EM. Start the Snapshot-Agent. The merge agent would apply only the new table to the subscriber. It's for the subscribers running SQL2000.|||Thanks for the prompt reply. The scripts will also modify some stored procedures - is that handled by the snapshot, or are the changes just replicated?|||Hi, the merge-agent applies the new tables to the subscriber.
About stored-procedures i am not sure, can u modify the stored-procedure if it's being published? Published tables can't be modified unless we use sp_repladdcolumn/sp_repldropcolumn to add or drop columns within the published tables. See if u can modify a published stored procedure at the publisher.

Howdy!