Must Declare the variable @SiteID

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Windows Services
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - A number in a Word property is not transferred to WSS We have a Word document with different properties. When we save a document in WSS - the alfanummeric ("text") properties (i.e. "F16" or "Report") are automatically transferred to a coloum with the same name in WSS. However if we create another property with the format number (i.e. 121212) nothing is shown within WSS (The coloum format is "number" in WSS as is the Word property format). Do you have any ideas? Cheers Karsten Poulsen, FlowIT Tag: Must Declare the variable @SiteID Tag: 3159
  - 2
    - Removal of Right Pane I'm trying to modify the appearance of the top level Team website and would like to be remove the right pane completely so I've got more turf to play with. Is this possible and, if so, how do I do it? Thanx, Garth Tag: Must Declare the variable @SiteID Tag: 3158
  - 3
    - Site Group quota limits I have a serious problem. I can't create more then 100 Site Groups. I really needs more. Exception is "The Web site group cannot be created due to quota limitations. The maximum number of Web site groups for this Web site has been reached. Please remove a Web site group before adding another." There are no limitations on Site Group quantity in any Sharepoint Document. Thank you for your help, Pavel. Tag: Must Declare the variable @SiteID Tag: 3155
  - 4
    - Windows Share Point from MSDE to SQL 2000 Is there any documents on moving from the MSDE that Sharepoint uses to SQL Server 2000? Thanks Roger Crawford HTS Tag: Must Declare the variable @SiteID Tag: 3143
  - 5
    - Info - for French speakers - overview of WSS The site of the Paris Academy of Computer Science has at http://www.supinfo-projects.com/fr/2004/wss/ a paper written on WSS by Pierre Chenaux who worked as an intern for Microsoft for six months in the first half of 2003. The paper is thus based on the Betas. [It is also messy to read as you have to read a section at a time and there is no Print article (or even Print Page) option.] Mike Walsh, Helsinki, Finland WSS FAQ at wss.collutions.com Please reply to the newsgroup Tag: Must Declare the variable @SiteID Tag: 3139
  - 6
    - SharePoint installation can put Exchange at risk Has this issue been solved? http://www.infoworld.com/article/03/11/26/HNexchangeatrisk_1.html Tag: Must Declare the variable @SiteID Tag: 3135
  - 7
    - Multiple line field in Document Libraries I have noticed a difference in behavior between the multiple line fields of a document library andother lists. In a document library, I am not allowed to save a record which has more then 255 characters of text in a multi line field. I have tried this on several document libraries on multiple servers. There seems to be no limit in the amount of text you can have in a multiple line field in other types of lists. I have also noticed that when adding or modifying a multiple line field in a document library, there is no choice to allow rich text editing. That choice exists in the properties in other lists. Can anyone confirm this behavior, and explain why there is this limit? I want to enable users the ability add their comments on a particular document, and this will severely limit that ability. Thanks Michael Tag: Must Declare the variable @SiteID Tag: 3126
  - 8
    - SharePoint + Hummingbird dm5.1 Is there an add-in to keep document checkin/out metadata and versioning in sync between Hummingbird DM5.1 and Sharepoint? Tag: Must Declare the variable @SiteID Tag: 3124
  - 9
    - Links in new window, and Mess. status Hi, I have two questions: I want to make that all those links which navigates away from the portal would open in a new window -- so for example the "Links" list items would open in a new window. Is that possible? And the other one: How can I put the Messenger online status next to someone's e-mail addredd in a Contacts list (I want the same thing as it is with the "Modified by" things, but in a contactlist)? If you know answer for at least one of my questions, please let me know. Thanks, Szajd (Daniel Said) Tag: Must Declare the variable @SiteID Tag: 3121
  - 10
    - send alert to individual user from task list hi i have windowsservices and sps2. i have a task list for all the team.but i want to send alerts to the person the task is assigned to.i also have office 2003 if it can help. thanks Tag: Must Declare the variable @SiteID Tag: 3120
  - 11
    - Data View Web Part Caching I'm using the dataview webpart to display RSS feeds. It works beautifully, but I'd like to know what the cache options actually do. I have it set to "Default" in the Miscellaneous section of the options for the web part and the cache time-out setting is 0 by default. What does this mean in practice? .... is the server downloading the RSS file every time the page is requested, or does it mean something else...... Also, I can't open pages with these webparts in Frontpage 2003 ("A web part or web form control on this web part page cannot be displayed or imported because it is not registered as safe on this site...." etc) Is there any documentation on this? Thanks Leslie Tag: Must Declare the variable @SiteID Tag: 3106
  - 12
    - Installing DC after WSS has been installed means trouble ? Hello people, First of all: a very happy 2004 to you all ! Now, I had a Windows 2003 server installed with WSS on SQL 2000 working just fine (all on the same machine, together with IIS). For some specific reasons, I had to upgrade the machine and install active directory (make it a DC) at a later stage. This installation has "broken down" my WSS and I am having some trouble to get it back on line. I first got the "Service Unavailable" errors and cured this by selecting the right application pool on the virtual server in IIS (why was this changed during the DC-installation ?). However, once I go to my WSS home page, I always get a "You are not authorized to view this page" error, even if I'm loged on as the administrator on the server itself. I think the connection between WSS and SQL or at least the rights of the account that connects to the SQL-server got messed up somewhere along the road, since the initial settings in the "set configuration database server" of my WSS administration pages now gives me an "create database permission denied" error. I think I should be able to solve this by adding an account to the SQL WSS database (NT Authority/Network account ?) and set the correct rights to it, but I don't want to mess around with this before I'm sure. Also, if this is the case indeed, why do I need to do this ? Should I had the DC installed before installing SQL/WSS/DC/IIS ? If so, what would be the best thing to get this up-and-running ? I have no problem re-installing one of the above applications it this solves the problem, rather than messing around with accounts and maybe forgetting a couple of settings... Many thanks in advance for your advice ! Regards, Benoit. Tag: Must Declare the variable @SiteID Tag: 3100
  - 13
    - reinstating mssql$sharepoint service I still have the problem from my original post (12/31/03 - can't connect to configuration database), and I'm wondering if (part of?) the problem is that I don't have the mssql$sharepoint service installed. However - If I attempt to reinstall msde, I get an invalid instance name error. I know that I can specify the instance name on the command line, but when I run setup with INSTANCENAME=SHAREPOINT, setup runs *almost* to completion, then silently fails. The application logs just say that installation failed with no additional information. Am I on the right path here. I've done nothing but read articles and try various things out for the last day and a half, but I'm no closer now than I was when I got into this mess. I'm installing sql server 2000 sp3 on this machine now, because I've tried everything else I can think of, and I'm hoping that will give me some more options. If anyone missed my original post, here's the summary: 1) Sharepoint was working great 2) I accidentally uninstalled msde 3) I tried reinstalling sharepoint (choosing repair) 4) Access requests result in "configuration database not found) The database is still there - I just don't know how to get them connected. If I attempt to access the server through the sharepoint admin site, I get an error that "the virtual server referenced here is not in the configuration database" - but I don't know how to get it there, nor do I know if it's the same or different problem. Tag: Must Declare the variable @SiteID Tag: 3097
  - 14
    - WSS TOAST AFTER RUNNING DCPROMO Here is the error I get in the event log now after I upgraded my member server running WSS to a DC. Event Type: Error Event Source: Windows SharePoint Services 2.0 Event Category: None Event ID: 1000 Date: 1/2/2004 Time: 12:36:01 PM User: N/A Computer: COMPUTERNAME Description: #50070: Unable to connect to the database MASTS on COMPUTERNAME\INSTANCENAME. Check the database connection information and make sure that the database server is running. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. >>> HAHAHA...no help there When trying to access any of the sites, including the Central Administrator, I get the following error in the browser. Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur. Any ideas? How do I restore the connection to the main database. I must be looking in the wrong documentation to mend this together. I hate to have everything in the content databases lost. Dave Durand Phoenix, Arizona boss@modernage.ws Tag: Must Declare the variable @SiteID Tag: 3093
  - 15
    - Setting up STMP on WSS Is there any documentation on how to set up SMTP for WSS, or any best practices regarding setting up SMTP? Does WSS require Exchange or can any SMTP email be used? I think this is the cause of my error that I posted; "The user does not exist". Thanks Tag: Must Declare the variable @SiteID Tag: 3083
  - 16
    - The user does not exist. I get the error "The user does not exist." when I attempt to add a new user in WSS. This is a new install of WSS. I have just started researching this error, any help regarding this message would be welcomed. Thanks... Tag: Must Declare the variable @SiteID Tag: 3080
  - 17
    - WSS and Project Server 2002 Can anyone tell me where I can find information about the integration of WSS and Project Server 2002? I can find info regarding project server 2003, but not 2002. We currently have Windows Services with Windows Server 2003 and would now like to stand up Project Server. However, we only have Project Server 2002. Any help or ideas would be appreciated. Thanks, Mark Tag: Must Declare the variable @SiteID Tag: 3073
  - 18
    - Info - 5 older "Developer Online Seminars" added to WebCasts in WSS FAQ In addition to the more recent 6 "Sharepoint" articles I added today to the WSS FAQ site (earlier posting), I've also added 5 Developer Online Seminars from the 16th of May 2003. Although these are naturally Beta-2 webcasts at least one of them (the WSS security one) doesn't seem covered by the more recent ones at all. Mike Walsh, Helsinki, Finland WSS FAQ at wss.collutions.com Please post questions to the newsgroup only. Tag: Must Declare the variable @SiteID Tag: 3063
  - 19
    - Soap example in vbscript for addition to doc lib ? Gary Hollfelder has asked me to post this message as he isn't getting through for some reason. ----------- I am looking for an example in vbscript using soap that will allow me to submit to the document location a graphic file, specific field information and folder location. I am also looking to accomplish is submit a document set and if the location folder does not exist to create a new one. ----------- (I haven't a clue btw) Anyone ? Mike Walsh, Helsinki, Finland WSS FAQ at wss.collutions.com Please post questions to the newsgroup only. Tag: Must Declare the variable @SiteID Tag: 3060
  - 20
    - Info - 10 new "ITPro" online seminars for "Sharepoint" http://www.microsoft.com/seminar/mmcfeed/mmcdisplay.asp?Lang=en&New=1&frame=true has a list of 10 online seminars that were posted on the 12th of December. All of them are about SharePoint with four of them specifying specifically SharePoint Portal Server and the remaining six "neutral". Times vary between 26 and 63 minutes. (I haven't yet listened to any of them) I shall be adding the addresses of the six non-SPS online seminars to the MS Articles / Webcasts section of the WSS FAQ. (Even though MS make extracting the addresses unnecessarily difficult it's not completely impossible) Mike Walsh, Helsinki, Finland WSS FAQ at wss.collutions.com Please post questions to the newsgroup only. Tag: Must Declare the variable @SiteID Tag: 3059
  - 21
    - Is it only me? Frontpage and Sharepoint RPC POST docs - a mess I'm trying to figure out how to use the Frontpage and Sharepoint HTTP RPC extensions. I'm trying to do a POST to do some command like "list themes", but the documentation seems to be a mess and I can't figure it out. Some of the docs say to use _vti_bin/owssvr.dll, some of the docs say to use _vti_bin/_vti_aut/owssvr.dll. Some of the docs say to use "Cmd=method name", and some of them say to use "method=method name". In any case, my POST is returning "(404) not found", a very cryptic and un-useful message if ever I saw one. Does anybody have experience with this stuff? A useful URL pointer, some sample code, perhaps? thanks. Note the part you need to remove in my email if you reply. Tag: Must Declare the variable @SiteID Tag: 3057
  - 22
    - Thesaurus and Stemming Supported by the search engine? Hi all, Just like to check if the above is supported by the search function provided by sharepoint services? Regards, Kit Kai Tag: Must Declare the variable @SiteID Tag: 3050
  - 23
    - During Setup: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. This is a multi-part message in MIME format. ------=_NextPart_000_000B_01C3D0E6.732AB4E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there!=20 After the Set Configuration Database Server installation page, I get the = following error. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (Error code: = 18456).=20 In this scenario I have specified the Network Service account = (IWAM_FS_SRV1) as the security account for the application pool used by = WSS. This error created an associated event log entry:=20 #50070: Unable to connect to the database on fs_srv1. Check the database = connection information and make sure that the database server is = running. Of course the Database is indeed running. I have also added the = IWAM_FS_SRV1 account to SQL directly with the appropriate 2 SQL rights, = though this may not even be nessesary for the Network Service account = (it would be for any other account). And I have confirmed that the = account is member of STS_WPG and IIS_WPG groups. I then changed the application pool identity to Local System (not = recommended!), to see if this would make a difference. And it does. The = Local System security context seems to have enough rights to succesfully = interface with SQL, create the database, etc. =20 But I am at a loss where the problem now lies, what rights or security = contexts I have forgotten about..=20 Hope someone can help. Cheers, Robert ------=_NextPart_000_000B_01C3D0E6.732AB4E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.3790.94" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi there! </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial = size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>After the Set Configuration = Database Server=20 installation page, I get the following error.</FONT></DIV> <DIV><SPAN class=3Dms-descriptiontext id=3DLabelMessage><BR><FONT = face=3DArial=20 size=3D2><EM>Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. = (Error code:=20 18456).</EM></FONT></SPAN><FONT face=3DArial size=3D2><EM> = </EM></FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>In this scenario I have specified the = Network=20 Service account (IWAM_FS_SRV1) as the security account for the = application pool=20 used by WSS.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT><BR><FONT face=3DArial = size=3D2>This error=20 created an associated event log entry: </FONT></DIV> <DIV> <P><FONT face=3DArial size=3D2><EM>#50070: Unable to connect to the = database on=20 fs_srv1. Check the database connection information and make sure that = the=20 database server is running.</EM></FONT></P></DIV> <DIV><FONT face=3DArial size=3D2>Of course the Database is indeed = running. I have=20 also added the IWAM_FS_SRV1 account to SQL directly with the appropriate = 2 SQL=20 rights, though this may not even be nessesary for the Network Service = account=20 (it would be for any other account). And I have confirmed that the = account is=20 member of STS_WPG and IIS_WPG groups.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I then changed the application pool = identity to=20 Local System (not recommended!), to see if this would make a difference. = And it=20 does.  The Local System security context seems to have enough = rights to=20 succesfully interface with SQL, create the database, etc.  = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>But I am at a loss where the = problem now lies,=20 what rights or security contexts I have forgotten about.. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Hope someone can help.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Cheers,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Robert</FONT></DIV></BODY></HTML> ------=_NextPart_000_000B_01C3D0E6.732AB4E0-- Tag: Must Declare the variable @SiteID Tag: 3049
  - 24
    - Drawing Graphs in a WebPart Hi Has anyone got an example of drawing a simple graph in a webpart, based on an x value for a number of items? I know we could use the Office webparts, but for a number of reasons this isn't an option for us. I am assuming it is possible to use the Drawing namespace and somehow draw into the webpart's canvas? Having only used renderWebpart to output text, I am not sure where to start. Anyone help a beginner ? Thanks Phil Tag: Must Declare the variable @SiteID Tag: 3048
  - 25
    - SharePoint recovery from MSDE mdf and ldf files. Is there a way that I can recover my SharePoint virtual servers... content from my MSDE mdf and ldf files? Lets pretend that something went horridly wrong and one of my servers died and all I have is a tape backup. Any step by step instructions would be apreciated. Tag: Must Declare the variable @SiteID Tag: 3043
- Next
  - 1
    - Info - META Group on WSS (and SPS 2003) http://www.theitportal.com/staticpages/metadeltanovember1p3.asp is the third page of a three page report on Office System 2003 and is the page where META Group write about WSS and SPS 2003. Makes for brief but interesting reading. Mike Walsh, Helsinki, Finland WSS FAQ at wss.collutions.com Please post questions to the newsgroup only. Tag: Must Declare the variable @SiteID Tag: 3039
  - 2
    - WSS Email alerts Hi, I had configured the WSS to send email alerts on a daily frequency. It was working fine and the users were getting those alerts. Suddenly the emails stopped coming. Can u please tell me how does WSS send email alerts. By how i mean what component does it use, and how do i configure that. I havent configured IIS SMTP with WSS to send emails. Would that be the problem. Also i have added another site in the IIS along with the WSS site. Would that be the problem Please help Jude Tag: Must Declare the variable @SiteID Tag: 3032
  - 3
    - Can't connect to configuration database on reinstall I was pointed here from the sts group. I debated titling this post "I'm an idiot" - because I sure feel like one. I was removing some old software from a server today, and accidentally uninstalled msde (I meant to select the item above msde in add/remove programs - feel free to make fun of me now). At that point, I probably *should* have just reinstalled msde, but I didn't notice the separate installation directory on the cd (this is sts 2.0 on server 2003). I reinstalled sharepoint, but now when I attempt to connect to the server, I get a "can't connect to configuration database" error. If I launch the administration pages on the server, and attempt to access the configuration pages for this virtual server, the config page can't be found. I've verified that the application pool is set properly in the IIS configuration for this web site, and I've also verified that the database it *should* be connecting to still exists. I'm willing to try anything to get this server back up. It's frustrating, because I think it shouldn't be that difficult... If it will help at all, I have an unused copy of SQL Server 2000 enterprise that I could install if the tools included with SQL would help me out. Any ideas? Tag: Must Declare the variable @SiteID Tag: 3030
  - 4
    - Using text formula in default value for a field Hello: I can't seem to figure out how to set up a text field so that the default value (for new records) is a concatenation of other fields in the same record. In this case, I have a single-line text field called "Full Name," and three other single-line text fields called "First Name," "Last Name" and "Honorific". According to the online help that comes up when I click the "Show more information" link on the Change Column page, I should be able to enter as a "Calculated (default) Value" a formula such as: =[Honorific]&" "&[First Name]&" "&[Last Name] and have WSS enter "Dr. Victor Zhivago" in the Full Name field after I type in "Dr.", "Victor", and "Zhivago" in the other fields. But in fact, when I enter that formula, WSS returns the error: The formula contains reference(s) to field(s). Well, duh. I encounter similar problems when trying to use date formulas to create calculated default values. So WSS seems to evaluate functions involving other fields correctly if the target field is of type "Calculated Value" but it does not do so to create a default value for a target field that can be edited. Or am I missing something? Editing the properties of the list in Frontpage2003 doesn't work either. Am I missing something? Any suggestions? TIA, Wayt Tag: Must Declare the variable @SiteID Tag: 3028
  - 5
    - Where's the SharePoint SQL Server database located? Where's the SharePoint SQL Server database located? In Sharepoint admin. I can see my database defined as MyServerName\SharePoint and a database called STS_MyServerName_1 But when I go into the MS SQL enterprise manager I only see the LOCAL database and no STS_MyServerName_1. Where's it hide? Tag: Must Declare the variable @SiteID Tag: 3021
  - 6
    - Author property wrong after migration Has anyone figured out a fix for this: I'm responsible for moving scores of files from our old portal repository to new WSS Document Libraries... I do so and suddenly, I'm the Author on all the documents... this is a BIG problem for us as I can't expect all the correct authors to "republish" their documents in various places... Michael Reinhart Tag: Must Declare the variable @SiteID Tag: 3019
  - 7
    - Sharepint 2.0 and SQL Do SQL server and sharepoint have to be on the same server? I have just upgraded to SQL 2000 and would like to install it on a different server than where I have Sharepoint installed, since SQL will be handling more than just sharepoint. I found information on migrating the content data to a server farm, but I just want to migrate it to a different server. thanks -k Tag: Must Declare the variable @SiteID Tag: 3012
  - 8
    - After installing sp After install share point on my 2003 win server, share point works fine, but none of the other vitural dir work anymore ? Help? Tag: Must Declare the variable @SiteID Tag: 3011
  - 9
    - Sites Listing I'd like to find a list of all the sites I've created and can't seem to find the button to list them all. (I've forgotten the exact names of a couple I know I've already created.) And btw, where does Sharepoint save all its files and then the data too? Thanks. Tag: Must Declare the variable @SiteID Tag: 3010
  - 10
    - Task Folders Anyway I can create folders for Tasks? We'd like to put tasks into folders such as, Developement Tasks, Testing Tasks, Thanks for any help. Ken Tag: Must Declare the variable @SiteID Tag: 3009
  - 11
    - Solution Accelerator for Recruiting Hi, I am having a problem (a few, actually) with the Solution Accelerator for Recruiting. Is this the right newsgroup for that component? If not, can you direct me to the right one? My first problem is that I have installed the pilot and are in the testing steps of the documentation. In planning for an interview, I get prompted for user name/password and then a "You are not authorized to view this page" error when I try to plan an interview. I have tried the following troubleshooting steps to no avail: - grant all domain users permissions on the Interview_Data form - grant all domain users permissions on the equivalent inetpub\wwwroot folder - grant all domain users permissions on the \Program Files\Microsoft Solutions\Information Worker\Recruiting\Interview Management \Server Components\Web Services folder - if i enable anonymous access on the recruiting web (equivalent to http://recruiting:81) then I get to the page but then I run into a SQL error. Any ideas as to why my installation is failing? Thanks, Teresa Tag: Must Declare the variable @SiteID Tag: 2994
  - 12
    - Migrating MSDE to SQL I need to migrate my MSDE to SQL database to have the search function working. What steps do I take? I don't want to lose any data. Tag: Must Declare the variable @SiteID Tag: 2989
  - 13
    - Alerts Anyways to put more specific information into the alerts? Tag: Must Declare the variable @SiteID Tag: 2988
  - 14
    - Info - new MS Solution Accelerator that uses WSS The latest MS Solution Accelerator (for Proposals) uses Windows SharePoint Services. You'll find it at http://www.microsoft.com/downloads/details.aspx?familyid=1a7c7900-f17d-4adf-959c-8e1a36c92da3&displaylang=en (December 30th 2003) Mike Walsh, Helsinki, Finland WSS FAQ at wss.collutions.com Please post questions to the newsgroup only. Tag: Must Declare the variable @SiteID Tag: 2979
  - 15
    - Info - the remit of this newsgroup [Given the occasional question here that is not covered by the remit of this newsgroup, it seems important to spell it out occasionally. This is the first attempt.]. This is the newsgroup for standalone Windows SharePoint Services (WSS). That's its main function. The products SharePoint Portal Server (SPS) 2003; Project Server 2003 and Small Business Server (SBS) 2003 (both editions) also include a WSS "element". (In the case of SPS 2003 this WSS element is a lower layer of the product. In the case of both Project Server 2003 and SBS 2003 this is an implementation of the WSS product itself which is installed in addition to the other product(s) in the package.) As most of the functionality of WSS is common between all four products mentioned above, it is sensible that discussion on those common functions take place here to avoid having parallel threads happening over several newsgroups. The "common" functions are those functions that are supplied with standalone WSS. Note - "Discussion on those *common* functions!" ONLY. What should not be discussed here are matters that require that particular product (SPS 2003; Project Server 2003; SBS 2003) to be present as these then do not fall under the "common functions" banner. These include for all three products *installation questions* and - for SPS 2003: web parts that are only supplied with SPS 2003 and not with standalone WSS; anything to do with the top layer such as My Site; Areas etc. for Project Server 2003: any special web parts supplied only with Project Server 2003; and special list types provided in the Project Server 2003 implementation of WSS. for SBS 2003: any special web parts supplied only with SBS 2003 (possibly there are none); and special list types provided in the SBS 2003 implementation of WSS (such as the Fax Library). Please try to follow the above guidelines when deciding whether to post to this newsgroup or whether it is best to post to the Product's own newsgroup. Please do not multi-post - people running standalone WSS do not want "their" newsgroup filled with threads that have no relevance to standalone WSS. Mike Walsh, Helsinki, Finland WSS FAQ at wss.collutions.com Please post questions to the newsgroup only. Tag: Must Declare the variable @SiteID Tag: 2978
  - 16
    - Upgrade a server or virtual server Ok I upgraded using Setupsts.exe I go to my Extend or Upgrade a Virtual Server list and I click on a specific Virtual Server I want to upgrade and it pops up a window displaying the following message: Upgrade a server or virtual server To upgrade your server to Microsoft Windows SharePoint Services, run Setupsts.exe. Running Setupsts.exe upgrades your server and the default virtual server. If you have additional virtual servers to upgrade, you can upgrade each virtual server individually by using the upgrade operation with the Stsadm.exe command-line tool. Click Start, point to All Programs, point to Accessories, and then click Command Prompt. Navigate to the C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\Bin folder. Type stsadm.exe -o upgrade -url <URL>, where <URL> is the URL of the virtual server you want to upgrade. I go ahead and follow the directions and a little SharePoint Setup window pops up telling me to wait while Setup upgrades my SharePoint sites and that it might take a few minutes to a few hours depending on the size of my site the *poof* it goes away and in my command prompt i get the following message: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denie d. (Error code: 17). Any suggestions? Tag: Must Declare the variable @SiteID Tag: 2970
  - 17
    - Disaster Recovery If your server crashed today, how would you restore all of your WSS sites? Anyone have to deal with this? Is it even possible to restore from databases? I've tried creating a new site, and restoring the database, but it does not work. TIA. Tag: Must Declare the variable @SiteID Tag: 2968
  - 18
    - Making Companyweb available to internet users How do I accomplish this? If i fwd port 80 it goes to my default SBS homepage which is http://servername - from there is a link to http://companyweb Thanks Tag: Must Declare the variable @SiteID Tag: 2966
  - 19
    - Small Business Server 2003 issues? I'm interested in installing WSS on a Small Business Server 2003 platform and hope to identify any issues that may be of concern. Does anybody have any comments related to WSS on SBS? -- <%= Clinton Gallagher A/E/C Consulting, Web Design, e-Commerce Software Development Wauwatosa, Milwaukee County, Wisconsin USA NET csgallagher@REMOVETHISTEXTmetromilwaukee.com URL http://www.metromilwaukee.com/clintongallagher/ Tag: Must Declare the variable @SiteID Tag: 2964
  - 20
    - Lookup column limit Is there any way to change the maximum number of lookup columns allowed in a list? We've gotten up to 16 but can't create any more. This is the error we receive: "There are too many columns of the specified data type. Please delete some other columns first. Note that some column types like numbers and currency use the same data type." Is this a problem in SPS 2003? Tag: Must Declare the variable @SiteID Tag: 2961
  - 21
    - Connecting a Web Part in the Display Form I'm looking to add a web part to my list display form (dispform.aspx) that shows related records in another list. The related records are designated using a lookup field. When I add the part to the page however, it doesn't seem to enable me to add a connection to the existing display form fields. Is there any way of getting this scenario to work? It would make for a fantastic master/detail view. Thanks! Colin Tag: Must Declare the variable @SiteID Tag: 2960
  - 22
    - KB Article removed - anyone know why ? "Unable to Connect to Database" Error Message When You Connect to a Windows SharePoint Services Site After You Upgrade WMSDE to SQL Server that was dated 3rd December is no longer available at the address http://support.microsoft.com/?kbid=831105 does anyone know why? I remember this being a useful article. Mike Walsh, Helsinki, Finland WSS FAQ at wss.collutions.com Please reply to the newsgroup Tag: Must Declare the variable @SiteID Tag: 2958
  - 23
    - Webpart migration I have a custom webpart on my page. When I move the site to another server using smigrate, the webpart does not migrate over. Is this normal? Tag: Must Declare the variable @SiteID Tag: 2953
  - 24
    - View List Accross multiple sites Is it possible to create a consolidated list view of multiple list across multiple sites? Thanks Tag: Must Declare the variable @SiteID Tag: 2950
  - 25
    - Link to Outlook button is not there I am trying to link my events calendar in Sharepoint to my Outlook calendars. I've done this on several other machines but have a machine that does not have the "Link To Outlook" link available. I've looked at the site configurations and don't see anything that allows me to show or not show this option. Tag: Must Declare the variable @SiteID Tag: 2949

We are trying to install WSS with Server Farm option.
We get an error

"Must Declare the variable '@SiteID". (Error Code -
137)."...

when it goes to create a new site and a new content
database. Configuration database was created succesfully.

Does anybody know how to manage this?

Top

Re: Must Declare the variable @SiteID by Iyaz

Iyaz
Mon Jan 05 13:07:39 CST 2004

To resolve this problem, use case-insensitive collation for your SQL
Server.. The collation for SQL Server 2000 is done at setup time I think.
Uninstall and reinstall SQL with case-insensitive collation.
-Iyaz

"Bogdan Chernyachuk" <anonymous@discussions.microsoft.com> wrote in message
news:086301c3d39f$39987760$a601280a@phx.gbl...
> We are trying to install WSS with Server Farm option.
> We get an error
>
> "Must Declare the variable '@SiteID". (Error Code -
> 137)."...
>
> when it goes to create a new site and a new content
> database. Configuration database was created succesfully.
>
> Does anybody know how to manage this?

Top