Database woes

[Nigel Hertz]

Hi guys,

I'm hoping someone here might have an idea / solution to the below.

On Monday, I went through the process of detaching and deleting a bunch of 
databases from our MOSS environment (these databases were duplicated and then 
we used the db attach method to upgrade them to SPS2010 last year)

Today, tech services brought to my attention a bunch of errors in the event log 
(I have no idea when they started, but the oldest records are from 4am 
yesterday - the events registered were coming through at around 4 per second, 
so my guess is the event log dropped older items)

Anyway, the specific errors are as follows:

Login failed for user DOMAIN\Acc1. Reason: Failed to open the explicitly 
specified database. [CLIENT: ]  (This is the DB server)
Login failed for user DOMAIN\Acc2. Reason: Failed to open the explicitly 
specified database. [CLIENT: 10.9.30.20]  (This is our IDX/CA server)

I've gone through this and related 
posts and set up SQL 
Profiler to capture some info.

In all cases, the database mentioned as being unavailable is 'master' (see 
screenshot from SQL Profiler below). The ClientProcessID on the DB box 
correlates to the PID for SQLAGENT.EXE (I haven't checked the other box yet)

So far, I've changed the default databases for both accounts to a different 
database, given both accounts 'public' and 'db_datareader' to the master 
database, mapped them etc. all to no avail - the errors are still coming 
through constantly.

I'm unsure if detaching the old databases could have caused this, and I'm 
stumped as to how to fix it.

Nigel


[cid:image001.png@01CD8B6B.05D74D10]



Nigel Hertz
SharePoint Administrator / Developer, Information Systems
Stockland, Level 22, 133 Castlereagh Street, Sydney NSW 2000

T +61 2 9035 2617  M +61 401 034 605
F +61 2 8988 2617  E   
nigel.he...@stockland.com.au
http://www.stockland.com.au/

BEFORE PRINTING THIS EMAIL PLEASE CONSIDER THE ENVIRONMENT



Stockland Notice: If this communication has been sent to you by mistake, please 
delete and notify us. If it has been sent to you by mistake, legal privilege is 
not waived or lost and you are not entitled to use it in any way. Stockland and 
its subsidiaries reserve the right to monitor e-mail communication through its 
networks.
<>___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

Windows Server 2012 does not support SharePoint Server 2010

[Wes MacDonald]

Hi,

Just in case anyone is curious, Microsoft has a KB article.

http://support.microsoft.com/kb/2724471

Wes
___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

Editable form with mixed content sources

[Web Admin]

Hi all,

I have a FBA web app that uses a separate DB to store user info (id, name,
password, email) for self-registration.

This is in turn tied to a Users list in SharePoint that stores additional
info based on user activity within the site.

I would like to create an editable Profile page that combines fields from
both the FBA DB and the SharePoint list.

The only way I can think to achieve this is to create a custom page with
two datasources? Can anyone recommend what the best approach might be in
2010? Should I be using the BCS and an external content type instead?

-- 
Regards,

Paul Noone

SharePoint Farm Admin/Developer
Infrastructure Team
CEO Sydney

p: (02) 9568 8461
f: (02) 9568 8483
e: paul.no...@syd.catholic.edu.au
w: http://www.ceosyd.catholic.edu.au/
___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss