-
Nov 13th, 2013, 08:47 AM
#1
Thread Starter
Junior Member
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"
-
Nov 13th, 2013, 09:32 AM
#2
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?
-
Nov 13th, 2013, 09:42 AM
#3
Thread Starter
Junior Member
Re: SQL server does not exist or access denied.
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 :/
-
Nov 13th, 2013, 10:05 AM
#4
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?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|