Connection Managers not installed?

apologies if this is the wrong group ..

whenever I create an Integrated Services project and attempt to add a Connection Manager I get the error

Connection Manager 'blah' is not properly installed on this computer.

(Microsoft.DataTransformationServices.Design)

This happens with all menu options except New Connection..

I have uninstalled and reinstalled both Visual Studio 2005 and SQL Server 2005 and made sure I have selected everything in each case

what am I missing?

Thanks

Chris

seems this has happened to others

see Jason Lodice thread for solution

Chris

Connection Manager - variables

hello all,

I have a scenario where I like to reuse one project from one machine to another machine.

- Server name is variable.

- database name is variable

- table name is fixed.

How do I specify a variable name for "server name" and "database name" ?

Are you taking about Server/Database name of your Data Sources?

For that you can use package configurations storing those names in a table, xml file, etc

Rafael Salas

|||

You can select the connection manager then go to the properties pane to set the expression for these properties. In your case, you'd want to change the server name and initialcatalog properties, which are very common. You could set these to a variable of course like in your requirement and then additionally later use a configuration file to externalize this all.

Also, the same type of concepts in this video would help you as well: http://www.jumpstarttv.com/Media.aspx?vid=34

-- Brian Knight

Connection Manager - No available servers

Hi

Windows XP Pro, SQL Server 2005 (Developer) & Visual Studio 2005 (Pro)

New SSIS project (Visual Studio)

New OLE DB/SQL Native client connection.

There's no servers available in the drop down box.

All the services that need to be running are running.

Guess I've missed the obvious here

Cheers

Dave

Hi,

did you try to enter the nae manually ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Yes I did. Will re-try and then post the error.|||

Just tried entering the name manually and it worked...

Any ideas why I can't browse to the instance/server?

|||Do you use another port than the default one 1433 ? If so, you will have to make sure that SQL Server browser is started. What for ? See the link here for more information about the SQL Browser.

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

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

connection between sql files and .Net

I have a project I'm trying to open using sql server .Net but there's a problem with the "connection" between the two. What should I do? Something with "attaching" the *.ldf and *.mdf files?!
I'll apperciate any kind of suggestion.
Thanks,
Inbal.
Hi,
Before connecting it from the application attach the database (MDF and LDF)
file using Query Analyzer.
Steps:
1. Login to SQL Serevr using Query analyzer
2. Copy the MDF and LDF file to a specific directory say (C:\mssql\data\)
3 Attach the MDF and LDF files to SQL server using a database name, use the
below command
sp_attach_db 'dbname','c:\msql\data\dbname_data.MDFdbname_log.L DF'
Executing the above command will attach the database to SQl server, After
that try to access your database using application.
Thanks
Hari
MCDBA
"inbal" <inbal_rulz@.hotmail.com> wrote in message
news:EF7647E2-5CDC-4651-9DE0-6DEE94456460@.microsoft.com...
> I have a project I'm trying to open using sql server .Net but there's a
problem with the "connection" between the two. What should I do? Something
with "attaching" the *.ldf and *.mdf files?!
> I'll apperciate any kind of suggestion.
> Thanks,
> Inbal.

connection between sql files and .Net

I have a project I'm trying to open using sql server .Net but there's a problem with the "connection" between the two. What should I do? Something with "attaching" the *.ldf and *.mdf files?
I'll apperciate any kind of suggestion.
Thanks
Inbal.Hi,
Before connecting it from the application attach the database (MDF and LDF)
file using Query Analyzer.
Steps:
1. Login to SQL Serevr using Query analyzer
2. Copy the MDF and LDF file to a specific directory say (C:\mssql\data\)
3 Attach the MDF and LDF files to SQL server using a database name, use the
below command
sp_attach_db 'dbname','c:\msql\data\dbname_data.MDFdbname_log.LDF'
Executing the above command will attach the database to SQl server, After
that try to access your database using application.
Thanks
Hari
MCDBA
"inbal" <inbal_rulz@.hotmail.com> wrote in message
news:EF7647E2-5CDC-4651-9DE0-6DEE94456460@.microsoft.com...
> I have a project I'm trying to open using sql server .Net but there's a
problem with the "connection" between the two. What should I do? Something
with "attaching" the *.ldf and *.mdf files?!
> I'll apperciate any kind of suggestion.
> Thanks,
> Inbal.

connection between sql files and .Net

I have a project I'm trying to open using sql server .Net but there's a prob
lem with the "connection" between the two. What should I do? Something with
"attaching" the *.ldf and *.mdf files?!
I'll apperciate any kind of suggestion.
Thanks,
Inbal.Hi,
Before connecting it from the application attach the database (MDF and LDF)
file using Query Analyzer.
Steps:
1. Login to SQL Serevr using Query analyzer
2. Copy the MDF and LDF file to a specific directory say (C:\mssql\data\)
3 Attach the MDF and LDF files to SQL server using a database name, use the
below command
sp_attach_db 'dbname','c:\msql\data\dbname_data.MDFdbname_log.LDF'
Executing the above command will attach the database to SQl server, After
that try to access your database using application.
Thanks
Hari
MCDBA
"inbal" <inbal_rulz@.hotmail.com> wrote in message
news:EF7647E2-5CDC-4651-9DE0-6DEE94456460@.microsoft.com...
> I have a project I'm trying to open using sql server .Net but there's a
problem with the "connection" between the two. What should I do? Something
with "attaching" the *.ldf and *.mdf files?!
> I'll apperciate any kind of suggestion.
> Thanks,
> Inbal.

Connection

Hi
when i design a report using SQL 2005 and try to run it in production mode
with setting the servertarget rul property of the project to http://localhost
i get an error that it cant connect to the local host, but when i click the
preview tab i find the report with correct data so whats the problem ?
the OS is win 2003 enterprise
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643
The url needs to be the path to the Reporting Services web service i.e.
http://localhost/ReportServer
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Pure Heart" <PureHeart@.discussions.microsoft.com> wrote in message
news:055ADB25-181E-41FE-BC2B-A081538FB646@.microsoft.com...
> Hi
> when i design a report using SQL 2005 and try to run it in production mode
> with setting the servertarget rul property of the project to
> http://localhost
> i get an error that it cant connect to the local host, but when i click
> the
> preview tab i find the report with correct data so whats the problem ?
> the OS is win 2003 enterprise
> --
> Ammar S. Mitoori
> IT Head QIMCO Co.
> Tel : +9744831199
> Mobile : +9745378400
> Fax : +9744831643
|||hi
thanx for ur replay i tried and it didnt work also,, so any suggestions ?
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643
"Jasper Smith" wrote:

> The url needs to be the path to the Reporting Services web service i.e.
> http://localhost/ReportServer
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Pure Heart" <PureHeart@.discussions.microsoft.com> wrote in message
> news:055ADB25-181E-41FE-BC2B-A081538FB646@.microsoft.com...
>
>

Connecting VS2005 to SQL Server 2005

When I try to attach an ".mdf" to a project by right clicking on the project name the software looks for an instance of SQL Server 2005 Express. How do I alter this behavior to have it look to my full copy of SQL Server 2005 which appears to be working correctly?

You have to configure VS to us a specific instance of SQL Server. Check out Tools | Options, you can set a number of options related to database access.

Mike

Connecting VS2005 to SQL Server 2005

When I try to attach an ".mdf" to a project by right clicking on the project name the software looks for an instance of SQL Server 2005 Express. How do I alter this behavior to have it look to my full copy of SQL Server 2005 which appears to be working correctly?

You have to configure VS to us a specific instance of SQL Server. Check out Tools | Options, you can set a number of options related to database access.

Mike

Connecting toTeradata .NET data provider

I need help connecting to the Teradata .NET data provider inReporting Services.

In Visual Studio I selectNew Project thenBusiness IntelligenceProject.

Once open, in theSolution Explorer I right-click onSharedData Sources and clickAdd New Data Source.

I do not understand how to get "Teradata" to show in theType list ofavailable data sources. I do not want toconnect to Teradata via ODBC or OLD DB. I want to connect directly to the Teradata .NET data provider.

Can anyone with more experience with SSRS help me shed somelight on this?

Add a new report say Test.rdl. Double click on it. The on click on Data tab. This is where you set Datasource etc.

-kushpaw

|||

kushpaw:

Add a new report say Test.rdl. Double click on it. The on click on Data tab. This is where you set Datasource etc.

-kushpaw

Hi kushpaw, that did not answer my question.

I am aware of how to set a datasource of type ODBC, SQL Server, XML, OLE DB, or Orical. What I want to know is how add Teradata to that list. Keep in mind, from my original question, I do not want to connect to Teradata through ODBC or OLE DB, but connect directly to the Teradata .NET data provider.

|||

Here is the solution for others who may want to do the same thing:

Inrsreportserver.config andRSReportDesigner.config add to the <data> tag
<ExtensionName="Teradata"Type="Teradata.Client.Provider.TdConnection,Teradata.Client.Provider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c"/>
*note* The Version, Cutlure, and PublicKeyToken can be found in C:\Windows\assembly

In RSReportDesigner.config add to the <Designer> tag
<ExtensionName="Teradata"Type="Microsoft.ReportingServices.QueryDesigners.GenericQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>

Connecting to SQLServer

I apologize if this is in the wrong place, I don't know where this
question would be appropriate.
We are doing a class project with ASP .Net and SQL Server. For this
exercise, we had to create tables and then connect to the tables from
a web form.
I have Visual Studio 2005, SQL Server Management Studio (Express) and
SQLServer Express. I can use Server Management studio and run SQL
against my database.
When I try to connect to the database from Visual Studio's Connection
Explorer, I get a long delay and then an error message pops us saying:
"An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections.(Provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)"
Is there something I need to configure or can anyone give me some
advice on what I need to do to connect?
Thanks
MikeFirst off, make sure that SQL Server is started. I don't remember if
SQL Express has SQL Server Configuration Manager, but you can check this
out in the Services applet of the control panel. That'd be my first
guess.
MikeB wrote:
> I apologize if this is in the wrong place, I don't know where this
> question would be appropriate.
> We are doing a class project with ASP .Net and SQL Server. For this
> exercise, we had to create tables and then connect to the tables from
> a web form.
> I have Visual Studio 2005, SQL Server Management Studio (Express) and
> SQLServer Express. I can use Server Management studio and run SQL
> against my database.
> When I try to connect to the database from Visual Studio's Connection
> Explorer, I get a long delay and then an error message pops us saying:
> "An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections.(Provider: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)"
> Is there something I need to configure or can anyone give me some
> advice on what I need to do to connect?
> Thanks
> Mike
>|||SQL Server Express does have Server Configuration Manager. It shows
the SQL Server (SQLEXPRESS) as running and SQL Server Browser as
stopped. As I said in my post, I can't seem to find a way to start the
SQL Server Browser, all the buttons are greyed out when I look at the
properties.
On Feb 27, 7:23 am, David Markle <new...@.markleconsulting.c0m> wrote:
> First off, make sure that SQL Server is started. I don't remember if
> SQL Express has SQL Server Configuration Manager, but you can check this
> out in the Services applet of the control panel. That'd be my first
> guess.
>
> MikeB wrote:
>
>
>
>
>
>
> - Show quoted text -|||I think you are correct that SQL Server is not started. If I open a
command prompt window and type
osql -L
I get a long pause and then the response
TRISTAN/SQLEXPRESS
Tristan is my computer name
When I type
CQLCMD -L
I get a long pause and then a blank list.
I really don't know what I should do to start SQL Server. Can you give
me a clue?
Thanks
On Feb 27, 7:23 am, David Markle <new...@.markleconsulting.c0m> wrote:
> First off, make sure that SQL Server is started. I don't remember if
> SQL Express has SQL Server Configuration Manager, but you can check this
> out in the Services applet of the control panel. That'd be my first
> guess.
>
> MikeB wrote:
>
>
>
>
>
>
> - Show quoted text -|||I'm so relieved, I got this fixed. It was the Server Browser that
wasn't started. I found this post that helped me locate the problem:
http://blogs.msdn.com/sqlexpress/ar.../23/192044.aspx
Just posting it here in case someone else come searching for the
answer...
On Feb 26, 4:39 pm, "MikeB" <MPBr...@.gmail.com> wrote:
> I apologize if this is in the wrong place, I don't know where this
> question would be appropriate.
> We are doing a class project with ASP .Net and SQL Server. For this
> exercise, we had to create tables and then connect to the tables from
> a web form.
> I have Visual Studio 2005, SQL Server Management Studio (Express) and
> SQLServer Express. I can use Server Management studio and run SQL
> against my database.
> When I try to connect to the database from Visual Studio's Connection
> Explorer, I get a long delay and then an error message pops us saying:
> "An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections.(Provider: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)"
> Is there something I need to configure or can anyone give me some
> advice on what I need to do to connect?
> Thanks
> Mike

Connecting to SQLServer

I apologize if this is in the wrong place, I don't know where this
question would be appropriate.
We are doing a class project with ASP .Net and SQL Server. For this
exercise, we had to create tables and then connect to the tables from
a web form.
I have Visual Studio 2005, SQL Server Management Studio (Express) and
SQLServer Express. I can use Server Management studio and run SQL
against my database.
When I try to connect to the database from Visual Studio's Connection
Explorer, I get a long delay and then an error message pops us saying:
"An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections.(Provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)"
Is there something I need to configure or can anyone give me some
advice on what I need to do to connect?
Thanks
Mike
I'm so relieved, I got this fixed. It was the Server Browser that
wasn't started. I found this post that helped me locate the problem:
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
Just posting it here in case someone else come searching for the
answer...
On Feb 26, 4:39 pm, "MikeB" <MPBr...@.gmail.com> wrote:
> I apologize if this is in the wrong place, I don't know where this
> question would be appropriate.
> We are doing a class project with ASP .Net and SQL Server. For this
> exercise, we had to create tables and then connect to the tables from
> a web form.
> I have Visual Studio 2005, SQL Server Management Studio (Express) and
> SQLServer Express. I can use Server Management studio and run SQL
> against my database.
> When I try to connect to the database from Visual Studio's Connection
> Explorer, I get a long delay and then an error message pops us saying:
> "An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections.(Provider: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)"
> Is there something I need to configure or can anyone give me some
> advice on what I need to do to connect?
> Thanks
> Mike

Connecting to SQLServer

I apologize if this is in the wrong place, I don't know where this
question would be appropriate.
We are doing a class project with ASP .Net and SQL Server. For this
exercise, we had to create tables and then connect to the tables from
a web form.
I have Visual Studio 2005, SQL Server Management Studio (Express) and
SQLServer Express. I can use Server Management studio and run SQL
against my database.
When I try to connect to the database from Visual Studio's Connection
Explorer, I get a long delay and then an error message pops us saying:
"An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections.(Provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)"
Is there something I need to configure or can anyone give me some
advice on what I need to do to connect?
Thanks
MikeFirst off, make sure that SQL Server is started. I don't remember if
SQL Express has SQL Server Configuration Manager, but you can check this
out in the Services applet of the control panel. That'd be my first
guess.
MikeB wrote:
> I apologize if this is in the wrong place, I don't know where this
> question would be appropriate.
> We are doing a class project with ASP .Net and SQL Server. For this
> exercise, we had to create tables and then connect to the tables from
> a web form.
> I have Visual Studio 2005, SQL Server Management Studio (Express) and
> SQLServer Express. I can use Server Management studio and run SQL
> against my database.
> When I try to connect to the database from Visual Studio's Connection
> Explorer, I get a long delay and then an error message pops us saying:
> "An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections.(Provider: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)"
> Is there something I need to configure or can anyone give me some
> advice on what I need to do to connect?
> Thanks
> Mike
>|||SQL Server Express does have Server Configuration Manager. It shows
the SQL Server (SQLEXPRESS) as running and SQL Server Browser as
stopped. As I said in my post, I can't seem to find a way to start the
SQL Server Browser, all the buttons are greyed out when I look at the
properties.
On Feb 27, 7:23 am, David Markle <new...@.markleconsulting.c0m> wrote:
> First off, make sure that SQL Server is started. I don't remember if
> SQL Express has SQL Server Configuration Manager, but you can check this
> out in the Services applet of the control panel. That'd be my first
> guess.
>
> MikeB wrote:
> > I apologize if this is in the wrong place, I don't know where this
> > question would be appropriate.
> > We are doing a class project with ASP .Net and SQL Server. For this
> > exercise, we had to create tables and then connect to the tables from
> > a web form.
> > I have Visual Studio 2005, SQL Server Management Studio (Express) and
> > SQLServer Express. I can use Server Management studio and run SQL
> > against my database.
> > When I try to connect to the database from Visual Studio's Connection
> > Explorer, I get a long delay and then an error message pops us saying:
> > "An error has occurred while establishing a connection to the server.
> > When connecting to SQL Server 2005, this failure may be caused by the
> > fact that under the default settings SQL Server does not allow remote
> > connections.(Provider: Named Pipes Provider, error: 40 - Could not
> > open a connection to SQL Server)"
> > Is there something I need to configure or can anyone give me some
> > advice on what I need to do to connect?
> > Thanks
> > Mike- Hide quoted text -
> - Show quoted text -|||I think you are correct that SQL Server is not started. If I open a
command prompt window and type
osql -L
I get a long pause and then the response
TRISTAN/SQLEXPRESS
Tristan is my computer name
When I type
CQLCMD -L
I get a long pause and then a blank list.
I really don't know what I should do to start SQL Server. Can you give
me a clue?
Thanks
On Feb 27, 7:23 am, David Markle <new...@.markleconsulting.c0m> wrote:
> First off, make sure that SQL Server is started. I don't remember if
> SQL Express has SQL Server Configuration Manager, but you can check this
> out in the Services applet of the control panel. That'd be my first
> guess.
>
> MikeB wrote:
> > I apologize if this is in the wrong place, I don't know where this
> > question would be appropriate.
> > We are doing a class project with ASP .Net and SQL Server. For this
> > exercise, we had to create tables and then connect to the tables from
> > a web form.
> > I have Visual Studio 2005, SQL Server Management Studio (Express) and
> > SQLServer Express. I can use Server Management studio and run SQL
> > against my database.
> > When I try to connect to the database from Visual Studio's Connection
> > Explorer, I get a long delay and then an error message pops us saying:
> > "An error has occurred while establishing a connection to the server.
> > When connecting to SQL Server 2005, this failure may be caused by the
> > fact that under the default settings SQL Server does not allow remote
> > connections.(Provider: Named Pipes Provider, error: 40 - Could not
> > open a connection to SQL Server)"
> > Is there something I need to configure or can anyone give me some
> > advice on what I need to do to connect?
> > Thanks
> > Mike- Hide quoted text -
> - Show quoted text -|||I'm so relieved, I got this fixed. It was the Server Browser that
wasn't started. I found this post that helped me locate the problem:
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
Just posting it here in case someone else come searching for the
answer...
On Feb 26, 4:39 pm, "MikeB" <MPBr...@.gmail.com> wrote:
> I apologize if this is in the wrong place, I don't know where this
> question would be appropriate.
> We are doing a class project with ASP .Net and SQL Server. For this
> exercise, we had to create tables and then connect to the tables from
> a web form.
> I have Visual Studio 2005, SQL Server Management Studio (Express) and
> SQLServer Express. I can use Server Management studio and run SQL
> against my database.
> When I try to connect to the database from Visual Studio's Connection
> Explorer, I get a long delay and then an error message pops us saying:
> "An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections.(Provider: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)"
> Is there something I need to configure or can anyone give me some
> advice on what I need to do to connect?
> Thanks
> Mike