Solved

Login failed for user 'sa' for SharedServices1 in Sharepoint 2007

Posted on 2010-11-25
6
617 Views
Last Modified: 2012-05-10
When im try edit SharedServices1, error is Login failed for user 'sa'. Yes password for sa was changed.
Can i change database auth throw command line?
stsadm.exe -o editssp -title SharedServices1 no help.
0
Comment
Question by:Aleksey_S
  • 2
  • 2
6 Comments
 
LVL 8

Expert Comment

by:TheMak
Comment Utility
1) Is this an attempt at creating a new farm or at re-running the SPTW on a farm that already exists?  I assume you are creating a new farm.2) What account were you logged in as when you ran the SPTW?  Did this account have securityadmin and dbcreator rights in the SQL instance that you're using for SharePoint?3) Is Windows Firewall turned on for your SQL Server and/or for your SharePoint server?


http://www.go4answers.com/Example/sharedservices1-default-49069.aspx
0
 

Author Comment

by:Aleksey_S
Comment Utility
1) farm already exists, problem run after detach and attach databases (and change sa password)
2) account domain\ssp is db owner SharedServices1 database
3)accout domain\spadmin is farm admin, im try get domain\spadmin dbowner on all bases, change SharedServices1 to domain\spadmin and still nothing.
Problem with SharedServices1 runnung with old sa password and can't change type auth for it.
0
 
LVL 8

Expert Comment

by:TheMak
Comment Utility
It sounds like a permissions issue. Can you check a number of things.

1. The application pool accounts will need to have dbo rights on the databases associated with the web applications.
2. If you are administrating the SSP you should be ogged on with an account that has full control on the SSP web application
3. SharedServices1_DB is the database containing the services configurations, your SSP app pool account will need dbo rights on this database at a minimum.

Come back with more info after checking these items.
--------------------------------------------------------------------------------
http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/b2e89723-067a-4177-86b5-16a28e208f61

OR

It looks like you've set up your connection to use your Windows account to connect to the database rather than supplying a user name and password.  When you're connecting through Visual Web Developer at design-time, you're connecting to the database as yourself.  I'm guessing that you're an administrator on the machine and for the database and you connect successfully.  The actual application will run under the ASP.NET account.  If you have not granted that account permission to the database, the connection attempt will fail with the message you described.

Here's a quick breakdown of some options:

1.)  Use a user name and password in the connection string
2.)  Have the application run under a different account that has permission to access the database
3.)  Grant permission to the ASP.NET account
4.)  Consider having ASP.NET impersonate the current user

I hope this information proves helpful.

http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/26fd5295-e9e2-44e7-9a3d-6af69da77093/
0
 

Accepted Solution

by:
Aleksey_S earned 0 total points
Comment Utility
in registry im find old sa password, so preblem resolved.

[HKEY_LOCAL_MACHINE\Software\Microsoft\Office Server\12.0\Search\Applications\GUID\ResourceManager]
"Data"="Server=server;Database=SharedServices1_Search_DB;Uid=sa;Pwd=*******;App=Windows SharePoint Services;Timeout=15"
0
 
LVL 12

Expert Comment

by:Hairbrush
Comment Utility
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now