SQL server does not exist or access denied.
I'm trying to connect my vb application to my database server, but my program is running in a virtual machine inside VMWARE and my database server is my real machine.
i was trying to solve this problem by turn off my firewall and turn on the TCP/IP connection on my sql server settings, but nothing happens.
when i try to run my program, i receive a message like this :
[DBNETLIB][ConnectionOpen (Connect()).]SQL server does not exist or access denied
My connection string :"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Data Source=tcp:192.168.2.3,1433"
Re: SQL server does not exist or access denied.
How do you have your network configured on the VM? Are you using the Bridged adapter setting or?
Re: SQL server does not exist or access denied.
Quote:
Originally Posted by
DataMiser
How do you have your network configured on the VM? Are you using the Bridged adapter setting or?
i'm using the Briged mode :/
Re: SQL server does not exist or access denied.
I have not tried to use a connection string quite that myself.
I generally use the MSDASQL provider and the SeverName and Initial DB rather than an IP address and port
Is your SQL Server set to allow connections using SQL Server authentication, Windows or both?
Can you connect to the server if you run that same code on the host machine?