Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

How i can configure SQL express to connect to SQL2005 server

Avatar of nasemabdullaa
nasemabdullaa asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
3 Comments1 Solution251 ViewsLast Modified:
Hi
iam new in SQL DATABASE and I have application work on VB.NET 2005
iam install SQL 2005 Enterprise addition on server (complete)
and on client iam install SQL2005  and VB.NET 2005 and when iam open VB.NET i can see my local SQL on my PC and iam try to add my server by using ip address but i can not do that but when i use computer name i can add the new server and i can test connection and its successful
my question is must i install SQL express on client to work the application or only SQL 2005 can do the same and if i install SQL express on client how i can configure it to connect to server

Thanks


ASKER CERTIFIED SOLUTION
Avatar of Faiga Diegel
Faiga DiegelFlag of United States of America imageSr Database Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answers