How To Avoid Credential Prompt
Nov 23, 2007hi all
any one can tell me to avoid credential prompt i.e. uid & pwd when the first time going to render report from the reporting server
ADVERTISEMENT
Avoid Windows Login Prompt While Accessing Report Server.
Dec 29, 2006Hi,
We are using Microsoft Reporting Service 2005 to develop reports and we are accessing these reports through a J2EE application.
The front end is implemented using Tapestry and we using JBoss as our applicaiton server.
We are using Shared Data Sources for the reports and we set its data source type to SQL Server Analysis Services.
In the credential tab, by default "Use Windows authentication" is selected. All other options are disabled.
When I access my reportserver through my web application, I am always prompted for a windows login and password.
How can I avoid being shown the windows login prompt, since our web application will be used by several users and we do not want the users to type in a username/password everytime they want to access our reports.
Please suggest me solution for this scenario.
Thanks in advance!
How To Avoid Athentication Prompt When Accessing A Report Through URL Access Using Web Service
Nov 23, 2007Hi,
I am accessing my reports through one aspx page designed by me.
in that i am using webservice to render the report and
linking the url of the report to reportviewer
it is working fine
but for the first time it is asking username & password of the reporting server to render the report.
i am using Reporting Services 2000
plz help to avoid this user name & password prompt.
How To Credential
Oct 22, 2007
I know the basic concept of credential from aritcle Credentials ,but there are some concept block me also.
1 what is outside resource
2 How to access outside resource if i create a credential.
3 is xp_cmdshell command affected If use sp_xp_cmdshell_proxy_account to creates a proxy credential for xp_cmdshell .
thanks
Credential Does Not Take Effect
Mar 13, 2008I have a sqlserve, which service account is 'local system', running in machine A.
A credential ,which associated a windows user U1 in machine A, mapped to a sqlserver login Login1.
A file named 1.txt that only can be accessed by U1 in machine A.
A CLR procedure P1 that would read the 1.txt file.
I encounter a error when i access the 1.txt file through P1 as Login1:
A .NET Framework error occurred during execution of user-defined routine or aggregate "HelloWorld":
System.UnauthorizedAccessException: Access to the path 'E:1.txt' is denied.
System.UnauthorizedAccessException:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize)
at System.IO.StreamReader..ctor(String path)
at StoredProcedures.StoredProcedure1(SqlString fileName)
.
I think it need a credential when a sqlserver login access some resource outside the sqlserver, so i add a credential and mapped to the login
any suggestions would be appreciated.
And please correct me if i have any inaccurate concept.
Error Creating Credential
Apr 3, 2007We upgraded from SQL Server 2000 to 2005 recently. I'm attempting to create a credential for the first time and I keep getting the error shown below. Can anyone tell me what to do to resolve it? Thank You
TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for Credential 'schjob'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Credential&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
An error occurred during decryption. (Microsoft SQL Server, Error: 15466)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=15466&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
rm
Proxy Account/Credential
Feb 14, 2008There is one thing that€™s confusing me in creating a proxy account.
I am trying to get an SSIS package configured as a SQL Server job and execute it from a non-sysadmin login. But when I execute it gives the error message:
Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.
I know that we have to create a proxy account for this to happen and creating of proxy account prompts me to choose a credential, and that is where I do not understand the logic. From MS website I can find the following, but it is confusing to me
This proxy account must use a credential that lets SQL Server Agent run the job as the account that created the package or as an account that has the required permissions.
ref: http://support.microsoft.com/default.aspx?scid=kb;EN-US;918760
I tried reading all the related articles, but still the process of creating the credential is confusing to me, can someone throw some light on the logic of proxy/credential here?
Thanks
Satya
XML Datasource Credential Issue
Feb 6, 2007I have a report using an XML data source. The data source is calling a web service method which returns the XML file. The security setting is "Use Windows Authentication (Integrated Security)" in the report. The web service and report are both deployed to ServerA.
The web service is pulling data from a file share. Only certain users have access to this share and they are identified in the <authorization> element of the web.config file in the web service.
If I open Internet Explorer on ServerA and go to //localhost/Reports, I can navigate to the report, run the report and everything works fine.
If I open Internet Explorer on ClientZ and go to //ServerA/Reports, I can navigate to the report. However, when I run the report I get a "Failed to execute web request for the specified URL". I do not believe my Windows Credentials are getting passed to ServerA from ClientZ.
Is this a known bug or am I doing something wrong in my set-up?
Thanks,
bbossi
How To Check/verify SQL Login Credential
Nov 15, 2007Hi, I am making a module to backup SQL Db from webpage. I impersonate asp.net user to a given Windows Account and need to verify that account has required permission in SQL Server.I don't know how to verify the windows account credential for SQL Server login. Now what I am doing is to run SQL query against database to select row from some table, if it is successful, the user is valid SQL login. But I know it's not the way. Any idea? Thanks,
View 1 Replies View RelatedSQL 2012 :: Mapped Credential Is Not Used In Any Query?
Jul 9, 2014Due to a previous (mis)configuration, i need to grant readwrite permission on a share from a MSSQL DB User.The SQL user will launch t-sql queries on demand and they cannot be scheduled.
I've created a credential object in SSMS, configured it with the correct AD user and mapped it to the MSSQL DB user.Now, if i execute a simple t-sql backup:
BACKUP DATABASE [DB] TO DISK = N'IP.ADD.RE.SSshareDB.bak' WITH NOFORMAT, NOINIT, NAME = N'DB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
I get an access denied error, monitoring the sqlserv.exe process via procmon, i see that the Sql Server process is not impersonating the AD user configured in the credential, it still try to access using the local machine account .
CREATE Credential Secret Storage
Sep 12, 2005I am hoping to use SQL Server Agent 2k5 to run jobs in the security context of another account. I have successfully done this, so I know it works.
View 4 Replies View RelatedDB2 Credential Storage For DB2 Connection Manager
Oct 9, 2007Hello,
Our department will create several SSIS packages that will contain connection managers that use the IBM or Microsoft OLE DB provider for DB2. In every case, we will have to use a specific user name and password.
We need one point of reference for the password for the multitude of packages in case the password changes. I'm guessing that we would do this with a single XML package configuration that each of these packages could use. If this is the case, how can it be done securely?
Are there other ideas that I should consider?
Thanks!
cdun2
Best Way To Confirm Password Change For A Credential?
Jun 8, 2007Looking for opinions here on what is the best way to programmatically test that a password change to a credential has occurred successfully.
The password change was made using Alter Credential, and I can see in sys.credentials that the credential was updated by the tool that handles these updates. I would just like to be able to confirm that all of the credential updates were successful (in other words, they authenticate correctly) before anything starts to fail.
Assume that the number of SQL Servers is too great to manually check them even if the whole team worked on it together.
Thanks in advance!!
SQL 2012 :: Create Credential With Password Masking
Sep 19, 2014I need to give the below script which contains CREATE CREDENTIAL query to an app team.
CREATE CREDENTIAL crdntl WITH IDENTITY = '<service_acct>',
SECRET = '<pwd>'
GO
My concern is i don't want the password to be visible. Basically i want to use this credential to create a proxy which is then used to run SQL Agent backupjob on number of SQL servers. Also, i cannot leave the SECRET value as blank (as the MSDN suggests.)
Is there any way to mask the password OR any other alternative solution.
DB Engine :: Selecting Credential That Are Mapped To Login?
Nov 23, 2015is any way to select SQL logins that are Mapped To Credentials as using this query I get only NULL:
SELECT credential_id FROM sys.server_principals WHERE name = 'test_login'
I see the list of Mapped Credentials in SQL login properties with GUI, but can not select this option.Â
SQL 2012 :: What Account To Use For Identity When Creating Credential And To Use As Job Owner
Aug 12, 2014We are running SQL Server 2012 on Windows 2008 Server. I created a credential with a proxy account. In creating the credential, it asked for an Indentity and Secret. I used my windows login and password. Now, I have tested the credential and proxy account by executing a Job which calls a SSIS Package. What is the 'best practice' to use when creating a credential? Should the credential be created with another windows login, created with the same abilities as my windows login, with a non-expiring password? Should that new windows login be used as the owner of my job with the Agent?
View 8 Replies View RelatedQuestion About Credential For Proxy For Ssis Package In Agent Job ...
Mar 6, 2008
I had a question about proxy account for ssis.
Is it necessary to set up credential with windows account for proxy account so that ssis package can be setup as a job in agent ?
without proxy account ssis package is unable to run under agent as a job ..but..
does identity in credential for proxy need to be windows account ?
SQL Security :: Connecting Linked Server Using Windows Credential
Sep 28, 2015I have a scenario where I want to make a linked server query and report using windows service account credential. I can able to do link query if I RDP into the Server where linked server established using the service account and run query successfully  but local client SSMS with my credential fails connecting linked server or querying. Looks to be a sql double hoping problem if so configuration each client domain account to enable delegation will be challenging as mentioned in the following articles instead service account only might work if possible.
View 3 Replies View RelatedReporting Services :: Changing Credential Used For SSRS Data Source Programmatically
Jun 15, 2015I am looking command (cmd/powershell/c#) for setting/updating credential for SSRS data source.
View 2 Replies View RelatedPrompt For Value
Jun 21, 2004What is the sql code to prompt for a value?
Can I do this in query analyzer or do I have to send the value from some other application?
Prompt In SQL Server 7
Mar 6, 2002HI,
I have a need where SQL Server should prompt me for a value when I run a Select statement.
Eg:
If I need the name of an employee by id number, SQL server should prompt me to enter a value for the ID when I run the statement like:
SELECT name FROM employee WHERE id=[Enter ID]
In oracle, it is possible by using "&" operator but I am not sure how it can be done in SQL Server. Is there any other way to get the prompts if not by the above method.
Thank you for your help in advance.
Sravan.
What's Sql Prompt Tool
Feb 26, 2008can anyone tell me what's sql prompt tool and how can it help in sql script? it finds error or what?
is it useful? its like visual studio?
thanks. pls reply.
SQL Bundle Pro And Sql Prompt
Sep 24, 2007
Hi,
we are using a development environment. what is the cost saving licence to buy sql bundle pro and sql prompt.
Please guide. we have eight programmers , do we need to buy licence for every one, for both the tools, and what is the cost
i saw the link in the internet, but not so clear.
Thanks
Parameter Prompt RTL
May 9, 2007How i can display parameter prompt in other language like arabic
(right to left)
Regard
LPW
Prompt When New Message Is Submitted
Jul 31, 2006Hey everyone I dont know if this is the right area to post this but here it goesAn easy expamle of this that everyone is really fimaler with is myspace. When a new database entry is submitted then on the admin page it will say like new message(s).. how can I do this. It doesnt have to be per member. It is only going to be on the admin page.
View 1 Replies View RelatedBCP Utility & Command Prompt
Dec 7, 2000Can anyone tell me how to enable bcp utility. Because anytime I try to run BCP I get the following error messages: (BCP not enable). Also how can I get to SQL Server command prompt? I look forward to hearing from anyone.
View 2 Replies View RelatedRunning DTS From Dos Prompt.....URGENT!!
Oct 17, 2000How to run a DTS job from command prompt? Any help is appreciated!
Thanks.
Running A DTS Job From Command Prompt
Oct 17, 2000Sorry for the new thread.
How to run a DTS job from command prompt? Any help is appreciated!
Thanks.
XP_CMDSHELL From DOS Prompt And SQL Mail!
Dec 3, 1999I have a problem like this.
I have a Folder on our NT4.0 server gets filled with different files with extensions(For ex. .bak, .new, .old, etc). These files with those extensions gets build up on a daily basis.
What I am looking for is,
a)I would like to do a count on those files with those extenstion
b)Send an email to the user and their boss if I have letz say more than 15 files of .bak or 15 files of .new files in that folder.
c) Also like to schedule this program to to run every day.
We have SQL Server6.5. Can some one assist me in coding this problem. Thanks
for your time. Roja96@hotmail.com
Start Job From The Command Prompt?
Feb 23, 2006I have a Microsoft SQL server that is setup, and inside it is a job. Inside the job is a bunch of lines of transact sql statements.
I would like to be able to start the job from the command prompt. Moreover, I do not want to have to create new files or modify anything that is existing. I just want to be able to have it set up so that a new user who installs the server and all of the job on their machine fresh, can just punch in the command to run the job.
I know I can copy the transact sql statements from the job, and run them through the command prompt, but that would be a poor way to do it, because if the statements in the job were ever modified, with this task being automated, the command prompt statements would be out of date.
So I just need a way to start the existing job from the command prompt. Is this possible? Maybe with OSQL?
Sql Install From Command Prompt
Jun 18, 2008Please let me know how to install sql server by using command prompt.
View 4 Replies View RelatedPrompt User For Data
Oct 20, 2006I need to prompt a user for start and end dates as well
as start and end times using a specific format for the
date and time.
I am having difficulty constructing the query.
So far I have...
DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
DECLARE @StartTime DATETIME
DECLARE @EndTime DATETIME
SELECT I.IncidentId,
I.CFScompanyname,
I.New_created_time,
E.createdon
FROM dbo.IncidentExtensionBase I
INNER JOIN dbo.IncidentBase E on I.IncidentId = E.IncidentId
WHERE E.createdon >= @StartDate AND
E.createdon <= @EndDate AND
E.createdon >= @StartTime AND
E.createdon <= @EndTime;
Could someone please let me know how I prompt the user for this data.
Thank you very much.
Prompt In Query Analyser
Feb 5, 2007Is there antway I can get the Query Analyser to prompt me with a message saying '234 records will be updated' and then give me the option to continue or not.
I want to run an update query but want to see how many records it will update first.