VMware vSphere

 View Only

  • 1.  VM server issue with ODBC

    Posted Aug 01, 2007 01:21 AM

    I have a host server running Windows 2003 R2 with VMware GSX server running. I have installed a VM server running also Windows 2003 R2 and I have an application on that server using DNS to access a SQL 2000 database, when I create the DSN and do a test connection it seems to work fine but when the application is try to use it it seems to have issues.



  • 2.  RE: VM server issue with ODBC

    Posted Aug 01, 2007 03:50 AM

    Hi darkelf!

    Are you saving the username and password for the database in the ODBC connection?



  • 3.  RE: VM server issue with ODBC

    Posted Aug 01, 2007 03:52 AM

    I have a host server running Windows 2003 R2 with

    VMware GSX server running. I have installed a VM

    server running also Windows 2003 R2 and I have an

    application on that server using DNS to access a SQL

    2000 database, when I create the DSN and do a test

    connection it seems to work fine but when the

    application is try to use it it seems to have issues.

    This sounds unrelated to being an issue with the VM.

    An ODBC "Test Connection" succeeds, but an application actually accessing the tables and data fails - sounds like an application problem.

    We'd need more information to help. This should also go into the Virtual Machine & Guest OS forum and not VirtualCenter's.



  • 4.  RE: VM server issue with ODBC

    Posted Aug 01, 2007 04:00 AM

    I did a little more testing and the issue looks like it's not an ODBC issue rather a authentication issue with AD. I have tested using the DNS with a local user account for the database and it connect fine but when using the AD login a get an message saying i'm not a authenticated user.



  • 5.  RE: VM server issue with ODBC

    Posted Aug 01, 2007 05:29 AM

    Are the SQL server, and the host, in the same AD domain - and the same one as the ad user you're trying?

    Also, give Native SQL authentications a go, bypassing AD altogether.



  • 6.  RE: VM server issue with ODBC

    Posted Aug 01, 2007 05:35 AM

    yeh they are all in the same AD domain



  • 7.  RE: VM server issue with ODBC

    Posted Aug 01, 2007 05:37 AM

    Has the AD user you're trying with been added as a login for SQL Server?



  • 8.  RE: VM server issue with ODBC

    Posted Aug 01, 2007 05:45 AM

    yep, this all works fine when it's running on the base harddware. I only get this issue when running on the VM



  • 9.  RE: VM server issue with ODBC

    Posted Aug 01, 2007 07:55 AM

    Check the network IP settings on your Virtual Machine and compare them with the physical machine. You might have an incorrect subnet mask entry.



  • 10.  RE: VM server issue with ODBC

    Posted Aug 01, 2007 10:30 PM

    All the network setting is correct, I can access all the network shares and emails