using sql server over internet

[amigoface]

Hi,
i am trying to use ms sql server 2008 located in my web host (arvixe.com) using zeos Lib

since every connection paramater are right , i cannot connect
i can connect with sql server management studio without any problem but not from the application i am writing


any help is welcome

thanks and good day

[ludob]

The connection is specified in TZConnection.HostName in the format host\instance. F.e 192.168.2.91\SQLEXPRESS.
To specify the port use the format host\instance,port. F.e. 192.168.2.91\SQLEXPRESS,1433

[amigoface]

the web host has sql server 2008 (not express)
and i can login with this account information with sql management studio :

Server : mydomainname
Username+password

[ludob]

Sql management studio uses the SQL Server Browser functionality to find running instances on the server using port 1434 (default). That is the reason why you don't have to specify an instance when connecting with Sql management studio. To get the instance, right click on the server object and select properties. The first line in the General tab called Name will give you the full name (host\instance). That is the name that needs to be used in Zeos.

the web host has sql server 2008 (not express)

That was only an example. The principle is the same for non express databases.

[amigoface]

after connecting in management studio it gave me some thing like :

C15472-154761\SQLEXPRESS

wich i doubt i can  access with that using zeos ...

otherwise i have tested with delphi and ado and it gave me more explicit error message :

[ludob]

after connecting in management studio it gave me some thing like :

C15472-154761\SQLEXPRESS

wich i doubt i can  access with that using zeos ...

C15472-154761 is the host name on the internal network at the web host. So try mydomainname\SQLEXPRESS.
BTW looks like your web host is cheating: it is SQLEXPRESS

otherwise i have tested with delphi and ado and it gave me more explicit error message :

Something went wrong there.

[amigoface]

lol

yes in delphi i have this error message

The login is from an untrusted domain and cannot be used with Windows authentication'

[ludob]

The login is from an untrusted domain and cannot be used with Windows authentication'

That is because ado tries to use Windows authentication. Do you have a "Trusted_Connection=yes;" or "Integrated Security=SSPI" in the connection string?
I assume you connect in Sql management studio with SQL Server Authentication, ie. providing a username and password.

Did you try mydomainname\SQLEXPRESS in TZConnection.HostName?

[BigChimp]

You're trying to use integrated authentication/SSPI/trusted connection, which uses your current Windows credentials.  Your PC obviously is not a member of a domain of the hosting provider's server, so that server doesn't accept your credentials.

You might need to specify username (hint: often sa) and password. Don't know Zeos, you might need to set trusted connection off explicitly, or it might not be necessary.