MsSql question , i'm using VPS with plsek software....

Discussion in 'Databases' started by greekhand, Oct 23, 2007.

0
  1. #1
    Hi , :)

    like i said i have VPS plan but on this plan the plsek sofware does not support
    MsSql , the stuff that host my website told me that they will not support anything that invovled to MsSql :mad:

    so ... what i was doing till now ?

    i download SqlExpress 2005 on the remote machine . and i can login to the Database engine using Windows Authentication ,

    also , i have 'webs develeoper express' (asp.net) on my PC and also have SQLExpress 2005 - when i run my website on my PC i successfuly
    insert some data into the DataTables .

    but when i run the same file on the VPS (after i upload them using FTP)
    that does not work and i see this message :

    Cannot open database "horse" requested by the login. The login failed. Login failed for user 'VE326\IWPD_4(main)'.



    my connectin string on my "DBLayer" class looks like this :

    connString = @"Server=(local)\sqlexpress;Integrated Security=True;Database=horse";



    ANY IDEA ???


    thanks .
     
    greekhand, Oct 23, 2007 IP