unable to connect to database after moving db to a sql server

J

Juergen Striegel

I installed the embedded tools including msde on my local computer.
Everything worked fine.
When getting a new computer I want to move the database to a sql server
so others can use it too.
I managed to get the database work on a sql2000 server after moving the
tyo database files. But I cannot connect via td or the Component
database manager.
My idea was that the msde workes with an empty password for sa. Thia
isn't a good idea and our sql2000 server of course has a set password. I
belief that the embedded tools need to be told that they should use a
password but I cannot find any information of how to get my password
into that tools.

- Who has done a move the same way as I did?
- Where can I find any information about how to set up a working
environment when moving to a sql2000 server?
- What kinds of authentification do the tools use (windows / db
authentification)
- What are the usernames and passwords that the tools use when
connecting to a db and where can I change them?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top