Results 1 to 4 of 4

Thread: SQL server does not exist or access denied.

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jun 2013
    Location
    Brazil
    Posts
    28

    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"

  2. #2
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    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?

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Jun 2013
    Location
    Brazil
    Posts
    28

    Re: SQL server does not exist or access denied.

    Quote Originally Posted by DataMiser View Post
    How do you have your network configured on the VM? Are you using the Bridged adapter setting or?
    i'm using the Briged mode :/

  4. #4
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    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
  •  



Click Here to Expand Forum to Full Width