Connecting new Content DB

Wed, 14 Apr 2010 17:11:56 -0700 

Hey Guys,

 

I've moved our SharePoint to another database and trying to connect it
but getting "error". I've got the following log data in relation and it
looks like a SQL access issue, I'm struggling to get it to work so
hoping for a hand!

 

Server setup:

 

HGHVMOSS

-          Moss 2007

-          SQL 2005 Express

 

Have moved the content DB to our SQL server

 

HGVMDB1

 

Do I need to setup some new accounts etc somewhere for the HGHVMOSS to
access the DB moved to HGVMDB1?

 

Cheers,

 

Ken Thompson

IT Support - Systems Administrator

HomeGround Services

68 Oxford Street, Collingwood, VIC 3066

Tel: 03 9288 9668 (Ex 668)

Mob: 0404 852 325

Fax: 03 9419 1876 

www.homeground.org.au <http://www.homeground.org.au> 

 

 


ÿþ04/15/2010 09:58:59.50         w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Topology                         8xqz       
Medium         Updating SPPersistedObject 
SPDatabaseServiceInstance 
Parent=SPServer Name=HGVMDB1. Version: 
-1 Ensure: 1, HashCode: 48144484, Id: 
6fa5d287-c122-437e-82cb-f099ed2fd2f0, 
Stack:    at 
Microsoft.SharePoint.Administration.SPPersistedObject.Update()
     at 
Microsoft.SharePoint.Administration.SPServiceInstance.Update()
     at 
Microsoft.SharePoint.Administration.SPPersistedObject.Update(Boolean
 ensure)     at 
Microsoft.SharePoint.Administration.SPPersistedChildCollection`1.Add(T
 newObj, Boolean ensure)     at 
Microsoft.SharePoint.Administration.SPPersistedChildCollection`1.Ensure(T
 newObj)     at 
Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(Guid
 newDatabaseId, String 
strDatabaseServer, String 
strDatabaseName, String 
strDatabaseUsername, String 
strDatabasePassword, Int32 warn...  

04/15/2010 09:58:59.50* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Topology                         8xqz       
Medium         ...ingSiteCount, Int32 
maximumSiteCount, Int32 status, Boolean 
provision, Boolean allowUpgrade, 
Boolean flushChangeLog)     at 
Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(String
 strDatabaseServer, String 
strDatabaseName, String 
strDatabaseUsername, String 
strDatabasePassword, Int32 
warningSiteCount, Int32 
maximumSiteCount, Int32 status, Boolean 
provision, Boolean allowUpgrade)     at 
Microsoft.SharePoint.ApplicationPages.NewContentDBPage.BtnSubmit_Click(Object
 sender, EventArgs e)     at 
System.Web.UI.WebControls.Button.OnClick(EventArgs
 e)     at 
System.Web.UI.WebControls.Button.RaisePostBackEvent(String
 eventArgument)     at 
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
 sourceControl, String eventArgument)   
  at 
System.Web.UI.Page.ProcessRequestMain(Bo...
    

04/15/2010 09:58:59.50* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Topology                         8xqz       
Medium         ...olean 
includeStagesBeforeAsyncPoint, Boolean 
includeStagesAfterAsyncPoint)     at 
System.Web.UI.Page.ProcessRequest(Boolean
 includeStagesBeforeAsyncPoint, Boolean 
includeStagesAfterAsyncPoint)     at 
System.Web.UI.Page.ProcessRequest()     
at 
System.Web.UI.Page.ProcessRequest(HttpContext
 context)     at 
ASP._admin_newcntdb_aspx.ProcessRequest(HttpContext
 context)     at 
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
     at 
System.Web.HttpApplication.ExecuteStep(IExecutionStep
 step, Boolean& completedSynchronously) 
    at 
System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception
 error)     at 
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
 context, AsyncCallback cb, Object 
extraDat...    

04/15/2010 09:58:59.50* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Topology                         8xqz       
Medium         ...a)     at 
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest
 wr)     at 
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest
 wr)     at 
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr
 ecb, Int32 iWRType)      

04/15/2010 09:58:59.50  w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Topology                         8xqz       
Medium         Updating SPPersistedObject 
SPServer Name=hgvmdb1 Parent=SPFarm 
Name=SharePoint_Config_9f82ff78-2e97-4689-ad9b-1460d884c017.
 Version: -1 Ensure: 1, HashCode: 
45367897, Id: 
5d581d99-f005-432b-bc72-ceb588180213, 
Stack:    at 
Microsoft.SharePoint.Administration.SPPersistedObject.Update()
     at 
Microsoft.SharePoint.Administration.SPServer.Update()
     at 
Microsoft.SharePoint.Administration.SPPersistedObject.Update(Boolean
 ensure)     at 
Microsoft.SharePoint.Administration.SPPersistedChildCollection`1.Add(T
 newObj, Boolean ensure)     at 
Microsoft.SharePoint.Administration.SPPersistedChildCollection`1.Ensure(T
 newObj)     at 
Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(Guid
 newDatabaseId, String 
strDatabaseServer, String 
strDatabaseName, String 
strDatabaseUsername, String...  

04/15/2010 09:58:59.50* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Topology                         8xqz       
Medium         ... strDatabasePassword, 
Int32 warningSiteCount, Int32 
maximumSiteCount, Int32 status, Boolean 
provision, Boolean allowUpgrade, 
Boolean flushChangeLog)     at 
Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(String
 strDatabaseServer, String 
strDatabaseName, String 
strDatabaseUsername, String 
strDatabasePassword, Int32 
warningSiteCount, Int32 
maximumSiteCount, Int32 status, Boolean 
provision, Boolean allowUpgrade)     at 
Microsoft.SharePoint.ApplicationPages.NewContentDBPage.BtnSubmit_Click(Object
 sender, EventArgs e)     at 
System.Web.UI.WebControls.Button.OnClick(EventArgs
 e)     at 
System.Web.UI.WebControls.Button.RaisePostBackEvent(String
 eventArgument)     at 
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
 sourceControl, String eventArgument)   
  at System.W...    

04/15/2010 09:58:59.50* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Topology                         8xqz       
Medium         
...eb.UI.Page.ProcessRequestMain(Boolean
 includeStagesBeforeAsyncPoint, Boolean 
includeStagesAfterAsyncPoint)     at 
System.Web.UI.Page.ProcessRequest(Boolean
 includeStagesBeforeAsyncPoint, Boolean 
includeStagesAfterAsyncPoint)     at 
System.Web.UI.Page.ProcessRequest()     
at 
System.Web.UI.Page.ProcessRequest(HttpContext
 context)     at 
ASP._admin_newcntdb_aspx.ProcessRequest(HttpContext
 context)     at 
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
     at 
System.Web.HttpApplication.ExecuteStep(IExecutionStep
 step, Boolean& completedSynchronously) 
    at 
System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception
 error)     at 
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
 context, A...    

04/15/2010 09:58:59.50* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Topology                         8xqz       
Medium         ...syncCallback cb, Object 
extraData)     at 
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest
 wr)     at 
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest
 wr)     at 
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr
 ecb, Int32 iWRType)      

04/15/2010 09:58:59.53  w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Database                         880i       
High           
System.Data.SqlClient.SqlException: 
Login failed for user 
'HOMEGROUND\HGHVMOSS$'.     at 
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
 exception, Boolean breakConnection)    
 at 
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
 stateObj)     at 
System.Data.SqlClient.TdsParser.Run(RunBehavior
 runBehavior, SqlCommand cmdHandler, 
SqlDataReader dataStream, 
BulkCopySimpleResultSet 
bulkCopyHandler, TdsParserStateObject 
stateObj)     at 
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
 enlistOK)     at 
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
 serverInfo, String newPassword, 
Boolean ignoreSniOpenTimeout, Int64 
timerExpire, SqlConnection 
owningObject)     at 
System.Data.SqlClient.SqlInternalConnection...
  

04/15/2010 09:58:59.53* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Database                         880i       
High           
...Tds.LoginNoFailover(String host, 
String newPassword, Boolean 
redirectedUserInstance, SqlConnection 
owningObject, SqlConnectionString 
connectionOptions, Int64 timerStart)    
 at 
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
 owningObject, SqlConnectionString 
connectionOptions, String newPassword, 
Boolean redirectedUserInstance)     at 
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
 identity, SqlConnectionString 
connectionOptions, Object providerInfo, 
String newPassword, SqlConnection 
owningObject, Boolean 
redirectedUserInstance)     at 
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
 options, Object poolGroupProviderInfo, 
DbConnectionPool pool, DbConnection 
owningConnection)     at 
System.Data.Provide...    

04/15/2010 09:58:59.53* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Database                         880i       
High           
...rBase.DbConnectionFactory.CreatePooledConnection(DbConnection
 owningConnection, DbConnectionPool 
pool, DbConnectionOptions options)     
at 
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
 owningObject)     at 
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
 owningObject)     at 
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
 owningObject)     at 
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
 owningConnection)     at 
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
 outerConnection, DbConnectionFactory 
connectionFactory)     at 
System.Data.SqlClient.SqlConnection.Open()
     at 
Microsoft.SharePoint.Utilities.SqlSession.OpenConnection()
  

04/15/2010 09:58:59.53  w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Database                         880j       
High           SqlError: 'Login failed for 
user 'HOMEGROUND\HGHVMOSS$'.'    
Source: '.Net SqlClient Data Provider' 
Number: 18456 State: 1 Class: 14 
Procedure: '' LineNumber: 65536 Server: 
'HGVMDB1'    

04/15/2010 09:58:59.53  w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Database                         6y64       
Critical       SQL database login failed. 
Additional error information from SQL 
Server is included below.  Login failed 
for user 'HOMEGROUND\HGHVMOSS$'.      

04/15/2010 09:58:59.53  w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Database                         880k       
High              at 
Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand
 command)     at 
Microsoft.SharePoint.Administration.SPDatabase.GetExists(SqlConnectionStringBuilder
 connectionString)     at 
Microsoft.SharePoint.Administration.SPDatabase.get_Exists()
     at 
Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(SPContentDatabase
 database, Boolean provision, Boolean 
allowUpgrade, Boolean flushChangeLog)   
  at 
Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(Guid
 newDatabaseId, String 
strDatabaseServer, String 
strDatabaseName, String 
strDatabaseUsername, String 
strDatabasePassword, Int32 
warningSiteCount, Int32 
maximumSiteCount, Int32 status, Boolean 
provision, Boolean allowUpgrade, 
Boolean flushChangeLog)     at 
Microsoft.SharePoint.Administration.S...
  

04/15/2010 09:58:59.53* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Database                         880k       
High           
...PContentDatabaseCollection.Add(String
 strDatabaseServer, String 
strDatabaseName, String 
strDatabaseUsername, String 
strDatabasePassword, Int32 
warningSiteCount, Int32 
maximumSiteCount, Int32 status, Boolean 
provision, Boolean allowUpgrade)     at 
Microsoft.SharePoint.ApplicationPages.NewContentDBPage.BtnSubmit_Click(Object
 sender, EventArgs e)     at 
System.Web.UI.WebControls.Button.OnClick(EventArgs
 e)     at 
System.Web.UI.WebControls.Button.RaisePostBackEvent(String
 eventArgument)     at 
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
 sourceControl, String eventArgument)   
  at 
System.Web.UI.Page.ProcessRequestMain(Boolean
 includeStagesBeforeAsyncPoint, Boolean 
includeStagesAfterAsyncPoint)     at 
System.Web.UI.Page.ProcessRequest(Boolean
 includeStagesBeforeAsyncPoint, 
Boolea...    

04/15/2010 09:58:59.53* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Database                         880k       
High           ...n 
includeStagesAfterAsyncPoint)     at 
System.Web.UI.Page.ProcessRequest()     
at 
System.Web.UI.Page.ProcessRequest(HttpContext
 context)     at 
ASP._admin_newcntdb_aspx.ProcessRequest(HttpContext
 context)     at 
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
     at 
System.Web.HttpApplication.ExecuteStep(IExecutionStep
 step, Boolean& completedSynchronously) 
    at 
System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception
 error)     at 
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
 context, AsyncCallback cb, Object 
extraData)     at 
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest
 wr)     at 
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest
 wr)     at S...    

04/15/2010 09:58:59.53* w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Database                         880k       
High           
...ystem.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr
 ecb, Int32 iWRType)        

04/15/2010 09:58:59.53  w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Database                         880l       
High           ConnectionString: 'Data 
Source=HGVMDB1;Initial 
Catalog=master;Integrated 
Security=True;Enlist=False;Connect 
Timeout=15'    ConnectionState: Closed 
ConnectionTimeout: 15        

04/15/2010 09:58:59.53  w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
Topology                         8dyx       
High           Deleting the 
SPPersistedObject, SPContentDatabase 
Name=WSS_Content 
Parent=SPDatabaseServiceInstance.        

04/15/2010 09:58:59.56  w3wp.exe 
(0x1388)                              
0x1278   Windows SharePoint Services      
General                          8dzz       
High           Exception Type: 
System.Data.SqlClient.SqlException  
Exception Message: Login failed for 
user 'HOMEGROUND\HGHVMOSS$'.       


_______________________________________________
ozmoss mailing list
[email protected]
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

Reply via email to