Web Assistant Wizard

[yuppy]

I would like to publish my database using SQL 2000/Windows 2000. I have two servers - IIS and SQL (not running IIS). Ran Web Assistant, but couldn't find .htm file as noted in wizard.
Questions:
Don't I have to place the file on the IIS server's

http://wwwroot

directory? Is it possible?
How do I access the published database via a browser; where is it?
Does IIS have to be active on the SQL server for this to work?

Thanks,
a very new SQL user

 

[tlbroadbent]

You don't have to run IIS on the SQL Server. You can export web pages using web tasks. Your SQL Server Agent account must have appropriate priveleges on the web server. That is, the SQL Agent account must have write permissions. Also, make sure that account is a domain account. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[yuppy]

But the two servers are standalones; no domain. And SQL is using SQL server authentication; not Windows.

Thanks again,
-still a very new SQL user

 

[tlbroadbent]

The SQL authentication is not the question. The SQL login account still needs to have NT permissions because it must write to an NT file on the other server. The SQL Account must be able to login to the other server.

You say you don't have a domain. Do you mean there is no LAN, no domain controller, and no domain logins? Are all workstations and servers standalones? That seems highly unusual to me. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[yuppy]

no domain; network users are authenticated via Netware. Netware used for file and printing services.

Users were created on the two standalone 2000 servers (IIS/ColdFusion server and SQL server).

Not logging onto SQL server using Windows authentication, only SQL "sa" account (which we're in the process of changing for security reasons). Don't think it's possible to give the "sa" account access to the IIS server.

Thanks again.

 

[tlbroadbent]

Again, it is not the SA login that is the question. SQL Server runs as an NT service with a login account. Look in the SQL service properties under Services in the Control Panel. Alternately, you can examine the server properties in Enterprise Manager.

Find the SQL Server login account. Make sure that account is also available on the IIS server and a trust relationship is setup between the two servers. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[yuppy]

Hi,

was able to create same Windows network login ID on all servers including my workstation and access the database after giving Public appropriate rights.

New problem: can't find Web Assistant Wizard. Does appear when I log in as "sa," however.

Help!