Prev: Remote Access Wizard annoyance
Next: Suggestion on Wireless ADSL Router
From: Costas on 12 Dec 2007 21:18
Brian,

I'm sorry it took me so long to reply but I got a bit busy in a hurry. I'm
not sure reinstalling will solve the problem but you never know. If you
have time go ahead and do it. If nothing else it will add to your
experience.

I'm not in favor of non-supported configuration only because if someone else
tries to maintain the server many things can go wrong. Nevertheless, the
configuration that Chad Gross described is very smart.

You can definitely have SQL Server as the back-end of WSS 3.0 without
issues. This will allow you more direct control over the databases and
their maintenance

--
Costas


"Brian" <Brian(a)discussions.microsoft.com> wrote in message
news:4FA5C882-4437-49F2-B187-953D066EABBF(a)microsoft.com...
> Costas,
>
> Unchecked 'proxy'.. same problem. (also, 'Bypass proxy for local
> addresses
> had been checked).
> At this point (not actually using WSS3) I am open to reinstalling, and
> even
> other configurations..
>
> What do you think about this:
> http://msmvps.com/blogs/cgross/archive/2007/02/04/companyweb-sharepoint-v3-part-5.aspx
> I am trying this out on a test box.. but I am not sure I want to go with
> an unsupported configuration on a production box. Although, it seems that
> the original companyweb could be side stepped [if the /Remote site was
> edited to link to a NewCompanyweb; and if internal IE browsers were
> pointed
> at the NewCompanyweb for homepage] with no change to the original
> companyweb
> site.
>
> Also, Is this:
> http://msmvps.com/blogs/cgross/archive/2007/05/28/using-your-sql-in-sbs-r2-premium-as-a-back-end-for-wss-3-0.aspx
> a supported configuration? (SBS 2003 SP2 /w SQL 2000)
>
> Thanks,
> Brian
>
>
> "Costas" wrote:
>
>> Brian,
>>
>> Check Internet Explorer | Internet Options | Connections | LAN settings.
>> If
>> there is a proxy server used, uncheck the checkbox and see if that solves
>> the problem.
>>
>> I'm not sure if that would be a permanent solution (assuming it helps)
>> but I
>> can't find much info on this type of error. My business server runs ISA
>> and
>> WSS 3.0 in parallel to WSS 2.0 and I tested your issue but I couldn't
>> replicate it.
>>
>> --
>> Costas
>>
>>
>> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
>> news:EAF40D09-C6DA-4C46-AA94-9A54E3870A16(a)microsoft.com...
>> > Costas,
>> >
>> > http://newcompanyweb:21276/sites/NewCompanyWeb/default.aspx
>> >
>> > Yes.. looks like site uses port 21276.
>> >
>> > Didn't see 2170 listed when I ran netstat -ano on the server or
>> > worksation.
>> >
>> > Brain
>> >
>> >
>> > "Costas" wrote:
>> >
>> >> Brian,
>> >>
>> >> How do you try to access the site? Do you use http or https? Do you
>> >> use
>> >> an
>> >> internal name (http://site) or an the full domain? Is 21276 the port
>> >> of
>> >> your site? Do you have anything listening to port 2170?
>> >>
>> >> --
>> >> Costas
>> >>
>> >>
>> >> "Costas" <cpstechgroup(a)gmail.com> wrote in message
>> >> news:AB71FF98-30A6-4403-8448-52FBF0D80CDB(a)microsoft.com...
>> >> > Brian,
>> >> >
>> >> > The problem doesn't seem to be with the SpreadSheet or SharePoint.
>> >> > It
>> >> > is
>> >> > ISA related and I don't have an answer right now. I'll do some
>> >> > research
>> >> > and get back to you.
>> >> >
>> >> > --
>> >> > Costas
>> >> >
>> >> >
>> >> > "Brian" <Brian(a)discussions.microsoft.com> wrote in message
>> >> > news:13A17012-489B-4529-BF4F-FF2EF84BAD14(a)microsoft.com...
>> >> >> Costas,
>> >> >>
>> >> >> The sheet was named "A & A". I renamed the sheet to "Sheet1".
>> >> >> same
>> >> >> probelm.
>> >> >>
>> >> >> Changed Table to a Range. same problem.
>> >> >>
>> >> >> Also, tried saving the workbook as .xls, .xlsx, and .xlsm same
>> >> >> problem.
>> >> >>
>> >> >> Brian
>> >> >>
>> >> >> "Costas" wrote:
>> >> >>
>> >> >>> Brian,
>> >> >>>
>> >> >>> The 'Select Range' element should be 'Sheet1!Table1' . I assume
>> >> >>> you
>> >> >>> renamed
>> >> >>> 'Sheet1' to 'A'. Is that correct? I'm not sure that the 'A &' in
>> >> >>> front
>> >> >>> of
>> >> >>> the table name is. If selecting the range is not an option (by
>> >> >>> selecting
>> >> >>> 'Range of Cells' under 'Range Type') try recreating the table by
>> >> >>> highlighting the range and clicking 'table'. Change the name of
>> >> >>> the
>> >> >>> columns
>> >> >>> and try importing again.
>> >> >>>
>> >> >>> Under 'Select Range' it should should "SheetName!TableName".
>> >> >>> Importing
>> >> >>> the
>> >> >>> range will be easier but you'll have to rename the default Colum
>> >> >>> names
>> >> >>> within SharePoint after you do that
>> >> >>>
>> >> >>> --
>> >> >>> Costas
>> >> >>>
>> >> >>>
>> >> >>> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
>> >> >>> news:3DCA76A4-18FF-42D1-A2A4-33C5283BBB81(a)microsoft.com...
>> >> >>> > Costas,
>> >> >>> >
>> >> >>> > Sorry.. I was tired..
>> >> >>> >
>> >> >>> > I am trying to Create a 'Custom List', using the 'Import
>> >> >>> > Spreadsheet'
>> >> >>> > function.
>> >> >>> > So..
>> >> >>> > 'Site Actions' | 'Create' then under “Custom Lists” | 'Import
>> >> >>> > Spreadsheet'
>> >> >>> > This opens a “New” window, and I fill out “Name”, “Description”,
>> >> >>> > and
>> >> >>> > “File
>> >> >>> > location” (the file is on the workstation I am using, on 'The
>> >> >>> > Desktop').
>> >> >>> > The
>> >> >>> > “Import” button causes Excel 2007 to open the spreadsheet, and
>> >> >>> > an
>> >> >>> > “Import
>> >> >>> > to
>> >> >>> > Windows SharePoint Services list” dialog box. I select “Range
>> >> >>> > Type” :
>> >> >>> > 'Table
>> >> >>> > Range', and “Select Range” : 'A & A!Table1'.
>> >> >>> > Clicking the 'Import' button produces the error.
>> >> >>> > Thanks for your help,
>> >> >>> > Brian
>> >> >>> >
>> >> >>> >
>> >> >>> > "Costas" wrote:
>> >> >>> >
>> >> >>> >> Brian,
>> >> >>> >>
>> >> >>> >> Did you create a document library to add the spreadsheet? What
>> >> >>> >> exactly
>> >> >>> >> did
>> >> >>> >> you do after you went to Site Actions | Create ?
>> >> >>> >>
>> >> >>> >> --
>> >> >>> >> Costas
>> >> >>> >>
>> >> >>> >>
>> >> >>> >> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
>> >> >>> >> news:6D5D57F2-BBBD-47A2-8412-6AB0CA62DCE6(a)microsoft.com...
>> >> >>> >> > Installed WSS3 in parallel to WSS2. (SBS 2003 SP2 /w ISA
>> >> >>> >> > 2004)
>> >> >>> >> >
>> >> >>> >> > When trying to Import Spreadsheet (to WSS3 site, under Site
>> >> >>> >> > Actions |
>> >> >>> >> > Create) I get the error:
>> >> >>> >> >
>> >> >>> >> > Import to Windows SharePoint Services List
>> >> >>> >> > Cannot connect to the server at this time. Your table cannot
>> >> >>> >> > be
>> >> >>> >> > published.
>> >> >>> >> >
>> >> >>> >> >
>> >> >>> >> > Isa shows this error:
>> >> >>> >> >
>> >> >>> >> > Closed Connection SERVER 12/10/2007
>> >> >>> >> > 8:39:42
>> >> >>> >> > PM
>> >> >>> >> > Log type: Firewall service
>> >> >>> >> > Status: A connection was abortively closed after one of the
>> >> >>> >> > peers
>> >> >>> >> > sent
>> >> >>> >> > a
>> >> >>> >> > RST
>> >> >>> >> > segment.
>> >> >>> >> > Rule: SBS Protected Networks Access Rule
>> >> >>> >> > Source: Internal ( 192.168.16.38:2170)
>> >> >>> >> > Destination: Local Host ( 192.168.16.10:21276)
>> >> >>> >> > Protocol: Unidentified IP Traffic (TCP:21276)
>> >> >>> >> > User:
>> >> >>> >> > Additional information
>> >> >>> >> > Number of bytes sent: 1313 Number of bytes received: 4710
>> >> >>> >> > Processing time: 0ms Original Client IP: 192.168.16.38
>> >> >>> >> > Client agent:
>> >> >>> >> >
>> >> >>> >> >
>> >> >>> >> > Anybody know how to fix this?
>> >> >>> >> >
>> >> >>> >> > Thanks!
>> >> >>> >> > Brian
>> >> >>> >> >
>> >> >>> >>
>> >> >>>
>> >> >
>> >>
>>

From: Brian on 13 Dec 2007 17:02
Costas,

No probelm.. just getting started with this "paper free" project.. and kinda
busy doing other things as well.

Ill watch this thread for any new findings or ideas. (and i am going to post
a new question about Chad's setup)

Hope you can get this figured out!
Brian


"Costas" wrote:

> Brian,
>
> I'm sorry it took me so long to reply but I got a bit busy in a hurry. I'm
> not sure reinstalling will solve the problem but you never know. If you
> have time go ahead and do it. If nothing else it will add to your
> experience.
>
> I'm not in favor of non-supported configuration only because if someone else
> tries to maintain the server many things can go wrong. Nevertheless, the
> configuration that Chad Gross described is very smart.
>
> You can definitely have SQL Server as the back-end of WSS 3.0 without
> issues. This will allow you more direct control over the databases and
> their maintenance
>
> --
> Costas
>
>
> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> news:4FA5C882-4437-49F2-B187-953D066EABBF(a)microsoft.com...
> > Costas,
> >
> > Unchecked 'proxy'.. same problem. (also, 'Bypass proxy for local
> > addresses
> > had been checked).
> > At this point (not actually using WSS3) I am open to reinstalling, and
> > even
> > other configurations..
> >
> > What do you think about this:
> > http://msmvps.com/blogs/cgross/archive/2007/02/04/companyweb-sharepoint-v3-part-5.aspx
> > I am trying this out on a test box.. but I am not sure I want to go with
> > an unsupported configuration on a production box. Although, it seems that
> > the original companyweb could be side stepped [if the /Remote site was
> > edited to link to a NewCompanyweb; and if internal IE browsers were
> > pointed
> > at the NewCompanyweb for homepage] with no change to the original
> > companyweb
> > site.
> >
> > Also, Is this:
> > http://msmvps.com/blogs/cgross/archive/2007/05/28/using-your-sql-in-sbs-r2-premium-as-a-back-end-for-wss-3-0.aspx
> > a supported configuration? (SBS 2003 SP2 /w SQL 2000)
> >
> > Thanks,
> > Brian
> >
> >
> > "Costas" wrote:
> >
> >> Brian,
> >>
> >> Check Internet Explorer | Internet Options | Connections | LAN settings.
> >> If
> >> there is a proxy server used, uncheck the checkbox and see if that solves
> >> the problem.
> >>
> >> I'm not sure if that would be a permanent solution (assuming it helps)
> >> but I
> >> can't find much info on this type of error. My business server runs ISA
> >> and
> >> WSS 3.0 in parallel to WSS 2.0 and I tested your issue but I couldn't
> >> replicate it.
> >>
> >> --
> >> Costas
> >>
> >>
> >> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> >> news:EAF40D09-C6DA-4C46-AA94-9A54E3870A16(a)microsoft.com...
> >> > Costas,
> >> >
> >> > http://newcompanyweb:21276/sites/NewCompanyWeb/default.aspx
> >> >
> >> > Yes.. looks like site uses port 21276.
> >> >
> >> > Didn't see 2170 listed when I ran netstat -ano on the server or
> >> > worksation.
> >> >
> >> > Brain
> >> >
> >> >
> >> > "Costas" wrote:
> >> >
> >> >> Brian,
> >> >>
> >> >> How do you try to access the site? Do you use http or https? Do you
> >> >> use
> >> >> an
> >> >> internal name (http://site) or an the full domain? Is 21276 the port
> >> >> of
> >> >> your site? Do you have anything listening to port 2170?
> >> >>
> >> >> --
> >> >> Costas
> >> >>
> >> >>
> >> >> "Costas" <cpstechgroup(a)gmail.com> wrote in message
> >> >> news:AB71FF98-30A6-4403-8448-52FBF0D80CDB(a)microsoft.com...
> >> >> > Brian,
> >> >> >
> >> >> > The problem doesn't seem to be with the SpreadSheet or SharePoint.
> >> >> > It
> >> >> > is
> >> >> > ISA related and I don't have an answer right now. I'll do some
> >> >> > research
> >> >> > and get back to you.
> >> >> >
> >> >> > --
> >> >> > Costas
> >> >> >
> >> >> >
> >> >> > "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> >> >> > news:13A17012-489B-4529-BF4F-FF2EF84BAD14(a)microsoft.com...
> >> >> >> Costas,
> >> >> >>
> >> >> >> The sheet was named "A & A". I renamed the sheet to "Sheet1".
> >> >> >> same
> >> >> >> probelm.
> >> >> >>
> >> >> >> Changed Table to a Range. same problem.
> >> >> >>
> >> >> >> Also, tried saving the workbook as .xls, .xlsx, and .xlsm same
> >> >> >> problem.
> >> >> >>
> >> >> >> Brian
> >> >> >>
> >> >> >> "Costas" wrote:
> >> >> >>
> >> >> >>> Brian,
> >> >> >>>
> >> >> >>> The 'Select Range' element should be 'Sheet1!Table1' . I assume
> >> >> >>> you
> >> >> >>> renamed
> >> >> >>> 'Sheet1' to 'A'. Is that correct? I'm not sure that the 'A &' in
> >> >> >>> front
> >> >> >>> of
> >> >> >>> the table name is. If selecting the range is not an option (by
> >> >> >>> selecting
> >> >> >>> 'Range of Cells' under 'Range Type') try recreating the table by
> >> >> >>> highlighting the range and clicking 'table'. Change the name of
> >> >> >>> the
> >> >> >>> columns
> >> >> >>> and try importing again.
> >> >> >>>
> >> >> >>> Under 'Select Range' it should should "SheetName!TableName".
> >> >> >>> Importing
> >> >> >>> the
> >> >> >>> range will be easier but you'll have to rename the default Colum
> >> >> >>> names
> >> >> >>> within SharePoint after you do that
> >> >> >>>
> >> >> >>> --
> >> >> >>> Costas
> >> >> >>>
> >> >> >>>
> >> >> >>> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> >> >> >>> news:3DCA76A4-18FF-42D1-A2A4-33C5283BBB81(a)microsoft.com...
> >> >> >>> > Costas,
> >> >> >>> >
> >> >> >>> > Sorry.. I was tired..
> >> >> >>> >
> >> >> >>> > I am trying to Create a 'Custom List', using the 'Import
> >> >> >>> > Spreadsheet'
> >> >> >>> > function.
> >> >> >>> > So..
> >> >> >>> > 'Site Actions' | 'Create' then under “Custom Lists” | 'Import
> >> >> >>> > Spreadsheet'
> >> >> >>> > This opens a “New” window, and I fill out “Name”, “Description”,
> >> >> >>> > and
> >> >> >>> > “File
> >> >> >>> > location” (the file is on the workstation I am using, on 'The
> >> >> >>> > Desktop').
> >> >> >>> > The
> >> >> >>> > “Import” button causes Excel 2007 to open the spreadsheet, and
> >> >> >>> > an
> >> >> >>> > “Import
> >> >> >>> > to
> >> >> >>> > Windows SharePoint Services list” dialog box. I select “Range
> >> >> >>> > Type” :
> >> >> >>> > 'Table
> >> >> >>> > Range', and “Select Range” : 'A & A!Table1'.
> >> >> >>> > Clicking the 'Import' button produces the error.
> >> >> >>> > Thanks for your help,
> >> >> >>> > Brian
> >> >> >>> >
> >> >> >>> >
> >> >> >>> > "Costas" wrote:
> >> >> >>> >
> >> >> >>> >> Brian,
> >> >> >>> >>
> >> >> >>> >> Did you create a document library to add the spreadsheet? What
> >> >> >>> >> exactly
> >> >> >>> >> did
> >> >> >>> >> you do after you went to Site Actions | Create ?
> >> >> >>> >>
> >> >> >>> >> --
> >> >> >>> >> Costas
> >> >> >>> >>
> >> >> >>> >>
> >> >> >>> >> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> >> >> >>> >> news:6D5D57F2-BBBD-47A2-8412-6AB0CA62DCE6(a)microsoft.com...
> >> >> >>> >> > Installed WSS3 in parallel to WSS2. (SBS 2003 SP2 /w ISA
> >> >> >>> >> > 2004)
> >> >> >>> >> >
> >> >> >>> >> > When trying to Import Spreadsheet (to WSS3 site, under Site
> >> >> >>> >> > Actions |
> >> >> >>> >> > Create) I get the error:
> >> >> >>> >> >
> >> >> >>> >> > Import to Windows SharePoint Services List
> >> >> >>> >> > Cannot connect to the server at this time. Your table cannot
> >> >> >>> >> > be
> >> >> >>> >> > published.
> >> >> >>> >> >
> >> >> >>> >> >
> >> >> >>> >> > Isa shows this error:
> >> >> >>> >> >
> >> >> >>> >> > Closed Connection SERVER 12/10/2007
> >> >> >>> >> > 8:39:42
> >> >> >>> >> > PM
> >> >> >>> >> > Log type: Firewall service
> >> >> >>> >> > Status: A connection was abortively closed after one of the
> >> >> >>> >> > peers
> >> >> >>> >> > sent
> >> >> >>> >> > a
> >> >> >>> >> > RST
> >> >> >>> >> > segment.
> >> >> >>> >> > Rule: SBS Protected Networks Access Rule
> >> >> >>> >> > Source: Internal ( 192.168.16.38:2170)
> >> >> >>> >> > Destination: Local Host ( 192.168.16.10:21276)
> >> >> >>> >> > Protocol: Unidentified IP Traffic (TCP:21276)
> >> >> >>> >> > User:
> >> >> >>> >> > Additional information
> >> >> >>> >> > Number of bytes sent: 1313 Number of bytes received: 4710
> >> >> >>> >> > Processing time: 0ms Original Client IP: 192.168.16.38
> >> >> >>> >> > Client agent:
> >> >> >>> >> >
> >> >> >>> >> >
> >> >> >>> >> > Anybody know how to fix this?
> >> >> >>> >> >
> >> >> >>> >> > Thanks!
> >> >> >>> >> > Brian
> >> >> >>> >> >
> >> >> >>> >>
> >> >> >>>
> >> >> >
> >> >>
> >>
>
First  |  Prev  | 
Pages: 1 2 3
Prev: Remote Access Wizard annoyance
Next: Suggestion on Wireless ADSL Router