Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How I can connect to Microsoft SQL Server 2000 Desktop Engine

  Asked By: Lavanya    Date: Aug 26    Category: Sharepoint    Views: 1539

I have to SQL Client Tools installated in my pc and i need to connect
to the MSDE 2000 that install SPS2 in other machine.
I can't connect because i don't know log/pass to connect to database.
I need install the SQL client in my SPS2 machine?



3 Answers Found

Answer #1    Answered By: Lora Wall     Answered On: Aug 26

You should be able to connect  from your client using Sql client tools to the
MSDE 2000 on another machine. You will need an account on the database and the
password for that account.

Answer #2    Answered By: Mahendra Parte     Answered On: Aug 26

the problem is that i don't know the usu/pass to conect MSDE of
Sarepoint V2. I try with usu/pass sa/"" , sa/sa but don't work.
Any know the usu/pass default of MSDE for Sharepoint V2?

Answer #3    Answered By: Sue Alford     Answered On: Aug 26

Did you ever get in? I grabbed an extra machine and loaded v2 with the MSDE
setup and let it go. I was suprised it did not prompt for a admin password or
account. I got on another machine and opened up the MSDE remotely using the SQL
Server tools. I was able to connect  using the same id as the id I installed v2
with. It also happened to be a user acct that was a domain admin. Might try the
same account that you set up SPS v2, if not try the a domain admin account.