Thursday, March 29, 2012
Cannot Export Data from SQL Server 2005
patches, running on Windows 2003 64 bits fully patched.
On both servers I get the same error everytime I use this sequence to export
data:
1) Right click DB and choose Tasks/Export Data
2) I select the same server as the datasource
3) When choosing the destination, the moment I select "Flat File" or
"Microsoft Excel" I get the same error:
===================================
An error occurred which the SQL Server Integration Services Wizard was not
prepared to handle. (SQL Server Import and Export Wizard)
===================================
Exception has been thrown by the target of an invocation. (mscorlib)
Program Location:
at System.RuntimeMethodHandle._InvokeConstructor(Obje ct[] args,
SignatureStruct& signature, IntPtr declaringType)
at System.RuntimeMethodHandle.InvokeConstructor(Objec t[] args,
SignatureStruct signature, RuntimeTypeHandle declaringType)
at System.Reflection.RuntimeConstructorInfo.Invoke(Bi ndingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder
binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttributes)
at
Microsoft.SqlServer.Dts.DtsWizard.Step2.DataSource ComboBox_SelectedIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.ComboBox.OnSelectedIndexChang ed(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Mes sage& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
===================================
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
Program Location:
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager. get_Properties()
at
Microsoft.DataTransformationServices.Controls.Flat FileConnectionManagerUtils.GetLocaleID(ConnectionM anager connectionManager)
at
Microsoft.DataTransformationServices.Controls.Flat FileManagerGeneralPage.LoadState(ConnectionManager connManager)
at
Microsoft.DataTransformationServices.Controls.Flat FileManagerGeneralPage.set_ConnectionManager(Conne ctionManager value)
at
Microsoft.SqlServer.Dts.DtsWizard.FlatFileDestForm ..ctor(DataSourceInfo info,
Boolean bDest, WizardInputs inputs, WizardPage page)
===================================
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
Program Location:
at
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSProper tiesProvider90.get_Properties()
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager. get_Properties()
=================================
So I cannot export data from these servers, I have tried everything and
installed all of the components and started all services to no avail.
I have even asked several Microsoft technicians and nobody seems to have a
clue and it's exactly the same behavior in both servers.
Please Help!
Hello John, I have tried using the management studio and business
intelligence studio on the same server and also using the management studio
from one server (acting as client) to the other server. Every time I get the
same error.
I'm running Windows 2003 64 bit with SP2 and SQL Server 64 bit with SP2 and
all the tools and services installed and started.
I never had any issues with sql server 2000 and after we spent so much money
to upgrade it's absurd you cannot even export a single excel worksheet from
the database.
"John Bell" wrote:
> Hi Luis
> "Luis Jahn" <Luis Jahn@.discussions.microsoft.com> wrote in message
> news:41A2A90F-2C98-4FAE-A1C0-DB432AD7D38C@.microsoft.com...
> Have you tried to export data from a workstation?
> Are you running SP2 or higher?
> John
>
>
|||Hi Luis
"Luis Jahn" wrote:
> Hello John, I have tried using the management studio and business
> intelligence studio on the same server and also using the management studio
> from one server (acting as client) to the other server. Every time I get the
> same error.
> I'm running Windows 2003 64 bit with SP2 and SQL Server 64 bit with SP2 and
> all the tools and services installed and started.
> I never had any issues with sql server 2000 and after we spent so much money
> to upgrade it's absurd you cannot even export a single excel worksheet from
> the database.
>
If you install the client tools on a workstations, can you use SSMS to
export the data when connected to the server? If so they you should be able
to create SSIS packages and import them on the server.
I don't have a 64bit server to connect to check this out, but I would not
expect this to be specific to your system although a similar post was created
at the same time as yours http://tinyurl.com/24w8jh !
John
Cannot Export Data from SQL Server 2005
patches, running on Windows 2003 64 bits fully patched.
On both servers I get the same error everytime I use this sequence to export
data:
1) Right click DB and choose Tasks/Export Data
2) I select the same server as the datasource
3) When choosing the destination, the moment I select "Flat File" or
"Microsoft Excel" I get the same error:
===================================
An error occurred which the SQL Server Integration Services Wizard was not
prepared to handle. (SQL Server Import and Export Wizard)
===================================
Exception has been thrown by the target of an invocation. (mscorlib)
Program Location:
at System.RuntimeMethodHandle._InvokeConstructor(Object[] args,
SignatureStruct& signature, IntPtr declaringType)
at System.RuntimeMethodHandle.InvokeConstructor(Object[] args,
SignatureStruct signature, RuntimeTypeHandle declaringType)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder
binder, Object[] args, CultureInfo culture, Object[] activationAttri
butes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttributes)
at
Microsoft.SqlServer.Dts.DtsWizard.Step2.DataSourceComboBox_SelectedIndexChan
ged(Object sender, EventArgs e)
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
===================================
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
Program Location:
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at
Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils
.GetLocaleID(ConnectionManager connectionManager)
at
Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.Loa
dState(ConnectionManager connManager)
at
Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set
_ConnectionManager(ConnectionManager value)
at
Microsoft.SqlServer.Dts.DtsWizard.FlatFileDestForm..ctor(DataSourceInfo info
,
Boolean bDest, WizardInputs inputs, WizardPage page)
===================================
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
Program Location:
at
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider90.get_Propert
ies()
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
=================================
So I cannot export data from these servers, I have tried everything and
installed all of the components and started all services to no avail.
I have even asked several Microsoft technicians and nobody seems to have a
clue and it's exactly the same behavior in both servers.
Please Help!Hi Luis
"Luis Jahn" <Luis Jahn@.discussions.microsoft.com> wrote in message
news:41A2A90F-2C98-4FAE-A1C0-DB432AD7D38C@.microsoft.com...
>I have two servers running SQL Server 2005 64 bit with all the available
> patches, running on Windows 2003 64 bits fully patched.
> On both servers I get the same error everytime I use this sequence to
> export
> data:
> 1) Right click DB and choose Tasks/Export Data
> 2) I select the same server as the datasource
> 3) When choosing the destination, the moment I select "Flat File" or
> "Microsoft Excel" I get the same error:
> ===================================
> An error occurred which the SQL Server Integration Services Wizard was not
> prepared to handle. (SQL Server Import and Export Wizard)
> ===================================
> Exception has been thrown by the target of an invocation. (mscorlib)
> --
> Program Location:
> at System.RuntimeMethodHandle._InvokeConstructor(Object[] args,
> SignatureStruct& signature, IntPtr declaringType)
> at System.RuntimeMethodHandle.InvokeConstructor(Object[] args,
> SignatureStruct signature, RuntimeTypeHandle declaringType)
> at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags
> invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
> at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
> Binder
> binder, Object[] args, CultureInfo culture, Object[] activationAtt
ributes)
> at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
> Binder binder, Object[] args, CultureInfo culture, Object[]
> activationAttributes)
> at
> Microsoft.SqlServer.Dts.DtsWizard.Step2.DataSourceComboBox_SelectedIndexCh
anged(Object
> sender, EventArgs e)
> at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
> at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
> at System.Windows.Forms.ComboBox.WndProc(Message& m)
> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
> m)
> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
> ===================================
> Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
> --
> Program Location:
> at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
> at
> Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUti
ls.GetLocaleID(ConnectionManager
> connectionManager)
> at
> Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.L
oadState(ConnectionManager
> connManager)
> at
> Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.s
et_ConnectionManager(ConnectionManager
> value)
> at
> Microsoft.SqlServer.Dts.DtsWizard.FlatFileDestForm..ctor(DataSourceInfo
> info,
> Boolean bDest, WizardInputs inputs, WizardPage page)
> ===================================
> Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
> --
> Program Location:
> at
> Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider90.get_Prope
rties()
> at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
> =================================
> So I cannot export data from these servers, I have tried everything and
> installed all of the components and started all services to no avail.
> I have even asked several Microsoft technicians and nobody seems to have a
> clue and it's exactly the same behavior in both servers.
> Please Help!
Have you tried to export data from a workstation?
Are you running SP2 or higher?
John|||Hello John, I have tried using the management studio and business
intelligence studio on the same server and also using the management studio
from one server (acting as client) to the other server. Every time I get the
same error.
I'm running Windows 2003 64 bit with SP2 and SQL Server 64 bit with SP2 and
all the tools and services installed and started.
I never had any issues with sql server 2000 and after we spent so much money
to upgrade it's absurd you cannot even export a single excel worksheet from
the database.
"John Bell" wrote:
> Hi Luis
> "Luis Jahn" <Luis Jahn@.discussions.microsoft.com> wrote in message
> news:41A2A90F-2C98-4FAE-A1C0-DB432AD7D38C@.microsoft.com...
> Have you tried to export data from a workstation?
> Are you running SP2 or higher?
> John
>
>|||Hi Luis
"Luis Jahn" wrote:
> Hello John, I have tried using the management studio and business
> intelligence studio on the same server and also using the management studi
o
> from one server (acting as client) to the other server. Every time I get t
he
> same error.
> I'm running Windows 2003 64 bit with SP2 and SQL Server 64 bit with SP2 an
d
> all the tools and services installed and started.
> I never had any issues with sql server 2000 and after we spent so much mon
ey
> to upgrade it's absurd you cannot even export a single excel worksheet fro
m
> the database.
>
If you install the client tools on a workstations, can you use SSMS to
export the data when connected to the server? If so they you should be able
to create SSIS packages and import them on the server.
I don't have a 64bit server to connect to check this out, but I would not
expect this to be specific to your system although a similar post was create
d
at the same time as yours http://tinyurl.com/24w8jh !
John
Cannot Export Data from SQL Server 2005
patches, running on Windows 2003 64 bits fully patched.
On both servers I get the same error everytime I use this sequence to export
data:
1) Right click DB and choose Tasks/Export Data
2) I select the same server as the datasource
3) When choosing the destination, the moment I select "Flat File" or
"Microsoft Excel" I get the same error:
===================================
An error occurred which the SQL Server Integration Services Wizard was not
prepared to handle. (SQL Server Import and Export Wizard)
===================================
Exception has been thrown by the target of an invocation. (mscorlib)
--
Program Location:
at System.RuntimeMethodHandle._InvokeConstructor(Object[] args,
SignatureStruct& signature, IntPtr declaringType)
at System.RuntimeMethodHandle.InvokeConstructor(Object[] args,
SignatureStruct signature, RuntimeTypeHandle declaringType)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder
binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttributes)
at
Microsoft.SqlServer.Dts.DtsWizard.Step2.DataSourceComboBox_SelectedIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
===================================
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
--
Program Location:
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at
Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at
Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at
Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at
Microsoft.SqlServer.Dts.DtsWizard.FlatFileDestForm..ctor(DataSourceInfo info,
Boolean bDest, WizardInputs inputs, WizardPage page)
===================================
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
--
Program Location:
at
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider90.get_Properties()
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
=================================
So I cannot export data from these servers, I have tried everything and
installed all of the components and started all services to no avail.
I have even asked several Microsoft technicians and nobody seems to have a
clue and it's exactly the same behavior in both servers.
Please Help!Hi Luis
"Luis Jahn" <Luis Jahn@.discussions.microsoft.com> wrote in message
news:41A2A90F-2C98-4FAE-A1C0-DB432AD7D38C@.microsoft.com...
>I have two servers running SQL Server 2005 64 bit with all the available
> patches, running on Windows 2003 64 bits fully patched.
> On both servers I get the same error everytime I use this sequence to
> export
> data:
> 1) Right click DB and choose Tasks/Export Data
> 2) I select the same server as the datasource
> 3) When choosing the destination, the moment I select "Flat File" or
> "Microsoft Excel" I get the same error:
> ===================================> An error occurred which the SQL Server Integration Services Wizard was not
> prepared to handle. (SQL Server Import and Export Wizard)
> ===================================> Exception has been thrown by the target of an invocation. (mscorlib)
> --
> Program Location:
> at System.RuntimeMethodHandle._InvokeConstructor(Object[] args,
> SignatureStruct& signature, IntPtr declaringType)
> at System.RuntimeMethodHandle.InvokeConstructor(Object[] args,
> SignatureStruct signature, RuntimeTypeHandle declaringType)
> at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags
> invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
> at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
> Binder
> binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
> at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
> Binder binder, Object[] args, CultureInfo culture, Object[]
> activationAttributes)
> at
> Microsoft.SqlServer.Dts.DtsWizard.Step2.DataSourceComboBox_SelectedIndexChanged(Object
> sender, EventArgs e)
> at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
> at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
> at System.Windows.Forms.ComboBox.WndProc(Message& m)
> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
> m)
> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
> ===================================> Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
> --
> Program Location:
> at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
> at
> Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager
> connectionManager)
> at
> Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager
> connManager)
> at
> Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager
> value)
> at
> Microsoft.SqlServer.Dts.DtsWizard.FlatFileDestForm..ctor(DataSourceInfo
> info,
> Boolean bDest, WizardInputs inputs, WizardPage page)
> ===================================> Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
> --
> Program Location:
> at
> Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider90.get_Properties()
> at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
> =================================> So I cannot export data from these servers, I have tried everything and
> installed all of the components and started all services to no avail.
> I have even asked several Microsoft technicians and nobody seems to have a
> clue and it's exactly the same behavior in both servers.
> Please Help!
Have you tried to export data from a workstation?
Are you running SP2 or higher?
John|||Hello John, I have tried using the management studio and business
intelligence studio on the same server and also using the management studio
from one server (acting as client) to the other server. Every time I get the
same error.
I'm running Windows 2003 64 bit with SP2 and SQL Server 64 bit with SP2 and
all the tools and services installed and started.
I never had any issues with sql server 2000 and after we spent so much money
to upgrade it's absurd you cannot even export a single excel worksheet from
the database.
"John Bell" wrote:
> Hi Luis
> "Luis Jahn" <Luis Jahn@.discussions.microsoft.com> wrote in message
> news:41A2A90F-2C98-4FAE-A1C0-DB432AD7D38C@.microsoft.com...
> >I have two servers running SQL Server 2005 64 bit with all the available
> > patches, running on Windows 2003 64 bits fully patched.
> >
> > On both servers I get the same error everytime I use this sequence to
> > export
> > data:
> > 1) Right click DB and choose Tasks/Export Data
> > 2) I select the same server as the datasource
> > 3) When choosing the destination, the moment I select "Flat File" or
> > "Microsoft Excel" I get the same error:
> >
> > ===================================> >
> > An error occurred which the SQL Server Integration Services Wizard was not
> > prepared to handle. (SQL Server Import and Export Wizard)
> >
> > ===================================> >
> > Exception has been thrown by the target of an invocation. (mscorlib)
> >
> > --
> > Program Location:
> >
> > at System.RuntimeMethodHandle._InvokeConstructor(Object[] args,
> > SignatureStruct& signature, IntPtr declaringType)
> > at System.RuntimeMethodHandle.InvokeConstructor(Object[] args,
> > SignatureStruct signature, RuntimeTypeHandle declaringType)
> > at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags
> > invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
> > at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
> > Binder
> > binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
> > at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
> > Binder binder, Object[] args, CultureInfo culture, Object[]
> > activationAttributes)
> > at
> > Microsoft.SqlServer.Dts.DtsWizard.Step2.DataSourceComboBox_SelectedIndexChanged(Object
> > sender, EventArgs e)
> > at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
> > at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
> > at System.Windows.Forms.ComboBox.WndProc(Message& m)
> > at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
> > m)
> > at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> > at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> > IntPtr wparam, IntPtr lparam)
> >
> > ===================================> >
> > Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
> >
> > --
> > Program Location:
> >
> > at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
> > at
> > Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager
> > connectionManager)
> > at
> > Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager
> > connManager)
> > at
> > Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager
> > value)
> > at
> > Microsoft.SqlServer.Dts.DtsWizard.FlatFileDestForm..ctor(DataSourceInfo
> > info,
> > Boolean bDest, WizardInputs inputs, WizardPage page)
> >
> > ===================================> >
> > Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
> >
> > --
> > Program Location:
> > at
> > Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider90.get_Properties()
> > at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
> > =================================> >
> > So I cannot export data from these servers, I have tried everything and
> > installed all of the components and started all services to no avail.
> >
> > I have even asked several Microsoft technicians and nobody seems to have a
> > clue and it's exactly the same behavior in both servers.
> >
> > Please Help!
> Have you tried to export data from a workstation?
> Are you running SP2 or higher?
> John
>
>|||Hi Luis
"Luis Jahn" wrote:
> Hello John, I have tried using the management studio and business
> intelligence studio on the same server and also using the management studio
> from one server (acting as client) to the other server. Every time I get the
> same error.
> I'm running Windows 2003 64 bit with SP2 and SQL Server 64 bit with SP2 and
> all the tools and services installed and started.
> I never had any issues with sql server 2000 and after we spent so much money
> to upgrade it's absurd you cannot even export a single excel worksheet from
> the database.
>
If you install the client tools on a workstations, can you use SSMS to
export the data when connected to the server? If so they you should be able
to create SSIS packages and import them on the server.
I don't have a 64bit server to connect to check this out, but I would not
expect this to be specific to your system although a similar post was created
at the same time as yours http://tinyurl.com/24w8jh !
John
cannot execute xp_cmdshell. Access is denied while copying data over the network
I am having some trouble copying data over my workgroup network from my Windows 2003 Server Machine (machineA with SQL SERVER 2005) to one of my network Machine's drive(MachineB).
Here is the T-SQL code that I am trying to execute:
EXEC xp_cmdshell 'copy D:\Data\file.txt \\MachineB\Documents'
Whenever I tried to execute the above piece of code, I get the error message "Access is denied", but if I try to copy the file from the Command Prompt (cmd.exe) with the copy command, the file copies fine over the network.
I have already searched over the internet and I found out that loads of people have the same issue, and they were suggested something like this:
"Check in Services and make sure that the MSSQLServer service is run as a domain user and that domain user has rights to these network resources."
Well it sounds plausible, but I don't know what are the exact steps to do this. How do I know which user is running the MSSQL Server service? Are they referring to the user which I use to connect to my SQL Server Database engine throuhg the SQL Server Management Studio?
Also they are suggesting 'domain user', and as I said before I do not have domain network just regular simple workgroup network.
Here are some details of the user that I use to login. I generally login into my Windows 2003 Server machine with user called 'User1' and I use the same 'User1' to connect to SQL Server through the Management Studio Screen.
Should I create a user called 'User1' on my MachineB(Destination Machine)?
I would really appreciate, if someone can give me detailed steps explaning how to solve this problem.
Thank you very much once again.
Open the Surface Area Configuration Manager. Go to the features section. Make sure that xp_cmdshell is enabled. (It is turned off by default.) Then once you have enabled xp_cmdshell, make sure that the SQL Server service account has the appropriate permissions granted.|||Hi Michael,
Thank you very much for your reply. xp_cmdshell is already enabled. How do I check the permissions of SQL Server Srvice account? Is that the same account which I use to connect to SQL SERVER through Management Studio?
Thanks
|||No. It is the Windows account that the SQL Server service is running under. Specifically, you can find this within SQL Server Configuration Manager.|||
Michael Hotek wrote:
No. It is the Windows account that the SQL Server service is running under. Specifically, you can find this within SQL Server Configuration Manager.
Ok I went to the SQL SERVER Configuration Manager. Then I clicked on SQL SERVER 2005 Services in the left pane. On the right pane, it listen 5-6 services running like Intergration Service, Analysis Service, Reporting Service, and so on. One of them was SQL SERVER(MSSQLSERVER), so I think this must be the one that you were talking about. I right clicked on it-> Properties. Under the properties tab, I saw Log on as: Built-in Account (radio button) was checked and in the dropdown below it, Local System was selected. So basically the SQL Server Service is running under Local System. Now how do I figure out what user is associated with Local System?
Thank you once again for the help.Much appreciated.
|||Local system is the local machine account. That would be why you are getting an access denied on a network resource. The SID for localsystem is not valid external to the machine. In order to be able to execute that command you would need to create a Windows login and then use that login to run the SQL Server services. That login would have to have permissions on the network resource you are trying to write to.|||Thanks a lot Michael, that really makes sense .
Now for the extension based on your reply. Are there any disadvantages of using a Windows user to run the SQL Server services instead of a Local Machine account?
Thank you very very much for your prompt reply and insightful suggestion.
|||No, in fact, there are entire feature sets that you can't use in SQL Server if you are running under the localsystem account, replication being one of them. I don't run any SQL Server under a local machine account. I always run them under specific user accounts and in particular regular domain user accounts.|||I just did this and it worked like a charm. You someone already posted the answer. Go to SQL Server Configuration Manager. Right click on Sql Server, click properties and change the user account to run under a domain or local pc account. that has access to the share.
cannot execute xp_cmdshell. Access is denied while copying data over the network
I am having some trouble copying data over my workgroup network from my Windows 2003 Server Machine (machineA with SQL SERVER 2005) to one of my network Machine's drive(MachineB).
Here is the T-SQL code that I am trying to execute:
EXEC xp_cmdshell 'copy D:\Data\file.txt \\MachineB\Documents'
Whenever I tried to execute the above piece of code, I get the error message "Access is denied", but if I try to copy the file from the Command Prompt (cmd.exe) with the copy command, the file copies fine over the network.
I have already searched over the internet and I found out that loads of people have the same issue, and they were suggested something like this:
"Check in Services and make sure that the MSSQLServer service is run as
a domain user and that domain user has rights to these network
resources."
Well it sounds plausible, but I don't know what are the exact steps to do this. How do I know which user is running the MSSQL Server service? Are they referring to the user which I use to connect to my SQL Server Database engine throuhg the SQL Server Management Studio?
Also they are suggesting 'domain user', and as I said before I do not have domain network just regular simple workgroup network.
Here are some details of the user that I use to login. I generally login into my Windows 2003 Server machine with user called 'User1' and I use the same 'User1' to connect to SQL Server through the Management Studio Screen.
Should I create a user called 'User1' on my MachineB(Destination Machine)?
I would really appreciate, if someone can give me detailed steps explaning how to solve this problem.
Thank you very much once again.Open the Surface Area Configuration Manager. Go to the features section. Make sure that xp_cmdshell is enabled. (It is turned off by default.) Then once you have enabled xp_cmdshell, make sure that the SQL Server service account has the appropriate permissions granted.|||Hi Michael,
Thank you very much for your reply. xp_cmdshell is already enabled. How do I check the permissions of SQL Server Srvice account? Is that the same account which I use to connect to SQL SERVER through Management Studio?
Thanks|||No. It is the Windows account that the SQL Server service is running under. Specifically, you can find this within SQL Server Configuration Manager.|||
Michael Hotek wrote:
No. It is the Windows account that the SQL Server service is running under. Specifically, you can find this within SQL Server Configuration Manager.
Ok I went to the SQL SERVER Configuration Manager. Then I clicked on SQL SERVER 2005 Services in the left pane. On the right pane, it listen 5-6 services running like Intergration Service, Analysis Service, Reporting Service, and so on. One of them was SQL SERVER(MSSQLSERVER), so I think this must be the one that you were talking about. I right clicked on it-> Properties. Under the properties tab, I saw Log on as: Built-in Account (radio button) was checked and in the dropdown below it, Local System was selected. So basically the SQL Server Service is running under Local System. Now how do I figure out what user is associated with Local System?
Thank you once again for the help.Much appreciated.|||Local system is the local machine account. That would be why you are getting an access denied on a network resource. The SID for localsystem is not valid external to the machine. In order to be able to execute that command you would need to create a Windows login and then use that login to run the SQL Server services. That login would have to have permissions on the network resource you are trying to write to.|||Thanks a lot Michael, that really makes sense .
Now for the extension based on your reply. Are there any disadvantages of using a Windows user to run the SQL Server services instead of a Local Machine account?
Thank you very very much for your prompt reply and insightful suggestion.|||No, in fact, there are entire feature sets that you can't use in SQL Server if you are running under the localsystem account, replication being one of them. I don't run any SQL Server under a local machine account. I always run them under specific user accounts and in particular regular domain user accounts.|||I just did this and it worked like a charm. You someone already posted the answer. Go to SQL Server Configuration Manager. Right click on Sql Server, click properties and change the user account to run under a domain or local pc account. that has access to the share.
Sunday, March 25, 2012
Cannot display database properties windows in Sql server management studio.
I use sql server 2005 developer edition with service pack 1.
When i right click on a database and i select properties an error occured with the folowing stack trace
===================================
Cannot show requested dialog.
===================================
Cannot show requested dialog. (SqlMgmt)
Program Location:
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
===================================
Object reference not set to an instance of an object. (System.Data)
Program Location:
at System.Data.SqlClient.TdsParserStateObject.ReadStringWithEncoding(Int32 length, Encoding encoding, Boolean isPlp)
at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadColumnData()
at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetObjectByKey(ObjectKeyBase key)
at Microsoft.SqlServer.Management.Smo.DatabaseCollection.get_Item(String name)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.DatabaseData..ctor(CDataContainer context, String databaseName)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.LoadDefinition(String newName)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype..ctor(CDataContainer context)
at Microsoft.SqlServer.Management.SqlManagerUI.DBPropSheet..ctor(CDataContainer context)
Accroding to the reflected sources:
public DatabaseData(CDataContainer context, string databaseName)
{
this.mirrorSafetyLevel = MirroringSafetyLevel.Off;
this.witnessServer = string.Empty;
Database database1 = context.Server.Databases[databaseName];
There might be a problem in getting the information from the database collection. So do the following steps:
-Run the profiler to the when the execution of the command stops. (Guess it has to do something with the database name)
-Select the database name from the sysdatabases and post it here
SELECT Name, DATALENGTH(Name),LEN(Name) from sys.databases
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
When i try to create a new view, in any of the databases i saw an error
Object reference not set to an instance of an object. (SQLEditors)
Program Location:
at System.Data.SqlClient.TdsParserStateObject.ReadStringWithEncoding(Int32 length, Encoding encoding, Boolean isPlp)
at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadColumnData()
at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname)
at Microsoft.SqlServer.Management.Smo.Database.get_DefaultSchema()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.GetDefaultSchema(Server server, String databaseName)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.GenerateNewObjectUrn()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.SetObjectAndParentUrns(Urn originalUrn)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProjectNode..ctor(Urn urn, DocumentOptions options, IManagedConnection connection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProjectNode.Allocate(Urn origUrn, DocumentType editorType, DocumentOptions options, IManagedConnection connection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)
I think that there is a problem with the server installation. I will try to reinstalle it.
|||If you want to solve the problem, follow the mentioned steps to reproduce the executed script on the server. That might also help others to solve their problems and help to improve the product itself.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Hi,
Please make sure the database exists and is not deleted by clicking refresh on the server node and see if you can still see the database whose properties you were not able to access. I believe the database was dropped by some other means and your SSMS window was not refreshed after that.
Hope this helps.
Thanks,
Sravanthi.
|||Stack trace dump means there might be a probelm with the Windows, a virus or mismatch of hotfix/service pack on operating system. Make sure to check what has been changed since this was working correctly in previous state, if not you might try testing the same on other machine.|||All databases are in place. i can open tables and see their data.|||thats what i believe too.
The problem appears after an update from microsoft windows update which find that my windows sql server installation need the service pack 1 update. I selected and install it.
after that i download and install service pack 2 for sql server 2005 but of course this doesn't correct anything.
I have in the same computer a sqlserver express edition installed and from microsoft sql server managment studio i can work properly with this instance without a problem (in case i thought that was a problem from microsoft sql server managment studio).
About response from Jens K. Suessmeyer .
Whene i execute the line
SELECT 'AdventureWorks', DATALENGTH('AdventureWorks'),LEN('AdventureWorks') from sys.databases
i get
'An error occurred while executing batch. Error message is: Object reference not set to an instance of an object.'
with any database there are in this installation.
Hi,
From where are you running the queries? Please run the query SELECT Name, DATALENGTH(Name),LEN(Name) from sys.databases (run it as is as Jens K. Suessmeyer has given, dont replace Name in the query, if you want it specific to AdventureWorks just add a where clause). Run this query from new query window in SSMS and let us know the output. From the error that you are getting "Object reference..." looks like you are trying to run the query programmatically. Just run it from a SSMS query window and let us know the output. Make sure the database that is causing all these issues comes up in the query result.
Sravanthi
|||If you believe its SSMS tools problem, try to reinstall them again.|||All databases causing that issues
The result after executing the above query is
NAME (no column name) (no column name)
master 12 6
tempdb 12 6
model 10 5
msdb 8 4
ReportServer$MAIMOY2005 46 23
ReportServer$MAIMOY2005TempDB 58 29
BASE DE DATOS ORIGINAL 44 22
ALKI 8 4
aspnetdb_ALKI 26 13
AdventureWorks 28 14
AdventureWorksDW 32 16
(11 row(s) affected)
|||After a full uninstall and reinstall everything seems to work perfect. Aftes installation i install also service pack 2 downloaded and installed locally and everything works properly.|||somehow, i missed this thread and I am sure if I could furnish this information bit earlier it would have been helpful. nevertheless, i think i should share my experience in this regards. the story is as follows :)
One of our development server had the same problem and I have documented this error. But at that time I was on the tows and somehow I was to get rid of this problem and I did the same trick - reinstalling the SQL Server. But I was not satisfied by this solution. when I did the postmortem of the process then I realized that our TL used to synchronies the Development database from Visio. There were many connection used to connect to different database (from visio) and one of them was to connect to master database. He used the master connection , and Visio automatically detects the objects in the connected database which are not there in the Model and it ask whether u want to delete those object or not. He selected Yes and Visio deleted all the objects from master database which are not there in the model. I verified the objects between two instances Master databases. There were five system tables missing , the missing tables were spt_fallback_db,spt_fallback_dev,spt_fallback_usg,spt_monitor,spt_value. Then I created the script of these tables from other instance and run on the problem server, but those tables were not having owner , though it shows owner as DBO. Actually these tables comes under System Tables tree but when I created these by the script those created as user table. I was pretty sure that these problem were because of these tables got deleted. But I was not having time to do R&D on this and I reinstalled the instance.
(a) How come Visio able to delete system tables (the irony is that , in SSMO these tables are shown as System Tables , but if u use sp_help it is shown as Usertable).
(b) IF somehow these tables got deleted, how can we restore these table and revert back to normal stage without reinstalling anything.
Also question to Antonisk, is something like this was happened in your side…
I think we need to dig out the root of this problem. If these tables are so critical , then these should not be deletable from anywhere. If it is a bug the we need to report this to MS..
Thanks for the time
Madhu
|||I don't use Visio at all. Also i can't check if this was the problem (system tables missing) because I reinstall the Sql Server.
Cannot display database properties windows in Sql server management studio.
I use sql server 2005 developer edition with service pack 1.
When i right click on a database and i select properties an error occured with the folowing stack trace
===================================
Cannot show requested dialog.
===================================
Cannot show requested dialog. (SqlMgmt)
Program Location:
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
===================================
Object reference not set to an instance of an object. (System.Data)
Program Location:
at System.Data.SqlClient.TdsParserStateObject.ReadStringWithEncoding(Int32 length, Encoding encoding, Boolean isPlp)
at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadColumnData()
at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetObjectByKey(ObjectKeyBase key)
at Microsoft.SqlServer.Management.Smo.DatabaseCollection.get_Item(String name)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.DatabaseData..ctor(CDataContainer context, String databaseName)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.LoadDefinition(String newName)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype..ctor(CDataContainer context)
at Microsoft.SqlServer.Management.SqlManagerUI.DBPropSheet..ctor(CDataContainer context)
Accroding to the reflected sources:
public DatabaseData(CDataContainer context, string databaseName)
{
this.mirrorSafetyLevel = MirroringSafetyLevel.Off;
this.witnessServer = string.Empty;
Database database1 = context.Server.Databases[databaseName];
There might be a problem in getting the information from the database collection. So do the following steps:
-Run the profiler to the when the execution of the command stops. (Guess it has to do something with the database name)
-Select the database name from the sysdatabases and post it here
SELECT Name, DATALENGTH(Name),LEN(Name) from sys.databases
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
When i try to create a new view, in any of the databases i saw an error
Object reference not set to an instance of an object. (SQLEditors)
Program Location:
at System.Data.SqlClient.TdsParserStateObject.ReadStringWithEncoding(Int32 length, Encoding encoding, Boolean isPlp)
at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadColumnData()
at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname)
at Microsoft.SqlServer.Management.Smo.Database.get_DefaultSchema()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.GetDefaultSchema(Server server, String databaseName)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.GenerateNewObjectUrn()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.SetObjectAndParentUrns(Urn originalUrn)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProjectNode..ctor(Urn urn, DocumentOptions options, IManagedConnection connection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProjectNode.Allocate(Urn origUrn, DocumentType editorType, DocumentOptions options, IManagedConnection connection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)
I think that there is a problem with the server installation. I will try to reinstalle it.
|||If you want to solve the problem, follow the mentioned steps to reproduce the executed script on the server. That might also help others to solve their problems and help to improve the product itself.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Hi,
Please make sure the database exists and is not deleted by clicking refresh on the server node and see if you can still see the database whose properties you were not able to access. I believe the database was dropped by some other means and your SSMS window was not refreshed after that.
Hope this helps.
Thanks,
Sravanthi.
|||Stack trace dump means there might be a probelm with the Windows, a virus or mismatch of hotfix/service pack on operating system. Make sure to check what has been changed since this was working correctly in previous state, if not you might try testing the same on other machine.|||All databases are in place. i can open tables and see their data.|||thats what i believe too.
The problem appears after an update from microsoft windows update which find that my windows sql server installation need the service pack 1 update. I selected and install it.
after that i download and install service pack 2 for sql server 2005 but of course this doesn't correct anything.
I have in the same computer a sqlserver express edition installed and from microsoft sql server managment studio i can work properly with this instance without a problem (in case i thought that was a problem from microsoft sql server managment studio).
About response from Jens K. Suessmeyer .
Whene i execute the line
SELECT 'AdventureWorks', DATALENGTH('AdventureWorks'),LEN('AdventureWorks') from sys.databases
i get
'An error occurred while executing batch. Error message is: Object reference not set to an instance of an object.'
with any database there are in this installation.
Hi,
From where are you running the queries? Please run the query SELECT Name, DATALENGTH(Name),LEN(Name) from sys.databases (run it as is as Jens K. Suessmeyer has given, dont replace Name in the query, if you want it specific to AdventureWorks just add a where clause). Run this query from new query window in SSMS and let us know the output. From the error that you are getting "Object reference..." looks like you are trying to run the query programmatically. Just run it from a SSMS query window and let us know the output. Make sure the database that is causing all these issues comes up in the query result.
Sravanthi
|||If you believe its SSMS tools problem, try to reinstall them again.|||All databases causing that issues
The result after executing the above query is
NAME (no column name) (no column name)
master 12 6
tempdb 12 6
model 10 5
msdb 8 4
ReportServer$MAIMOY2005 46 23
ReportServer$MAIMOY2005TempDB 58 29
BASE DE DATOS ORIGINAL 44 22
ALKI 8 4
aspnetdb_ALKI 26 13
AdventureWorks 28 14
AdventureWorksDW 32 16
(11 row(s) affected)
|||After a full uninstall and reinstall everything seems to work perfect. Aftes installation i install also service pack 2 downloaded and installed locally and everything works properly.|||somehow, i missed this thread and I am sure if I could furnish this information bit earlier it would have been helpful. nevertheless, i think i should share my experience in this regards. the story is as follows :)
One of our development server had the same problem and I have documented this error. But at that time I was on the tows and somehow I was to get rid of this problem and I did the same trick - reinstalling the SQL Server. But I was not satisfied by this solution. when I did the postmortem of the process then I realized that our TL used to synchronies the Development database from Visio. There were many connection used to connect to different database (from visio) and one of them was to connect to master database. He used the master connection , and Visio automatically detects the objects in the connected database which are not there in the Model and it ask whether u want to delete those object or not. He selected Yes and Visio deleted all the objects from master database which are not there in the model. I verified the objects between two instances Master databases. There were five system tables missing , the missing tables were spt_fallback_db,spt_fallback_dev,spt_fallback_usg,spt_monitor,spt_value. Then I created the script of these tables from other instance and run on the problem server, but those tables were not having owner , though it shows owner as DBO. Actually these tables comes under System Tables tree but when I created these by the script those created as user table. I was pretty sure that these problem were because of these tables got deleted. But I was not having time to do R&D on this and I reinstalled the instance.
(a) How come Visio able to delete system tables (the irony is that , in SSMO these tables are shown as System Tables , but if u use sp_help it is shown as Usertable).
(b) IF somehow these tables got deleted, how can we restore these table and revert back to normal stage without reinstalling anything.
Also question to Antonisk, is something like this was happened in your side…
I think we need to dig out the root of this problem. If these tables are so critical , then these should not be deletable from anywhere. If it is a bug the we need to report this to MS..
Thanks for the time
Madhu
|||I don't use Visio at all. Also i can't check if this was the problem (system tables missing) because I reinstall the Sql Server.sql
Cannot Deploy Reports to Report Server
We have just set up SQL Server (2005, SP2) with RS on a Windows 2003 server.
None of us have ever deployed RS before. To make matters worse, all of our
network operations have been outsourced, so we do not have control of the
machine and the people who do don't know what they're doing either.
I can browse to <servername>\reports and to
<servername>\reportexecution2005.asmx. However when I try to browse to
<servername>\reportserver or try to deploy reports from VS2003, I get the
following error: The permissions granted to user 'ADSDOMAIN\ERichardson' are
insufficient for performing this operation. (rsAccessDenied) .
a)How should the permissions be set up so that I can deploy and manage the
reports?
b)How should the permissions be set up so that certain users can access the
Report Manager?
c)How should the permission be set up so that the majority of users can
access reports through links in the VS.Net application?
I know this is a lot of material to cover at once. We've got the blind
leading the blind here. Maybe we could start with how to grant me access to
deploy and manage the reports and then take it from there.
I would appreciate any help I can get. These outsourced people aren't going
to make the effort to figure this out. We're going to have to spoonfeed
them:-)
LizOn Sep 10, 12:40 pm, Liz <L...@.discussions.microsoft.com> wrote:
> I am in desperate need of help.
> We have just set up SQL Server (2005, SP2) with RS on a Windows 2003 server.
> None of us have ever deployed RS before. To make matters worse, all of our
> network operations have been outsourced, so we do not have control of the
> machine and the people who do don't know what they're doing either.
> I can browse to <servername>\reports and to
> <servername>\reportexecution2005.asmx. However when I try to browse to
> <servername>\reportserver or try to deploy reports from VS2003, I get the
> following error: The permissions granted to user 'ADSDOMAIN\ERichardson' are
> insufficient for performing this operation. (rsAccessDenied) .
> a)How should the permissions be set up so that I can deploy and manage the
> reports?
> b)How should the permissions be set up so that certain users can access the
> Report Manager?
> c)How should the permission be set up so that the majority of users can
> access reports through links in the VS.Net application?
> I know this is a lot of material to cover at once. We've got the blind
> leading the blind here. Maybe we could start with how to grant me access to
> deploy and manage the reports and then take it from there.
> I would appreciate any help I can get. These outsourced people aren't going
> to make the effort to figure this out. We're going to have to spoonfeed
> them:-)
> Liz
For Item (a), you may want to check the security on the Reports and
ReportServer Virtual Directories. You may want to change the Directory
Security (via right-clicking the virtual directories in IIS ->
Properties -> Directory Security tab -> Edit... button -> select
'Anonymous access' and 'Integrated Windows Authentication').
For Item (b), you set the user permissions in the Report Manager in
the second tab on the main page (I don't remember the name of it). You
can allow Browse, Publish, etc for various users that you add (note
that the standard windows format is: DOMAIN\User).
For Item (c), Browse permissions should be sufficient for most users
(refer to Item (b) response).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Tuesday, March 20, 2012
Cannot create or modify tables in any database ("The parameter is incorrect.")
Using SQL Server 2005 and Microsoft SQL Server Management Studio, I connect using windows authentication. On any database I have created or attached (from a previous version of SQL Server), if I try to add a new table or modify an existing table, I get an error. A dialog pops up that says, "The parameter is incorrect." And I realy can't go any further.
I tried to remedy the problem by applying SP1 (x64) to the installation but I still get the same error.
Has anybody got a clue as to why I get this error? This is not SQL Server Express but the standard version of SQL Server. Fabulous software, I just can't get this to work on this new server. SQL Server Express is wonderful on our test machines but we need to get past this issue to fully utilize the server version.
Thanks for any help somebody can give me.
Please file a defect report on http://connect.microsoft.com/sqlserver. Defects reported on the Connect site go directly into our internal issue tracking system.
The error message pop-up should have a button/icon at bottom to show technical details. This includes the detailed exception message and the call stack. This can help us diagnose the problem. Be sure to include the version number of management studio and the engine (use menu Help | About to see the management studio version, and use this T-SQL to get the engine version: select @.@.version) and the call stack from the error dialog in the defect report.
One thing I would check is whether the database you've attached has a valid owner in the new server. If the database doesn't have an owner, you can give it one using the database properties dialog in management studio (connect to the server, right click on the database in Object Explorer, and select Properties. The owner can be set on the Files page.) or by issuing the "ALTER AUTHORIZATION ON DATABASE::{your db} TO {server principal}" statement in sqlcmd or a management studio query window.
You also need fairly high privileges to modify tables. Can you modify tables if you log in as a database owner?
Thanks,
Steve
Cannot create new Subscription?
I recently got the September CTP Enterprise version and installed it on box with Windows Server2003 os. When I go to a report and try to create a new subscription by going to SQL Server management studio, that option is disabled for me.
I have already setup the email configurations and started the sql server agent.
Anyone has ideas why this should happen?
Most likely, the credentials for the report aren't stored. What do you see in Report Manager? The same?|||
I'm having a similar problem where:
- "New Subscription" is greyed out in Server Management Studio.
- Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error
"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"
Any suggestions?
Monday, March 19, 2012
Cannot create new Subscription?
I recently got the September CTP Enterprise version and installed it on box with Windows Server2003 os. When I go to a report and try to create a new subscription by going to SQL Server management studio, that option is disabled for me.
I have already setup the email configurations and started the sql server agent.
Anyone has ideas why this should happen?
Most likely, the credentials for the report aren't stored. What do you see in Report Manager? The same?|||
I'm having a similar problem where:
- "New Subscription" is greyed out in Server Management Studio.
- Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error
"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"
Any suggestions?
Sunday, March 11, 2012
Cannot create an ODBC connection to SQl 2000.
Hi all,
I have SQL 2000 enterprise edition(no service pack) installed on a Windows Server 2003 machine. I can remote access into the server and run SQL but I cannot create an ODBC connection to this from my desktop. From some research it looks like installing service packs might correct this but here is the error:
--connection failed
--sqlstate '01000'
--sql server error 10061
--connection failed
--sqlstate 08001
--sql server error 17
--SQL server does not exist or access denied
Any help would be appreciated.
Verify whether the SQL Server is listening on a TCP port. If it's a default instance it is by default 1433, so you can use
netstat -an | findstr 1433
If not but the TCP protocol is turned on for the server (and set to port 1433) then upgrading to the latest service pack will most likely solve your problem.
|||It'd better for you to upgrade SQL Server 2000 to latest service pack 4 from here:
http://support.microsoft.com/kb/290211#EOADAA
then make sure following things before you make connection:
1) SQL Service is running
2) If make remote connection, make sure named pipe or TCP was enabled and try Peter's suggestion if you want to connect through tcp.
HTH.
Thursday, March 8, 2012
Cannot create a row of size 8075 which is greater than... (-214721
I have some VB6 code using ADO 2.5 running on a Windows 2003 Server box that
sometimes fails when trying to update an ADO field type of adLongVarChar
(stored as a text column in a SQL Server 2000 database, 6.5 compatiblity
mode) and produces the following error:
Error Number: -21472179
Error Description: Cannot create a row of size 8075 which is greater than
the allowable maximum of 8060.
The error seems to be occurring when we try to update the field with a large
string value. The strange thing is that it works without producing an error
sometimes. The reason I say this is that I can see some entries in my table
that have a DATALENGTH of the text field much larger than some of the ones
that are failing.
My VB6/ADO code looks like so:
'inserts a new record into a table with default values
sql = "call mydatadatable_insert "
Set objRecordset = New ADODB.Recordset
objRecordset.CursorLocation = adUseClient
Call objRecordset.Open(sql, objConnection, adOpenKeyset, adLockOptimistic)
myID= objRecordset.Fields.Item("ID").Value
objRecordset.Close
Set objRecordset = Nothing
'loads a 23 KB xml file
sXML = ReadFile("c:\temp\test.xml")
'...more processing here (non database)
sql = "exec mydatadatable_update" & cstr(myID)
Set objRecordset = New ADODB.Recordset
objRecordset.CursorLocation = adUseClient
Call objRecordset.Open(sql, objConnection, adOpenKeyset, adLockOptimistic)
'this is the problem area!!
objRecordset.Fields("FileTxt").Value = sXML
objRecordset.Update
objRecordset.Close
Set objRecordset = Nothing
I was thinking it might have something to do with the reference to ADO 2.5,
rather than 2.8 which is what comes with Windows Server 2003. But again, it
seems to be working some of the time.
I found this article on Microsoft's site:
http://msdn.microsoft.com/library/d...serr_1_20hd.asp
Any help would be greatly appreciated!!!
Thanks in advance!
Brian McCulloughHi,
After reading your post I have one question.
Is XML file always the same size?
My opinion is that sometimes XML file (or string) is small enough to fit
into varchar (which I think you're using for data-type) and sometimes it os
too large (8075).
You could generaly solve the problem with using text or ntext as a datatype
in the affected column.
Danijel
"brianpmccullough" <bmccullough11@.comcast.net> wrote in message
news:593E87AE-3407-4ACB-9908-7F5A8969EAB8@.microsoft.com...
> Hello all,
> I have some VB6 code using ADO 2.5 running on a Windows 2003 Server box
> that
> sometimes fails when trying to update an ADO field type of adLongVarChar
> (stored as a text column in a SQL Server 2000 database, 6.5 compatiblity
> mode) and produces the following error:
> Error Number: -21472179
> Error Description: Cannot create a row of size 8075 which is greater than
> the allowable maximum of 8060.
> The error seems to be occurring when we try to update the field with a
> large
> string value. The strange thing is that it works without producing an
> error
> sometimes. The reason I say this is that I can see some entries in my
> table
> that have a DATALENGTH of the text field much larger than some of the ones
> that are failing.
> My VB6/ADO code looks like so:
> 'inserts a new record into a table with default values
> sql = "call mydatadatable_insert "
> Set objRecordset = New ADODB.Recordset
> objRecordset.CursorLocation = adUseClient
> Call objRecordset.Open(sql, objConnection, adOpenKeyset,
> adLockOptimistic)
> myID= objRecordset.Fields.Item("ID").Value
> objRecordset.Close
> Set objRecordset = Nothing
> 'loads a 23 KB xml file
> sXML = ReadFile("c:\temp\test.xml")
> '...more processing here (non database)
> sql = "exec mydatadatable_update" & cstr(myID)
> Set objRecordset = New ADODB.Recordset
> objRecordset.CursorLocation = adUseClient
> Call objRecordset.Open(sql, objConnection, adOpenKeyset,
> adLockOptimistic)
> 'this is the problem area!!
> objRecordset.Fields("FileTxt").Value = sXML
> objRecordset.Update
> objRecordset.Close
> Set objRecordset = Nothing
>
> I was thinking it might have something to do with the reference to ADO
> 2.5,
> rather than 2.8 which is what comes with Windows Server 2003. But again,
> it
> seems to be working some of the time.
> I found this article on Microsoft's site:
> http://msdn.microsoft.com/library/d...serr_1_20hd.asp
> Any help would be greatly appreciated!!!
> Thanks in advance!
> Brian McCullough
Cannot create a row of size 8075 which is greater than... (-214721
I have some VB6 code using ADO 2.5 running on a Windows 2003 Server box that
sometimes fails when trying to update an ADO field type of adLongVarChar
(stored as a text column in a SQL Server 2000 database, 6.5 compatiblity
mode) and produces the following error:
Error Number: -21472179
Error Description: Cannot create a row of size 8075 which is greater than
the allowable maximum of 8060.
The error seems to be occurring when we try to update the field with a large
string value. The strange thing is that it works without producing an error
sometimes. The reason I say this is that I can see some entries in my table
that have a DATALENGTH of the text field much larger than some of the ones
that are failing.
My VB6/ADO code looks like so:
'inserts a new record into a table with default values
sql = "call mydatadatable_insert "
Set objRecordset = New ADODB.Recordset
objRecordset.CursorLocation = adUseClient
Call objRecordset.Open(sql, objConnection, adOpenKeyset, adLockOptimistic)
myID= objRecordset.Fields.Item("ID").Value
objRecordset.Close
Set objRecordset = Nothing
'loads a 23 KB xml file
sXML = ReadFile("c:\temp\test.xml")
'...more processing here (non database)
sql = "exec mydatadatable_update" & cstr(myID)
Set objRecordset = New ADODB.Recordset
objRecordset.CursorLocation = adUseClient
Call objRecordset.Open(sql, objConnection, adOpenKeyset, adLockOptimistic)
'this is the problem area!!
objRecordset.Fields("FileTxt").Value = sXML
objRecordset.Update
objRecordset.Close
Set objRecordset = Nothing
I was thinking it might have something to do with the reference to ADO 2.5,
rather than 2.8 which is what comes with Windows Server 2003. But again, it
seems to be working some of the time.
I found this article on Microsoft's site:
http://msdn.microsoft.com/library/de...err_1_20hd.asp
Any help would be greatly appreciated!!!
Thanks in advance!
Brian McCullough
Hi,
After reading your post I have one question.
Is XML file always the same size?
My opinion is that sometimes XML file (or string) is small enough to fit
into varchar (which I think you're using for data-type) and sometimes it os
too large (8075).
You could generaly solve the problem with using text or ntext as a datatype
in the affected column.
Danijel
"brianpmccullough" <bmccullough11@.comcast.net> wrote in message
news:593E87AE-3407-4ACB-9908-7F5A8969EAB8@.microsoft.com...
> Hello all,
> I have some VB6 code using ADO 2.5 running on a Windows 2003 Server box
> that
> sometimes fails when trying to update an ADO field type of adLongVarChar
> (stored as a text column in a SQL Server 2000 database, 6.5 compatiblity
> mode) and produces the following error:
> Error Number: -21472179
> Error Description: Cannot create a row of size 8075 which is greater than
> the allowable maximum of 8060.
> The error seems to be occurring when we try to update the field with a
> large
> string value. The strange thing is that it works without producing an
> error
> sometimes. The reason I say this is that I can see some entries in my
> table
> that have a DATALENGTH of the text field much larger than some of the ones
> that are failing.
> My VB6/ADO code looks like so:
> 'inserts a new record into a table with default values
> sql = "call mydatadatable_insert "
> Set objRecordset = New ADODB.Recordset
> objRecordset.CursorLocation = adUseClient
> Call objRecordset.Open(sql, objConnection, adOpenKeyset,
> adLockOptimistic)
> myID= objRecordset.Fields.Item("ID").Value
> objRecordset.Close
> Set objRecordset = Nothing
> 'loads a 23 KB xml file
> sXML = ReadFile("c:\temp\test.xml")
> '...more processing here (non database)
> sql = "exec mydatadatable_update" & cstr(myID)
> Set objRecordset = New ADODB.Recordset
> objRecordset.CursorLocation = adUseClient
> Call objRecordset.Open(sql, objConnection, adOpenKeyset,
> adLockOptimistic)
> 'this is the problem area!!
> objRecordset.Fields("FileTxt").Value = sXML
> objRecordset.Update
> objRecordset.Close
> Set objRecordset = Nothing
>
> I was thinking it might have something to do with the reference to ADO
> 2.5,
> rather than 2.8 which is what comes with Windows Server 2003. But again,
> it
> seems to be working some of the time.
> I found this article on Microsoft's site:
> http://msdn.microsoft.com/library/de...err_1_20hd.asp
> Any help would be greatly appreciated!!!
> Thanks in advance!
> Brian McCullough
Cannot create a connection to data source
When I open a report in the Report Server I get the following error:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ASCCSP'. (rsErrorOpeningConnection)
The ConnectionString property has not been initialized.
I am connecting to an Oracle database (using the Oracle client).
I have run into the problem before and have always been able to fix it by
giving the Web Service Identity, ASP.NET Service Account read/execute
permissions on the Oracle driver folder. This is not fixing the issue in
this case. The ASP.NET Service Account that I see in the Reporting Services
Configuration Manager is "NT Authority\Network Service". When I am adding
permissions to the security of the Oracle driver folder, I don't find an
exact match for this user (NT Authority\Network Service), I only find NETWORK
SERVICE. I gave NETWORK SERVICE read/execute rights to the Oracle client
folder. But no luck.
Any suggestions?
Thank you.
--
LaurieTCan you create a read-only user on the Oracle side and then enter those
credentials in the report connection?
"LaurieT" wrote:
> I am running SQL Server 2005, SP2 on a Windows Server 2003, SP1.
> When I open a report in the Report Server I get the following error:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection to data source 'ASCCSP'. (rsErrorOpeningConnection)
> The ConnectionString property has not been initialized.
> I am connecting to an Oracle database (using the Oracle client).
> I have run into the problem before and have always been able to fix it by
> giving the Web Service Identity, ASP.NET Service Account read/execute
> permissions on the Oracle driver folder. This is not fixing the issue in
> this case. The ASP.NET Service Account that I see in the Reporting Services
> Configuration Manager is "NT Authority\Network Service". When I am adding
> permissions to the security of the Oracle driver folder, I don't find an
> exact match for this user (NT Authority\Network Service), I only find NETWORK
> SERVICE. I gave NETWORK SERVICE read/execute rights to the Oracle client
> folder. But no luck.
> Any suggestions?
> Thank you.
> --
> LaurieT|||The issue is not with accessing the report data in Oracle (this works fine in
the business intelligence development studio, I can preview the reports here
with no issue) ... it is just with getting the Oracle client to run. When I
try to run reports through the Report Manager, I believe that Reporting
Services uses the Web Service Identity account to access and run the Oracle
client and in my case, it does not have the correct permissions to access and
run the client ... but I can't figure out how to change it.
--
LaurieT
"lonnye" wrote:
> Can you create a read-only user on the Oracle side and then enter those
> credentials in the report connection?
> "LaurieT" wrote:
> > I am running SQL Server 2005, SP2 on a Windows Server 2003, SP1.
> >
> > When I open a report in the Report Server I get the following error:
> > An error has occurred during report processing. (rsProcessingAborted)
> > Cannot create a connection to data source 'ASCCSP'. (rsErrorOpeningConnection)
> > The ConnectionString property has not been initialized.
> >
> > I am connecting to an Oracle database (using the Oracle client).
> >
> > I have run into the problem before and have always been able to fix it by
> > giving the Web Service Identity, ASP.NET Service Account read/execute
> > permissions on the Oracle driver folder. This is not fixing the issue in
> > this case. The ASP.NET Service Account that I see in the Reporting Services
> > Configuration Manager is "NT Authority\Network Service". When I am adding
> > permissions to the security of the Oracle driver folder, I don't find an
> > exact match for this user (NT Authority\Network Service), I only find NETWORK
> > SERVICE. I gave NETWORK SERVICE read/execute rights to the Oracle client
> > folder. But no luck.
> >
> > Any suggestions?
> >
> > Thank you.
> > --
> > LaurieT|||You can change the service accounts by using the Reporting Services
Configuration Tool... Here is a link to more info on how to do this:
http://technet.microsoft.com/en-us/library/bb326419.aspx
--
~lb
"LaurieT" wrote:
> The issue is not with accessing the report data in Oracle (this works fine in
> the business intelligence development studio, I can preview the reports here
> with no issue) ... it is just with getting the Oracle client to run. When I
> try to run reports through the Report Manager, I believe that Reporting
> Services uses the Web Service Identity account to access and run the Oracle
> client and in my case, it does not have the correct permissions to access and
> run the client ... but I can't figure out how to change it.
> --
> LaurieT
>
> "lonnye" wrote:
> > Can you create a read-only user on the Oracle side and then enter those
> > credentials in the report connection?
> >
> > "LaurieT" wrote:
> >
> > > I am running SQL Server 2005, SP2 on a Windows Server 2003, SP1.
> > >
> > > When I open a report in the Report Server I get the following error:
> > > An error has occurred during report processing. (rsProcessingAborted)
> > > Cannot create a connection to data source 'ASCCSP'. (rsErrorOpeningConnection)
> > > The ConnectionString property has not been initialized.
> > >
> > > I am connecting to an Oracle database (using the Oracle client).
> > >
> > > I have run into the problem before and have always been able to fix it by
> > > giving the Web Service Identity, ASP.NET Service Account read/execute
> > > permissions on the Oracle driver folder. This is not fixing the issue in
> > > this case. The ASP.NET Service Account that I see in the Reporting Services
> > > Configuration Manager is "NT Authority\Network Service". When I am adding
> > > permissions to the security of the Oracle driver folder, I don't find an
> > > exact match for this user (NT Authority\Network Service), I only find NETWORK
> > > SERVICE. I gave NETWORK SERVICE read/execute rights to the Oracle client
> > > folder. But no luck.
> > >
> > > Any suggestions?
> > >
> > > Thank you.
> > > --
> > > LaurieT
Cannot create a connection to data source
I created a report on data from another server. I can run the report just
fine on the server with Reporting Services.
When I try to run the report from my computer I get the cannot create
connection error. I have full rights to the server and sa privilages to SQL
Server on the RS server and the remote server on which the data is located.
I have checked with the Network administrator and kerberos is enabled.
I really need to get this working and prove to management that RS will do
all we need in the way of a reporting tool.
Your help will be apprecited.
RoyWith the June CTP comes the Surface Area Configuration tool. Launch the
tool and makes sure that remote connections are enabled for your SQL
Server. By default, SQL is much tighter on security and remote connections
are off after initial install.
--
| Thread-Topic: Cannot create a connection to data source
| thread-index: AcWsvM7xh3SUrYS9QcCFLHwzj12wwg==| X-WBNR-Posting-Host: 65.118.63.88
| From: =?Utf-8?B?Um95?= <Roy@.discussions.microsoft.com>
| Subject: Cannot create a connection to data source
| Date: Mon, 29 Aug 2005 10:12:17 -0700
| Lines: 12
| Message-ID: <EB5CC7FC-F898-48AC-A8CD-E9B6668EF797@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51349
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Windows 2003 Enterprise SP1, Sql Server 2005 June CTP.
| I created a report on data from another server. I can run the report just
| fine on the server with Reporting Services.
| When I try to run the report from my computer I get the cannot create
| connection error. I have full rights to the server and sa privilages to
SQL
| Server on the RS server and the remote server on which the data is
located.
| I have checked with the Network administrator and kerberos is enabled.
| I really need to get this working and prove to management that RS will do
| all we need in the way of a reporting tool.
| Your help will be apprecited.
| Roy
|
||||Brad,
I did set the server to allow remote connections.
Roy
""Brad Syputa - MS"" wrote:
> With the June CTP comes the Surface Area Configuration tool. Launch the
> tool and makes sure that remote connections are enabled for your SQL
> Server. By default, SQL is much tighter on security and remote connections
> are off after initial install.
> --
> | Thread-Topic: Cannot create a connection to data source
> | thread-index: AcWsvM7xh3SUrYS9QcCFLHwzj12wwg==> | X-WBNR-Posting-Host: 65.118.63.88
> | From: =?Utf-8?B?Um95?= <Roy@.discussions.microsoft.com>
> | Subject: Cannot create a connection to data source
> | Date: Mon, 29 Aug 2005 10:12:17 -0700
> | Lines: 12
> | Message-ID: <EB5CC7FC-F898-48AC-A8CD-E9B6668EF797@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51349
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Windows 2003 Enterprise SP1, Sql Server 2005 June CTP.
> | I created a report on data from another server. I can run the report just
> | fine on the server with Reporting Services.
> | When I try to run the report from my computer I get the cannot create
> | connection error. I have full rights to the server and sa privilages to
> SQL
> | Server on the RS server and the remote server on which the data is
> located.
> | I have checked with the Network administrator and kerberos is enabled.
> | I really need to get this working and prove to management that RS will do
> | all we need in the way of a reporting tool.
> | Your help will be apprecited.
> | Roy
> |
> |
>