Accessing remote SQL 2005 db using C# express edition

I have downloaded Visual C# express edition and SQL Server 2005 Express
Edition.
Installed Visual C# Express and SQL Server Express edition on Windows XP Sp2
and .NET framework 2.0
I am trying to write a C# program using ADO.NET to access a SQL 2000
database stored on a remote server Windows 2003 Sp1.
User logged in on this XP machine does not have rights on Windows 2003 serve
r.
Getting some kind of errors that login failed. And if I use user name and
password while connecting to SQL 2000 database getting some different errors
.
My questions are:
1. Is it possible with Visual C# express edition to access remote server SQL
db?
or do I need to use local database?
2. Is it possible to import SQL 2000 datbase in SQL 2005 Express edition?
Please advise.
Thanks in advance.Hi
1. If you are using windows authentication then there will need to be a
trust between the server and workstation if they are not on the same domain.
If you have mixed mode authentication then you may be able to use a SQL
Server login. Try connecting with osql first.
2. You can backup/restore from SQL 2000 to SQL 2005.
John
"SPD" wrote:

> I have downloaded Visual C# express edition and SQL Server 2005 Express
> Edition.
> Installed Visual C# Express and SQL Server Express edition on Windows XP S
p2
> and .NET framework 2.0
> I am trying to write a C# program using ADO.NET to access a SQL 2000
> database stored on a remote server Windows 2003 Sp1.
> User logged in on this XP machine does not have rights on Windows 2003 ser
ver.
> Getting some kind of errors that login failed. And if I use user name and
> password while connecting to SQL 2000 database getting some different erro
rs.
> My questions are:
> 1. Is it possible with Visual C# express edition to access remote server S
QL
> db?
> or do I need to use local database?
> 2. Is it possible to import SQL 2000 datbase in SQL 2005 Express edition?
> Please advise.
> Thanks in advance.
>