• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 664
  • Last Modified:

WSS 3.0 create new configuration database on new SQL server

Experts,

I recently migrated my content database from the WSS 3.0 default SQL Express \ windows internal database to a new SQL 2008 server database.

The server I migrated from still has the configuration database on there and is dying fast. can someone give me the steps to create a new configuration database on my new SQL server?

Thanks in advance!
0
Raymo12
Asked:
Raymo12
  • 5
  • 4
1 Solution
 
chapmanjwCommented:
0
 
Raymo12Author Commented:
Thanks chapmanjw for your fast response. Will it matter that my destination SQL server is 2008 and my content DB is the windows internal database version?
0
 
chapmanjwCommented:
You should be able to backup and restore that to SQL 2008.  Windows Internal Database is simply a watered down version of SQL 2005.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
chapmanjwCommented:
Of course back things up before in case ;)
0
 
chapmanjwCommented:
Note (according to Wikipedia, http://en.wikipedia.org/wiki/Windows_Internal_Database) you can connect with SMSS locally by using \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query as the server to connect to.
0
 
Raymo12Author Commented:
Unfortunately I can't test in another environment so with these commands to be run from my sharepoint server i had a question.

stsadm -o deleteconfigdb

stsadm –o setconfigdb -connect –databaseserver target_SQL_server -databasename databasename -farmuser your_farm_sql_account -farmpassword your_farm_sql_password

The farm SQL account and farm sql password are for the accounts on the new SQL server correct?
0
 
Raymo12Author Commented:
the deleteconfig db command worked but the setconfigdb is giving a syntax error
0
 
Raymo12Author Commented:
HELP!   :-)
0
 
Raymo12Author Commented:
My front end box that also had the windows internal database died! I have the content and search databases over on my new sql box but i need to install the front end again

Total bummer!  Thanks for your help though
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now