I am using SQL Server 2008 Enterprise.
1) What would be the URL for a file named "test.asp" that is stored in this directory - "C:/Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/test.asp". Assume the servername is "ServerJoe". I have
tried "http://ServerJoe/MSSQL/test.asp" and many other combinations without success (I get "HTTP request error", "Server.Error.RequestError: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error
#2032: Stream Error. URL: http://JWHPC/Reports/Pages/fas_mssql_connector.asp?irand=0.5500319339334965"]". (Noticed I also tried storing the asp file in /Reports.)
2) What is the root directory for SQL Server 2008?
3) When asked for "userid" is it domain\userid or just userid?
4) In which directory should the crossdomain.xml file be stored?
Thanks much.
View Complete Post