VB.net 2003 in client cannot connect SQL Server 2000 in server

• andrikaunang

  SSC Rookie

  Points: 36

  More actions

  October 4, 2009 at 11:27 pm

  #211676

  hi,

  I am sorry if my english is very bad, but i will try to explain my problem.

  I have 1 laptop and 1 PC. I have installed VB.NET 2003 in my laptop(OS : Windows XP), and SQL Server 2000 in my PC(OS : Windows XP).

  I have been trying to connect SQL Server from VB.NET but it's not working.

  I have tried to get connection string from oledbconnection(<new connection>).

  The first step at provider tab, i choose "Microsoft OLE DB Provider for SQL Server".

  The second step at connection tab, i choose "PT-000FA4DAEDE3" which is server name in my PC.

  The third step at connection tab, i choose "use Windows NT integrated security".

  When I press the drop down button to select database on the server, error message is showing.

  The first error message : "[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied."

  The second error message : "Login failed. Catalog information cannot be retrieved."

  I have tried to choose "use a specific user name(sa) and password(********)" and it's not working too.

  I have ping from laptop to PC and PC to laptop. Both of them success.

  I have disabled firewall from laptop and PC.

  I still newbie in VB.NET 2003 and SQL Server 2000.

  I don't have experience in networking.

  I have search other website for a solution, but i have no luck.

  Thank you for your attention. ^^

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  October 5, 2009 at 8:09 am

  #1061744

  I would guess that the issue is that you are not logging into a domain, thus Windows NT Integrated Security is not going to work (there may be ways to make it work, but probably not worth the trouble). You want the SQL Server to allow mixed mode authentication and then create a SQL Server account for you to connect with. Then in VS 2003 use SQL Server Authentication and provide the user name and password you just created.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• andrikaunang

  SSC Rookie

  Points: 36

  More actions

  October 8, 2009 at 12:26 am

  #1063242

  Well... luckly my IT supervisor give me a solution. With that solution I have solved the problem. My laptop(VB.NET 2003) cannot connect my PC(SQL Server 2000) because SQL Server that i install is service pack 2. With SQL Server 2000 sp 4, I can connect to a remote server.