Encryption not supported on SQL Server

Hi,
I have a problem with Integration services. When connecting to
Integration services in Management studio and clicking on MSDB, I get
the error:
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
Integration Services
This problem occured after all files were deleted by mistake from:
..\Application Data\Microsoft\Crypto\RSA
SQL Server 2000 client tools(only) were also installed on the box.
There is one package installed in msdb that was working fine before.
Server: sql server 2005 Standard
OS: Windows 2003 Standard
Asim.To add to the post above,
I changed the file:MsDtsSrvr.ini.xml
and replaced the "." with the sql server name for the tag: <ServerName>
Restarted sql, agent and integration services but still get the same
error.
Asim.

Encryption not supported on SQL Server

Hi,
I have a problem with Integration services. When connecting to
Integration services in Management studio and clicking on MSDB, I get
the error:
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
Integration Services
This problem occured after all files were deleted by mistake from:
..\Application Data\Microsoft\Crypto\RSA
SQL Server 2000 client tools(only) were also installed on the box.
There is one package installed in msdb that was working fine before.
Server: sql server 2005 Standard
OS: Windows 2003 Standard
Asim.To add to the post above,
I changed the file:MsDtsSrvr.ini.xml
and replaced the "." with the sql server name for the tag: <ServerName>
Restarted sql, agent and integration services but still get the same
error.
Asim.

Enable Maintenance Plan MSSQL 2005 Express

Hello,

I am running MSSQL 2005 Express in Windows 2003 Server. I am trying to create a Maintenance Plan. I click Management, and then only SQL server logs and activity monitor show up. I am told that I should see a folder called maintenance plans, and be able to right click to start the wizard. This is not the case though.

After looking through the help, I see that the user must be a member of the sysadmin group, which I am. The only thing I can think of, is that express doesnst support Maintenance Plans. Is this the case?

Thanks for the help

As SQL Express doesn't support SSIS (which is required for Maintenance Plans) you are correct, SQL Express doesn't support Maintenance Plans.

SQL Express also doesn't support SQL Agent which is what the Maintenance Plans use for scheduling.

You can write the T/SQL commands which the Mainenance Plan would generate and use the Windows Task Scheduler to schedule it to run.

|||

Ok, that explains it. Darn express.

I was able to get it working, via the following useful article:

http://www.brianmadden.com/content/article/How-to-Automate-the-Backup-of-a-SQL-Server-2005-Express-Data-Store

Simply follow the steps, create a script file, and then create a windows scheduled task with the command given, except change the instance name to the name of YOUR mssql instance.

Hope it helps others.

|||Yep, that would be the work around.

Empty Messagebox

Hi

When I start the MSQL Server Management Studio Express I get a Message Box with a yellow exclamation icon and NO message, just an OK button. Which when I press it goes away allowing me to logon to the Management Studiio.

All seems to be working fine (although I have not used it much since getting this strange behaviour).

I have re-installed Win XP Pro SP2, applied all patches from MS website, install is clean and no errors. Also downloaded latest SQLExpress Edition and as well as latest Server Management Studio.

Any ideas?

Thanks, any help will be appreciated.

I'm moving this to the Tools group where the management studio folks hang out.

Mike

|||

I recently installed Windows Live Local Add-in for Microsoft Office Outlook which also installed .Net 1.1 (although it was already installed on my PC along with .Net 2.0). I then started to get the same empty message box when Management Studio started. I did a repair on .Net 2.0 and the empty message box has stopped.

|||

Hi Steve

Thanks, that worked for me as well.

Had me worried!!

Regards.

Larry.

|||

This also occured after the install of SP2 for 2005 Developers Edition. (Blank message box with exclamation icon)

Repairing .Net 2.0 corrected the message.

I think it was caused by an update to the .Net 1.1 Framework that happened immediately following the install of SP2.

Thanks for the tip...

Empty Messagebox

Hi

When I start the MSQL Server Management Studio Express I get a Message Box with a yellow exclamation icon and NO message, just an OK button. Which when I press it goes away allowing me to logon to the Management Studiio.

All seems to be working fine (although I have not used it much since getting this strange behaviour).

I have re-installed Win XP Pro SP2, applied all patches from MS website, install is clean and no errors. Also downloaded latest SQLExpress Edition and as well as latest Server Management Studio.

Any ideas?

Thanks, any help will be appreciated.

I'm moving this to the Tools group where the management studio folks hang out.

Mike

|||

I recently installed Windows Live Local Add-in for Microsoft Office Outlook which also installed .Net 1.1 (although it was already installed on my PC along with .Net 2.0). I then started to get the same empty message box when Management Studio started. I did a repair on .Net 2.0 and the empty message box has stopped.

|||

Hi Steve

Thanks, that worked for me as well.

Had me worried!!

Regards.

Larry.

|||

This also occured after the install of SP2 for 2005 Developers Edition. (Blank message box with exclamation icon)

Repairing .Net 2.0 corrected the message.

I think it was caused by an update to the .Net 1.1 Framework that happened immediately following the install of SP2.

Thanks for the tip...

Empty Message Box

Hi

When I start the MSQL Server Management Studio Express I get a Message Box with a yellow exclamation icon and NO message, just an OK button. Which when I press it goes away allowing me to logon to the Management Studiio.

All seems to be working fine (although I have not used it much since getting this strange behaviour).

I have re-installed Win XP Pro SP2, applied all patches from MS website, install is clean and no errors. Also downloaded latest SQLExpress Edition and as well as latest Server Management Studio.

Any ideas?

Thanks, any help will be appreciated.

I'm moving this thread to the Tools forum.

Empty dialog box on startup of Management Studio Express

Hi,
Everytime I start Studio Express I get an empty dialog box. I've seen some
posts about a similar problem but they were linked to upgrades. I have not
upgraded SQLExpress so there must be something else that causes it.
The only thing that I have done recently was to delete few users from a
database and instance.
I'm using SQLExpress 2005.
Any ideas what could be happening and how to troubleshoot this?
ThanksHi
I would suggest removing and re-installing, but other posts say fixing .NET
Framework 2 .0 fixed it!
John
"bogdan" <bogdan@.company.com> wrote in message
news:OvOLTAplIHA.2396@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Everytime I start Studio Express I get an empty dialog box. I've seen
> some posts about a similar problem but they were linked to upgrades. I
> have not upgraded SQLExpress so there must be something else that causes
> it.
> The only thing that I have done recently was to delete few users from a
> database and instance.
> I'm using SQLExpress 2005.
> Any ideas what could be happening and how to troubleshoot this?
> Thanks
>