Problem running data driven subscription

I've been testing out a scenario for running data driven
subscriptions. I've successfully scheduled a subscription, and at
the appointed time the subscription runs. Report Manager says it runs
with no error, however the reports aren't generated. The event log
says "An encrypted user data value could not be decrypted." I've
done a search on this message and haven't turned up anything useful.
I assume it is trying to retrieve some encrypted info from a config
file but it isn't obvious where the error might be. I've checked the
connection information in the subscription and all seems OK. I am
testing using SQL Server security at the moment. Thanks for any help
anyone can offer.Does this happen for all subscriptions or just this one? Can you try
creating a new subscription identical to the old one and see if it works?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve Coatney Geac" <steve.coatney@.geac.com> wrote in message
news:22acd8cb.0407181305.394befa9@.posting.google.com...
> I've been testing out a scenario for running data driven
> subscriptions. I've successfully scheduled a subscription, and at
> the appointed time the subscription runs. Report Manager says it runs
> with no error, however the reports aren't generated. The event log
> says "An encrypted user data value could not be decrypted." I've
> done a search on this message and haven't turned up anything useful.
> I assume it is trying to retrieve some encrypted info from a config
> file but it isn't obvious where the error might be. I've checked the
> connection information in the subscription and all seems OK. I am
> testing using SQL Server security at the moment. Thanks for any help
> anyone can offer.

Problem Registering Existing Server

I am trying to reregister an existing server that we've been able to
register previously.
I can successfully register it inside the network, i.e., from another
workstation on the network, but when I try to register via a gateway, i.e.,
over the internet I can't. I can ping the server, and the router has port
forwarding setup correctly (port 1433), I've turned off the firewall, and
nothing else has changed that I am aware of, but it just won't respond. I
am confident that the SA password is correct.
I'm stumped. I have remote users who need to access this server, but can't
get in.
Can anyone give me any suggestions. I've tried everything I can imagine.
The one change on this system is that we had to reinstall the Server, and
we've installed CA Antivirus. But I've uninstalled the CA firewall
software, and turned off the Windows Firewall (just to get this up...we had
it running before with SQL traffic allowed).
Any Ideas are welcome!!
Bob
Hi Bob
"Bob Bartel" wrote:

> I am trying to reregister an existing server that we've been able to
> register previously.
> I can successfully register it inside the network, i.e., from another
> workstation on the network, but when I try to register via a gateway, i.e.,
> over the internet I can't. I can ping the server, and the router has port
> forwarding setup correctly (port 1433), I've turned off the firewall, and
> nothing else has changed that I am aware of, but it just won't respond. I
> am confident that the SA password is correct.
> I'm stumped. I have remote users who need to access this server, but can't
> get in.
> Can anyone give me any suggestions. I've tried everything I can imagine.
> The one change on this system is that we had to reinstall the Server, and
> we've installed CA Antivirus. But I've uninstalled the CA firewall
> software, and turned off the Windows Firewall (just to get this up...we had
> it running before with SQL traffic allowed).
> Any Ideas are welcome!!
> Bob
>
It would be safer to use a VPN for this rather than leaving the server open.
http://support.microsoft.com/kb/287932 describes the communication between
the client and server, make sure you are using TCP/IP protcols and the client
is not blocking the returning traffic. If you have set up this correctly you
should be in-undated with people trying to hack in.
John
|||As I mentioned, I have already had this working before. And only shut down
my firewall for this test. I agree a VPN is a good choice and I'll probably
turn it on, but...
But the real problem is that even with the router correctly forwarding 1433
and the firewall configured to allow the traffic, I can't register the
server remotely.
The only thing I can think of that may be effecting it is that I had to
reinstall the server. Can anyone think of anything that would keep remote
users from registering with a new install? Is there some setting on the
server that I neglected to turn back on?
Bob
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5E55FAA1-601D-4DED-8E5C-0324E2ED46B6@.microsoft.com...
> Hi Bob
> "Bob Bartel" wrote:
> It would be safer to use a VPN for this rather than leaving the server
> open.
> http://support.microsoft.com/kb/287932 describes the communication between
> the client and server, make sure you are using TCP/IP protcols and the
> client
> is not blocking the returning traffic. If you have set up this correctly
> you
> should be in-undated with people trying to hack in.
> John
|||Hi
"Bob Bartel" wrote:

> As I mentioned, I have already had this working before. And only shut down
> my firewall for this test. I agree a VPN is a good choice and I'll probably
> turn it on, but...
> But the real problem is that even with the router correctly forwarding 1433
> and the firewall configured to allow the traffic, I can't register the
> server remotely.
> The only thing I can think of that may be effecting it is that I had to
> reinstall the server. Can anyone think of anything that would keep remote
> users from registering with a new install? Is there some setting on the
> server that I neglected to turn back on?
> Bob
>
If this is SQL Express you may not have turned on remote access. If this is
a named instance then it would not be using the default ports.
John
|||Its a named instance...where to I specify the port?
bob
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1B0EB2A5-8E12-41C2-9D87-5C38176D1783@.microsoft.com...
> Hi
> "Bob Bartel" wrote:
> If this is SQL Express you may not have turned on remote access. If this
> is
> a named instance then it would not be using the default ports.
> John
|||Hi Bob
"Bob Bartel" wrote:

> Its a named instance...where to I specify the port?
> bob
In the SQL Server Configuration manager there will be an entry in the SQL
Server 2005 Network Configuration branch for your instance. This will shows
which protocols are installed and enabled. Right clicking TCP/IP and choosing
properties and on the IP Address tab you can set the protocol to be enabled
and also set the port. You will need to make sure that there are no other
instances using this port.
John

Problem Registering Existing Server

I am trying to reregister an existing server that we've been able to
register previously.
I can successfully register it inside the network, i.e., from another
workstation on the network, but when I try to register via a gateway, i.e.,
over the internet I can't. I can ping the server, and the router has port
forwarding setup correctly (port 1433), I've turned off the firewall, and
nothing else has changed that I am aware of, but it just won't respond. I
am confident that the SA password is correct.
I'm stumped. I have remote users who need to access this server, but can't
get in.
Can anyone give me any suggestions. I've tried everything I can imagine.
The one change on this system is that we had to reinstall the Server, and
we've installed CA Antivirus. But I've uninstalled the CA firewall
software, and turned off the Windows Firewall (just to get this up...we had
it running before with SQL traffic allowed).
Any Ideas are welcome!!
BobHi Bob
"Bob Bartel" wrote:
> I am trying to reregister an existing server that we've been able to
> register previously.
> I can successfully register it inside the network, i.e., from another
> workstation on the network, but when I try to register via a gateway, i.e.,
> over the internet I can't. I can ping the server, and the router has port
> forwarding setup correctly (port 1433), I've turned off the firewall, and
> nothing else has changed that I am aware of, but it just won't respond. I
> am confident that the SA password is correct.
> I'm stumped. I have remote users who need to access this server, but can't
> get in.
> Can anyone give me any suggestions. I've tried everything I can imagine.
> The one change on this system is that we had to reinstall the Server, and
> we've installed CA Antivirus. But I've uninstalled the CA firewall
> software, and turned off the Windows Firewall (just to get this up...we had
> it running before with SQL traffic allowed).
> Any Ideas are welcome!!
> Bob
>
It would be safer to use a VPN for this rather than leaving the server open.
http://support.microsoft.com/kb/287932 describes the communication between
the client and server, make sure you are using TCP/IP protcols and the client
is not blocking the returning traffic. If you have set up this correctly you
should be in-undated with people trying to hack in.
John|||As I mentioned, I have already had this working before. And only shut down
my firewall for this test. I agree a VPN is a good choice and I'll probably
turn it on, but...
But the real problem is that even with the router correctly forwarding 1433
and the firewall configured to allow the traffic, I can't register the
server remotely.
The only thing I can think of that may be effecting it is that I had to
reinstall the server. Can anyone think of anything that would keep remote
users from registering with a new install? Is there some setting on the
server that I neglected to turn back on?
Bob
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5E55FAA1-601D-4DED-8E5C-0324E2ED46B6@.microsoft.com...
> Hi Bob
> "Bob Bartel" wrote:
>> I am trying to reregister an existing server that we've been able to
>> register previously.
>> I can successfully register it inside the network, i.e., from another
>> workstation on the network, but when I try to register via a gateway,
>> i.e.,
>> over the internet I can't. I can ping the server, and the router has
>> port
>> forwarding setup correctly (port 1433), I've turned off the firewall,
>> and
>> nothing else has changed that I am aware of, but it just won't respond.
>> I
>> am confident that the SA password is correct.
>> I'm stumped. I have remote users who need to access this server, but
>> can't
>> get in.
>> Can anyone give me any suggestions. I've tried everything I can imagine.
>> The one change on this system is that we had to reinstall the Server, and
>> we've installed CA Antivirus. But I've uninstalled the CA firewall
>> software, and turned off the Windows Firewall (just to get this up...we
>> had
>> it running before with SQL traffic allowed).
>> Any Ideas are welcome!!
>> Bob
> It would be safer to use a VPN for this rather than leaving the server
> open.
> http://support.microsoft.com/kb/287932 describes the communication between
> the client and server, make sure you are using TCP/IP protcols and the
> client
> is not blocking the returning traffic. If you have set up this correctly
> you
> should be in-undated with people trying to hack in.
> John|||Hi
"Bob Bartel" wrote:
> As I mentioned, I have already had this working before. And only shut down
> my firewall for this test. I agree a VPN is a good choice and I'll probably
> turn it on, but...
> But the real problem is that even with the router correctly forwarding 1433
> and the firewall configured to allow the traffic, I can't register the
> server remotely.
> The only thing I can think of that may be effecting it is that I had to
> reinstall the server. Can anyone think of anything that would keep remote
> users from registering with a new install? Is there some setting on the
> server that I neglected to turn back on?
> Bob
>
If this is SQL Express you may not have turned on remote access. If this is
a named instance then it would not be using the default ports.
John|||Its a named instance...where to I specify the port?
bob
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1B0EB2A5-8E12-41C2-9D87-5C38176D1783@.microsoft.com...
> Hi
> "Bob Bartel" wrote:
>> As I mentioned, I have already had this working before. And only shut
>> down
>> my firewall for this test. I agree a VPN is a good choice and I'll
>> probably
>> turn it on, but...
>> But the real problem is that even with the router correctly forwarding
>> 1433
>> and the firewall configured to allow the traffic, I can't register the
>> server remotely.
>> The only thing I can think of that may be effecting it is that I had to
>> reinstall the server. Can anyone think of anything that would keep
>> remote
>> users from registering with a new install? Is there some setting on the
>> server that I neglected to turn back on?
>> Bob
>>
> If this is SQL Express you may not have turned on remote access. If this
> is
> a named instance then it would not be using the default ports.
> John|||Hi Bob
"Bob Bartel" wrote:
> Its a named instance...where to I specify the port?
> bob
In the SQL Server Configuration manager there will be an entry in the SQL
Server 2005 Network Configuration branch for your instance. This will shows
which protocols are installed and enabled. Right clicking TCP/IP and choosing
properties and on the IP Address tab you can set the protocol to be enabled
and also set the port. You will need to make sure that there are no other
instances using this port.
John

Problem Registering Existing Server

I am trying to reregister an existing server that we've been able to
register previously.
I can successfully register it inside the network, i.e., from another
workstation on the network, but when I try to register via a gateway, i.e.,
over the internet I can't. I can ping the server, and the router has port
forwarding setup correctly (port 1433), I've turned off the firewall, and
nothing else has changed that I am aware of, but it just won't respond. I
am confident that the SA password is correct.
I'm stumped. I have remote users who need to access this server, but can't
get in.
Can anyone give me any suggestions. I've tried everything I can imagine.
The one change on this system is that we had to reinstall the Server, and
we've installed CA Antivirus. But I've uninstalled the CA firewall
software, and turned off the Windows Firewall (just to get this up...we had
it running before with SQL traffic allowed).
Any Ideas are welcome!!
BobHi Bob
"Bob Bartel" wrote:

> I am trying to reregister an existing server that we've been able to
> register previously.
> I can successfully register it inside the network, i.e., from another
> workstation on the network, but when I try to register via a gateway, i.e.
,
> over the internet I can't. I can ping the server, and the router has port
> forwarding setup correctly (port 1433), I've turned off the firewall, and
> nothing else has changed that I am aware of, but it just won't respond. I
> am confident that the SA password is correct.
> I'm stumped. I have remote users who need to access this server, but can'
t
> get in.
> Can anyone give me any suggestions. I've tried everything I can imagine.
> The one change on this system is that we had to reinstall the Server, and
> we've installed CA Antivirus. But I've uninstalled the CA firewall
> software, and turned off the Windows Firewall (just to get this up...we ha
d
> it running before with SQL traffic allowed).
> Any Ideas are welcome!!
> Bob
>
It would be safer to use a VPN for this rather than leaving the server open.
http://support.microsoft.com/kb/287932 describes the communication between
the client and server, make sure you are using TCP/IP protcols and the clien
t
is not blocking the returning traffic. If you have set up this correctly you
should be in-undated with people trying to hack in.
John|||As I mentioned, I have already had this working before. And only shut down
my firewall for this test. I agree a VPN is a good choice and I'll probably
turn it on, but...
But the real problem is that even with the router correctly forwarding 1433
and the firewall configured to allow the traffic, I can't register the
server remotely.
The only thing I can think of that may be effecting it is that I had to
reinstall the server. Can anyone think of anything that would keep remote
users from registering with a new install? Is there some setting on the
server that I neglected to turn back on?
Bob
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5E55FAA1-601D-4DED-8E5C-0324E2ED46B6@.microsoft.com...
> Hi Bob
> "Bob Bartel" wrote:
>
> It would be safer to use a VPN for this rather than leaving the server
> open.
> http://support.microsoft.com/kb/287932 describes the communication between
> the client and server, make sure you are using TCP/IP protcols and the
> client
> is not blocking the returning traffic. If you have set up this correctly
> you
> should be in-undated with people trying to hack in.
> John|||Hi
"Bob Bartel" wrote:

> As I mentioned, I have already had this working before. And only shut dow
n
> my firewall for this test. I agree a VPN is a good choice and I'll probab
ly
> turn it on, but...
> But the real problem is that even with the router correctly forwarding 143
3
> and the firewall configured to allow the traffic, I can't register the
> server remotely.
> The only thing I can think of that may be effecting it is that I had to
> reinstall the server. Can anyone think of anything that would keep remote
> users from registering with a new install? Is there some setting on the
> server that I neglected to turn back on?
> Bob
>
If this is SQL Express you may not have turned on remote access. If this is
a named instance then it would not be using the default ports.
John|||Its a named instance...where to I specify the port?
bob
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1B0EB2A5-8E12-41C2-9D87-5C38176D1783@.microsoft.com...
> Hi
> "Bob Bartel" wrote:
>
> If this is SQL Express you may not have turned on remote access. If this
> is
> a named instance then it would not be using the default ports.
> John|||Hi Bob
"Bob Bartel" wrote:

> Its a named instance...where to I specify the port?
> bob
In the SQL Server Configuration manager there will be an entry in the SQL
Server 2005 Network Configuration branch for your instance. This will shows
which protocols are installed and enabled. Right clicking TCP/IP and choosin
g
properties and on the IP Address tab you can set the protocol to be enabled
and also set the port. You will need to make sure that there are no other
instances using this port.
John

problem on importing datas from .csv file to sql 2005 database using DTS

Hello,

I'm running into an issue on importing datas from a .csv file to sql 2005 database.
All my datas has been imported successfully but the datas with doublequotes(") are imported along with additional double quotes.
For example, a cell has the data, iron rod - 34" and this has been imported as "iron rod - 34"""

Can anyone please help me to come out of this issue.

Thanks.

Raviraj Danasekaran

If you are using integration services wizard then set the text qualifier to " in the flat file source connection settings

PROBLEM INSTALLING SQL SERVER EXPRESS

Hi,

I successfully installed Visual Basic 2005 express edition and but the SQL Server component did not get installed.

12:37:11 AM Sunday, April 09, 2006: [Fail] ConfigSamplesDll_DoTasks:: [Fail] Config_SSE_INST_Install: SQL Express service install (failed). The process did not return a success value. ExitCode: 1282 Command: 'C:\Documents and Settings\Oluwaseyi Awoga\Local Settings\Temp\SQLEXPR32.exe -q /norebootchk /qn reboot=ReallySuppress addlocal=all SCCCHECKLEVEL=IncompatibleComponents:1 instancename=SQLEXPRESS'.

I keep getting this error. Can anybody help me? I have uninstalled and installed ALL versions of the .NET framework etc several times. Thanks

This is also the error signature. Thanks for your help.

Error Signature:
EventType : BEX P1 : setup.exe P2 : 2005.90.1399.0 P3 : 434f6403
P4 : msdtcprx.dll P5 : 2001.12.4414.258 P6 : 41109703 P7 : 0000a2c9
P8 : c0000409 P9 : 00000000

|||

This is the content of the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files

Microsoft SQL Server 2005 Setup beginning at Sun Apr 09 01:46:18 2006
Process ID : 952
c:\e37376beb65a16277a8441b9\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/3/9 1:46:17
Complete: LoadResourcesAction at: 2006/3/9 1:46:18, returned true
Running: ParseBootstrapOptionsAction at: 2006/3/9 1:46:18
Loaded DLL:c:\e37376beb65a16277a8441b9\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/3/9 1:46:18, returned true
Running: ValidateWinNTAction at: 2006/3/9 1:46:18
Complete: ValidateWinNTAction at: 2006/3/9 1:46:18, returned true
Running: ValidateMinOSAction at: 2006/3/9 1:46:18
Complete: ValidateMinOSAction at: 2006/3/9 1:46:18, returned true
Running: PerformSCCAction at: 2006/3/9 1:46:18
Complete: PerformSCCAction at: 2006/3/9 1:46:18, returned true
Running: ActivateLoggingAction at: 2006/3/9 1:46:18
Complete: ActivateLoggingAction at: 2006/3/9 1:46:18, returned true
Running: DetectPatchedBootstrapAction at: 2006/3/9 1:46:18
Complete: DetectPatchedBootstrapAction at: 2006/3/9 1:46:18, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__952" returned false.
Running: PerformSCCAction2 at: 2006/3/9 1:46:18
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2006/3/9 1:46:18, returned true
Running: PerformDotNetCheck at: 2006/3/9 1:46:18
Complete: PerformDotNetCheck at: 2006/3/9 1:46:18, returned true
Running: ComponentUpdateAction at: 2006/3/9 1:46:18
Complete: ComponentUpdateAction at: 2006/3/9 1:46:23, returned true
Running: DetectLocalBootstrapAction at: 2006/3/9 1:46:23
Complete: DetectLocalBootstrapAction at: 2006/3/9 1:46:23, returned true
Running: LaunchLocalBootstrapAction at: 2006/3/9 1:46:23
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1282
Aborting queue processing as nested installer has completed
Message pump returning: 1282

Thanks!!

|||

I'm going to move this to the SQL Setup forum.

- Mike

|||

I don't believe 1282 is a Setup error code; it's probably a Windows error code. 1282 translates to stack buffer overflow. We did fix one or two such issues a long time back. If the version of Express you're trying to install is pre-RTM then please download the RTM version or the remastered Express SP1 which should be available soon, and try again. If you're already trying with RTM then I suspect we're going to need to see the complete SQL Install logs to debug your problem.

Paul

Problem installing SQL Server 2005 Express Edition

I have downloaded a free set of SQL Server 2005 Express edition. This set up has been installed successfully on my machine but it is showing me following links.

SQL Server Instance=SQLExpress

User Id=sa

Password=admin12

Start --> Microsoft Sql Server 2005 -->Configuration Tools --->SQL Server Configuration Manager

--->SQL Server Eroor and Usage Reporting

---->SQL Server Surface Area Configuration

But I don't find any option to start SQL Server 2005 express edition. Please help me out how to start SQL Server 2005 express edition?

dineshpatil:

But I don't find any option to start SQL Server 2005 express edition. Please help me out how to start SQL Server 2005 express edition?

You can use the SQL Server Surface area configuration to start/stop services like your SQL instance.

If you want a GUI interface then you need to install SQL Server Management Studio.

|||

Dear Jimmy,

Thanks for your reply. I have started SQL Server instance service. Is SQL Server Management Studio is free?
If it is free, Please provide me URL path from where I can download?

Is there any other way with which I can run or access Microsoft SQL Server 2005 Express Edition?

|||

http://msdn2.microsoft.com/nl-nl/express/bb410792(en-us).aspx

|||

dineshpatil:

Thanks for your reply. I have started SQL Server instance service. Is SQL Server Management Studio is free?
If it is free, Please provide me URL path from where I can download?

Yes it is free and you can download it here

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

dineshpatil:

Is there any other way with which I can run or access Microsoft SQL Server 2005 Express Edition?

Your Express database is already installed so you can use it right away. You can either connect from the VS IDE, but if you want a GUI to the database then you need to use the SQL Management tool another 3rd party tool or rely on Visual Studio's server explorer.

|||

Thanks guys. Now it is working fine.