problem in executing package in production environment

hi all!

This is my problem. My package executes fine when i set the connection string with the same database where i execute the query. If i execute with another database connection stirng if fails bacause while executing the pacakge it trys to access the same connection string at design mode.

when i try to execute through cmd prompt by setting \conn <new database connection string> it fails.

Is package configuration is the only solution. how can i change conn string depending on different server?

Any help would be appreciated.

Thanks,

Jas

As far as my knowledge, package configuration is the only one solution.|||

Package configurations will work but you'll need to reference the configuration at runtime. You can also use the /SET switch from dtexec.exe to set a property dynamically at runtime. If you're trying to set a connection string though, you can set it with the /Connection swtich. Try doing this from DtsExecUI.exe first to see if you have better luck then grab the command line from the last page down. Hope this helps!

Brian

|||

i am currently trying to set the variable with the /set and give connection string as /conn but when i do it another environment and change the conn string it does not work. Now thats my problem. Now i am trying through package configuration but that too i have some issues. I don't want to use environment variable and cannot use parent pacakge varibale for this particular pacakge cos it is the main parent pacakge. I want to use registry key but if i give the value other than current user. it does not work. I am trying to use the HKEY_local machine /software / .../ .../ value. How doi set the registry key for this in pacakge configuration. And i also tried the config file. I works well through indirect method only in another environment where i need to set the environment variable to hold the path of the config file.

Is there any suggestions?

Thanks,

JAs

sql

problem in executing package in production environment

hi all!

This is my problem. My package executes fine when i set the connection string with the same database where i execute the query. If i execute with another database connection stirng if fails bacause while executing the pacakge it trys to access the same connection string at design mode.

when i try to execute through cmd prompt by setting \conn <new database connection string> it fails.

Is package configuration is the only solution. how can i change conn string depending on different server?

Any help would be appreciated.

Thanks,

Jas

As far as my knowledge, package configuration is the only one solution.|||

Package configurations will work but you'll need to reference the configuration at runtime. You can also use the /SET switch from dtexec.exe to set a property dynamically at runtime. If you're trying to set a connection string though, you can set it with the /Connection swtich. Try doing this from DtsExecUI.exe first to see if you have better luck then grab the command line from the last page down. Hope this helps!

Brian

|||

i am currently trying to set the variable with the /set and give connection string as /conn but when i do it another environment and change the conn string it does not work. Now thats my problem. Now i am trying through package configuration but that too i have some issues. I don't want to use environment variable and cannot use parent pacakge varibale for this particular pacakge cos it is the main parent pacakge. I want to use registry key but if i give the value other than current user. it does not work. I am trying to use the HKEY_local machine /software / .../ .../ value. How doi set the registry key for this in pacakge configuration. And i also tried the config file. I works well through indirect method only in another environment where i need to set the environment variable to hold the path of the config file.

Is there any suggestions?

Thanks,

JAs

Problem in Deploying Userlogin database on Webserver aspnetdb.mdf

I read scott's tutorial for Deploying database to Hoster's server

"Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1)"

bt cud nt upload n get the user login functinality wrking..

so plz help me..

hi,

whats the actual problem, not being to upload or to connect ? What is the error message you are getting ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Problem in connecting to SSAS

I'm facing some security when deploying SSAS and reports using Reporting Services. In my environment, I don't understand why I can access the SSAS via the management studio if I don't have the domain administrator right. The support team have granted this right to me for development purpose.
In the connection dialog of Management Studio, I can only choose Server name after I click Connect --> Analysis Services. The authentication type is dimmed out by default. Please gives me some more relevant links to setup properly.
After deployed my cubes and reports, the other user cannot view the reports as they can't access the SSAS database. What should I do? There're so many security setting and I don't know which one I should tune. Thanks in advance.

Hello! You do not need to be an domain adminstrator in order to access Reporting Services and Analysis Services. It is sufficient to be a local administrator on the server running these two applications.

In Reporting Services you have the option to run a report with windows authentication or an assigned account for Reporting Services access to Analysis Services.

If you run with the first option each user need to mapped to a role in Analysis Services which can be done with individual accounts or windows groups. For the second option it is only the Reporting Services(AS2005) account that needs to mapped to a role in Analysis Services.

You can do this both in BIDS, Report Manager or Management Studio.

This is true for a server where both these applications are running. If Reporting Services is on a separate server things are a little bit more complicated. In this case you will have to set up account delegation in Active Directory. The key word for this setup is 'Kerberos' .

HTH

Thomas Ivarsson

|||Can you give me some more detail on the configuration please? Are there any guides available on the web? Thanks!|||

Hello! I have not found any best official practices regarding SSRS2005 and SSAS2005 integration.

My advice is based on customer cases/practises that I have used and some good writing in a reporting services book.

Regards

Thomas Ivarsson

|||http://technet.microsoft.com/en-us/library/ms175386(SQL.90).aspx

This website provides what I needed.

Problem in connecting to SSAS

I'm facing some security when deploying SSAS and reports using Reporting Services. In my environment, I don't understand why I can access the SSAS via the management studio if I don't have the domain administrator right. The support team have granted this right to me for development purpose.
In the connection dialog of Management Studio, I can only choose Server name after I click Connect --> Analysis Services. The authentication type is dimmed out by default. Please gives me some more relevant links to setup properly.
After deployed my cubes and reports, the other user cannot view the reports as they can't access the SSAS database. What should I do? There're so many security setting and I don't know which one I should tune. Thanks in advance.

Hello! You do not need to be an domain adminstrator in order to access Reporting Services and Analysis Services. It is sufficient to be a local administrator on the server running these two applications.

In Reporting Services you have the option to run a report with windows authentication or an assigned account for Reporting Services access to Analysis Services.

If you run with the first option each user need to mapped to a role in Analysis Services which can be done with individual accounts or windows groups. For the second option it is only the Reporting Services(AS2005) account that needs to mapped to a role in Analysis Services.

You can do this both in BIDS, Report Manager or Management Studio.

This is true for a server where both these applications are running. If Reporting Services is on a separate server things are a little bit more complicated. In this case you will have to set up account delegation in Active Directory. The key word for this setup is 'Kerberos' .

HTH

Thomas Ivarsson

|||Can you give me some more detail on the configuration please? Are there any guides available on the web? Thanks!|||

Hello! I have not found any best official practices regarding SSRS2005 and SSAS2005 integration.

My advice is based on customer cases/practises that I have used and some good writing in a reporting services book.

Regards

Thomas Ivarsson

|||http://technet.microsoft.com/en-us/library/ms175386(SQL.90).aspx

This website provides what I needed.sql

Problem in Configuring ASPState DB for .NET 2.0

Hi,

In the current production environment we have web applications running in asp.net 1.1 (win 2003 server) which uses ASPState DB for the session management. We are in the process of migrating few of the web application in asp.net 2.0. We would like to use the same ASPState DB for both 1.1 and 2.0 applications for maintaining the session.

Problem that we are facing: After going through couple of article for configuring the ASPState DB, We ran the InstallPersistSqlState.sql of .net 2.0 framework (log information is given below). Though the sql has updated the existing ASPState DB with the stored procedure corresponding to asp.net 2.0, still we get the following error

Exception: System.Web.HttpException
Message: Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.

For certain reasons, we are not able to use aspnetreg_sql.exe for setting up the ASPState database. Is there something that I am missing when I run InstallPersistSqlState.sql alone.

Appreciate your help.

Thanks,

Siva

PS: We ran the InstallPersistSqlState.sql in the local sqlserver2000 (residing in winxp) and it works fine.

Result Log:

Run 'aspnet_regsql.exe -?' for details.
--

Completed execution of UninstallPersistSqlState.SQL
Starting execution of InstallPersistSqlState.SQL

--
Note:
This file is included for backward compatibility
only. You should use aspnet_regsql.exe to install
and uninstall SQL session state.
Run 'aspnet_regsql.exe -?' for details.
--
The CREATE DATABASE process is allocating 0.63 MB on disk 'ASPState'.
The CREATE DATABASE process is allocating 0.49 MB on disk 'ASPState_log'.
If the job does not exist, an error from msdb.dbo.sp_delete_job is expected.
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61
The specified @.job_name ('ASPState_Job_DeleteExpiredSessions') does not exist.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
If the category already exists, an error from msdb.dbo.sp_add_category is expected.
Server: Msg 14261, Level 16, State 1, Procedure sp_add_category, Line 32
The specified @.name ('[Uncategorized (Local)]') already exists.
-
Completed execution of InstallPersistSqlState.SQL
-

First of all, this is not the right place for posting a question about the ASP.NET Session DB, this is a CLR in SQLServer related forum only. But from the logs posted the db should have been installed. Make sure that you are trying to connect to the right session database from your web.config file. Also try to monitor if the passwort / username provided are right.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Dod you solve the problem ?|||

Hi,

I got this problem resolved by running the aspnet_regsql.exe with command line options to setup the ASPState DB.

Anyways, Thanks for the suggestion.

Thanks,

Siva

problem formatting date

Hi all,
I make an insert of date with VB.Net using the "format" function:
format(Now(), "dd/MM/yyyy hh:mm:ss").
In my dev environment it work fine.
But when I put the page on production server
the format fuction change the tima formatting, change ":" with "."
so it pass hh.mm.ss to the DB crashing the insert.
I used a replace function to restore ":", and it work fine.
Bue any idea?
Why this happen
thanks allThis is a pure VB.NET question, so you probably have better luck asking this
in a VB.NET forum.
However, I strongly encourage you to format the datetime as 'YYYYMMDD hh:mm:
ss'. Check
http://www.karaszi.com/SQLServer/info_datetime.asp for the reason.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Henry Cabot Enaus III" <hceiii@.yahoo.com> wrote in message
news:512ff012.0409010324.126ebd78@.posting.google.com...
> Hi all,
> I make an insert of date with VB.Net using the "format" function:
> format(Now(), "dd/MM/yyyy hh:mm:ss").
> In my dev environment it work fine.
> But when I put the page on production server
> the format fuction change the tima formatting, change ":" with "."
> so it pass hh.mm.ss to the DB crashing the insert.
> I used a replace function to restore ":", and it work fine.
> Bue any idea?
> Why this happen
> thanks all

problem formatting date

Hi all,
I make an insert of date with VB.Net using the "format" function:
format(Now(), "dd/MM/yyyy hh:mm:ss").
In my dev environment it work fine.
But when I put the page on production server
the format fuction change the tima formatting, change ":" with "."
so it pass hh.mm.ss to the DB crashing the insert.
I used a replace function to restore ":", and it work fine.
Bue any idea?
Why this happen
thanks all
This is a pure VB.NET question, so you probably have better luck asking this in a VB.NET forum.
However, I strongly encourage you to format the datetime as 'YYYYMMDD hh:mm:ss'. Check
http://www.karaszi.com/SQLServer/info_datetime.asp for the reason.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Henry Cabot Enaus III" <hceiii@.yahoo.com> wrote in message
news:512ff012.0409010324.126ebd78@.posting.google.c om...
> Hi all,
> I make an insert of date with VB.Net using the "format" function:
> format(Now(), "dd/MM/yyyy hh:mm:ss").
> In my dev environment it work fine.
> But when I put the page on production server
> the format fuction change the tima formatting, change ":" with "."
> so it pass hh.mm.ss to the DB crashing the insert.
> I used a replace function to restore ":", and it work fine.
> Bue any idea?
> Why this happen
> thanks all
sql

problem formatting date

Hi all,
I make an insert of date with VB.Net using the "format" function:
format(Now(), "dd/MM/yyyy hh:mm:ss").
In my dev environment it work fine.
But when I put the page on production server
the format fuction change the tima formatting, change ":" with "."
so it pass hh.mm.ss to the DB crashing the insert.
I used a replace function to restore ":", and it work fine.
Bue any idea?
Why this happen
thanks allThis is a pure VB.NET question, so you probably have better luck asking this in a VB.NET forum.
However, I strongly encourage you to format the datetime as 'YYYYMMDD hh:mm:ss'. Check
http://www.karaszi.com/SQLServer/info_datetime.asp for the reason.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Henry Cabot Enaus III" <hceiii@.yahoo.com> wrote in message
news:512ff012.0409010324.126ebd78@.posting.google.com...
> Hi all,
> I make an insert of date with VB.Net using the "format" function:
> format(Now(), "dd/MM/yyyy hh:mm:ss").
> In my dev environment it work fine.
> But when I put the page on production server
> the format fuction change the tima formatting, change ":" with "."
> so it pass hh.mm.ss to the DB crashing the insert.
> I used a replace function to restore ":", and it work fine.
> Bue any idea?
> Why this happen
> thanks all

Problem deploying reports

Apologies in advance, newbee to SQL Server and Reporting Services...
Installed Reporting Services in TEST environment (without SSL). I can author
a report, view the data from the data source and preview successfully.
However, I receive the following error message when trying to Deploy a
Solution from within Visual Studio Report Designer..."The underlying
connection was closed: Unable to connect to the remote server."
I can navigate to both the Report Manager and Report Server pages
successfuly using IE. Following the deployment failure the Report Manager
contains the new folder to which I was attempting to deploy the report but
it's empty (no report).
Any help would be appreciated.
Thanks,
Chris.In Report Manager, can you simply click on Upload File? Then you can upload
an RDL file manually.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Chris W, AgriBank" <ChrisWAgriBank@.discussions.microsoft.com> wrote in
message news:96862E2B-8F7C-422F-8A6E-71C86897BB60@.microsoft.com...
> Apologies in advance, newbee to SQL Server and Reporting Services...
> Installed Reporting Services in TEST environment (without SSL). I can
> author
> a report, view the data from the data source and preview successfully.
> However, I receive the following error message when trying to Deploy a
> Solution from within Visual Studio Report Designer..."The underlying
> connection was closed: Unable to connect to the remote server."
> I can navigate to both the Report Manager and Report Server pages
> successfuly using IE. Following the deployment failure the Report Manager
> contains the new folder to which I was attempting to deploy the report but
> it's empty (no report).
> Any help would be appreciated.
> Thanks,
> Chris.|||hey chris,
i m having the same issue .. are u able to resolve it ..
Please post ur comments if u know the solutions..
Thanks
SR
"Chris W, AgriBank" wrote:
> Apologies in advance, newbee to SQL Server and Reporting Services...
> Installed Reporting Services in TEST environment (without SSL). I can author
> a report, view the data from the data source and preview successfully.
> However, I receive the following error message when trying to Deploy a
> Solution from within Visual Studio Report Designer..."The underlying
> connection was closed: Unable to connect to the remote server."
> I can navigate to both the Report Manager and Report Server pages
> successfuly using IE. Following the deployment failure the Report Manager
> contains the new folder to which I was attempting to deploy the report but
> it's empty (no report).
> Any help would be appreciated.
> Thanks,
> Chris.

Problem Converting XML to table in SQL server

Hi There,
I'm new to the .Net environment, and I am currently trying to convert an xml document and its appropriate schema, to a dataset then with this Dataset I would like to load it into the database. This XML file is generated from the Access 2000 format. Then sent over the internet where it is received by an HttpFileCollection object, then the schema and xml file are loaded into a dataset.
I have created a new SQL database in which I imported the table required from Access, so in theory the table that the xml is generated from should be the same as the table that the xml is destined for.
I am getting the data loaded into the dataset however, when I try to execute the data adapter update command

oda.Update(myDS, "MSGLOBAL") it is throwing an Exception, in this exception the message is telling me that there is a problem near the key word 'on'.
Now I have added a watch window to monitor the sql statements, now the oda has an insert statement generated from a query builder, however this same query builder will not create either an update or delete command.
I hope this is a good enough explanation to get a few answers, or a possible example, it seems to be a topic that is quite difficult to research.
Thank you, and if you require more info please indicate this.
Damon

Http://www.ezywiz.biz

Access 2000 is barely relational and XML that old is not relational either so use DTS to move the data to SQL Server. Try the link below for DTS samples. Hope this helps.
http://www.sqldts.com|||Thanks Gary for your quick response.
I'll have a look at the link with the SQL examples.
The dataset isn't coming directly from Access 2000 though, it is coming from the XML file extracted from the Access database on the client side and received at the server. Is DTS still an appropriate option.
Thanks...Damon|||You can move the data to SQL Server with DTS and get the dataset from SQL Server. Hope this helps.|||

Choices aplenty.

1. You can code your own inserts statement rather than using the command builder

2. Use SQL/XML updategrams

3. Use SQL OpenXML and send the XML in

4. Process the XML and send in straight forward insert commands

5. Process the dataset and send in straight forward insert command

Do you really need to use a dataset?

Problem connecting to SQL-Server

Hello and thanks for reading.
This is my environment:
3 CITRIX Servers with anonymous users to login
Win2K Server with MS-SQL2K and the databases
Users logging in from the first server can connect to the sql-server, the
users logging in on the two other servers can´t. I think the reason is that
the anoymous users from the latter 2 servers have no right to connect to the
DB-Server. I think it is a problem with the windows users security, not with
the SQL-server´s. But I can´t figure out how to change this.
Any idea?
Thank you!
BerndI could tell you how to do this but then I would have to kill you...
But seriously
You will need to add some sort of security in your SQL Server database.
This can be in two forms.
Either Server 2000 security or SQL Security.
So the question is this.
When your CITRIX Servers users log into the Windows server do they have a particualr domain, or are they assigned any sort of proxy ID for use on the Server 2000 ?
If the answer is yes then this domain or ID can be used is SQL Server Secrurity.
If the answer is no then you will need to create each user (or CITRIX Servers application) individually within SQL Server security, assigning it User ID and passwords.
If you have any further questions then please do not hesitate to ask.
Peter Nolan
MCP
>--Original Message--
>Hello and thanks for reading.
>This is my environment:
>3 CITRIX Servers with anonymous users to login
>Win2K Server with MS-SQL2K and the databases
>Users logging in from the first server can connect to the sql-server, the
>users logging in on the two other servers can=B4t. I think the reason is that
>the anoymous users from the latter 2 servers have no right to connect to the
>DB-Server. I think it is a problem with the windows users security, not with
>the SQL-server=B4s. But I can=B4t figure out how to change this.
>Any idea?
>Thank you!
>Bernd
>
>.
>|||Maybe I was not clear enough:
1) My application connects to the MS-SQL instance using SQL security.
User/Password inside SQL-Sever and does not exist outside.
2) MS-SQL Instance is located on Server DB
3) CITRIX Terminalserver is located on SERVER CT1, CT2, CT3
4) Users log on CT1 - CT3 using windows anonymous users and start the
application (wich tries to connect to the db using the SQL-user)
5) On CT1 this succeeds, CT2-CT3 this fails.
Cheers
Bernd
---
This can be in two forms.
Either Server 2000 security or SQL Security.
So the question is this.
When your CITRIX Servers users log into the Windows server
do they have a particualr domain, or are they assigned any
sort of proxy ID for use on the Server 2000 ?
If the answer is yes then this domain or ID can be used is
SQL Server Secrurity.
If the answer is no then you will need to create each user
(or CITRIX Servers application) individually within SQL
Server security, assigning it User ID and passwords.
If you have any further questions then please do not
hesitate to ask.
Peter Nolan
MCP
>--Original Message--
>Hello and thanks for reading.
>This is my environment:
>3 CITRIX Servers with anonymous users to login
>Win2K Server with MS-SQL2K and the databases
>Users logging in from the first server can connect to the
sql-server, the
>users logging in on the two other servers can´t. I think
the reason is that
>the anoymous users from the latter 2 servers have no
right to connect to the
>DB-Server. I think it is a problem with the windows users
security, not with
>the SQL-server´s. But I can´t figure out how to change
this.
>Any idea?
>Thank you!
>Bernd
>
>.
>