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
Tuesday, March 27, 2012
Cannot enlist with MSX server
We have a server with the default instance and 2 additional named instances running SQL 2000 SP4. Recently I installed another instance for SQL Server 2005. We also use MSX/TSX approach to manage the servers so I tried to enlist the SQL 2005 instance with the master server using the
msdb..sp_msx_enlist @.msx_server_name = N'SQLMON', @.location = N'Datacentre. Margin Lending overnight copy'
and got this error,
Msg 22026, Level 16, State 1, Line 0
The enlist operation failed (reason: SQLServerAgent Error: Unable to connect to MSX 'SQLMON'.)
Looking at the text for this procedure it looks like it reads the wrong registry keys. The procedure it hardcoded to read,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent
This key doesn't exist, but this one does,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerAgent
Is this causing the connection error? I know that the MSX server is available as I can connect and query it in Management Studio.
http://msdn2.microsoft.com/en-us/library/ms365379.aspx
Please take a look at the above link on what has changed in MSX/TSX on security lines.
Also, note that in a mixed(SQL 2K and 2005) multi-server environment MSX can be only SQL 2000. TSXs can be both SQL 2K and 2005
|||Thanks for your reply. I set the Encryption option to zero.and was able to make the SQL 2005 server a TSX.
When will the encryption option be selecteable in the TSX setup wizard?
|||Unfortunately no. We have a tracking bug for the next release to expose it at SMO and UI levelCannot empty a data file to another using DBCC SHRINKFILE EMPTYFILE
A month ago, we were running out of disk space on a drive that stores
the data file for a SQL Server 7 database. So I added a new drive and
created a new data file on the primary filegroup and restricted the
growth of the first data file.
We have a new server now with heaps of space and I want to merge the two
data files into one but am running into huge issues. The reason why I
want to do this is to eliminate the possibilty that the creation of the
new data file is why our database has started to run a bit slower.
When I try to execute the DBCC SHRINKFILE data2,EMPTYFILE) I get the the
result "DBCC execution completed. If DBCC printed error messages,
contact your system administrator." within a matter of seconds... the
data2 file is still sitting on 11GB and the data1 file is on 28GB
(restricted file growth)... I noticed that the log file grew
significantly and the data2 file emptied out a little but it was still
at 11GB...
I have tried doing log backups, database backups then shrinking again
but still nothing...
If anyone knows how to get rid of the second primary data file it would
be MUCH appreciated...
Regards,
Auday Alwash
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
What service pack level do you have? There was a bug in SQL 7.0 with DBCC
SHRINKFILE with the EMPTYFILE option where heaps (tables with no clustered
index) & text pages were not always emptied properly - it was fixed in SP3.
For more info see: http://support.microsoft.com/kb/279511/EN-US/
HTH.
Cheers,
Mike
"Auday Alwash" <odies@.hotmail.com> wrote in message
news:eN7xN2RzEHA.3408@.tk2msftngp13.phx.gbl...
> Hi,
> A month ago, we were running out of disk space on a drive that stores
> the data file for a SQL Server 7 database. So I added a new drive and
> created a new data file on the primary filegroup and restricted the
> growth of the first data file.
> We have a new server now with heaps of space and I want to merge the two
> data files into one but am running into huge issues. The reason why I
> want to do this is to eliminate the possibilty that the creation of the
> new data file is why our database has started to run a bit slower.
> When I try to execute the DBCC SHRINKFILE data2,EMPTYFILE) I get the the
> result "DBCC execution completed. If DBCC printed error messages,
> contact your system administrator." within a matter of seconds... the
> data2 file is still sitting on 11GB and the data1 file is on 28GB
> (restricted file growth)... I noticed that the log file grew
> significantly and the data2 file emptied out a little but it was still
> at 11GB...
> I have tried doing log backups, database backups then shrinking again
> but still nothing...
> If anyone knows how to get rid of the second primary data file it would
> be MUCH appreciated...
> Regards,
> Auday Alwash
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hi Mike,
SQL Server is on Service Pack 3 already...
Can you think of anything else that could be causing this?
Regards,
Auday
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Auday
It removes the file which was emtied.
CREATE DATABASE test
GO
ALTER DATABASE test
ADD FILE
( NAME = ww,
FILENAME = 'D:\wwdat1.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
create table test..test(id int identity) on [primary]
--Performed many many inserts here.
dbcc shrinkfile(ww,EMPTYFILE)
GO
ALTER DATABASE test REMOVE FILE ww
select * from test.dbo.sysfiles
"Auday Alwash" <odies@.hotmail.com> wrote in message
news:OBXOVjUzEHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi Mike,
> SQL Server is on Service Pack 3 already...
> Can you think of anything else that could be causing this?
> Regards,
> Auday
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Make sure there is no one using data in the file... I can imagine that would
prevent the data movement...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Auday Alwash" <odies@.hotmail.com> wrote in message
news:eN7xN2RzEHA.3408@.tk2msftngp13.phx.gbl...
> Hi,
> A month ago, we were running out of disk space on a drive that stores
> the data file for a SQL Server 7 database. So I added a new drive and
> created a new data file on the primary filegroup and restricted the
> growth of the first data file.
> We have a new server now with heaps of space and I want to merge the two
> data files into one but am running into huge issues. The reason why I
> want to do this is to eliminate the possibilty that the creation of the
> new data file is why our database has started to run a bit slower.
> When I try to execute the DBCC SHRINKFILE data2,EMPTYFILE) I get the the
> result "DBCC execution completed. If DBCC printed error messages,
> contact your system administrator." within a matter of seconds... the
> data2 file is still sitting on 11GB and the data1 file is on 28GB
> (restricted file growth)... I noticed that the log file grew
> significantly and the data2 file emptied out a little but it was still
> at 11GB...
> I have tried doing log backups, database backups then shrinking again
> but still nothing...
> If anyone knows how to get rid of the second primary data file it would
> be MUCH appreciated...
> Regards,
> Auday Alwash
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
Cannot empty a data file to another using DBCC SHRINKFILE EMPTYFILE
A month ago, we were running out of disk space on a drive that stores
the data file for a SQL Server 7 database. So I added a new drive and
created a new data file on the primary filegroup and restricted the
growth of the first data file.
We have a new server now with heaps of space and I want to merge the two
data files into one but am running into huge issues. The reason why I
want to do this is to eliminate the possibilty that the creation of the
new data file is why our database has started to run a bit slower.
When I try to execute the DBCC SHRINKFILE data2,EMPTYFILE) I get the the
result "DBCC execution completed. If DBCC printed error messages,
contact your system administrator." within a matter of seconds... the
data2 file is still sitting on 11GB and the data1 file is on 28GB
(restricted file growth)... I noticed that the log file grew
significantly and the data2 file emptied out a little but it was still
at 11GB...
I have tried doing log backups, database backups then shrinking again
but still nothing...
If anyone knows how to get rid of the second primary data file it would
be MUCH appreciated...
Regards,
Auday Alwash
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!What service pack level do you have? There was a bug in SQL 7.0 with DBCC
SHRINKFILE with the EMPTYFILE option where heaps (tables with no clustered
index) & text pages were not always emptied properly - it was fixed in SP3.
For more info see: http://support.microsoft.com/kb/279511/EN-US/
HTH.
Cheers,
Mike
"Auday Alwash" <odies@.hotmail.com> wrote in message
news:eN7xN2RzEHA.3408@.tk2msftngp13.phx.gbl...
> Hi,
> A month ago, we were running out of disk space on a drive that stores
> the data file for a SQL Server 7 database. So I added a new drive and
> created a new data file on the primary filegroup and restricted the
> growth of the first data file.
> We have a new server now with heaps of space and I want to merge the two
> data files into one but am running into huge issues. The reason why I
> want to do this is to eliminate the possibilty that the creation of the
> new data file is why our database has started to run a bit slower.
> When I try to execute the DBCC SHRINKFILE data2,EMPTYFILE) I get the the
> result "DBCC execution completed. If DBCC printed error messages,
> contact your system administrator." within a matter of seconds... the
> data2 file is still sitting on 11GB and the data1 file is on 28GB
> (restricted file growth)... I noticed that the log file grew
> significantly and the data2 file emptied out a little but it was still
> at 11GB...
> I have tried doing log backups, database backups then shrinking again
> but still nothing...
> If anyone knows how to get rid of the second primary data file it would
> be MUCH appreciated...
> Regards,
> Auday Alwash
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi Mike,
SQL Server is on Service Pack 3 already...
Can you think of anything else that could be causing this?
Regards,
Auday
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Auday
It removes the file which was emtied.
CREATE DATABASE test
GO
ALTER DATABASE test
ADD FILE
( NAME = ww,
FILENAME = 'D:\wwdat1.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
create table test..test(id int identity) on [primary]
--Performed many many inserts here.
dbcc shrinkfile(ww,EMPTYFILE)
GO
ALTER DATABASE test REMOVE FILE ww
select * from test.dbo.sysfiles
"Auday Alwash" <odies@.hotmail.com> wrote in message
news:OBXOVjUzEHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi Mike,
> SQL Server is on Service Pack 3 already...
> Can you think of anything else that could be causing this?
> Regards,
> Auday
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Make sure there is no one using data in the file... I can imagine that would
prevent the data movement...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Auday Alwash" <odies@.hotmail.com> wrote in message
news:eN7xN2RzEHA.3408@.tk2msftngp13.phx.gbl...
> Hi,
> A month ago, we were running out of disk space on a drive that stores
> the data file for a SQL Server 7 database. So I added a new drive and
> created a new data file on the primary filegroup and restricted the
> growth of the first data file.
> We have a new server now with heaps of space and I want to merge the two
> data files into one but am running into huge issues. The reason why I
> want to do this is to eliminate the possibilty that the creation of the
> new data file is why our database has started to run a bit slower.
> When I try to execute the DBCC SHRINKFILE data2,EMPTYFILE) I get the the
> result "DBCC execution completed. If DBCC printed error messages,
> contact your system administrator." within a matter of seconds... the
> data2 file is still sitting on 11GB and the data1 file is on 28GB
> (restricted file growth)... I noticed that the log file grew
> significantly and the data2 file emptied out a little but it was still
> at 11GB...
> I have tried doing log backups, database backups then shrinking again
> but still nothing...
> If anyone knows how to get rid of the second primary data file it would
> be MUCH appreciated...
> Regards,
> Auday Alwash
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
Cannot empty a data file to another using DBCC SHRINKFILE EMPTYFILE
A month ago, we were running out of disk space on a drive that stores
the data file for a SQL Server 7 database. So I added a new drive and
created a new data file on the primary filegroup and restricted the
growth of the first data file.
We have a new server now with heaps of space and I want to merge the two
data files into one but am running into huge issues. The reason why I
want to do this is to eliminate the possibilty that the creation of the
new data file is why our database has started to run a bit slower.
When I try to execute the DBCC SHRINKFILE data2,EMPTYFILE) I get the the
result "DBCC execution completed. If DBCC printed error messages,
contact your system administrator." within a matter of seconds... the
data2 file is still sitting on 11GB and the data1 file is on 28GB
(restricted file growth)... I noticed that the log file grew
significantly and the data2 file emptied out a little but it was still
at 11GB...
I have tried doing log backups, database backups then shrinking again
but still nothing...
If anyone knows how to get rid of the second primary data file it would
be MUCH appreciated...
Regards,
Auday Alwash
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!What service pack level do you have? There was a bug in SQL 7.0 with DBCC
SHRINKFILE with the EMPTYFILE option where heaps (tables with no clustered
index) & text pages were not always emptied properly - it was fixed in SP3.
For more info see: http://support.microsoft.com/kb/279511/EN-US/
HTH.
--
Cheers,
Mike
"Auday Alwash" <odies@.hotmail.com> wrote in message
news:eN7xN2RzEHA.3408@.tk2msftngp13.phx.gbl...
> Hi,
> A month ago, we were running out of disk space on a drive that stores
> the data file for a SQL Server 7 database. So I added a new drive and
> created a new data file on the primary filegroup and restricted the
> growth of the first data file.
> We have a new server now with heaps of space and I want to merge the two
> data files into one but am running into huge issues. The reason why I
> want to do this is to eliminate the possibilty that the creation of the
> new data file is why our database has started to run a bit slower.
> When I try to execute the DBCC SHRINKFILE data2,EMPTYFILE) I get the the
> result "DBCC execution completed. If DBCC printed error messages,
> contact your system administrator." within a matter of seconds... the
> data2 file is still sitting on 11GB and the data1 file is on 28GB
> (restricted file growth)... I noticed that the log file grew
> significantly and the data2 file emptied out a little but it was still
> at 11GB...
> I have tried doing log backups, database backups then shrinking again
> but still nothing...
> If anyone knows how to get rid of the second primary data file it would
> be MUCH appreciated...
> Regards,
> Auday Alwash
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Make sure there is no one using data in the file... I can imagine that would
prevent the data movement...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Auday Alwash" <odies@.hotmail.com> wrote in message
news:eN7xN2RzEHA.3408@.tk2msftngp13.phx.gbl...
> Hi,
> A month ago, we were running out of disk space on a drive that stores
> the data file for a SQL Server 7 database. So I added a new drive and
> created a new data file on the primary filegroup and restricted the
> growth of the first data file.
> We have a new server now with heaps of space and I want to merge the two
> data files into one but am running into huge issues. The reason why I
> want to do this is to eliminate the possibilty that the creation of the
> new data file is why our database has started to run a bit slower.
> When I try to execute the DBCC SHRINKFILE data2,EMPTYFILE) I get the the
> result "DBCC execution completed. If DBCC printed error messages,
> contact your system administrator." within a matter of seconds... the
> data2 file is still sitting on 11GB and the data1 file is on 28GB
> (restricted file growth)... I noticed that the log file grew
> significantly and the data2 file emptied out a little but it was still
> at 11GB...
> I have tried doing log backups, database backups then shrinking again
> but still nothing...
> If anyone knows how to get rid of the second primary data file it would
> be MUCH appreciated...
> Regards,
> Auday Alwash
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
Cannot drop/restore or detach db
There are no connections or processes running against one
database yet I can't restore over it, detach it or drop it
because it says that it is in use. How is this possible'
Thanks
JUser DB or system DB?
>--Original Message--
>Hi ALL
>There are no connections or processes running against one
>database yet I can't restore over it, detach it or drop
it
>because it says that it is in use. How is this
possible'
>Thanks
>J
>.
>|||Make sure that you don't use the db from the connection where you want to drop it.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:045f01c3aef9$12df4e20$a501280a@.phx.gbl...
> Hi ALL
> There are no connections or processes running against one
> database yet I can't restore over it, detach it or drop it
> because it says that it is in use. How is this possible'
> Thanks
> Jsql
Sunday, March 25, 2012
Cannot drop the table "xyz" as it is being used for replication
Server 2000.
Both the PCs have a common DB installed on them.
The setup takes care of starting one PC as primary and other as
backup.
It also starts the SQL replication (transactional), where both the PCs
are configured as publisher, distributor and subscriber.
Now the replication service creates a publication ONLY ON
PRIMARY and a subscription ONLY ON BACKUP. The replication starts.
When a switch-over of primary and backup is done, the existing
publication and subscription are deleted. A new publication is created
on new PRIMARY and a new subscription on the new BACKUP. Again,
replication works without a problem.
HOWEVER, sometimes, (I'm not able to reproduce & it is very
infrequent) on a switch-over I get thee error--"Cannot drop the table
"xyz" as it is being used for replication." The table is the one I
used for replication. Also, the primary keys exist on this table in
this case even though it's a part of subscription. The only solution
till now is to delete the entire replication on both machines and
re-create it.
I'm not using this DB anywhere else for any other purpose. Any
clues, why am I getting this problem occasionaly?
Thanks in advance.
Nelabh,
it's sometimes the case that some replication metadata is left hanging
around in system tables. sp_removedbreplication usually fixes these issues,
or the more granular sp_MSunmarkreplinfo may also be of interest.
HTH,
Paul Ibison
Cannot deploy SSIS package on 64bit SQL Server
I have a SSIS package, which get data from oracle 9i, and dump into sql server 2005 64bit itanium, its running fine. When I am deploying the package on SQL Server 2005 its showing me the error with connection. on 64bit Oracle Net manager showing its able to connect oracle successfully. I think actually the problem is with encryption, as the package is developed on 32bit machine, therefore all connection strings are encrypted for that machine. Is there some has faced same issue? please help!
Please see this article which discusses the common encryption-related problems and ways to solve them:http://support.microsoft.com/kb/918760
Thursday, March 22, 2012
Cannot deploy new report
I been not been uploading any new reports for a while but reporting services is running fine on our network.
I added a new report via Visual studio 2003 today but got the following error when trying to deploy
a connection cannot be made to the report server.
Im not sure if sql server 2000 user has been taken off as I was doing a spring clean and may have remove the vital user. This is just a worry, maybe not true.
What users shoulod I have on SQL server to enable deploying of reports, or has anyone come across this problem?
Many thanks in advance
Scott
If anyone else has this problem, I have figured it out for me..
The SSL needed re-importing. Work fine after this. When importing into IE I allowed the system to decided where to put it rather than selecting myself. Hope that helps anyone else
Scott
sqlCannot delete users in SQL 2005?
Hi,
Running multiple SQL 2000 servers and on each can easily go under Enterprise Manager>>ServerXYZ>>Security>>Logins>>Delete and delete user regardless users DB membership etc...now installed SQL 2005 (MS SQL Server Management Studio) and trying to do the same (attached to server running SQL 2000) and I cannot do it. Each time I try it, I am getting:
TITLE: Microsoft SQL Server Management Studio
Drop failed for Login 'testdelete'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3033.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Login&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Login 'testdelete' is aliased or mapped to a user in one or more database(s). Drop the user or alias before dropping the login. (Microsoft SQL Server, Error: 15175)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=15175&LinkId=20476
BUTTONS:
OK
If I go and manually remove user from all databases and then try to delete it only then I can delete such user...this is not the solution for me as we have some servers where users can be associated up to different 300+ databases.
I would like to move from 2000 and start using 2005 tools exclusively and this is only reason I cannot.
Any fix, suggestion or solution is appreciated. Thanks.
I believe the error is by default as you can see that user is mapped/aliased to other databases, if you are using linked servers then thsi is expected. As a matter of access can you try revoking the permissions for that user and then drop it.|||Thanks for your reply.
Yes I know what the message is meaning but what I do not understand is how I can just go to any user setup with access to multiple databases on same server (not linked) and select "Delete" using SQL 2000 Enterprise Manager and it drops it w/o any issues but when I go to the same server and user with same setup under SQL 2005 Server Managment Studio it tells me that user is associated to other databases and it cannot delete it w/o me first revoking all the access just then to drop it (that works)...this is lot more complex and requires extra steps?
|||The issue is not so much that the login has mapped users, but that the mapped users own something in a database. In SQL Server 2005, we made security enhancements that require every object to be owned by some security principal. A user can no longer simply relinquish ownership. Instead, ownership must be positively taken by some other principal. Once all the users mapped to the login are no longer owners of anything, you should be able to drop the login without error.
This sounds like a pain point for you. If you could file a suggestion to make this easier at http://connect.microsoft.com/sqlserver, that would help. The development team gives additional weight to defect reports and feature requests submitted by customers when we are prioritizing future work.
Hope this helps,
Steve
Cannot delete users in SQL 2005?
Hi,
Running multiple SQL 2000 servers and on each can easily go under Enterprise Manager>>ServerXYZ>>Security>>Logins>>Delete and delete user regardless users DB membership etc...now installed SQL 2005 (MS SQL Server Management Studio) and trying to do the same (attached to server running SQL 2000) and I cannot do it. Each time I try it, I am getting:
TITLE: Microsoft SQL Server Management Studio
Drop failed for Login 'testdelete'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3033.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Login&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Login 'testdelete' is aliased or mapped to a user in one or more database(s). Drop the user or alias before dropping the login. (Microsoft SQL Server, Error: 15175)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=15175&LinkId=20476
BUTTONS:
OK
If I go and manually remove user from all databases and then try to delete it only then I can delete such user...this is not the solution for me as we have some servers where users can be associated up to different 300+ databases.
I would like to move from 2000 and start using 2005 tools exclusively and this is only reason I cannot.
Any fix, suggestion or solution is appreciated. Thanks.
I believe the error is by default as you can see that user is mapped/aliased to other databases, if you are using linked servers then thsi is expected. As a matter of access can you try revoking the permissions for that user and then drop it.|||Thanks for your reply.
Yes I know what the message is meaning but what I do not understand is how I can just go to any user setup with access to multiple databases on same server (not linked) and select "Delete" using SQL 2000 Enterprise Manager and it drops it w/o any issues but when I go to the same server and user with same setup under SQL 2005 Server Managment Studio it tells me that user is associated to other databases and it cannot delete it w/o me first revoking all the access just then to drop it (that works)...this is lot more complex and requires extra steps?
|||The issue is not so much that the login has mapped users, but that the mapped users own something in a database. In SQL Server 2005, we made security enhancements that require every object to be owned by some security principal. A user can no longer simply relinquish ownership. Instead, ownership must be positively taken by some other principal. Once all the users mapped to the login are no longer owners of anything, you should be able to drop the login without error.
This sounds like a pain point for you. If you could file a suggestion to make this easier at http://connect.microsoft.com/sqlserver, that would help. The development team gives additional weight to defect reports and feature requests submitted by customers when we are prioritizing future work.
Hope this helps,
Steve
Tuesday, March 20, 2012
Cannot create user on Report Server 2005
running 2000.
I launched the reports website.
When I try to do New System Role Assignment, I type in a domain user and
select a role and click OK, nothing at all happens. No error message, no
response, nothing.
Does anyone have any idea what might be going on?What I tend to do is create a local group and add my domain users to the
local group. Two things to try. Did you put the domain in front of the user?
I.e. MyDomain\Username
Second, are you in the local administrators group. Perhaps you don't have
rights to be doing this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RebeccaTS" <RebeccaTS@.discussions.microsoft.com> wrote in message
news:730D7944-B019-4E7A-8B9C-EA7EEB33486A@.microsoft.com...
> Hi, we installed SQL Server 2005 & Reporting Services on a box that had
> been
> running 2000.
> I launched the reports website.
> When I try to do New System Role Assignment, I type in a domain user and
> select a role and click OK, nothing at all happens. No error message, no
> response, nothing.
> Does anyone have any idea what might be going on?
Cannot create subscriptions from Management Studio
Reports have shared Data Source with stored credentials
SQL Agent is up and running
In surface area configuration "Scheduling and delivery" for SSRS are enabled
SSRS Execution account has been set up
E-mail settings are fine
I'm logged in as Admin, able to everything, but...
When I right-click on report/subscriptions folder, both "New subscription"
and "New data driven subscription" are DISABLED.
What's wrong? That's driving me crazy!
DmitryHello Dmitry,
I would like to know, when you try to use the Report Manager Via web
interface,
If you try to use the Report Manager via web and create the subscription,
what's the result?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:sOpkHyeGIHA.4268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I would like to know, when you try to use the Report Manager Via web
> interface,
> If you try to use the Report Manager via web and create the subscription,
> what's the result?
I am using custom (forms) security and the admin can only log in through
Management Studio. For security purposes (this is internet-faced
application) no separate login pages for SSRS exist.
Regular users (authenticated and authorized) can see the reports inside web
application via ReportViewer control, which is getting the instance of
IReportServerCredentials.
Regards,
Dmitry|||Hello Dmitry,
Well, since you are using the form authentication, the management studio
may not connect to the reporting services correctly.
I would like to know whether the admin account you use have the proper
permission of reporting services.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:bIg%23C9rGIHA.4200@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Well, since you are using the form authentication, the management studio
> may not connect to the reporting services correctly.
> I would like to know whether the admin account you use have the proper
> permission of reporting services.
Yes, the admin is in any possible role. I already mentioned that in my
initial message. I'm able to do everything that's not subscriptions related.
Subscription-related menu items are simply disabled and I need to know why.
Dmitry.|||Hello Dmitry,
The admin you use is a domain account or a form authentication account?
Have you checked what's the role of this account on the reporting services?
Is it a System admin ?
Also, for the report, does it have the Manage all subscriptions permission?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:2rG$mH3GIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> The admin you use is a domain account or a form authentication account?
There's no such account technically. Admin is authenticated by
username/password inside forms security extension and after that it is given
unlimited access in any CheckAccess method...
> Have you checked what's the role of this account on the reporting
> services?
I answered this question already:
System User
System Administrator
Browser
Content Manager
Publisher
Report Builder
> Is it a System admin ?
Yes.
> Also, for the report, does it have the Manage all subscriptions
> permission?
Through Content Manager role, yes
As a matter of fact I have just installed the second instance of RS with
standard security and all the defaults. And I observe the same damn thing:
subscription related menu items are disabled in Management studio, but I can
create subscriptions using the same Windows credentials in the browser.
Which tells me the original issue may be not related to my custom security
extension at all.
Regards,
Dmitry|||Hello Dmitry,
Could you please let me know the config file content?
rsreportserver.config and RSWebApplication.config under the ReportManager
and Reporserver folder is appreicated.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:p$%23GYM5GIHA.5176@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you please let me know the config file content?
> rsreportserver.config and RSWebApplication.config under the ReportManager
> and Reporserver folder is appreicated.
E-mail delivery of those files failed. Please provide valid e-mail address.
The following message to <weilu@.online.microsoft.com> was undeliverable.
The reason for the problem:
5.1.2 - Bad destination host 'DNS Hard Error looking up online.microsoft.com
(MX): NXDomain'|||Hello Dmitry,
Please remove the ONLINE in my display email.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Dmitry,
I get your email.
I would like to suggest you check the web services account you use.
Could you please change it to the network services?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:7mWE3N4HIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I get your email.
> I would like to suggest you check the web services account you use.
> Could you please change it to the network services?
Please advise WHERE EXACTLY this change to be made.
D.|||Hello Dmitry,
There is an element in the reportserver.config file:
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
Please modify it like this.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:R78DbCCIIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> There is an element in the reportserver.config file:
> <WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
> Please modify it like this.
It is configured to be running as MYPCNAME\ASPNET
If I modify "like this" I'm getting the following message while trying to
navigate to any folder in Management Studio:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
--
ADDITIONAL INFORMATION:
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Report Services SOAP Proxy Source)
--
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Microsoft.ReportingServices.Diagnostics)
D.|||Hello Dmitry,
I am performing some test on my side. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Dima,
I would like to know whether you have applied the latest service pack of
sql server and have you stored the credential for the report.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:K1afiFOLIHA.6908@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dima,
> I would like to know whether you have applied the latest service pack of
> sql server
It is 9.00.3054.00
> and have you stored the credential for the report.
There is no such thing as "stored credential for the report"
If you mean "stored credentials for the DATA SOURCE", yes that's the case.
Dmitry|||Hello Dmitry,
Could you lease send me an email and that I may involve other resources?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:j33I7UmMIHA.4380@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you lease send me an email and that I may involve other resources?
Wei,
I sent you the e-mail a week ago. Where are those "other resourses"?
D.|||Hello,
My colleague is Out of Office. Once he is back, I will escalate this issue.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Monday, March 19, 2012
Cannot create INSTANCENAME
MSDE is already running supporting Veritas Backup exec and another
application.
Attempting to configure WSUS.
Need to create a new INSTANCENAME=WSUS
Command line setup SAPWD="oursapwd" INSTANCENAME="WSUS"
What I get is this a blackened screen with "Windows 2000 Setup" in the upper
right hand corner. In the center of the screen is a blank menu box entitled
"Usage"
ERRORLOG: entries
2005-07-06 15:33:40.19 server Microsoft SQL Server 2000 - 8.00.818
(Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4)
2005-07-06 15:33:40.19 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-07-06 15:33:40.20 server All rights reserved.
2005-07-06 15:33:40.20 server Server Process ID is 9384.
2005-07-06 15:33:40.20 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2005-07-06 15:33:40.20 server SQL Server is starting at priority class
'normal'(4 CPUs detected).
2005-07-06 15:33:40.31 server SQL Server configured for thread mode
processing.
2005-07-06 15:33:40.31 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-07-06 15:33:40.34 spid3 Starting up database 'master'.
2005-07-06 15:33:40.45 spid5 Starting up database 'model'.
2005-07-06 15:33:40.45 server Using 'SSNETLIB.DLL' version '8.0.818'.
2005-07-06 15:33:40.47 spid3 Server name is: "Left Blank".
2005-07-06 15:33:40.47 spid3 Skipping startup of clean database id 4
2005-07-06 15:33:40.47 spid3 Skipping startup of clean database id 5
2005-07-06 15:33:40.47 spid3 Starting up database 'SUSDB'.
2005-07-06 15:33:40.53 server SQL server listening on Shared Memory.
2005-07-06 15:33:40.53 server SQL Server is ready for client connections
2005-07-06 15:33:40.56 spid5 Clearing tempdb database.
2005-07-06 15:33:40.56 spid3 3 transactions rolled forward in database
'SUSDB' (6).
2005-07-06 15:33:40.58 spid3 0 transactions rolled back in database
'SUSDB' (6).
2005-07-06 15:33:40.58 spid3 Recovery is checkpointing database 'SUSDB'
(6)
2005-07-06 15:33:40.76 spid5 Starting up database 'tempdb'.
2005-07-06 15:33:40.80 spid3 Recovery complete.
2005-07-06 15:33:40.80 spid3 SQL global counter collection task is
created.
2005-07-06 15:33:43.64 spid51 Starting up database 'SUSDB'.
2005-07-06 15:48:59.22 spid52 Starting up database 'msdb'.
2005-07-06 15:48:59.44 spid52 Using 'xpsqlbot.dll' version '2000.80.760'
to execute extended stored procedure 'xp_qv'.
hi,
Lokton wrote:
> SVR: W2KADV SP4
> MSDE is already running supporting Veritas Backup exec and another
> application.
> Attempting to configure WSUS.
> Need to create a new INSTANCENAME=WSUS
> Command line setup SAPWD="oursapwd" INSTANCENAME="WSUS"
> What I get is this a blackened screen with "Windows 2000 Setup" in
> the upper right hand corner. In the center of the screen is a blank
> menu box entitled "Usage"
> ERRORLOG: entries
this is the error log of the default MSDE instance probably used by Veritas
and other sw...
if you are using the new sp4 ugraded MSDE installation package, please try
omitting the quotes surrounding "oursapwd" and "WSUS"
then please add the
/L*v "c:\msdelog.txt"
parameter to your call to setup.exe boostrap installer, in order to allow
verbose logging of the installation process.. should error(s) be raised a
RETURN VALUE 3
will be written to the log, and about 10/15 lines before each entry some
(sometime criptic) description of the problem will be reported...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Sunday, March 11, 2012
Cannot CREATE ASSEMBLY
I am new to SQL Server 2005 but not to dotnet development. I am trying to
use the CREATE ASSEMBLY on my machine that is running the developer edition.
The ASSEMBLY keyword is not highlighted as a recognised keyword and when I
run the SQL it fails (see below). Have I not enabled something or have I
just installed it incorrectly?
CREATE ASSEMBLY
helloworld FROM 'c:\helloworld.dll'
WITH PERMISSION_SET = SAFE
Regards,
Landers
Hello landers,
Some questions first:
a.) What error message do you actually get?
b.) What are you using for a T-SQL editor?
c.) If you run xp_msver, what output do you get?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
Cannot CREATE ASSEMBLY
I am new to SQL Server 2005 but not to dotnet development. I am trying to
use the CREATE ASSEMBLY on my machine that is running the developer edition.
The ASSEMBLY keyword is not highlighted as a recognised keyword and when I
run the SQL it fails (see below). Have I not enabled something or have I
just installed it incorrectly?
CREATE ASSEMBLY
helloworld FROM 'c:\helloworld.dll'
WITH PERMISSION_SET = SAFE
Regards,
LandersHello landers,
Some questions first:
a.) What error message do you actually get?
b.) What are you using for a T-SQL editor?
c.) If you run xp_msver, what output do you get?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
Cannot CREATE ASSEMBLY
I am new to SQL Server 2005 but not to dotnet development. I am trying to
use the CREATE ASSEMBLY on my machine that is running the developer edition.
The ASSEMBLY keyword is not highlighted as a recognised keyword and when I
run the SQL it fails (see below). Have I not enabled something or have I
just installed it incorrectly?
CREATE ASSEMBLY
helloworld FROM 'c:\helloworld.dll'
WITH PERMISSION_SET = SAFE
Regards,
LandersHello landers,
Some questions first:
a.) What error message do you actually get?
b.) What are you using for a T-SQL editor?
c.) If you run xp_msver, what output do you get?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
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