Wednesday, March 7, 2012

installation of sp1. sql server integration services do not start

hi,

after installing sp1 for sql server 2005 the sql server integration services did not start. and i can`t start them manually. the installation succeeded without problems (both sql server and sp1)

the only problem was with installing sql server 2005. in the sql server configurations manager the following protocols were disabled:

- named pipes

- tcp/ip

- via

- shared memory was enabled

is this a problem. because in the "how to verify installation of sql server" is written, that tcp/ip has to be enabled. however i can manually enable it.

i can`t start the sql server integration services manually. so what can i do? i also tried reinstall sql server but i do get the same error.

hope somebody can help me!

Hi,

be sure to apply the post hotfixes, that fixes the issue around the SP1 and SSIS issue:

http://www.sqlserver2005.de/sqlserver2005/MyBlog/tabid/56/EntryID/7/Default.aspx

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment