sql server new users: Often, the quality of the responses received is related to our ability to
'bounce' ideas off of each other. In the future, to make it easier for us to
give you ideas, and to prevent folks from wasting time on already answered
questions, please:

Don't post to multiple newsgroups. Choose the one that best fits your
question and post there. Only post to another newsgroup if you get no answer
in a day or two (or if you accidentally posted to the wrong newsgroup -and
you indicate that you've already posted elsewhere).

If you really think that a question belongs into more than one newsgroup,
then use your newsreader's capability of multi-posting, i.e., posting one
occurrence of a message into several newsgroups at once. If you multi-post
appropriately, answers 'should' appear in all the newsgroups. Folks
responding in different newsgroups will see responses from each other, even
if the responses were posted in a different newsgroup.


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

I got sbs 2003 server with sql 2000, and using backup data function to move
the database to another 2k server w/sql2k, after I restore on the 2k server,
I from workstation try to login by using that data, but there is no account
appear on the screen.

What is wrong with it or I did something wrong in SQL setting??

Thanks!

Danny

What do you mean by no account appear on the screen? How are you trying to
log onto SQL Server? Through Query Analyzer (ISQLW.exe) or Enterprise
Manager. Did you register the SQL Server in Enterprise Manager (right click
on the SQL Server icon in Enterprise Manager and select register SQL
Server).

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Hi,

Masater database stores all the login information and looks like you have
not restored the Master database.
Now you could use the below URL to script and move logins from old SQL
server and execute the script in new server.

http://www.databasejournal.com/features/mssql/article.php/2228611

Thanks
Hari


[quoted text, click to view]