Only one of our users is getting this error
unable to load client print control
She was able to print fine before, any idea why this is happening.
I guess you have to allow your browser to download ActiveX controls because print control is an activex object. If your browser is Interner Explorer, try setting it in Tools menu -> Internet Options -> Security tab -> Custom Level button. Then enable all options related to downloading or prompting for activex controls.
Shyam
Hi everyone,
Primary platform is Framework 2.0 and Sql25k 64-bit
When I try to save my DTSX package from my client to the production server I get this error:
"No Description found"
Either Windows or Sql authentication.
Does anyone have ever faced this drawback?
Thanks in advance,
Any idea?
Is something related to Visio 2003? http://support.microsoft.com/kb/922546
Thanks again,
I have an SQL Server 2005 installed on Windows 2003 64 bit server (no itanium)
I have a 32 bit client where I run Management Studio.
This is the full detail of the error:
--
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
--
I have tried installing a new 64bit Jet driver, but it only exists for Itanium.
How to force the system to use the 32 bit one?
I am stuck!The is no way to use Jet driver from a 64-bit SQL Server unfortunately. They did not port the driver to 64-bit. So this would only work from a 32-bit SQL Server.|||xxx|||You can force the SQL Server Agent to execute the 32-bit version of DTExec by setting up the job as a CmdExec task instead of an SSIS package call, as detailed here:
http://wiki.sqlis.com/default.aspx/SQLISWiki/x64.html?diff=y
I have an SQL Server 2005 installed on Windows 2003 64 bit server (no itanium)
I have a 32 bit client where I run Management Studio.
This is the full detail of the error:
--
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
--
I have tried installing a new 64bit Jet driver, but it only exists for Itanium.
How to force the system to use the 32 bit one?
I am stuck!The is no way to use Jet driver from a 64-bit SQL Server unfortunately. They did not port the driver to 64-bit. So this would only work from a 32-bit SQL Server.|||xxx|||You can force the SQL Server Agent to execute the 32-bit version of DTExec by setting up the job as a CmdExec task instead of an SSIS package call, as detailed here:
http://wiki.sqlis.com/default.aspx/SQLISWiki/x64.html?diff=y
I have an SQL Server 2005 installed on Windows 2003 64 bit server (no itanium)
I have a 32 bit client where I run Management Studio.
This is the full detail of the error:
--
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
--
I have tried installing a new 64bit Jet driver, but it only exists for Itanium.
How to force the system to use the 32 bit one?
I am stuck!
The is no way to use Jet driver from a 64-bit SQL Server unfortunately. They did not port the driver to 64-bit. So this would only work from a 32-bit SQL Server.|||xxx|||You can force the SQL Server Agent to execute the 32-bit version of DTExec by setting up the job as a CmdExec task instead of an SSIS package call, as detailed here:
http://wiki.sqlis.com/default.aspx/SQLISWiki/x64.html?diff=y
After giving some users read access to the cube, by using a readonly role -
The [Measures] are displayed with #N/A in Excel 2003. Only users with loal administrator previledge can see measures.
Please advise.
What I encountered with AS 2005 was that Cell Security defaulted to denying access to a reader role, resulting in #N/A. So I simply entered "1" as the MDX expression for "allow reading of cube content" - not sure if this is the issue for you as well:
http://msdn2.microsoft.com/en-us/library/ms174847(SQL.90).aspx
>>
Granting Custom Access to Cell Data
After you grant a database role in Microsoft SQL Server 2005 Analysis Services (SSAS) read or read/write permissions to a cube, you have to grant to this database role the permission to view some or all cell data. Only granting cube access to a database role does not give that database role access to specific cube cells.
...
>>
|||Can you please give more details about when AS2005 by default disables cell security ? Creating cell security, even as trivial as constant 1 may have very bad effect on performance, since there are many important optimizations which are disabled in the presence of cell security...|||Hi Mosha,
From what I can tell (based on a simple prototype AS 2005 RTM cube), cell read is disabled by default, unless "Full control (Administrator)" is selected on this page:
http://msdn2.microsoft.com/en-us/library/ms188508(SQL.90).aspx
>>
General (Role Designer) (SSAS)
>>
And that is regardless of "Enable read permissions" being checked on this page (unless "1" is entered for the "Allow reading of cube content" MDX expression):
http://msdn2.microsoft.com/en-us/library/ms177279(SQL.90).aspx
>>
Cell Data (Role Designer) (SSAS)
>>
Is there perhaps a better way to configure cell read access for a non-admin role?
|||Dear ASMK,
Please check your cell security MDX, the measure you are viewing might be in the
denied member list. This might be helpfull.
After giving some users read access to the cube, by using a readonly role -
The [Measures] are displayed with #N/A in Excel 2003. Only users with loal administrator previledge can see measures.
Please advise.
What I encountered with AS 2005 was that Cell Security defaulted to denying access to a reader role, resulting in #N/A. So I simply entered "1" as the MDX expression for "allow reading of cube content" - not sure if this is the issue for you as well:
http://msdn2.microsoft.com/en-us/library/ms174847(SQL.90).aspx
>>
Granting Custom Access to Cell Data
After you grant a database role in Microsoft SQL Server 2005 Analysis Services (SSAS) read or read/write permissions to a cube, you have to grant to this database role the permission to view some or all cell data. Only granting cube access to a database role does not give that database role access to specific cube cells.
...
>>
|||Can you please give more details about when AS2005 by default disables cell security ? Creating cell security, even as trivial as constant 1 may have very bad effect on performance, since there are many important optimizations which are disabled in the presence of cell security...|||Hi Mosha,
From what I can tell (based on a simple prototype AS 2005 RTM cube), cell read is disabled by default, unless "Full control (Administrator)" is selected on this page:
http://msdn2.microsoft.com/en-us/library/ms188508(SQL.90).aspx
>>
General (Role Designer) (SSAS)
>>
And that is regardless of "Enable read permissions" being checked on this page (unless "1" is entered for the "Allow reading of cube content" MDX expression):
http://msdn2.microsoft.com/en-us/library/ms177279(SQL.90).aspx
>>
Cell Data (Role Designer) (SSAS)
>>
Is there perhaps a better way to configure cell read access for a non-admin role?
|||Dear ASMK,
Please check your cell security MDX, the measure you are viewing might be in the
denied member list. This might be helpfull.
