Connection Manager in SSIS packages

I am trying to run a package outside of the Business Intelligence development Studio. It continuously fails and tell me that my username cannot logon due to a password failure. When I check my connections the password never shows in the connection string and remains blank in the connection properties although I have checked Save Password in the connection properties. Does anyone know how I can save the password in the connection string being utilized in the SSIS package?Passwords are not shown in the properties due to security. I am assuming you are using SQL Server authentication instead of Windows Authentication. When you specify the password and save password, it saves it. But if you open the connection manager again, it won't show you the password (though it is still saved). However, to be able to leave it in the current state, you should now click Cancel to exit the connection manager, instead of OK. If you press OK, it will expect you to enter the password again. I think you must have opened the connection manager, and then pressed Ok, instead of Cancel, which erased the password.|||

I don't think that's the problem. I experiencing the same problem in my development Environment (using SQL Server authentication):

We're a group of developers working on the same package. after setting the connection managers with the correct username and password (and checking the save option) and saving the package by a certain user, when a different user accessing it, he cannot run the package and have to go through all the connection managers and ser the user and passwords all over again.

Any solution?

|||

Liran,

Check the ProtectionLevel property of your package. My guess is that you have ProtectionLevel=EncryptSensitiveWithUserKey

This means that all passwords are encrypted with a user-specific value meaning that only that user can run it.

If you follow best practice (http://blogs.conchango.com/jamiethomson/archive/2006/01/05/2554.aspx) of making your packages location-independant (http://www.windowsitpro.com/SQLServer/Article/ArticleID/47688/SQLServer_47688.html) then this should not be a problem.

-Jamie

sqlsql

Connection from command prompt

All,
Though sound silly, but I require it by any chance...
I need to connect to the sql server 2000 from command prompt and then I
need to run query and see the resultset.
Any suggestion...'osql.exe in SQL 2000 (in SQL 2005 this command line utility is replace
by sqlcmd.exe). You can use the -q or -Q switches to specify a batch to
run rather than use it in interactive mode. Or even use the -i switch
to specify an input file that contains the SQL batch you wish to run.
*mike hodgson*
http://sqlnerd.blogspot.com
MUKUT wrote:

>All,
> Though sound silly, but I require it by any chance...
>I need to connect to the sql server 2000 from command prompt and then I
>need to run query and see the resultset.
>Any suggestion...'
>
>|||Mukut, Just do this,
1. Start >> Run >> cmd
2. osql /?
THis would list out the possible options for this osql utility.
I am sure this is what you are looking for :)
Best Regards
Vadivel
http://vadivel.blogspot.com
"MUKUT" wrote:

> All,
> Though sound silly, but I require it by any chance...
> I need to connect to the sql server 2000 from command prompt and then I
> need to run query and see the resultset.
> Any suggestion...'
>|||Thanks all for your kind suggestion.

Connection Failed: SQl SErver Error 18456

I am runnig a program through Microsoft Access 2000 that uses SQL server and is run on 8 different machines. It has worked great for months but yesterday this message appeared:

Connection Failed:
SQL State: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for User 'SA'.

And when I try to use Outlook, this message is displayed:

The Microsoft Exchange Server Computer is not available. Either there are network problems or thhe Microsoft Exchange Server is down for mmaintenance.

Obvious problems with the SQL recognition but it seems to be up and running fine.

Any help appreciated.Make sure no change in SA's password and try connecting with other user with ADMIN privileges.

Connection Failed.

Hi everyone, I need help.

I am using Windows Server 2003, VS.NET 2003 and SQL 2000&sp3 on same PC. I was try to run the samples from Framework DSK v1.0 and v1.1, both failed on SQL connection. No matter sa or ASPNET userID, can't make it works.
I can run these samples on Windows 2000, VS.NET 2002 and SQL 2000&sp3 without problem, also runs on Windows XP, VS.NET 2002, SQL 2000&sp3 with WC service on my notebook.

Any particular section I should scope it for troubleshooting?

Thanks for any suggestion on this issue.You have to help us a little. EXACTLY what is the error message.|||The error message is:

Login Failed for user 'NT Authority\Network Service'.

Lin 4: sqlDataAdapter1.Fill(dSet) is in Red.

Thank you for helping me.|||I imagine you are using integrated security to try and connect to SQL Server.

This might help
You need to add the Network Service user into SQL Server, or use a username and password, if your SQL Server will allow it.|||Actually, I try the Integrated Security and Trusted_Connection both ways, neither of these works. I was thinking the IIS 6.0 security features on Windows server 2003 may block connection to SQL server. While, I will try to add the password to sa and hope get succeed at this time.

Thank you very much.|||Hi Douglas,

It works right now. In my case, Windows server 2003, IIS 6.0, .Net 2003 and SQL 2000server are configuring correctly but one thing I forget (Usually I do, but not this time) that is the ODBC configuration for default user ID. Well, thanks again for your helpful opinion.

Have a nice day.

Connection Error when trying to run MDX-queries

To learn MDX (on SQL Server 2005 dev edition) I decided to put up some sample cubes and run MDX-queries from SQL Server Management Studio. When processing the cube in BI Studio I get the following error:

"The datasource , 'Adventure Works DW', contains an ImpersonationMode that that is not supported for processing operations."

Fair enough, then I change the impersonationmode in the datasource to service account. It all processes/deploys well and I can browse the cube in BI Studio. Off to Management studio to run some mdx-queries. Here however I get the error:

"Error (Data mining): Either the user, ######, does not have permission to access the referenced mining model, Analysis Services Tutorial, or the object does not exist."

That is of course due to me using the current user credentials for the query. So I try to change the current connection in management studio but the helpbutton informs me that as of now only windowsauthentication can be used for analysis services. So the only connectionway I can use from here is the only one not supported when processing?! This must mean I've done some childishly simple newbiemistake and I would be very grateful if you pointed it out so I could get started with the MDX.

Perhaps I should add that the user ##### is administrator for the entire server. The server administrator role should take precedence over database roles, right (not that it helped when I added one of those and included me)? The user is also a member of the SQLServer2005OLAPUser group. I also have full access to the underlying relational database. So I can delete or create elements or entire databases at will but not ask simple questions to them...

The other option - that the cube doesn't exist seems dispelled by being able to browse it and the dimensions etc. showing up in object explorers and in the left pane of the MDX Query interface.

Which leaves me at some permission problem again - some help would REALLY be appreciated.

|||Please provide more information as something strange is going on here - given what you have provided, you should not be having a permission error - but, the error message does not make sense as the Analysis Services Tutorial has no data mining component.|||

I don't have the queries I tested with anymore since I got it to work but the bottomline was that I didn't have any "ON ROW|COLUMNS" etc. part of the selection clause which obviously sent the engine looking for something that didn't exist. I.e. just had queries with variations on the form:

SELECT dim

FROM cube

Looked at what the browser sent with the profiler and changed to:

SELECT dim ON 0

FROM cube

and everything has been working well since then. Perhaps a bit strange errormessage but otherwise my mistake. Sorry for taking up your time with this one

|||

I am new to Analysis services. I migared on of the Sql 2000 cube to sql 2005 .I am getting the same message , when i use Pivot table to dipaly data from sql 2005 Cube.With sql 2000, it works great.Here is the eror message.

Error (Data mining): Either the user, Domain/User doen not have permission to access the referenced mining model, SalesHistoryData , or the object does not exist. Error (Data mining): Either the user, DOMAIN\USER , does not have permission to access the referenced mining model, SalesHistoryData , or the object does not exist.

When i ran Profiler , it is trying to run the following sql statement.

SELECT * FROM "SalesHistoryData "

I have granted all high level rights.Still not working.

Expecting fix from someone.

|||

hi, i recv the same while trying to query the cube from SSMS...

Error (Data mining): Either the user, domain\account, does not have permission to access the referenced mining model, MaxMinSalesDM, or the object does not exist.

no error building or deploying the cube..

can see the cube in the database folder as well

please help...

|||

sorry, my mistake...

it should be select from [Cube Name], not select * from [Cube Name]

|||

My issue solved.I just had to change the Data Source Provider to msolap.2 to msolap.3 in the Pivot table properties.

You may also have to try with just msolap(No vesion) in case the above change doesn't fix it.

Connection Error when trying to run MDX-queries

To learn MDX (on SQL Server 2005 dev edition) I decided to put up some sample cubes and run MDX-queries from SQL Server Management Studio. When processing the cube in BI Studio I get the following error:

"The datasource , 'Adventure Works DW', contains an ImpersonationMode that that is not supported for processing operations."

Fair enough, then I change the impersonationmode in the datasource to service account. It all processes/deploys well and I can browse the cube in BI Studio. Off to Management studio to run some mdx-queries. Here however I get the error:

"Error (Data mining): Either the user, ######, does not have permission to access the referenced mining model, Analysis Services Tutorial, or the object does not exist."

That is of course due to me using the current user credentials for the query. So I try to change the current connection in management studio but the helpbutton informs me that as of now only windowsauthentication can be used for analysis services. So the only connectionway I can use from here is the only one not supported when processing?! This must mean I've done some childishly simple newbiemistake and I would be very grateful if you pointed it out so I could get started with the MDX.

Perhaps I should add that the user ##### is administrator for the entire server. The server administrator role should take precedence over database roles, right (not that it helped when I added one of those and included me)? The user is also a member of the SQLServer2005OLAPUser group. I also have full access to the underlying relational database. So I can delete or create elements or entire databases at will but not ask simple questions to them...

The other option - that the cube doesn't exist seems dispelled by being able to browse it and the dimensions etc. showing up in object explorers and in the left pane of the MDX Query interface.

Which leaves me at some permission problem again - some help would REALLY be appreciated.

|||Please provide more information as something strange is going on here - given what you have provided, you should not be having a permission error - but, the error message does not make sense as the Analysis Services Tutorial has no data mining component.|||

I don't have the queries I tested with anymore since I got it to work but the bottomline was that I didn't have any "ON ROW|COLUMNS" etc. part of the selection clause which obviously sent the engine looking for something that didn't exist. I.e. just had queries with variations on the form:

SELECT dim

FROM cube

Looked at what the browser sent with the profiler and changed to:

SELECT dim ON 0

FROM cube

and everything has been working well since then. Perhaps a bit strange errormessage but otherwise my mistake. Sorry for taking up your time with this one

|||

I am new to Analysis services. I migared on of the Sql 2000 cube to sql 2005 .I am getting the same message , when i use Pivot table to dipaly data from sql 2005 Cube.With sql 2000, it works great.Here is the eror message.

Error (Data mining): Either the user, Domain/User doen not have permission to access the referenced mining model, SalesHistoryData , or the object does not exist. Error (Data mining): Either the user, DOMAIN\USER , does not have permission to access the referenced mining model, SalesHistoryData , or the object does not exist.

When i ran Profiler , it is trying to run the following sql statement.

SELECT * FROM "SalesHistoryData "

I have granted all high level rights.Still not working.

Expecting fix from someone.

|||

hi, i recv the same while trying to query the cube from SSMS...

Error (Data mining): Either the user, domain\account, does not have permission to access the referenced mining model, MaxMinSalesDM, or the object does not exist.

no error building or deploying the cube..

can see the cube in the database folder as well

please help...

|||

sorry, my mistake...

it should be select from [Cube Name], not select * from [Cube Name]

|||

My issue solved.I just had to change the Data Source Provider to msolap.2 to msolap.3 in the Pivot table properties.

You may also have to try with just msolap(No vesion) in case the above change doesn't fix it.

Connection Error when trying to run MDX-queries

To learn MDX (on SQL Server 2005 dev edition) I decided to put up some sample cubes and run MDX-queries from SQL Server Management Studio. When processing the cube in BI Studio I get the following error:

"The datasource , 'Adventure Works DW', contains an ImpersonationMode that that is not supported for processing operations."

Fair enough, then I change the impersonationmode in the datasource to service account. It all processes/deploys well and I can browse the cube in BI Studio. Off to Management studio to run some mdx-queries. Here however I get the error:

"Error (Data mining): Either the user, ######, does not have permission to access the referenced mining model, Analysis Services Tutorial, or the object does not exist."

That is of course due to me using the current user credentials for the query. So I try to change the current connection in management studio but the helpbutton informs me that as of now only windowsauthentication can be used for analysis services. So the only connectionway I can use from here is the only one not supported when processing?! This must mean I've done some childishly simple newbiemistake and I would be very grateful if you pointed it out so I could get started with the MDX.

Perhaps I should add that the user ##### is administrator for the entire server. The server administrator role should take precedence over database roles, right (not that it helped when I added one of those and included me)? The user is also a member of the SQLServer2005OLAPUser group. I also have full access to the underlying relational database. So I can delete or create elements or entire databases at will but not ask simple questions to them...

The other option - that the cube doesn't exist seems dispelled by being able to browse it and the dimensions etc. showing up in object explorers and in the left pane of the MDX Query interface.

Which leaves me at some permission problem again - some help would REALLY be appreciated.

|||Please provide more information as something strange is going on here - given what you have provided, you should not be having a permission error - but, the error message does not make sense as the Analysis Services Tutorial has no data mining component.|||

I don't have the queries I tested with anymore since I got it to work but the bottomline was that I didn't have any "ON ROW|COLUMNS" etc. part of the selection clause which obviously sent the engine looking for something that didn't exist. I.e. just had queries with variations on the form:

SELECT dim

FROM cube

Looked at what the browser sent with the profiler and changed to:

SELECT dim ON 0

FROM cube

and everything has been working well since then. Perhaps a bit strange errormessage but otherwise my mistake. Sorry for taking up your time with this one

|||

I am new to Analysis services. I migared on of the Sql 2000 cube to sql 2005 .I am getting the same message , when i use Pivot table to dipaly data from sql 2005 Cube.With sql 2000, it works great.Here is the eror message.

Error (Data mining): Either the user, Domain/User doen not have permission to access the referenced mining model, SalesHistoryData , or the object does not exist. Error (Data mining): Either the user, DOMAIN\USER , does not have permission to access the referenced mining model, SalesHistoryData , or the object does not exist.

When i ran Profiler , it is trying to run the following sql statement.

SELECT * FROM "SalesHistoryData "

I have granted all high level rights.Still not working.

Expecting fix from someone.

|||

hi, i recv the same while trying to query the cube from SSMS...

Error (Data mining): Either the user, domain\account, does not have permission to access the referenced mining model, MaxMinSalesDM, or the object does not exist.

no error building or deploying the cube..

can see the cube in the database folder as well

please help...

|||

sorry, my mistake...

it should be select from [Cube Name], not select * from [Cube Name]

|||

My issue solved.I just had to change the Data Source Provider to msolap.2 to msolap.3 in the Pivot table properties.

You may also have to try with just msolap(No vesion) in case the above change doesn't fix it.

Connection Error when trying to run MDX-queries

To learn MDX (on SQL Server 2005 dev edition) I decided to put up some sample cubes and run MDX-queries from SQL Server Management Studio. When processing the cube in BI Studio I get the following error:

"The datasource , 'Adventure Works DW', contains an ImpersonationMode that that is not supported for processing operations."

Fair enough, then I change the impersonationmode in the datasource to service account. It all processes/deploys well and I can browse the cube in BI Studio. Off to Management studio to run some mdx-queries. Here however I get the error:

"Error (Data mining): Either the user, ######, does not have permission to access the referenced mining model, Analysis Services Tutorial, or the object does not exist."

That is of course due to me using the current user credentials for the query. So I try to change the current connection in management studio but the helpbutton informs me that as of now only windowsauthentication can be used for analysis services. So the only connectionway I can use from here is the only one not supported when processing?! This must mean I've done some childishly simple newbiemistake and I would be very grateful if you pointed it out so I could get started with the MDX.

Perhaps I should add that the user ##### is administrator for the entire server. The server administrator role should take precedence over database roles, right (not that it helped when I added one of those and included me)? The user is also a member of the SQLServer2005OLAPUser group. I also have full access to the underlying relational database. So I can delete or create elements or entire databases at will but not ask simple questions to them...

The other option - that the cube doesn't exist seems dispelled by being able to browse it and the dimensions etc. showing up in object explorers and in the left pane of the MDX Query interface.

Which leaves me at some permission problem again - some help would REALLY be appreciated.

|||Please provide more information as something strange is going on here - given what you have provided, you should not be having a permission error - but, the error message does not make sense as the Analysis Services Tutorial has no data mining component.|||

I don't have the queries I tested with anymore since I got it to work but the bottomline was that I didn't have any "ON ROW|COLUMNS" etc. part of the selection clause which obviously sent the engine looking for something that didn't exist. I.e. just had queries with variations on the form:

SELECT dim

FROM cube

Looked at what the browser sent with the profiler and changed to:

SELECT dim ON 0

FROM cube

and everything has been working well since then. Perhaps a bit strange errormessage but otherwise my mistake. Sorry for taking up your time with this one

|||

I am new to Analysis services. I migared on of the Sql 2000 cube to sql 2005 .I am getting the same message , when i use Pivot table to dipaly data from sql 2005 Cube.With sql 2000, it works great.Here is the eror message.

Error (Data mining): Either the user, Domain/User doen not have permission to access the referenced mining model, SalesHistoryData , or the object does not exist. Error (Data mining): Either the user, DOMAIN\USER , does not have permission to access the referenced mining model, SalesHistoryData , or the object does not exist.

When i ran Profiler , it is trying to run the following sql statement.

SELECT * FROM "SalesHistoryData "

I have granted all high level rights.Still not working.

Expecting fix from someone.

|||

hi, i recv the same while trying to query the cube from SSMS...

Error (Data mining): Either the user, domain\account, does not have permission to access the referenced mining model, MaxMinSalesDM, or the object does not exist.

no error building or deploying the cube..

can see the cube in the database folder as well

please help...

|||

sorry, my mistake...

it should be select from [Cube Name], not select * from [Cube Name]

|||

My issue solved.I just had to change the Data Source Provider to msolap.2 to msolap.3 in the Pivot table properties.

You may also have to try with just msolap(No vesion) in case the above change doesn't fix it.

Connection error after already connected

I am using Access 2002 as a front end and SQL Server 2000 as a back end.
After I have connected, I use ADO to run a process that gets ten different
sum queries from various SQL Server tables and writes the results to local
Access table. This loops thru 300 to 800 records.
The second time thru this process, at any of the queries, I will almost
always get this error:
-2147467259, Sql Server does not exist or access denied. Now I am already
connected and I have run this same query many times.
If I debug and force the same line, it runs.
Why is it hanging occasionally, and more importantly, what can I do to fix
this?
TIA,
Mike
Are you using named pipes or tcp/ip ?
Vikram
"Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
> I am using Access 2002 as a front end and SQL Server 2000 as a back end.
> After I have connected, I use ADO to run a process that gets ten different
> sum queries from various SQL Server tables and writes the results to local
> Access table. This loops thru 300 to 800 records.
> The second time thru this process, at any of the queries, I will almost
> always get this error:
> -2147467259, Sql Server does not exist or access denied. Now I am already
> connected and I have run this same query many times.
> If I debug and force the same line, it runs.
> Why is it hanging occasionally, and more importantly, what can I do to fix
> this?
> TIA,
> Mike
>
|||TCP/IP
"Vikram Vamshi" <vikram.vamshi@.nospam.com> wrote in message
news:efh1gyyTEHA.3180@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Are you using named pipes or tcp/ip ?
> Vikram
> "Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
> news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
different[vbcol=seagreen]
local[vbcol=seagreen]
already[vbcol=seagreen]
fix
>

Connection error after already connected

I am using Access 2002 as a front end and SQL Server 2000 as a back end.
After I have connected, I use ADO to run a process that gets ten different
sum queries from various SQL Server tables and writes the results to local
Access table. This loops thru 300 to 800 records.
The second time thru this process, at any of the queries, I will almost
always get this error:
-2147467259, Sql Server does not exist or access denied. Now I am already
connected and I have run this same query many times.
If I debug and force the same line, it runs.
Why is it hanging occasionally, and more importantly, what can I do to fix
this?
TIA,
MikeAre you using named pipes or tcp/ip ?
Vikram
"Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
> I am using Access 2002 as a front end and SQL Server 2000 as a back end.
> After I have connected, I use ADO to run a process that gets ten different
> sum queries from various SQL Server tables and writes the results to local
> Access table. This loops thru 300 to 800 records.
> The second time thru this process, at any of the queries, I will almost
> always get this error:
> -2147467259, Sql Server does not exist or access denied. Now I am already
> connected and I have run this same query many times.
> If I debug and force the same line, it runs.
> Why is it hanging occasionally, and more importantly, what can I do to fix
> this?
> TIA,
> Mike
>|||TCP/IP
"Vikram Vamshi" <vikram.vamshi@.nospam.com> wrote in message
news:efh1gyyTEHA.3180@.TK2MSFTNGP11.phx.gbl...
> Are you using named pipes or tcp/ip ?
> Vikram
> "Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
> news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
different[vbcol=seagreen]
local[vbcol=seagreen]
already[vbcol=seagreen]
fix[vbcol=seagreen]
>

connection error

Hello I have this error when I run my report.
. An error has occurred during report processing.
(rsProcessingAborted) Get Online Help
o Cannot create a connection to data source myDB.
(rsErrorOpeningConnection) Get Online Help
 Login failed for user myDB.
What is problem? I am testing my ODBC connection it seem
fine.Are you trying to use integrated security and the credentials your using
need to make more than 1 hop? If so you're running into a limitation in
windows integrated auth. To resolve it either deploy kerberos or you can
try changing the data source credentials to stored and see if it works after
that.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:2cc5301c46913$fdfae570$a301280a@.phx.gbl...
> Hello I have this error when I run my report.
> . An error has occurred during report processing.
> (rsProcessingAborted) Get Online Help
> o Cannot create a connection to data source myDB.
> (rsErrorOpeningConnection) Get Online Help
>  Login failed for user myDB.
> What is problem? I am testing my ODBC connection it seem
> fine.
>

Connection confusion

When I try to run my application on our server I cannot connect to the SQL Server that's on the same machine (a named instance). I get the SqlException:Login failed for ("null") user. Not a trusted SQL Server connection. I CAN however, connect to this database from the IDE on my laptop--the app works just fine.

I have reconfigured the IIS, the default site and the directory for the app: I turned off anonymous access, turned it on, changed users, changed passwords, etc. I have done the same for the database, added users, changed permissions, added permissions, etc., you get the picture...none of it worked. (I changed the connection string to those users/pwds)

I saw on an MS site that this error can occur under heavy loads...but that's not the case here.

Please help! Thanks!!

You have what is called orphan user, it happened to me recently I had to delete some files in the master but there are other solutions. You may have moved the database from another server or recreated it, the login you are trying to use only exist in the Master but is not available. Try the links below for solutions. If you are still having the problem, I would restore from backup using the device option in the backup wizard. Hope this helps.

http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12615

|||

Sorry to be so long responding, got pulled to another issue...

I'm not sure that an orphan user isn't the problem, but I ran sp_helplogins and the results show user ASPNET mapped toservername/ASPNET.I think that means that ASPNET is recognized as a validated user. This would explain why I can connect from my laptop IDE (Visual Studio.NET) with no problems, wouldn't it?

Is there something within the .NET framework installed on the server that needs to be changed or upgraded?

Thanks again for your help!

Connection

Hi all,

I was on SQL 2000 and now changed over to SQL 2005 Ex Ed. When I run my application I get the following error Mssg @. Conn.Open
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
Code:
Imports System.Data.SqlClient

Public Conn As SqlConnection = New SqlConnection
Dim da As New SqlDataAdapter

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Conn.ConnectionString = "Data Source=(local);" & _
"Initial Catalog=Rsch1;" & _
"Integrated Security=SSPI"
Conn.Open()

Did you added the ASPNET Account to the database security section|||Actually this is not a ASP.NET project.

Basically VB.NET is not accepting the Server name as (Local)
If I hardcode my servername as in 072-Rsch1 then it works fine.

I would like to have the server name as local as I was working with
SQL 2K.

Tnx
|||If you are using ado.net1.0 against SQL2K5, you need enable named pipe on both server and client to make (local) work. SQL2k5's local sharememory connection is not compatible with SQL2k's and ado.net1.0. If the SQL2k5 is default instaince, and you're using ado.net1.0, (local) is a known issue. You can upgraded to ado.net2.0 or use alias to work around if you don't want to change your connection string.

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...
>
>

Connection

iam using an execute sql task

ineed the connection to be daynamic ,changed at run time ..

how can i do that

Depending on your scenario you may have more than one option. Serach in package configurations or "http://msdn2.microsoft.com/en-us/library/ms141682.aspx">http://msdn2.microsoft.com/en-us/library/ms141682.aspx

"http://msdn2.microsoft.com/en-us/library/ms141232.aspx">http://msdn2.microsoft.com/en-us/library/ms141232.aspx

|||

Batool wrote:

iam using an execute sql task

ineed the connection to be daynamic ,changed at run time ..

how can i do that

Use an "http://blogs.conchango.com/jamiethomson/archive/2006/10/05/SSIS-Nugget_3A00_-Dynamically-set-a-logfile-name.aspx">http://blogs.conchango.com/jamiethomson/archive/2006/10/05/SSIS-Nugget_3A00_-Dynamically-set-a-logfile-name.aspx

talks about setting an expressoin on the ConnectionString property of a file conenction manager rather than an OLE DB Conenction Manager, but the concept is the same.

-Jamie

|||

Hi,

The easiest way to set dynamic connection at run time is by declaring two SSIS variables

1. DBName
2. DBServer

In connection properties open the "InitialCatalog" = "@.[User::DBName]" and "ServerName" = "@.[User::DBServer]".While running the package if you just set the value of variables dynamically the connection to the DB will be created accordingly. Using this connection in SQL task will server your purpose. This works with both OLEDB and ADO.NET connections.

Thanks

Mohit

|||thx for ur replay and i think its my solution but,can we read theses variable from the registry|||

Hi,

Using follwoing in Script tasks will retrieve value from registry

Imports Microsoft.Win32

VarValue = Registry.LocalMachine.GetValue(<Registry Key>)

After getting the value you can set this in SSIS variables using Dts.Variables("DBServer").Value = VarValue will set the value from registry

Thanks

Mohit

|||Sorry that seems a bit mad. Why write code when there is a built in mechanism, see Configurations. You can use the registry as a source for a configuration. It also happens before the package starts executing, so things start working from the very begining. Often changing a connection part way can be an issue, as tasks have started to validate or do other preparation.|||

I PUT THE NEEDED VALUES IN THE REGISTRY

(DB NAME AND SERVER NAME )

BUT I DID NOT KNOW HOW TO RETRIVE THESE VALUES AND MADE THE CONNECTION STRING

|||

Independently where you want to store your configuration values; in the case of connection managers you can better store the whole connection string, instead of Server name and DB name; and then use that value against the connection string property.

|||

There is a section in Books Online that describes the registry format. Seems that you must use one value per key, and that value must be called Value. It also seems to be limited to values within HKEY_CURRENT_USER. In retrospect the Script task method may be better after all with these rather restrictive limitations.

Package Configurations
(http://msdn2.microsoft.com/en-us/library/d20e0311-1fc9-4ddc-a381-6d127cf11b69.aspx)

Added Connect Feedback on these restrictions - https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=250871

connection

Please help me resolve I'm stuck and a novice
I have a connection string in a VB app that I am working
on but when i execute app I get
Run time Error -2147467259 (80004005) Login failed for
user *** reseaon not a trusted SQL Server connection.
I am set up on SQL server I can run enterprise manage from
my PC and run queries against server but I can not through
my application, I am set up using my windows user info..Hi, Chuck.
Refer to the following site:
http://www.able-consulting.com/ado_conn.htm
You can see many connection examples. This may help you.
"Chuck" <anonymous@.discussions.microsoft.com> wrote in message
news:051d01c3bbd7$20610da0$a501280a@.phx.gbl...
> Please help me resolve I'm stuck and a novice
> I have a connection string in a VB app that I am working
> on but when i execute app I get
> Run time Error -2147467259 (80004005) Login failed for
> user *** reseaon not a trusted SQL Server connection.
> I am set up on SQL server I can run enterprise manage from
> my PC and run queries against server but I can not through
> my application, I am set up using my windows user info..

Connecting to SQLServer 2000 (sqlsrv32.dll)

Hello,

I am having problem with our network. We run a clinic database system that uses SQLServer 2000 Enterprise as the backend, and Microsoft Access on the front end.

I have had a running problem with all our newer machines (which run Windows 2000 or XP) in that while it connects to the server and retrieves some of the info properly, on some of the pages it doesnt. It will take 2 or 3 minutes for a page of the database to load, and even then not all the information will be retrieved properly.

I was able to fix the problem on the Windows 2000 machines by replacing the Sqlsrv32.dll file with an older version (usually with 3.70.06.23). And then the W2000 machines would work. But for some reason, the XP machines wont accept the older sqlsrv32.dll file...it gives me this error:
SQLState: 'HY000'
SQL Server Error: 126 Unable to load communication module driver correctly.

...and i cant seem to downgrade the MDAC...

any ideas on what I can do?

thanksYou didnt test it properly before it was rolled out for XP, did you?

Tut tut....

Best check technet & see if there is a work around. Failing that, best roll XP boxes back to W2000. Quick, easy & saves face....then I'd spend a LOT of time ironing out the XP issue BEFORE it goes near the client again.

HTH,

Cheers,|||no they are the new computers we got in...they come with XP loaded on them already...

i'll check technet...and then possibly put W2K on them...

thanks...