Re: Moving Database to new SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

just a note: the SMS database is not supported on a clustered SQL server!

Torsten
Microsoft MVP - SMS

Am Tue, 24 Oct 2006 20:42:57 +0200 schrieb Kim Oppalfens <MVP>:

Correct, let an account be local admin.
Depending on your security mode, the site server computer account or the sms
service account.

--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System SMS - MVP


"Gareth" <Gareth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:27FED97E-BA48-44B9-BBAF-A3CF367B0AFA@xxxxxxxxxxxxxxxx
Hi

I am moving my SMS database to a new SQL server, i am leaving the software
installed on the current server, just looking to move the database in to
our
new Clustered Environment. I have found an article on moving the database
and have followed it as per all the steps. The article is

http://www.microsoft.com/technet/prodtechnol/sms/sms2003/opsguide/ops_2rvx.mspx?mfr=true

When i get to the final step of the SMS Setup Wizard, i get the error
message

"The Windows server <SQLSERVER> that is running the SQL Server is down or
not on the network, or your current Windows logon ID does not allow you to
access the Windows server."

I am assuming that i have to allow an account to log on as a service /
something like this. Or let an account be a local admin?

Any help would be appriciated in this

Cheers

Gareth Collins


.

Relevant Pages

  • Re: MP Control Manager detected MP is not responding to HTTP requests
    ... IIS lockdown isn't needed for Windows server 2003. ... Did you get an error status message in the SMS admin console for MP control ... The SQL server site system is turned off, ...
    (microsoft.public.sms.setup)
  • Does anyone know how to fix this??
    ... Basically sms secondary site reports me 3 kind of error.... ... This site's SMS Service account or the site server's machine ... http error is Internal Server Error. ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)
  • Re: Move SMS Database to new SQL Server
    ... Because you aren't just backing up the database, you're doing a full SMS ... later and move database from a remote server back to the SMS site server.) ... >>> I have SMS running right now on its own SQL server. ...
    (microsoft.public.sms.setup)
  • Problems installing Security Scan and Office Scan
    ... I have been to the MS Managing SMS 2003 class. ... I have installed SMS 2003 on a Win2003 server and placed the database on one ... installed the SMS Provider on the SQL server. ... I initially had some problem getting the reports to install. ...
    (microsoft.public.sms.tools)
  • Re: User Creation problem in AD
    ... its being used as Pre-production purpose to implement SMS ... # Jorge de Almeida Pinto # MVP Windows Server - Directory Services ... BLOG --> http://blogs.dirteam.com/blogs/jorge/default.aspx ...
    (microsoft.public.windows.server.active_directory)