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

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

Installing SharePoint 2010 with SQL Server 2008 - SQL Exception - Login Failed

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :SharePoint
Hello I've been trying to install SharePoint 2010 with SQL Server 2008 in my Windows Server 2008 R2 box. I've got the same error all the times. System Specifications Windows Server 2008 R2 SQL Server 2008 with SP1 SharePoint 2010 Enterprise 6GB RAM, 320GB HDD Installation Steps I followed Installed Windows Server 2008 R2 and joined it to our domain Logged in as domain administrator Installed SQL Server 2008 Selected the Local Service account for all the SQL Server 2008 services during installation Selected Mixed mode authentication Selected 'Add Current User' in all the other installation screens Installed SQL Server 2008 SP1 Installed SharePoint 2010 Selected Farm option Selected Complete Installation Tried to run the configuration wizard and got sqlexception error - login failed But i checked that the current user (domain admin) is having all the permissions. Also added the domain admin as Security Admin and DB Creator in SQL Server instance. Any ideas?  Regards NLV Visit SharePoint User group - India

View Complete Post

More Related Resource Links

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

Failed to change Farm Account in Sharepoint 2010 server, now Central Administration is not accessibl

Hello, I have a problem, that I no longer can access Central Administration Website, only the Sharepoint itself. I was running installation of Sharepoint 2010 Server with administrative account ImTheAdmin, who is a Domain Admin in the domain on one of the Windows 2008 R2 member servers. Besides that, I made ImTheAdmin the primary administrator of the Sharepoint. ImTheAdmin became the only user of this Sharepoint 2010 server after installation.  I installed everything on one box with default installation settings. I used builtin SQL server, not Standard or Enterprise. What then happened is: Using ImTheAdmin account, I opened Central Administration Website, and it said, that I need to change the Farm Account, for the account for Farm was the default one (I think it was network service). So I created a regular domain user MYDOMAIN\SharepointFarmAccount. The account name was too long to be as a Windows 2000 name, so it showed there without last 't', e.g. MYDOMAIN\SharepointFarmAccoun. I thought, Windows 2000 is long gone, so I didn't pay much attention, I think everywhere the account SID is important. I don't know if that is the real problem with my failure later, but it might be one of the reasons. I put MYDOMAIN\SharepointFarmAccount down in to the form of Central Administration Website, added the check mark, that it would react to password changes, and pre

Upgrading to SharePoint 2010 Foundation on SBS Server 2008

Hi all, I've just tried to install SharePoint Foundation on 2010 on Windows Small Business Server 2008 and whilst the literature I've found suggests that this is supported, I receive the following error: SharePoint 2010 Products cannot be installed in Stand-alone mode on a Domain Controller.  For more information on upgrading, see http://support.microsoft.com/?kbid=975805. What's funny about the KB ID, is that it doesn't exist.  The pre-requisites for SharePoint 2010 Foundation installed OK and the SharePoint installer has detected that it will perform an in-place upgrade.  the STSADM -o preupgradecheck output is below. Any idea's?  It would be really great if we could start using the shared workspace and ribbon features that are inherent with SPF2010. Jason.  

SharePoint 2010 AD FS 2.0 Integration - login works then fails, looping back to the adfs server

Hello, I setup SharePoint 2010 Claims auth with AD FS 2.0 following this post: http://blogs.technet.com/b/speschka/archive/2010/07/30/configuring-sharepoint-2010-and-adfs-v2-end-to-end.aspx.  I have no access to the ADFS server, but I think they followed the steps as outlined.  If I do an iisreset (or just recycle the app pool of the SharePoint site) I can login successfully using the remote credentials.  Also I can under security in SharePoint search for and find users and roles from the remote ADFS server. If I close my browser, open a new browser and go to the site I am prompted to login again (this is fine).  I do, using the same credentials, and the login fails because I am redirected between the SP and ADFS servers until the ADFS server stops the redirecting.  I have been doing some digging and I found this post: http://blogs.technet.com/b/speschka/archive/2010/08/09/setting-the-login-token-expiration-correctly-for-sharepoint-2010-saml-claims-users.aspx, which describes the situation I have in point # 3 at the bottom.  I have tried setting the token time out as low as 1 second but this hasn't helped. I have also, just to see, tried setting all the other lifetime settings to 1 second - but no luck.  Because the initial login works I think the setup is correct, but something is maintaining some state that is causing the loop

Can WEBDAV be disabled in Sharepoint 2010 on a Windows Server 2008 R2?

Hello, we had some issues with WEBDAV use with Sharepoint 2010 placed behind WEBSeal proxies. We decided to only use FPSE (front page server extensions) for an external access to this portal. I cannot find a way, how to disable WEBDAV, or how to force clients to only use FPSE with this portal. It is fair, to say, that we would like to make such configuration on a server side, rather then configure client computers. We are running Sharepoint 2010 on a Windows Server 2008R2 server (i.e. IIS 7.5) thank you in advance for help/ideas Roman Cernovsky

error when installing sharepoint server 2007 on Windows server 2008 r2

I ve tried to install sharepoint server 2007 on server 64 bit with windows server 2008 r2,but it gave me compatibilty error

Can I install SQL 2008 on a server running SQL 2005 to install Sharepoint 2010 Enterprise (Productio



Sharepoint 2010 Upgrade Question - A customer is currently running sharepoint 2007 on a 64bit windows 2003 OS with SQL 2005 sp2, they are looking to install/upgrade to Sharepoint 2010 and want to use the current SQL server,for the upgrade a new SharePoint 2010 environment will be built and for a short while they will have two instances of SharePoint running SP2007 and SP2010. The plan is to then manually migrate the data from SP2007 to SP2010 (ENT), the web and application servers will be newly built. From research I think they have three options

1) Upgrade the current SQL 2005(SP2) instance to SQL 2008 R2 standard.

2) Install a new instance of SQL 2008 R2 on the same server and have both SQL 2005 & SQL 2008 running on the same server (Is this an option? Will sharepoint happily run from a SQL server running two SQL instances, do I have to be careful regarding the installation and configuration, could I break the existing sharepoint farm doing this?)

3) Upgrade the current SQL server to SP3 and install a new instance of SQL 2005 SP3 and install SharePoint 2010 Enterprise here, again I have all the questions from point 2 above.

We are thinking of trying option 1, then 2, then 3, and obviously only moving to the next option if we come across a show stopper. H

SharePoint 2010 + SQL Server 2008 SP1 and R2


I have Sharepoint 2010 + Sql Server 20008 SP1 availabel on the server. I want to install Sql Server 2008 R2 also on the same server (side by side).

Will the installation effect the existing Sharepoint 2010 system? 

Which is a good option, have Sp1 and R2 side by side or upgrade to R2?

Error Installing SQL Server 2008 Express: '' is not a valid login or you do not have permission


I have tried installing SQL Server 2008 multiple times on my machine, and I always receive this error about 3/4 of the way through: '' is not a valid login or you do not have permission.

I have tried installing both SQL Server 2008 Express with Tools and SQL Server 2008 with Advanced Services, and they both fail the same way. I am trying to do a new stand-alone installation.

I'm running Windows XP Home Edition SP3.

Looking into the error, some forums say I have to install it from THE Administrator account, and not an account with administrator permissions; it also cannot be in Safe Mode, because then the Windows Installer won't work. Unfortunately, I haven't been able to login to the Administrator account. I can go to the home login screen, do ctrl+alt+del twice, and attempt to login to the Administrator account, but I receive this error: Unable to Log You on because of an Account Restriction.

Other forums say that in the Server Configuration section, all you have to do is provide the username and a strong password from an administrative account on the computer, and it doesn't have to be THE Administrator. Well, I did that, but for some reason it doesn't recognize my username and passw

Windows 7/Server 2008 R2 + Office 2010 cannot connect to SharePoint 2010


I have a Windows 7 x64 machine, with Office 2010 x86 installed.  I also have (2) Server 2008 and (2) 2008 R2 machines with Office 2010 x86 installed on them. On all of these machines I can not connect to SharePoint 2010 using Office.  The following occurs:

  • From the browser, browse to a doc lib. 
  • Click on an Office document, select "Edit in Microsoft ..."
  • An "Open Document" dialogue box appears, indicating that "Some files can harm your computer. If the file information below looks suspicious, or you do not fully trust the source, do not open the file.  File Name: Whatever.docx  From: SPServer2010.  (This is the first clue that something is not working properly.  I don't think this would appear otherwise)
  • Click OK.
  • The document opens, but with a [Read-Only] in the title bar. 
  • If I click save, it tries to save to a default location on my desktop computer.

Another example of the problem:

  • Open an Office 2010 application. 
  • Click File>Open
  • In the Open dialogue box, type in the URL of a document lib on the server. 
  • The error message: You can't open this location using this program. Please try a different location.

Final example of the problem:

  • Click Upload Multiple

SharePoint 2010 Foundation - Standalone - SQL Server Express 2008 R2 - Moving databases to another d


Setting up a new install who will be using SharePoint Foundation 2010 in Standalone mode. They do not have SQL SERVER 2008 so need to utilize the Standalone option and the latest version of SQL Server 2008 Express R2. They are just getting started with SharePoint and it is unknown how much the technology will be embraced to afford to purchase SQL Server at this point. I wanted to get that explanation out of the way before everyone tells me the best practice of installing in Farm mode only! I realize the best practice but sometimes we have to roll with the punches because getting a client to begin using SharePoint on their current budget is better than never getting the chance to use it at all.

So SharePoint Foundation 2010 is installed with the default SQL Server 2008 R2 Express instance. Is there a procedure for moving the databases to a new drive? What is the default instance name that is created? I'm having a hard time locating that information in the documentation. I've done this before with WSS 3.0 without issue but wondered if there were any documents on moving the newest databases and what the default instance name is. Thank you in advance.


SharePoint 2010 and Reporting Services 2008 R2 Integration Fail - Failed to establish connection wit


We have installed SQL Server 2008 R2 Standard Edition on a virtual server (C-SQL) and SharePoint Server 2010 on another virtual server (C-SPOINT), with the SQL Backend of the SharePoint database residing on C-SQL. This worked fine.

SQL Server was installed with the domain administrator account and SharePoint with an account called 'visi' that has domain administrator privileges.

SSRS on C-SQL was initially installed as a native database. I changed this to a SharePoint integrated database with all authentications done as the visi user. Report server url was set to the normal http://C-SQL:80/ReportServer/.

On the SharePoint central administration site under General Application Settings -> Reporting Services Integration I filled in the details as required:

  • Reporting services and Sharepoint Foundation 2010 + SQL Server 2008 R2 RTM - Express with Advanced S



    is possible use reporting services in Sharepoint Foundation 2010 if I have installed SQL Server 2008 R2 RTM - Express with Advanced Services? I tried various settings and configurations, but it not works (I am not able successfully configure Reporting Services Integration in Central Administration).

    Now I am not sure that is possible use reporting services in SPF 2010 + SQL Server 2008 R2 RTM - Express with Advanced Services...

    Thank you!

    Error installing SharePoint Server 2010 Prerequisites - Namely Windows Identity Foundation


    Good day to all

    i am trying to install Sharepoint server 2010 on my server, i have a windows server 2008 sbs sp2 pc. i have manually downloaded the Prerequisites and installed all except the windows identity foundation which just hangs. i have downloaded the file from the windows site namely: Windows6.0-KB974405-x64.msu, please can someone assist me in this matter i am at a lost.

    Installing SQL Server Express 2008: Powershell failed


    During the install of SQL Server Express 2008 I get an error "Powershell failed". I tried to find a Powershell download but only found a "Powershell snap in" and that won't install on XP Home SP3. I get a message it should be installed using "Programs and Services" or "Servers". I can't find these on XP Home (perhaps using a dutch windows version doesn't help). I just want to install SQL Express and I dont need Powershell.

    I tried the Windows Weblauncher but this doesnt work on XP Home.

    I have succesfully installed and used SQL server on XP Home, but after a crash and a new installation of Windows with all updates, including SP3, I can't get it working anymore,

    How can I (1) install SQL Server Express 2008 without this Powershell error by skipping the powershell check or (2) how can I install PowerShell first on my XP Home computer to run a succesful installation afterwards.

    Unhandled exception when installing SQL Server 2008 R2

    I tried to download SQL Server 2008 R2 Express it ran for about 30 minutes and then gave a Net Framework error stating that "an Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue....." Once I clicked Continue and it did continue to run and then brought up an info screen with no semblance of the download having worked. I had successfully installed SQL Server 2005 Express previously. I uninstalled it along with the Studio Manager. Do I need to uninstall .NET Framework 3.5 SP1 and  .NET Framework 4 Client Profile which are still currently installed before I can install 2008? 

    Lists and Libraries are not populated in Sharepoint 2010 Designer in server 2008



    We have installed SharePoint Foundation 2010 in Windows server 2008 R2 machine. Also having SharePoint Designer 2010 in the same machine. While opening any sites in the Designer, it does not populating the lists and libraries in the same site.

    Is there need to apply any fix for Windows server 2008 to solve this?If then which fix..

    Thanks in Advance,


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