Connect to sql server 2005 Standard thru internet

Hi!

I am trying to connect to my SqlServer 2005 thru internet, but it is not
working. I have a dyndns updater on my server which tells me an ip address
of the router. The router is configured to forward TCP port 1433 to LAN IP
address of the computer on which is SQL Server installation.
What is the connection string to connect to my server.

I tried xxx.dyndns.org:1433, but it doesn't work. There is a default
instance installed on that machine.

Please help.

Zvonko

Re: Connect to sql server 2005 Standard thru internet

Am Thu, 12 Jul 2007 14:09:21 +0200 schrieb Zvonko Bi¹kup:
....
> I tried xxx.dyndns.org:1433, but it doesn't work. There is a default
> instance installed on that machine.

You have to use the instance name too. If it would be a standard
installation from SQLExpress, then it would work with
xxx.dyndns.org:1433\SQLExpress.
But you said you have a "full" SQL-Server, there i don't know the name of
the standard instance.
And i hope you have enabled connect from outside of the server, by default
this is forbidden!

bye,
Helmut

Re: Connect to sql server 2005 Standard thru internet

"Zvonko Bi¹kup" wrote in message
news:46961a92$1@news.novi-net.net...
> Hi!
>
> I am trying to connect to my SqlServer 2005 thru internet, but it is not
> working. I have a dyndns updater on my server which tells me an ip address
> of the router. The router is configured to forward TCP port 1433 to LAN IP
> address of the computer on which is SQL Server installation.
> What is the connection string to connect to my server.
>
> I tried xxx.dyndns.org:1433, but it doesn't work. There is a default
> instance installed on that machine.

OK. I am able to connect to my server using SQL SERVER Mangement Studio
using xxx.dyndns.org\InstanceName,1433. But when I try to connect thru PHP
script using
msssql_connect("xxx.dyndns.org\InstanceName,1433","username" ,"password"); no
such luck. Any ideas?

Zvonko

Re: Connect to sql server 2005 Standard thru internet

Zvonko Bi¹kup (zvonko_NO_SPAM_@velkat.net) writes:
> OK. I am able to connect to my server using SQL SERVER Mangement Studio
> using xxx.dyndns.org\InstanceName,1433. But when I try to connect thru
> PHP script using
> msssql_connect("xxx.dyndns.org\InstanceName,1433","username" ,"password");
> no such luck. Any ideas?

Doesn't PHP use DB-Library to connect? Which version of NTWDBLIB.DLL do
you have in System32?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Connect to sql server 2005 Standard thru internet

"Erland Sommarskog" wrote in message
news:Xns996C6C348C702Yazorman@127.0.0.1...
>
> Doesn't PHP use DB-Library to connect? Which version of NTWDBLIB.DLL do
> you have in System32?

In Windows\system32 there is no such file. In apache and php folder file
version is 2000.80.194.0
Is that the problem?

Zvonko

Re: Connect to sql server 2005 Standard thru internet

Zvonko Biškup (zvonko_NO_SPAM_@velkat.net) writes:
> "Erland Sommarskog" wrote in message
> news:Xns996C6C348C702Yazorman@127.0.0.1...
>>
>> Doesn't PHP use DB-Library to connect? Which version of NTWDBLIB.DLL do
>> you have in System32?
>
> In Windows\system32 there is no such file. In apache and php folder file
> version is 2000.80.194.0
> Is that the problem?

Maybe. The latest version of the DB-Library DLL is 2000.80.2039.0 and this
is the one that ships with SQL 2000 SP4. You may want to try to get hold
of that one.

However, don't hold your breath. DB-Library is an extinct technology and
Microsoft has not done much with since SQL 6.5 was released. They added
support for named instances, although to docs say the opposite. So the
SP4 DLL may be just the same as the RTM DLL.

Furthermore, Microsoft has announced that SQL 2008, currently in beta, will
be the last version of SQL Server to accept connections from DB-Library
connections. So the PHP crowd may want to look for a new client API soon.

In the meanwhile, try adding an alias. With SQL 2005 you do that in
the SQL Configuration Manager. But whether SCM writes where DB-Library
reads, I don't know. You can also try cliconfg.exe in System32. I believe
there is one, even if you don't have SQL 2000 installed, although SQL 2000
installs a different version.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Connect to sql server 2005 Standard thru internet

"Erland Sommarskog" wrote in message
news:Xns996CF06341967Yazorman@127.0.0.1...

> In the meanwhile, try adding an alias. With SQL 2005 you do that in
> the SQL Configuration Manager. But whether SCM writes where DB-Library
> reads, I don't know. You can also try cliconfg.exe in System32. I believe
> there is one, even if you don't have SQL 2000 installed, although SQL 2000
> installs a different version.

Erland you are really something. cliconfg.exe did the trick! Whenever I had
a problem with MSSQL I posted here and Erland helped. Thanks a million
times.
I wish there would be more people like you on newsgroups in my country
(Croatia). Here people would say "just Google it". I did, as I would never
post a question if I haven't try all sources before. But some things you
just can not Google in time.

Thanks again!

Zvonko