?
Solved

accessing sql server through VB.net

Posted on 2005-04-10
8
Medium Priority
?
229 Views
Last Modified: 2012-05-05
I would like to access sql server through VB.net server explorer, but each time it gives me error "[DBNETLIB][Connectionopen(connect()).]SQL Server doesn't exist or access denied"

I have logged to the computer where VB.net is installed with the domain administrator account, and with the same account I am logged to the sql server.

the computername where the sqlserver is installed shows up on the server explorer.

I can run MSSQL service on the computer where sql server is installed.

thanks

0
Comment
Question by:Chuckbuchan
  • 3
  • 3
7 Comments
 
LVL 7

Expert Comment

by:sweatbeast
ID: 13748972
Is your SQL server setup to accept domain credentials or are the DB accounts administered on the SQL server? If so then you need to specify the DB account when connecting...
0
 

Author Comment

by:Chuckbuchan
ID: 13749598
on the MSSSQLSERVER properties/logon, I selected windows authentication and entered administrator account and password.

with the same account and password I logged on to the domain from another computer where VB.net is installed, and from the server explorer in VB.net I couldn't even expand the node that has the computer name where the sql server is installed. It gives me the following error:
"[DBNETLIB][Connectionopen(connect()).]SQL Server doesn't exist or access denied"
0
 
LVL 7

Expert Comment

by:sweatbeast
ID: 13756598
when you say administrator do you mean domain administrator or the administrator on the SQL server?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:Chuckbuchan
ID: 13768296
I meant domain administrator and the SQL Server is installed on the DC.
0
 
LVL 7

Expert Comment

by:sweatbeast
ID: 13776340
Can you create an ODBC connection from a client to the DB? When you set this up and test the connection this should highlight whether this is a general connection problem or .NET specific.
0
 

Author Comment

by:Chuckbuchan
ID: 13798374
I fixed the problem:
I stopped then restarted MSSQL services from the server, and on the vb.net server explorer I deleted the server and re-added it .
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 14219890
PAQed with points refunded (250)

modulo
Community Support Moderator
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Make the most of your online learning experience.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question