Adding Certificates for SSL connection for a user account in Windows 2008 Server

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? 

Full reported error

StdOut -2068578304: The following error occurred:
The Windows account doman\user does not exist and cannot be provisioned as a SQL system administrator
Error result: -2068578304
Result facility code: 1204
Result error code: 0

domain/user is a domain administrator and also a local administrator and is the currently logged in user.  This failure is happening as part of A Citrix XenApp 6.0 configuration which was started as an Administrator

A Google search for
"The Windows account" "does not exist and cannot be provisioned as a SQL system administrator"
Came up with absolutely nothing.


A Google search for -2068578304 failed to find anything, which did not surprise me.

-2068578304 translates into hex as 84B40000.

A Google search for 84B40000

Comes up with a fair few different textual descriptions with the same error code, which I am wading through.

Any help would be welcome.  I am also asking my friends at Citrix.

With thanks in advance.

JC

Hello,

Hoping someone can help me with this one...apologies if I am in the wrong forum.

I have a small VBScript snippet that I can run on my desktop (Win XP 32bit) without any issue.

I'm now ready to put this code on our Win 2008 R2 server that runs scheduled jobs.

Here is a small piece of the code I am trying to get to work:

strConOracle = "DSN=test;Uid=test;Pwd=test;"

Set oConOracle = CreateObject("ADODB.Connection")
oConOracle.ConnectionString = strConOracle

msgbox (oConOracle.connectionstring)

oConOracle.Open

msgbox "State:" & oConOracle.state

oConOracle.Close

msgbox "State:" & oConOracle.state

Set oConOracle = Nothing

I've used the odbcad32.exe under C:\Windows\SysWOW64 to create my data source which connects to an Oracle DB.

I've tested an Oracle connection from both the odbcad32.exe and from sqlplus. Both connections are successful.

However, when I use the odbcad32.exe under C:\Windows\System32, I only see 1 driver "Sql Server". I don't see any other ODBC, OLE DB, Oracle drivers.

I've tried changing my connection string to a DNS-Less string, but I always get one of the 2 errors below:

Error: "

Hi,

I know there are similar questions posed but none that provided a solution to my particular problem.

I am upgrading a SSIS package from Sql Server 2005 (32bit) to Sql Server 2008 (64bit) on Windows Server 2008 R2. It worked on the Sql Server 2005 machine. This package connects to an Oracle 10g (64bit) database.

The Oracle 11g client and networking tools are installed (by the Oracle DBA). I tested my connection on the sql server 2008 machine using SqlPlus and doing a tnsping. I can also create a Windows ODBC datasource connection to the Oracle 10g database.

The package executes properly on my local computer XP (32bit) running bids 2008.

The package fails on the server in SSIS. I need to be able to schedule the package in a job so it must run in SSIS.

I have also tired to create a connection manager to the Windows ODBC oracle connection without success. It is blank and does not allow me to select or refresh to view the Windows ODBC datasources.

Any assistance would be greatly appreciated. I have seen other forums where installing the Oracle 11g ODAC and Oracle Developer Tools for Visual Studio might assist in creating the package. But I need assistance in running the package from SSIS and not BIDS.

Thanks,

Jan

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
  

  Sql server Management studio 2005 64 bit connection failed on windows server 2008 R2

    

  Recently i have installed windows server 2008(64 bit) now  i host to run virtual directory with database on local host. for that purpose i installed Sql server managemnet studio express (64 bit) and SqlExpress.exe (32 bit) based on information given internet .

  Now i make Virtual directory successfully but not able to login into application(build on visual studio 2005 with framework 2.0) , so that database connection not working

  I used following connectstring in web config file

  <connectionStrings>
      <add name="ConnectionString" connectionString="Data Source=./SqlExpress;Initial Catalog=Ecohomes;Integrated security = True; " providerName="System.Data.SqlClient"></add>
    </connectionStrings>

   

  
  

  MS SQL Server 2008 sa account locked out and Windows Authentication login is greyed out

    

  down vote favorite

  Hi, The sa account got locked out and even though mixed mode authentication is enabled. When I select "Windows Authentication" the Username and Password fields are greyed out. The username field contains my current windows logon and the password field is blank. I am logged in with a windows administrator account though I hadnt explicitly added this account to the SQL server sysadmin role. I have also tried "Run as Administrator" with the SQL server management studio but the problem persists Please note that SQL server was installed with another windows administrator account. Could this be the reason ? Will it work if I login with the account with which SQL server was installed ?