.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Management Studio won't let me connect to Integration Services. What's wrong?

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

I'm trying to connect to Integration Services on a our SQL Server 2008 database server, so I can set up an SSIS package to run as a job.

But when I start SQL Server Management Studio and click on the Server type list, Integration Services is not one of the choices available (the only choices are Database Engine and SQL Server Compact.

When this happens, the documentation suggests going to the SQL Server Configuration Manager and starting the Integration Services service.  But this service is already running on my computer.  I tried restarting it, but that doesn't make a difference.

Any suggestions?

View Complete Post

More Related Resource Links

HTTP 401: Unauthorized when trying to specify reporting services for integration, cannot connect to




I am trying to install reporting services and join it into existing service farm.

Main  MOSS 2007 is on one pc, with config bases etc, while reporting services, reporting services db will be on other pc. 

We are using same domain account to run sharepoint services and reporting services. 

I've installed web part of MOSS on that other computer, also reporting services and sql server, set reporting services in integration mode.

Either way, it wont work for me:


If i am running the service of reporting services as Network Service account, then the /reportserver page will complain about some generic error "probably you dont have access to the farm if you are in integrated mode" etc.... 

I've read that i should include networkservice into a group WSS_WPG which i did, no luck anyway, same error

If i try to type the adress into the integration with reporting services in moss admin page, i will get error like "expected xml received html" and alot of red text.


If i switch service to run from domain account (the one that is used for running sharepoint on the domain) (we did the spn thing, didnt work either), the /reportserver page will open

(moss2k7/ReportServer - /

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Can't connect to SQL 2005 Enterprise using Management Studio with Server Name (only (local) works

This is a test system, everything running locally & no domains. Win 2003 Ent. Server & SQL Server 2005 Enterprise. I can't log into SQL Server Management Studio using the server name & using either Windows Authentication or SQL login. If I change the name of the server in the drop-down list to "(local)", I connect just fine (both Windows & SQL security modes). Shared Memory, Named Pipes & TCP/IP enabled in both server & client. Remote connections allowed. I have IP adresses (both & external IP) in my hosts file pointing to the server name. Does SQL require a DNS server? This wouldn't be a problem except for the fact that I can't install SQL 2005 SP3 due to authentication failure since there's no way to enter (local) as the server name. SQL tools (management studio, SP install) seem to see the SQL server running but won't authenticate the user through any means other than setting server name to (local). This is driving me crazy!!!

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

Reports are not showing on management studio for SQL 2008 reporting services

I just did the side by side upgrade for reproting server from 2005 to 2008 and everything was fine. But when I login to the reporting server from management studio I am not able to see the report server folders like we do in SQL 2005. The only think i saw is jobs, security and shared schedules. I dont even see any jobs under this jobs folder. Do i need to do anything after the upgrade to be able to see the reports, subscriptions and data sources from the management studio? please let me know. Thanks!  kp

how to connect my hosting database from my pc using sql server management studio 2005



I have one asp.net hosting account with some service provider.. 

They have given me some xxx.xxxxxx.com to access sql server from my desktop... 

I enter xxx.xxxxx.com in server name and username and password but it will not connect.. 

so please let me know what are the steps i have to do to access my hosting database...

they have given sql server 2008 im using in local sql server 2005 management studio so let me know how to connect

thanks in advance

Connecting to SQL Server Reporting services using SQL Server Management Studio



I have problem connecting to reporting services from SSMS, it used to work before, but recently in the rsreportserver.config file <UrlRoot>http........</UrlRoot> was changed to a different one. After that I had problem connecting to reporting services. We need that URL retained in the config file, if anyone know any work around to get into SSRS, please let me know.

I am getting an error that, the remote name could not be resolved: 'xxxxx.xxx.com' (Here it is showing the new URL that is in the config file)

We are using Reporting Services 2005

Connect to RS 2008 using Management Studio 2008 R2


According to Microsoft:
SQL 2008 Management Studio reports an error if you attempt to connect to a SQL 2005 Reporting Services Instance using the the SQL instance name. You can still manage the instance by http webservices if you use the http address to the service instead of the servername. (1)

I have two Reporting Services instances that are version 10.0.2531.0 (SQL 2008). Using Management Studio 2008 R2 (10.50.1734.0) I can connect to one instance using the instance name but for the other I have to use the URL.

Is it a valid assumption for me to say that I should be able to connect to RS 2008 from Management Studio 2008 R2 using the instance name? If so, what could be the problem that is preventing me from doing so on one of my RS instances?


Aaron Sentell
Sr. Database Administrator
Compass Group USA
Charlotte, NC

(1) https://connect.microsoft.com/SQLServer/feedback/details/361680/sql-2008-management-studio-and-sql-2005-reporting-services?wa=wsignin1.0#tabs

Unable to connect oracle from SSIS management studio


the connection failed because of an error in initiallinzing provider. ora-01017: invalid username/password; logon denied.


but can connect from SQL PLUS.

Unable to Connect to SQL Serrver using SQL Server Management Studio


I just installed the 64bit version of SQL Server using the Developer edition CD for SQL Server.  The problem I'm having is that I cannot connect to SQL Server using SQL Server Management Studio.  I’m getting the message “a network-related or instance specific error occurred while establishing a connection to sql server. the server was not found or not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections.”.  I’ve done a lot of Google searches but yet to find a solution.  I've checked to be sure it is started and enabled all protocols except VIA.  I have remote connections allowed.  I used the default name MSSQLSERVER which is what I'm using to connect to in Management Studio.

Can someone help, I have no idea what to check now.  BTW, I've also installed SP3.

Error while trying to connect with SSRS through Sql server management studio



I have installed SQL Server 2008 R2 on my system. Reports manager is working fine for me, but when I tried to connect to Reporting service instance using SSMS, I got the following error. I am not able to understnad why it is happening.

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. (System.Web.Services)


The remote certificate is invalid according to the validation procedure. (System)



how can i connect to my sql server management studio??


when i run the SSMS,while i have to enter my server name,i dont know it...

also,in the installation time,the istall didn't require any password or server name or anything to enter...

in other word,i dont have any server name for my sql server and so that i got this error:

TITLE: Connect to Server

Cannot connect to Bahador-gh-PC.


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476



how can i resolve it??

plz as soon as you can, answer me...

tnx a lot :):)

SQL server management studio reconnects / connect fails / connects fine



I am checking out an application performance issue on a particular (distributed SQL express) machine - and now have the machine back in my possession. I have narrowed it to SQL and/or our application.

In short SQL seems 'hesitant' - SSMS connects first time sometimes, fails another time, disconnects after being connected and so-on. I'm connecting to the machine via real simple cable-hub-cable, and I'm positive its not networking as I'm RDP'd onto the machine and get quick responses whilst SSMS is being moody.

SQL logs show nothing, neither default trace or custom trace show anything, or windows logs.

In SSMS I have a query open, it returns immediately on some runs and takes 2 mins on other runs - it is a tiny query, straight select.

The treeview in SSMS is sporadically taking a long time to respond and times out sometimes - other times it was connected and then prompts for authentication ....fails to connect, you cancel, then reconnects first time after that.

...something odd is happening.

There are loads of other angles I have tried - autoclose is disabled by the way.

Anyone experiencing this sort of behaviour elsewhere or have any thoughts ?  I use SQL connections and technologies everywhere in my normal working day - this has me scratching my head.

Thanks for your brain cycles in advance !

Can't connect to SQL Express 2008 from Visual Studio, but can connect from SQL Server Management St



I've been struggling with the following issue for 3 days:  I can access and use my SQL Express 2008R2 database flawlessly from SQL Server Management Studio.  But I can only intermittently access it from Visual Studio (ultimate edition with TF Server).  Sometimes it works, sometimes it doesn't.  I mostly see the error when I try to "Update Model from Database" within my Entity framework model, or when I try to access the database from within Server Explorer.


Here is the error I see when I try to update my Entities form the Database: An error occurred while connecting to the database.  The database might be unavailable.  An exception of type 'System.Data.SqlClient.SqlException' occurred.  The error message is: 'Cannot open user default database. Login failed.  Login failed for user 'Tim-PC\Tim'.'


I think the connection string is fine as I am able to connect

To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects


What could be wrong?

I get this error when a stored procedure is executing sp_OAMethod from SQL Server 2000 SP4.

EXEC @rc = master..sp_OAMethod @Obj, 'Execute'

The linked server is SQL Server 2005 x64.  Already installed is SQLServer2005_BC_x64.msi version April 15, 2006.  Local server is SQL Server 2000 SP4. 

I can execute the sproc successfully in Query Analyzer from my local dev box which has both 2000 and 2005 installed.  Profiler in 2005 indicates success for the whole sproc. 

It fails when I execute in Query Analyzer while connected on SQL 2000 SP4.  Tried this with 3 different machines SQL Server 2000 SP4.  The server do not have any 2005 component installed.

According to Profiler in 2005, the last event that happen is

SQL: BatchCompleted

if (object_id('master.dbo.sp_MSSQLDMO80_version') is not null) exec master.dbo.sp_MSSQLDMO80_version else if
(object_id('master.dbo.sp_MSSQLDMO70_version') is not null) exec master.dbo.sp_MSSQLDMO70_version else select 0

Below is the trapped Query Analyzer message.

Error Source: Microsoft Data Transformation Services (DTS) Package 
Error Description:Package failed because Step 'dts_name_removed' failed. 
Error code: 80040428 \
Error Help File:sqldts80.hlp 
Error Help Context ID:700 

Step Error Source: Microsoft SQL-DMO (O

VS 2010: Entity Framework 4.0 and WCF Data Services 4.0 in Visual Studio 2010


Elisa Flasko takes you through a sample weblog application to demonstrate how new improvements in Entity Framework and WCF Data Services work together to simplify the way data is modeled, consumed and produced in Visual Studio 2010.

Elisa Flasko

MSDN Magazine April 2010

SAAS: Connect Enterprise Apps with Hosted BizTalk Services


In this article we introduce you to BizTalk Services, new technology that offers the Enterprise Service Bus features of BizTalk Server as a hosted service.

Jon Flanders and Aaron Skonnard

MSDN Magazine June 2008

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend