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

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

Password prompt with R2 on a separate machine

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


I am able to access report manager and service URLs locally on a machine running SQL 2008 R2, but when I try openning either of those URLs from another machine under where I am logged under the same user name, I am getting endless password prompts and unable to log in.

The IE machine is 2003 R2, the server is 2008 R2.

What is wrong here?


View Complete Post

More Related Resource Links

Accessing SharePoint via UNC Path Causes Password Prompt

I have a script that has to use a UNC path to drop a file into a SharePoint document library. For some users on some computers when they try to access the SharePoint site (http://Sharepoint) via the UNC Path (\\Sharepoint) they get a password prompt. Most users do not get a password prompt and get let right in. I have checked all the obvious things like zone settings, saved network passwords, etc. If I log a user that gets a password prompt into a different machine (that isn't having the problem) then it works just fine. This indicates to me that it is a client issue as opposed to a user issue.

Open Office Documents from Document Library without Password Prompt

We have a SharePoint site and Document library set up for anonymous access.   All non-Microsoft file types open correctly without a password.   When users click on Microsoft Office documents they are prompted for passwords.   Is there some way to configure the Office documents or Document Library so that users are not prompted for passwords when they open documents or is this a bug?

installing SSRS 2008 R2 on a separate machine than the SS 2008 R2 database



I set up SQL Server 2008 R2 along with SSRS on a Windows 2008 server--let's call it "SQLDB"--and all's working fine.  I'm able to upload reports that are pulling data from the SQLDB databases.  There is no problem.

However, the operations dept. now tells me that a server with SQL Server installed absolutely will not be made available to the users and so I will need a separate SSRS 2008 R2 server (named "SQLRS") that pulls data from SQLDB databases.  Basically, I need to stop using SSRS on SQLDB and start using SSRS on SQLRS.  Makes sense to me, although I've never done this.

I'm confused about what services and components of SQL Server 2008 R2 need to be installed on which server(s).  Could somebody please point me to a page that explains it thoroughly or, if it's fairly simple, explain it for me here? 

For instance, "SQLDB" has SSAS, SSIS, database engine, SQL Browser, Management Tools, and SQL Agent installed. 

On "SQLRS", I installed SSRS, database engine, SQL Agent, SQL Browser, Management Tools, and SQL Agent.  Was it necessary to install the database engine, considering the data to be pulled is on "SQLDB"?  I read that the Agent is only required for subscriptions, but what about SQL Browser?  Is it only required on s

Remote copy and execution given admin username and password for remote machine



I have an application (.exe files) that I need to install on remote machine. For this I need to copy .exe file from my machine A remote machine B  and execute it remotely.

I have local administrative privilleges on remote machine.

For e.g. Username & password on remote machine : "remoteAdmin" , "remotePassword".

However this "remoteAdmin" account is not present in my local admin group on my machine A.

Is there a way to do this ?

Also on remote machine B firewall may be on or off.

I tried this using WMI but there were some issues due to firewall.

I can do this using File.Copy method of System.IO namespace but it needs "remoteAdmin" account to be present in my local machine's (A) Administrators group. I have even tried creating new user account and adding to admin goup using DirectoryServices but I don't know how to set domain for the new account.

Also for remote execution I tried using wmic but it did not work when firewall was on. Iteried remotely running notepad.exe. It works if firewall is off but I cannot assume that firewall would be always off.

So , is there a way to copy file and remotely execute them if I have admin username and password for remote machine ( preferable using C++ or C#) ?

 Also I cannot

Document prompt for password



The publishing site has been added as an intranet site to all users

Now, I have a document library, some of the users (visitors) will get prompted for password, username when they tried to open the document, is there a way to get rid of that prompt, I thought SP will picked up the credential automatically, and the weird thing is some users get prompt, but some don't.

Any idea?

Thanks in advance.

Windows authentication using SSRS 2008 R2 on separate machine from SQL db engine - Kerberos required


Is this still an issue in SSRS 2008 R2:  Can't use Windows authentication (integrated security) when the SQL database server is on a different machine than Reporting Services -- unless you (1) use Kerberos security, or (2) store credentials, or (3) use credentials supplied by the user when running report AND use as Windows credentials to impersonate?

I have SSRS 2008 R2 set up on a different machine than MSSQLServer 2008 R2.  When I create a report on the SSRS server that uses a data source specifying Windows integrated security, my symptom is that I get the following  error:

Cannot create a connection to data source 'myDataSource'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Here is a blog describing the problem under SSRS 2005 (with IIS): http://blogs.msdn.com/b/jgalla/archive/2006/03/16/reporting-services-and-windows-authentication.aspx



Richard Thompson

Checksum of the Machine Account Password


I would like to be able to obtain a checksum, hash value or the actual machine account password for a Domain computer.  A C# application can be run on the computer itself with administrative privileges.  Perhaps I need to be asking a different question, but an authorized computer can drop out of a Domain and prevent user logins.  I want to be able to determine if the machine account password has just been changed or has stayed the same in order to help debug what is happening when a computer falls out of sync with the Domain.  Thanks.


How to Encrypt and Decrypt a Password using SQLSERVER 2005?(Video)

Encypt and Decrypt a Password using SQLSERVER 2005(Video)

symmetric key protected by a password

An alternative could be using a symmetric key protected by a password, as long as your application generates the CREATE SYMMETRIC KEY and OPEN SYMMETRIC KEY statements directly instead of calling them inside a SP (otherwise the password will still be passed as a parameter, and will be in clear in the profiler).

Reference HttpApplication from a separate HttpApplication


I want to create a website that can monitor the status of other websites running on the same server. Is this possible? How do I get a reference to a site's HttpApplication context from a separate HttpApplication?

Use Membership but bypass / disable password usage for users


I have an application that does LDAP authentication. The authentication is done on the code behind page of my Login.aspx page. Once the user passes LDAP authentication, a cookie is set and I redirect:

FormsAuthentication.RedirectFromLoginPage(UserName.Text, False)

I would like to setup membership in my application and keep track of some user information. But due to company security requirements, I cannot store user passwords on my application. That must stay on the LDAP server only.

Is there a way to store users but disable password storage on the aspnet_membership table?

help needed: Ldap User authentication using userDN and password



Is it possible to authenticate a user using userDN and password? If so, then tell me the syntax.So far i have tried to authenticate using username and password from my c# code using directoryentry which takes the parameters like domainname,username and password. But i need to authenticate using Userdn and password.

Need help using control adapters at the machine level

Hi guys!

Let me explain our situation. I do web development at a university at which we have to meet strict accessibility guidelines. I've specially modified the adapters (as well as extended CompositeDataBoundControlAdapter to include GridView) for use on our site and to use with our global stylesheets as well as compiled the control adapters into a DLL.

The control adapters now all reside in the WebServices.CssFriendlyAdapters DLL.  (For example, WebServices.CssFriendlyAdapters.GridViewAdapter).

Currently, when someone drops an App_Browsers folder in to their site with the adapters specified, the adapters work. However, we'd like to be able to specify this in the C:\WINDOWS\Microsoft.NET\Framework\(version number)\CONFIG\Browsers directory so that the adapters work automatically without anyone having to move anything into App_Browsers for every site. To ensure that someone can still use the "old way" or will not be confused by their controls being adapted, I've written in code that uses the base rendering methods unless xhtmlConformance is set to "Strict" in the site's web.config file.

Anyway, on to the problem. When trying to compile the controlAdapters into the C:\WINDOWS\Microsoft.NET\Framework\(version number)\CONFIG\Browsers directory using aspnet_regbrowsers.exe (see http://msdn2.microsoft.com/en-us/library/ms229858.a

{ End Bracket }: The Emergence Of Machine Translation


Vikram Dendi looks at how machine translation is poised to change the world and why it is so important to deliver information in multiple languages.

Vikram Dendi

MSDN Magazine January 2009

Security: Safer Authentication with a One-Time Password Solution


One-time passwords offer solutions to dictionary attacks, phishing, interception, and lots of other security breaches. Here's how it all works.

Dan Griffin

MSDN Magazine May 2008

Security Briefs: Password Minder Internals


In my last column I introduced Password Minder, the tool I use to manage all of my passwords. It generates a long, random password for each site I visit, and makes it possible for me to use the most complex passwords possible, without ever having to see the actual password material or type it in manually.

Keith Brown

MSDN Magazine October 2004

{ End Bracket }: Microsoft Java Virtual Machine Update


In a settlement agreement reached in January 2001 to resolve a dispute over the Microsoft distribution of its Java implementation, Sun Microsystems and Microsoft agreed to limit the duration of the time Microsoft would use Sun's source code and compatibility test suites to support the Microsoft® Java Virtual Machine (MSJVM).

Brian Keller

MSDN Magazine October 2004

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

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