Can't start SSIS

Hello,

Our enterprise have bought a sql server 2005 standard edition.
Before installing it i have installed the beta version.
And after I desinstalled this beta version (with difficulties).
But the problem is that I can't start SSIS.

I have the following message:
"The request failed or the service did not respond in a timely fashion.
Consult event log or other applicable error logs for details."

Please can you help me.
Thanks.

You should really format the machine and reinstall the OS, especially if you had an early beta. The fact that you had problems cleaning it up would be a clear indication to me that you should do that more than ever.

Are there any errors in the event log, as the message directs?

Have you applied SP1? There is an issue with starting the service with that.

|||If you have installed SP1, please review this KB article
http://support.microsoft.com/kb/918644|||

Thanks!!!
In fact I haven't installed the SP1 because the SP1 I have seen is only for express edition (I have the standard edition)!!
For the event log I haven't seen it yet!! I'll try to do it Monday.

PS:
One thing I remembered during the installation is that all the system requirements were not OK.I didn't have errors but there were 2 warnings(i don't remember them)!! .

May be it will be that!!Or it will be because I haven't installed SP1 (if you know where I can download it please indicate me ).

Thanks for comments!!!

|||

taze wrote:

if you know where I can download it please indicate me

The SP1 can be downloaded http://www.microsoft.com/sql/sp1.mspx, but I don't think it will fix this particular issue.

I join Darren's advice to reinstall the OS if earlier it had any beta builds.

|||Thank U very much for your advice!!!
I will try reinstall SQL Server 2005 in a new machine wirhout any SQL 2005 beta version!!!
Thanks!!!

Can't shrink a database

Hi there,
I am running SQL2005 SP1 Standard.
I have a database that was originally a SQL2K db that was rolled up to 2K5.
Everything was fine with it until I truncated a few tables and dropped a
large column & index on a few tables. Since then the following symptoms are
present:
1) The size of the datafile and log file are about 2.5x the size of the
actual data
2) The DB properties ALWAYS shows "Space Available" as "0.00 MB"
3) The shrink dialog with the file type set to "Log" shows avaialble free
space to be 98% but shrinking it does not release any of the free space.
I have tried backing up the database, deleting it and restoring it but the
inflated log file still exists. I've also tried creating a new blank DB
(versus letting the restore create it) and restoring into that but the
problem persists.
Does anyone have any ideas on how to shrink this database down?
Thanks,
--
-Steven1) Is it the data or the log file which is "too big"?
2) Read about DBCC UPDATEUSAGE
3) See http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steven Berkovitz" <mbcdev@.community.nospam> wrote in message
news:F4B6BA40-9143-4D52-BC8F-3FB9CFBEB133@.microsoft.com...
> Hi there,
> I am running SQL2005 SP1 Standard.
> I have a database that was originally a SQL2K db that was rolled up to 2K5.
> Everything was fine with it until I truncated a few tables and dropped a
> large column & index on a few tables. Since then the following symptoms are
> present:
> 1) The size of the datafile and log file are about 2.5x the size of the
> actual data
> 2) The DB properties ALWAYS shows "Space Available" as "0.00 MB"
> 3) The shrink dialog with the file type set to "Log" shows avaialble free
> space to be 98% but shrinking it does not release any of the free space.
> I have tried backing up the database, deleting it and restoring it but the
> inflated log file still exists. I've also tried creating a new blank DB
> (versus letting the restore create it) and restoring into that but the
> problem persists.
> Does anyone have any ideas on how to shrink this database down?
> Thanks,
> --
> -Steven|||Hi Steven,
I would like to know the issue status and whether or not you need further
research.
You can try setting the recovery mode to simple, backing up your database
completely, truncating the log with BACKUP LOG ... WITH TRUNCATE ONLY, and
then use DBCC SHRINKFILE to shrink the log file.
Have a great day!
Charles Wang
Microsoft Online Community Support

Can't shrink a database

Hi there,
I am running SQL2005 SP1 Standard.
I have a database that was originally a SQL2K db that was rolled up to 2K5.
Everything was fine with it until I truncated a few tables and dropped a
large column & index on a few tables. Since then the following symptoms are
present:
1) The size of the datafile and log file are about 2.5x the size of the
actual data
2) The DB properties ALWAYS shows "Space Available" as "0.00 MB"
3) The shrink dialog with the file type set to "Log" shows avaialble free
space to be 98% but shrinking it does not release any of the free space.
I have tried backing up the database, deleting it and restoring it but the
inflated log file still exists. I've also tried creating a new blank DB
(versus letting the restore create it) and restoring into that but the
problem persists.
Does anyone have any ideas on how to shrink this database down?
Thanks,
--
-Steven1) Is it the data or the log file which is "too big"?
2) Read about DBCC UPDATEUSAGE
3) See http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steven Berkovitz" <mbcdev@.community.nospam> wrote in message
news:F4B6BA40-9143-4D52-BC8F-3FB9CFBEB133@.microsoft.com...
> Hi there,
> I am running SQL2005 SP1 Standard.
> I have a database that was originally a SQL2K db that was rolled up to 2K5
.
> Everything was fine with it until I truncated a few tables and dropped a
> large column & index on a few tables. Since then the following symptoms a
re
> present:
> 1) The size of the datafile and log file are about 2.5x the size of the
> actual data
> 2) The DB properties ALWAYS shows "Space Available" as "0.00 MB"
> 3) The shrink dialog with the file type set to "Log" shows avaialble free
> space to be 98% but shrinking it does not release any of the free space.
> I have tried backing up the database, deleting it and restoring it but the
> inflated log file still exists. I've also tried creating a new blank DB
> (versus letting the restore create it) and restoring into that but the
> problem persists.
> Does anyone have any ideas on how to shrink this database down?
> Thanks,
> --
> -Steven|||Hi Steven,
I would like to know the issue status and whether or not you need further
research.
You can try setting the recovery mode to simple, backing up your database
completely, truncating the log with BACKUP LOG ... WITH TRUNCATE ONLY, and
then use DBCC SHRINKFILE to shrink the log file.
Have a great day!
Charles Wang
Microsoft Online Community Supportsql

cant see Report manager page

Hi Friends
we've report server (sql server 2005 standard edi) on win 2003 server. i can see report manager page (i.e. http://servername/reports) from my machine but some of out users cant see this page !!
all they can see is "sql server reporting services" text nothing else. no reports and no models ertc.,

i assume its something to do with rights issue. where can i set these rights so that all users within our domain can see and create reports off report server page.
Thanks for your help.From the main page, select the properties tab, then select the security sub-tab. You can grant the necessary permissions to any group or user there.|||Thanks for that Brian. I just tried that but did not work.
our domain name is "yabba.co.nz" so i added domain by clicking "new role assignment" but to no avail.
so i tried add one of users ,who is having this problem like "yabba.co.nz\Peter" but got following error
The user or group name 'yabba.co.nz/Peter' is not recognized. (rsUnknownUserName)

any ideas please.
Thanks for your help|||You should be specifying the user or group name the same way you would for an ACL, such as for the file system. If you are using a domain user, the report server machine must be a part of that domain.|||Thank you very much Brian.
That really helped . now all our users could view report manager page and they can view and run reports now :)

one thing remained though, they cant see "Report builder" link .i tried to assign all roles (i.e. browser,content manager etc.,) but still did not help.
any ideas on this one.
Thanks for your help again :)|||

The user must have "Execute Report Definition" permission. This is a system level permission that can be configured from the "Site Settings" link at the top of Report Manager.

|||Thank you very much Brian.
That worked like a charm. Thanks for all your help :)

Can't see a New Data Driven Subscription link

Hi:

I have SSRS 2005 standard but can't see the New Data Driven Subscription link so I am not sure how to create it! Please help..

Thanks.

As far as I am concerned the data driven subscription is an enterprise-only feature.

cheers,
Markus

Can't load Report Builder

I am having a problem where a standard user cannot load Report Builder. It works as an Administrator but not as a standard user.

When the user clicks on the Report builder button the message "Application download did not succeed, please contact your system administrator"

How do I provide the ability for a standard user to run this tool ?

Anyone's help would be greatly appreciated.!!

Thanks

Hi

Have a look at the following link.

http://msdn2.microsoft.com/en-us/library/ms159667.aspx

It talks about role assignments for report builder access

Hope this helps.

|||

I have given the user system adminstrator rights to report builder but it still won't load. I have found that it loads when i turn the proxy off. I have even made an exception for the SQL Server IP Address bt still nothing. I need to leave the proxy on - but still let the user access the Report Builder.

Thanks.

Cant Install SQL Standard Edition on VISTA Ultimate

I ve been coping with the follwing Error for 2 months , and i desperately need sb helping me out with a practical solution. the error has become a real pain in the neck 4 me .I want to install SQL 2005 standard edition on a vista ultimate however the error appears at almost the end of installation proceess .and the sql server database services fails to be installed on vista? and doesnt get a check mark. this is the Error:

sQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'computer-name\SQLServer2005MSSQLUser$computer-name$MSSQLSERVER' not found. Check the name again..

It sounds to me like you are running into the problem that is described in the following article:

http://support.microsoft.com/kb/932593/en-us

You can try following the instructions in that article to obtain the fix, or try using the workaround from the article. If neither of these helps resolve your problem, please follow up by posting to the SQL Server Setup forum, not the MSDN and TechNet Feedback forum. The SQL Server Setup forum is here:

http://forums.microsoft.com/TechNet/ShowForum.aspx?ForumID=95&SiteID=17

hope this helps,

Tai Yee

SQL Server

Can't install SQL Server 2005 Standard on Windows Server 2003

--
SQL Server 2005 Setup has detected incompatible components from beta
versions of Visual Studio, .NET Framework, or SQL Server 2005.
(Full text of dialog below.)
--
Well, thanks guys, for narrowing it down for me with such precision. :-\
Yes, I did have Beta components installed at one point, but I've removed
them all. I've looked through Add/Remove Programs and I don't see any Beta
products left to uninstall. How can I find out what exactly is blocking my
install?
Thanks for your help!
- Joe Geretz -
TITLE: Microsoft SQL Server 2005 Setup
--
SQL Server 2005 Setup has detected incompatible components from beta
versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or
Remove Programs to remove these components, and then run SQL Server 2005
Setup again. For detailed instructions on uninstalling SQL Server 2005, see
the SQL Server 2005 Readme.
For help, click:
http://go.microsoft.com/fwlink?Link...rform%400x11190
BUTTONS:
OK
--OK, I found it.
It was the SQL Server Setup Support Files, must have been left over form a
previous Beta install. Tricky, because it wasn't titled as Beta in the Add /
Remove Programs listing.
- Joe Geretz -
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:%23P$1CbOaGHA.3896@.TK2MSFTNGP05.phx.gbl...
> --
> SQL Server 2005 Setup has detected incompatible components from beta
> versions of Visual Studio, .NET Framework, or SQL Server 2005.
> (Full text of dialog below.)
> --
> Well, thanks guys, for narrowing it down for me with such precision. :-\
> Yes, I did have Beta components installed at one point, but I've removed
> them all. I've looked through Add/Remove Programs and I don't see any Beta
> products left to uninstall. How can I find out what exactly is blocking my
> install?
> Thanks for your help!
> - Joe Geretz -
> TITLE: Microsoft SQL Server 2005 Setup
> --
> SQL Server 2005 Setup has detected incompatible components from beta
> versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or
> Remove Programs to remove these components, and then run SQL Server 2005
> Setup again. For detailed instructions on uninstalling SQL Server 2005,
> see the SQL Server 2005 Readme.
>
> For help, click:
> http://go.microsoft.com/fwlink?Link...rform%400x11190
> --
> BUTTONS:
> OK
> --
>

Can't install SQL Server 2005 Standard -- beta versions detected

===============================================
UNACCEPTABLLY POOR UNINSTALL AND INSTALL ROUTINES !!!
===============================================

These routines should be unstoppable! How can we sell if we can't install!

I can't get the SQL Server 2005 Standard Edition to load after I have removed SQL Server 2005 Developer Edition CTP (June). I have been using the Beta 2 for a few months.

I have used the uninstall routine located on this page:
http://lab.msdn.microsoft.com/vs2005/uninstall/preRTMuninstall/default.aspx

The above uninstall routine reports that everything has been uninstalled.
However, when I run setup from my RTM dvd, I get the following message:

"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
Microsoft SQL Server 2005 Setup

SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 again. For detailed instructions on uninstalling SQL Server 2005, see SQL Server 2005 Readme.
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

Thank you for your help.
Charles Sommers

The problem above was fixed by running the following commands. I had a named instance of "sql_inst_01". Initially, I ran the following command for only the named instances, not the default instance. When I ran the commands for the MSSQLSERVER instance the install worked.

start /wait <CD Drive>\setup.exe /qb REMOVE=ALL INSTANCENAME=<InstanceName>

For the default instance, specify "MSSQLSERVER" for InstanceName.

start /wait msiexec /qb /X <CD Drive>\Setup\sqlncli.msi

start /wait <CD Drive>\redist\2.0\dotnetfx.exe /q:a /c:"install /qu"

The key was to run the uninstall for the named and default instance.

A more descriptive error message would have saved me 5 hours of frustration.

Thank you,
Charles Sommers

can''t import views and store procedures

I recently set up a new sql 2005 standard edition and planning to mirgrate our production sql 2000 data. but only the tables were migrated from the copy data or import / export task. I cannot find a way to recreate the store procedures and views on the new server without create one view and one store procedure at a time unless all hundreds of views and procedures were rescripted. can anyone help

Thank

Andy Wong

awong@.virginiadare.com

Right click the database > Taks > Generate Scripts, this will give you the option to put it in one output-file

Jens K. Suessmeyer

http://www.sqlserver2005.de

Cant get Reports Server page to work

hi I have sql 2005 Standard on WinXP and i cant get http://localhost/ReportServer to work.
I get the web page error
Server Application Error
The server has encountered an error while loading an application during the

processing of your request. Please refer to the event log for more detail

information. Please contact the server administrator for assistance.

I have re-installed sql 2005, reinstalled IIS .
I have run the aspnet_regiis -i and still nothing.

Please someone, anyone , help.

just a suggestion

have a look in your sql server configuration tools // configuration manager // expand the network configuration until you get protocols and then in the right hand pane you should see TCPIP - double click - it might say disabled. - double click and in the properties - then select IP addresses tab - 127.0.0.1 make sure this is enabled. Also check this for remote connections.

We have been down this road and that's what solved ours.

Hope it helps

jewel

|||Hi, I tried as you suggested. That was already enabled.
Still not working.|||what does your event viewer say?|||Event Type: Warning
Event Source: W3SVC
Event Category: None
Event ID: 36

Description:
The server failed to load application '/LM/W3SVC'. The error was 'The specified metadata was not found.|||

here is a link that may help :)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257267

|||Hi, i tried what was said in the post but still nothing.
i

dont have the file mentioned above in my c:\winnt\system 32. I think

the above is for win nt . I have win xp and my component services

doesnt hang.
|||This seems more like an IIS issue. How about trying to recreate the default web site? If you deploy an ASP.NET app on the default website, does it work? If you reinstall SQL and IIS, make sure you install IIS before SQL.