Publishing a SQL Server Computer with ISA Server 2004 Standard


I have to publish SQL Server so I can access it from Internet.

I did exactly as is say on Microsoft webpage but still no luck.


When I try to connect to my SQL Server by giving my Isa Server IP
address I get the error that the SQL Server does not exist or I don't
have permission.

I use on *.UDL file to test this.

Provider=SQLOLEDB.1;Password=nukedi;Persist Security Info=True;User
ID=sa;Data Source=192.168.10.2,1433

When I change the connection string to

Provider=SQLOLEDB.1;Password=nukedi;Persist Security Info=True;User
ID=sa;Data Source=192.168.10.1,1433

I work's fine.


Any ideas


Burim Hajrizaj

.

Relevant Pages

  • Re: General Question: Single Quotes in Text Fields
    ... StoredPrcedure in the SQL server, when single quote involved. ... Good Luck ... to morph apostrophes into some other character or just delete them ...
    (microsoft.public.access.modulesdaovba)
  • Provider not found
    ... occur with any ODBC or SQL based database, not just MS SQL Server. ... controls connected to a Sybase database. ... I re-applied the SQL server SP 3 - no luck ... I found these in my i386 folder. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Dynamic Table Name is Source Query
    ... >lookup books and other source for few days and still out of luck. ... Then use a dynamic properties task to take the global variable and ... assign it to the SourceObjectName property of your DataPump task. ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • MSSQL works internally not towards Internet.
    ... The main problem is that I cannot access the SQL Server from the internet. ... DMZ without luck. ... I might be doing the connectionstring wrong. ...
    (microsoft.public.sqlserver.setup)
  • Re: ORDER BY in VIEW not working
    ... it's just a coincidence that in other views (see ... > sorted in the specified order? ... You could call it luck, ... SQL Server 2005 added some engine improvements ...
    (comp.databases.ms-sqlserver)