asked on

accessing sql server through VB.net

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

sweatbeast

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...

Chuckbuchan

ASKER

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"

sweatbeast

when you say administrator do you mean domain administrator or the administrator on the SQL server?

Chuckbuchan

ASKER

I meant domain administrator and the SQL Server is installed on the DC.

sweatbeast

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.

Chuckbuchan

ASKER

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 .

ASKER CERTIFIED SOLUTION

modulo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial