Re: Moving MSDE SQL Server with OSQL

First, you need to know the new SQL Server (on your Smaill Business
Server2003) has mixed security mode enabled (Only Windows security is
enabled by default installation). If not, you would obviously cannot use
"sa" ( and cannot use any username/password pair in that matter).

To use OSQL.exe tool, you do not have to use "sa" though, you can use -E
swicth with osql.exe to log into SQL Server with trusted connection (Windows
Authentication). Of course you need to log onto your computer as local
admin.

"Mark Grantom" <mgrantom@xxxxxxxxxx[no spam]> wrote in message
news:D218EA2E-9D0B-4372-8E22-A58E8FBA1F96@xxxxxxxxxxxxxxxx
I am a complete neophyt to SQL. I am attempting to restore a backup from a
MSDE 2000 SQL server from a peer to peer server to a server running Small
Business Server 2003 using OSQL. (In other words I'm moving the database
to
a dedicated server.) I performed a RESTORE DATABASE xxx FROM DISK=
'PATHNAME' WITH REPLACE
OSQL responded with "RESTORE DATABASE successfully processed xxx pages"
Now
I need to run some stored procedures to fix the orphaned user issue, but
when
I attempt to login to the database with user "sa" no matter what password
I
use I can't get in. (I'm not sure there is a user "sa" in the restored
database). From what I've read, I believe a may need to run the
sp_changedbowner command, but I'm not sure what login I need to change to.
Also, I DID NOT move any "system files" ie master.mdf or model.mdf files.
Do
these have to be moved as well? Any suggestions would be greatly
appreciated. Thanks in advance.

--
Mark G


.

Relevant Pages
Loading