using sql server over internet
lazarus / 16-Databases

----------------------------------------------------------------------
amigoface · 2011-11-16 05:32

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 · 2011-11-16 09:06

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 · 2011-11-16 09:19

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 · 2011-11-16 10:04

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.
Quotethe web host has sql server 2008 (not express)That was only an
example. The principle is the same for non express databases.

----------------------------------------------------------------------
amigoface · 2011-11-16 10:35

after connecting in management studio it gave me some thing like :
QuoteC15472-154761\SQLEXPRESS wich i doubt i can  access with that
using zeos ...

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

----------------------------------------------------------------------
ludob · 2011-11-16 10:53

Quote from: amigoface on November 16, 2011, 11:35:30 amafter
connecting in management studio it gave me some thing like :
QuoteC15472-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

Quote from: amigoface on November 16, 2011, 11:35:30 amQuoteotherwise
i have tested with delphi and ado and it gave me more explicit error
message :Something went wrong there.

----------------------------------------------------------------------
amigoface · 2011-11-16 11:07

lol

yes in delphi i have this error message

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

----------------------------------------------------------------------
ludob · 2011-11-16 11:44

QuoteThe 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 · 2011-11-16 11:45

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.