Community
Command Central
MVP Program
Monthly Mission
Blogs
Groups
Events
Media Vault
Products
Observability
Network Management
Application Management
IT Security
IT Service Management
System Management
Database Management
Content Exchange
SolarWinds Platform
Server & Application Monitor
Database Performance Analyzer
Server Configuration Monitor
Network Performance Monitor
Network Configuration Manager
SQL Sentry
Web Help Desk
Free Tools & Trials
Store
Home
Products
Network Performance Monitor (NPM)
Orion v7.8 and Sql 2005
NEroNErd
Trying to move the DB from 2000 to 2005...
SQL 2005 imports the DB fine... But the config can not login to it.. It keeps telling me to use SMO
Any ideas?
Find more posts tagged with
Accepted answers
All comments
FormerMember
Are you trying to log into the database via the web interface, Solarwinds Database Manager, or through the Microsoft SQL Management Studio.
Is this a parallel migration or in place migration of MSSQL?
aLTeReGo
If you are trying to move the database from one server to another, the proper way would be to backup the database on your SQL 2000 server and then copy the .BAK file to your SQL2005 server and perform a restore. Works like a charm every time.
FormerMember
There is some informative documentation concerning database migrations here.
www.solarwinds.net/.../faq.aspx
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of
