Publish and test a WebMatrix web site using a Local Windows Server 2008

No matter What I do, I can't seem to authenticate to SSRS using a local windows account unless that account is a member of administrators. Is there some sort of special role that local users need to be a member of to authenticate properly?

When I attempt to access reporting services, am prompted with a login window asking for login as password. If is use a local admin account it works fine, if I use a local user account, it prompts me again two times and then just shows a blank page. 

NOTES:

• I've tried adding the local non-admin user account to all of the SQLServer groups but no luck.
• I've tried deleting and creating a new local user account with the same group membership as above, but no luck.

• SQL 2005/2008 on Windows Server 2008 R2 cluster - Service only starts when account is local admin

    

  I have a single node Windows Server 2008 R2 cluster configured with SQL Server 2008 Enterprise Edition installed as a clustered instance.

  I am having an issue where the SQL Server service will only start using TCP/IP when the service account is a member of the local admins group. To get SQL to install I had to add the sql server service account to the local admins group.

  I have configured group policy with the permissions required for SQL Server 2008 and this is correctly applied to the node.

  Errorlog shows the following...

  Error: 26054, Severity: 16, State: 1.
  2010-05-05 15:23:41.98 Server      Could not find any IP address that this SQL Server instance depends upon.  Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available.  Error code: 0x5.

  
  2010-05-05 15:23:41.98 Server      Error: 17182, Severity: 16, State: 1.
  2010-05-05 15:23:41.98 Server      TDSSNIClient initialization failed with error 0x5, status code 0xa. Reason: Unable to initialize the TCP/IP listener. Access is denied.

  2010-05-05 15:23:41.98 Server      Error: 17182, Severity: 16
  

  Word Automation Issue in Windows Server 2008 Hosting

    

  Hi,

  The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

  Word Automation in sample ASP.NET(C#) application.

  I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.
  

  When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

  But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

  Data: System.Collections.ListDictionaryInternal
  Message: Word has encountered a problem.
  Source: Microsoft Word

  The code gets failed in the following line:

  ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

  Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line
  

  I cannot able to proceed further. Can anybody please help me in solving this issue?
  

  Thank you.

  
  

  With Regards,

  Ashok
  

  
  

  
  

  No ASPNET User in Windows Server 2008?

    

  I have been looking everywhere online regarding this, but have not found a clear answer.

   

  I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.

   

  I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.

   

  I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.

   

  Did I set the server up wrong? or do I have to do something within ASP.Net to  create this user and then give it rights? 

  
  

  Not working on Windows Server 2008

    

  Hi,

   

  I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.

  We are using SharePoint 2007.

  Is there another work thru for 64bit environment.

  I notice windows server 2008 has a directory  C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???

  Please help!

  
  

  How can Install Office 2007 on Windows server 2008 R2 64 bit machine in WSS 3.0

    

  I have  64 bit machine  and Windows server 2008 R2 has installed. i have successfully install WSS 3.0  , but  when i tried to install  office 2007 ,  one  error  has  come  "OS is not compatible "  i thought  it was asking  for 64 bit office  2007   and i go through the  google and R&d find no 64 bit office is available ,  i have used   excel .dll in my custom code  so my problem is that   how can  install office 2007  on 64 bot OS 2008 r2  machine .  if anyone can help   me  , please let me know . thanks in advance
  

  VS Studio WorkFlow Failed on Start in MOSS 2007 ON Windows Server 2008 64 Bit

    

  I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.

  But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.

  I repaired .NET Framework 3.5sp1 installed

   tried this

   1. I tried again, in C Prompt:  Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"  it says initiation file cannot be found

  2   i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"

  it says reloaded  from the system restored

  i am still getting the same error.

  When i manually go to my  C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..

  I dont know what is happening i am trying it from 2 days and still no solution.

  any ideas would be real great help for me.

  My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.

  .Net Framework 3.5 sp1

  and WSP builder the one from Codeplex for 64 bit machines

  
  

  How to connect to local instance of SQL Server 2008 Management Studio Express ?

    

  I just installed SQL Server 2008 Management studio Express on my Vista machine.
  
  i tried connecting to local machine using :
  
  .\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress
  
  nothing is working, getting this error:
  
  -----------------------------
  Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
  ----------------------------

  
  

  MS Word Component Not Getting Created on Windows 2008 64 bit Web Server Edition When I Try Using ASP

    

  Hi All, This might look like a similar question to a lot of you considering there are a lot of web activity happening in terms of blogs/forums/suggestions that I have seen with reference to changes that one needs to do in COM+ Services to enable their ASP.NET Web Application to be able to create Word Objects & I have actually used them personally & they worked for me on Windows 2003 32 bit/64 bit servers. The issue started some 1 month back when I was told that we are upgrading our server to Windows 2008 Web Server edition 64 bit ‘cause of some real benefits it offers if used only as a web server. This was just great as we tested a lot of features /functionality that we were using on our existing server & everything seems to be working just fine on this product by Microsoft. However we also have one web module which is responsible for opening up a MS Word 2007 template file at runtime and fill it with data & is then converted into a PDF document. A lot of ideas on Web suggested that we should move onto Open XML standards to generate documents at runtime, which I have been able to do with no issues. But one activity which still requires me to create a Word document is when I have to convert/SaveAs the Word (docx) document into PDF. I tried all the COM+ & registry related changes that I did on my Windows 2003 64 bit server, but nothing seems
  

  Can't Create ODBC to Local SQL Server Express 2008

    

  Hello. I have SQL Server Express 2008 SP1 LOCALLY on my Windows XP Professional SP3 box. I have databases already created in Access 2007 that I imported into SQL. Now I want to keep the front end Access forms for data entry but have them connect to the databases in SQL. What I can't seem to do is connect from Access to the SQL db's because I can't create the ODBC connection. When I try to connect, I get the following two 'Connection failed' errors: 1. SQLState: '08001' SQL Server Error: 10061 [Microsoft][SQL Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it. 2. SQLState: 'HYT00' SQL Server Error: 0 [Microsoft][SQL Server Native Client 10.0]Login timeout expired Additionally, this information may help. 1. Windows firewall is turned off. 2. In SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLEXPRESS, Shared Memory, Named Pipes and TCP/IP are all 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). 3. In SQL Server Configuration Manager > SQL Native Client 10.0 Configuration > Client Protocols, the above three are also 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). Double-clicking TCP/IP tells me that the default port is 1433. 4. Running "netstat -ano", I see no entries for [myIPaddress]:1433.
  

  Remote access to SQL-Server 2008 R2 on Windows Server 2008 denied

    

  Hello, after successful installation of SQLServer 2008 R2 and providing my account as a 'sysadmin' I failed to access the server from a management studio of a SQL-Server 2005 release installation. The TCP/IP access is enabled and the server is configured to allow access from remote connections.  The error message reads a follows: ' A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify ... (Provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error:2)' Accessing the SQL-Server by the management studio from the local host works fine but trying to acces by command line using the '-E' parameter fails. Is there any additional configuration on the operation system level needed to open a SQL-Server 2008 instance to be selected by other members of  domain groups from the non-local host? Thank you for the answer  
  

  SQL Server 2008 Installation issue in Windows 7 64 bit

    

  I'm trying to install SQL 2008, but an error message keeps appearing: Microsoft .NET Framework 3.5 installation has failed. SQL Server 2008 Setup requires .NET Framework 3.5 to be installed.   My OS is Windows 7 Ultimate 64 bits, so already has de .NET Framework 3.5, I turned on/off a lot of times and the same error occurs! I download the .NET Framework 3.5 and .NET Framework 3.5 SP1 from the links: (http://www.microsoft.com/downloads/details.aspx?FamilyId=333325fd-ae52-4e35-b531-508d977d32a6&displaylang=en http://www.microsoft.com/downloads/details.aspx?familyid=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en) But, when installing the Framework 3.5 or the SP1, I get the message: "Use turn on or off disable features in Windows control panel".   Someone can help me?! - Windows 7 Ultimate 64 bits - SQL Server 2008 Developer (x86, x64, ia64).   Thanks! Marcelo.
  

  SQL express 2008 r2 on windows server 2003

    

  install ends with the following error : "MsiEnumRelatedProducts failed to enumerate products with UpgradeCode='{1B117BA7-5BC1-419E-820E-7D4F3F412C7B}'. Error code: 1610."
  

  SQL Server 2008 R2 fails after Windows XP Pro SP3 install

    

  We recently encountered an issue with SQL Server 2008 R2 failing to run after the upgrade from Windows XP Pro SP2 to SP3. This was tested and reproduced (with varying results) on more than one computer. Steps to reproduce this. On a Windows XP Pro machine with Service Pack 2 installed, install SQL Server 2008 R2. Next upgrade Windows to Service Pack 3. Now upon opening SSMS or trying to start the SQL server service you receive the following message: "This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem". In some instances reinstalling/repairing SQL Server 2008 R2 does fix the issue.  In other cases the installer crashes and you need to use msizap to clean it up before you can reinstall.  In other cases you do not receive any errors at all. After testing in multiple virtual machines it looks like the cleaner the Windows install the more likely you are to run into this issue.  On machines with most or all windows updates (prior to SP3) installed you do not necessarily even get the failure.  On machines with just Windows XP Pro SP2 installed with no additional updates you get the failure every time. Obviously the SQL Server 2008 R2 prerequisites are installed in all cases in order to be able to install SQL server to begin with. Any help with this would be appre
  

  Snap in sample on windows server 2008

    

  Hello. I am trying to test the snap in sample introduced in the snap in guideline: http://msdn.microsoft.com/en-us/library/ms692759%28v=VS.85%29.aspx   I was able to build and install the snap. However, when I try to add the snap in in the mmc console, the following error appairs: FX:{6732a1ed-c9bf-4c01-a5e5-9c779d1a73c8} System.IO.FileNotFoundException    at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)    at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)    at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)    at System.Activator.CreateInstance(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo, StackCrawlMark& stackMark)    at System.Activator.CreateInstance(String assemblyName, String typeName)    at System.AppDomain.CreateInstanceAndUnwrap(String assemblyName, String typeName)    at Microsoft.Manageme
  

  Server 2008 R2 Express accepts only local connections?

    

  My question SQL Server 2008 R2 Express accepts only local connections? [closed] was closed unanswered and my account (with the same username/nick vgv8) was banned in 1 min without any warning and notification from all StackExchange sites (StackOverFlow.com, ServerFault.com, SuperUser.com). I could not understand can MS SQL Server 2008 R2 Express  accept remote connections? And what are local connections - in the same subnetwork, AD, workgroup, the same machine?