How to create a local SQL Server

[Peter Larsson]

Hi!

I'm running SQL Server 7.0 and currently have a registrered server at my web
host. I wish, however, to create a local server on my computer so that I can
replicate the remote server to my local and access all data locally. I have
tried to register a new server through Enterprise Manager, but I have a
feeling that I'm not doing it right (or if I'm even at the right place). I
do have one local server to select when I try to register a new one, and it
has the name "9R7860J", which happens to be my Dell Service Tag Number.
However, I am not able to connect to this server since I have no clue what
username and password to use.

Does anyone have any suggestions to how I can solve this, or where I can I
look for help? I would highly appreciate it.

Thank you in advance!

Peter Larsson

[Jude Robert]

Try user 'sa' and leave the password blank.

"Peter Larsson" <pig...@hotmail.com> wrote in message
news:ccTt8.6723$cq.44...@news01.chello.se...

[Alexander Chigrik]

Try to specify as 'Server' name:

- computer name
- IP address
- . (dot character)
- (local) (word local in brackets)

If you have problems with SQL Server installation, check these links:
"SQL Server 7.0: Installation problems"
http://www.MSSQLCity.com/Articles/Adm/SQL70InstProbl.htm

"I'm having trouble installing SQL Server."
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14039

With best regards,
Alexander Chigrik
http://www.MSSQLCity.com/ - all about MS SQL
(SQL Server Articles, FAQ, Scripts, Tips and Test Exams).

"Peter Larsson" <pig...@hotmail.com> сообщил/сообщила в новостях следующее:
news:ccTt8.6723$cq.44...@news01.chello.se...

[Mark Broadbent]

further to the other two replies, to be able to register a sql server, sql
server or MSDE must be running on that machine (the name you are trying to
register).

Note that by default the sa account is set to blank ie '' by default
although this can and should be changed -sql2000 persuades you to give a
password.

Alternatively a nt user account/group can be registered within the sql
server to have system admin access -you could also connect with this.

Your problem is that either the machine you are trying to register has
either not got an instance of sql running OR the username and password you
are trying to connect via doesnot have system admin privelages to the sql
server

best regards,
Mark Broadbent. mcse+i

"Peter Larsson" <pig...@hotmail.com> wrote in message
news:ccTt8.6723$cq.44...@news01.chello.se...