View Complete Post
If IP address of the backend database server will be changed for sharepoint 2007 and project server 2007, will it impact any way both the servers.
We have SharePoint and SQL server in a extranet domain. We would like move the SQL server databases for SharePoint to our corporate SQL server (on the corporate domain).
The Corporate domain does not trust the extranet domain, and thus the web farm account cannnot be specified on the corportare SQL instance. If it possible to migrate the databases to a non tusted domain?
I've seen the script to create a new Config database using SQL authentication
psconfig -cmd configdb -create -server <SQL server name> -database <database name> -dbuser <SQL account> -dbpassword <SQL password> -user <AD user account> -password <AD user password>
Can I edit the config of SharePoint to point to the new SQL server, or do I need to create the entire sharepoint enviromnent again and attach the content databases?
I also have a SSP database that's heavily customised for searcvhing and the BDC. Will this need recreating again or can I move the BDC database to the new server and attach?
I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.
Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.
Can some one have idea on this. Please help me to get it done
Thanks in Advance.
SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.
SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10
to 15 min.
when ever these errors occur in eventvwr sharepoint will not work.
Please suggest on this issue.
waiting for MS replies..
I have a three server environment – T1 – a domain controller and T2 and T3 for SharePoint and SQL Server 08 and respectively, where each is a virtual machine.
These servers are on a domain separate from our company domain.
While installing sharepoint on t2, I get the following error at the step that creates a config database (on T3 SQL Server)
Failed to create the configuration database.
An exception of type System.SystemExcep
We are migrating our SharePoint databases to a new database server. This new database server will have a new name for SharePoint to reference. How do I go about pointing SharePoint 2007 from the old database server name to the
It seems like there should be a simple solution, but I have yet to find a solid procedure.
I'm done with the installation of our new SharePoint Server 2007 but i was not able to find its config database. Can you please help me locate it? We are running SQL Server 2005.
I have Sharepoint 2007 and SQL server 2008 Running on two separate machines. What i want to do is to Remove SharePoint server and shift all the data to SQL server machine (yes i want to run SharePoint From Database server to remove the actual sharepoint
what i think is
1. I can install fresh SharePoint to Database server and can give the Existing database when configuring (As SharePoint database is already on Database server)
2. I can take a backup of sharepoint, install fresh sharepoint on database server and use the new database for sharepoint configuration and then Move things like, site definitions and collections to new server by using the restore.
3. OR I can just fresh install sharepoint, Take a backup of the databases of the sites i need, create new sites in newly installed sharepoint server, connect the provisos database with new created sites.
There are some ways i can think of, But i dont want any pain. Any thing you guys can suggust will be good.
I created few users from "Computer Management" --> "Local Users and Groups" --> "Users" --> "New User" as my login user in SharePoint 2007
Then I having a custom page where store the data into SQL Server Database.
below is how my connectionstring look like:
<add name="XXConnectionString" connectonString="Data Source=XXX;Initial Catalog=YYY;Integrated Security=True" providerName="System.Data.SqlClient"/>
however I hit error when browse to the custom page by the users.
Cannot open database "XXX" requested by the login. The login failed.
Login failed for user 'xx\user1'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
I have to create Test Server (Single server with Database on Same Server).
What Kind of Backup should i be asking to Hosting Company,SharePoint MOSS 2007 SP1 Extra net site Hosted by 3rd Party.
How to restore it to Test Server and Has any one documented this process and has anyone had sucess in doing similar work ?
I do not have any access to Production server.How to make sure i have same server setup & configuration as Production Server.
I have to customize this site and do some development work so i thought this would be best approach ?
Please let me know..thanks..
Technologies - SQL Server 2008 R2, MOSS2007, and Office 2007
I have a set of SharePoint lists which I would like to expose to a variety of reporting technologies (SSAS, SSRS, etc).
I am constrained with out of the box functionality, so custom solutions or third party options is not a luxury I have. SO, I am thinking of...
Data entered into a sharepoint list
Using MS Access "link to data source by creating a linked table" option in Access to my Sharepoint lists
Then creating a linked server in SQL Server to the Access database.
Is this at all possible?