error during quiet installation of June CTP.

I am trying quiet installation of June CTP with the .ini file .

The installation is failing with Last Action :Install Finalize:
The sql server service failed to start.
Error number:29523
--
My ini file settings were as folllows
[snip]
SQLBROWSERACCOUNT= "NT AUTHORITY\LOCAL SERVICE"
SQLBROWSERPASSWORD=

SQLACCOUNT="NT AUTHORITY\LOCAL SERVICE"
SQLPASSWORD=

AGTACCOUNT="NT AUTHORITY\LOCAL SERVICE"
AGTPASSWORD=

ASACCOUNT=
ASPASSWORD=

RSACCOUNT=
RSPASSWORD=
[snip]
-
As mentioned in one of the mails in the group i changed the three accounts to
"NT AUTHORITY\LOCAL SYSTEM".

Now i get new errors as follows
Last Action : Validate_ServiceAccounts
Error String : SQL Server Setup was unable to validate the account or accounts you provided. To continue, verify that the user name, password, and domain name are correct, or provide another user account for SQL Server service login.
The logon account cannot be validated for the service SQL Browser.
Error Number : 29609
--

One observation is that the installation goes fine with <domain\user> and providing the password . But in my case i will have to ship the ini file with the product and dont the the settings on the customer system.
So i cannot use domain user.

Try removing the unused parameters (e.g. SQLBROWSERPASSWORD=, ASACCOUNT=, etc). When using a built-in account the password parameter is not necessary. Also, if you're installing on a localized OS (e.g. German or French) you need to pass the localized version of the built-in account. For example, Local System on a German OS is: NT-AUTORIT?T\SYSTEM

You can find the complete list in the setup help file, setupsql9.chm, under the topic Setting Up Windows Service Accounts.

If you still get errors please post your entire .ini file here.

Dan|||

Hello Dan,

Thanks for your reply.

I have made changes as per your suggestions , but still getting the validation error.

Last Action : Validate_ServiceAccounts
Error String : SQL Server Setup was unable to validate the account or accounts you provided. To continue, verify that the user name, password, and domain name are correct, or provide another user account for SQL Server service login.
The logon account cannot be validated for the service SQL Browser.
Error Number : 29609

Here is the test.ini file.

-
[Options]
;--
; If USERNAME or COMPANYNAME are not specified, the default operating system username and company name values for the server are used.
; Note: If names contain spaces, surround the names with quotes.

USERNAME=test
COMPANYNAME=test
;--
; Usage: PIDKEY=ABCDE12345FGHIJ67890KLMNO (This is not an actual key value.)

; NOTE: For the SQL Server 2005 CTP releases, the following PIDKEY command is not required
; because the PIDKEY parameter for the MSI file is preset. However, the final released version
; of SQL Server 2005 will require the PIDKEY parameter.
; NOTE: PIDKEY is not required for SQL Server Express Edition.
; NOTE: Do not include "-" in the PIDKEY.

;PIDKEY=
;--
; INSTALLSQLDIR specifies the location for the instance specific binary files.
; Default location is: %ProgramFiles%\Microsoft SQL Server\
; To use the default path, do not specify the following parameter.

; NOTE: INSTALLSQLDIR is REQUIRED for clustered installations and must point to a local
; drive for which the drive letter exists on all nodes in the cluster definition.
; NOTE: If there is a space in a specified path, surround the path with quotes
; and end every path with a '\'.

INSTALLSQLDIR="C:\Program Files\Microsoft SQL Server\"
;--
; INSTALLSQLSHAREDDIR specifies a custom location for Integration Services
; Notification Services, Client Components, SQL Server Books Online and Samples.
; To use the default path, do not specify the following parameter. Default path is %ProgramFiles%\Microsoft SQL Server\

; If Tools components are already installed on the computer, this parameter is ignored.
; NOTE: If there is a space in a specified path, surround the path with quotes
; and end every path with a '\'.

; The installation paths will be:
;<InstallDir>\90\DTS
;<InstallDir>\90\Notification
;<InstallDir>\90\Tools

INSTALLSQLSHAREDDIR=
;--
; INSTALLSQLDATADIR specifies the location for the SQL Server data files.
; Default: INSTALLSQLDIR\Data\
; To use the default path, do not specify the following parameter.

; NOTE: INSTALLSQLDATADIR is REQUIRED for clustered installations and must point to a
; shared drive which is a member of the cluster group specified for installation.
; NOTE: If there is a space in a specified path, surround the path with quotes
; and end every path with a '\'.

INSTALLSQLDATADIR=
;--
; INSTALLASDATADIR specifies the location for the Analysis Server Data Files.
; Default: INSTALLSQLDIR\Data\
; If Analysis Server is already installed on the computer, this parameter is ignored.
; To use the default path, do not specify the following parameter.

; NOTE: Do not use with a SQL Server Express installation.
; NOTE: If there is a space in a specified path, surround the path with quotes
; and end every path with a '\'.

INSTALLASDATADIR=
;--
; ADDLOCAL specifies which components to install. If ADDLOCAL is not
; specified, setup will fail.
; See SQL Server Books Online for more information on this topic.

ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,Client_Components,Connectivity,SQL_Tools90,SQL_Profiler90,SQLXML,SQL_Documentation,SQL_BooksOnline,SQL_SQLServerBooksOnline

INSTANCENAME=MSSQLSERVER
;--
; The UPGRADE property specifies which product to upgrade.
; The allowed values are SQL_Engine, RS_Server and AS_Server.
; If the UPGRADE option is specified, the INSTANCENAME parameter
; is REQUIRED to define which instance to upgrade.

;--
; The services for SQL Server and Analysis Server are set auto start. To use the *ACCOUNT settings
; make sure to specify the DOMAIN, e.g. SQLACCOUNT=DOMAINNAME\ACCOUNT
; NOTE: When installing SQL_Engine 3 accounts are REQUIRED: SQLACCOUNT, AGTACCOUNT and SQLBROWSERACCOUNT.
; SQLACCOUNT Examples:
; SQLACCOUNT=<domain\user>
; SQLACCOUNT="NT AUTHORITY\SYSTEM"
; SQLACCOUNT="NT AUTHORITY\NETWORK SERVICE"
; SQLACCOUNT="NT AUTHORITY\LOCAL SERVICE"

;Note that if SQLBrowser is already installed, SQLBROWSERACCOUNT and SQLBROWSERPASSWORD are ignored.
SQLBROWSERACCOUNT= "NT AUTHORITY\LOCAL SYSTEM"
;SQLBROWSERPASSWORD=

SQLACCOUNT="NT AUTHORITY\LOCAL SYSTEM"
;SQLPASSWORD=

AGTACCOUNT="NT AUTHORITY\LOCAL SYSTEM"
;AGTPASSWORD=

;ASACCOUNT=
;ASPASSWORD=

;RSACCOUNT=
;RSPASSWORD=
;--
; To use the *AUTOSTART features, specify 1 to start automatically or 0 to start manually.
; NOTE: If you decide to start SQL Agent automatically, then SQL is also started automatically.
; If *AUTOSTART is not specified on the command line, startup is set to manual.

SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
AGTAUTOSTART=1
ASAUTOSTART=0
RSAUTOSTART=0
;--
; To use Mixed mode authentication, use SECURITYMODE=SQL.
; If SECURITYMODE=SQL is not specified, then Windows Authentication only will be used by default.
; If you use SQL Authentication, you are REQUIRED to provide a strong system administrator (SA) password.
; If you use Windows Authentication, the SA account will be disabled.
; To set SA password specify SAPWD.

SECURITYMODE=SQL
SAPWD=Ericsson
;--
; SQLCOLLATION specifies the collation for Database Services.
; ASCOLLATION specifies the collation for Analysis Server.
; See SQL Server Books Online for more information on collation options.

SQLCOLLATION=SQL_Latin1_General_Cp1_CS_AS
ASCOLLATION=SQL_Latin1_General_Cp1_CS_AS
;--

I am not able to figure out what is wrong with this file.
However as specified in the setupsql9.chm file i am successfully installing from
command line using

Start /wait <DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> ADDLOCAL=SQL_Engine,SQL_Replication SAPWD=<StrongPassword>

Here nothing is specified about the service accounts . It seems specifying them
i am gettting into trouble.

Regards
Ray

|||

I have tried removing all the accounts related information from the inin file . Then installation fails with

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_DNASERVER3_SQL.log
Last Action : SetUnattendedSvcAccountProp
Error String : SQL Server Setup has determined that the following account properties are not specified: 'SQLBROWSERACCOUNT, AGTACCOUNT, SQLACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.
Error Number : 28006

Ray

|||

Well the ini file should be like this ..
[snip]
SQLACCOUNT="NT AUTHORITY\SYSTEM"
;SQLPASSWORD=

AGTACCOUNT="NT AUTHORITY\SYSTEM"
;AGTPASSWORD=

SQLBROWSERACCOUNT= "NT AUTHORITY\SYSTEM"
;SQLBROWSERPASSWORD=

;ASACCOUNT=
;ASPASSWORD=

;RSACCOUNT=
;RSPASSWORD=
[snip]

I had put "NT AUTHORITY\LOCAL SYSTEM" instead.. A very painful oversight.

However there is a new problem . On 2003 server installation goes on just fine
but on 2000 server it fails with ->[Microsoft][SQL Native Client]Encryption not supported on the client. Refer to the blah blah blah.

On 2003 i have cryptography sercices running ...
Has neone faced this problem before

|||

Well the ini file should be like this ..
[snip]
SQLACCOUNT="NT AUTHORITY\SYSTEM"
;SQLPASSWORD=

AGTACCOUNT="NT AUTHORITY\SYSTEM"
;AGTPASSWORD=

SQLBROWSERACCOUNT= "NT AUTHORITY\SYSTEM"
;SQLBROWSERPASSWORD=

;ASACCOUNT=
;ASPASSWORD=

;RSACCOUNT=
;RSPASSWORD=
[snip]

I had put "NT AUTHORITY\LOCAL SYSTEM" instead.. A very painful oversight.

However there is a new problem . On 2003 server installation goes on just fine
but on 2000 server it fails with ->[Microsoft][SQL Native Client]Encryption not supported on the client. Refer to the blah blah blah.

On 2003 i have cryptography sercices running ...
Has neone faced this problem before?

Ray

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specifiedProbably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!sql

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube
,
the wizard successfully finds and connects to the cube, but when I click
'finish' to retrieve the data, I get the following error:
"Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again. If you
see this message again, create a new data source to connect to the database.
"
Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
CTP) running on the same machine.
Thanks,
--
DuncanHi Duncan
I have the same error.
I have Excel 2000 and Excel 2003 installed on my pc and SQL server 2000 and
SQL Server 2005 installed on a server. It seems that I can use most
combinations of these 2 - Excel 2000 will read data from SQL server 2000 and
2005, Excel 2003 will read data from SQL Server 2000 cubes.
But I get the same error as you when I try to read data from SQL Server 2005
Analysis Services Cubes from Excel 2003. It knows the cubes are there but
can't read the data.
Did you manage to resolve this? Can anyone else help?
Regards
Dave
"Duncan" wrote:

> When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cu
be,
> the wizard successfully finds and connects to the cube, but when I click
> 'finish' to retrieve the data, I get the following error:
> "Initialization of the data source failed.
> Check the database server or contact your database administrator. Make sur
e
> the external database is available, and then try the operation again. If y
ou
> see this message again, create a new data source to connect to the databas
e. "
> Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
> CTP) running on the same machine.
> Thanks,
> --
> Duncan|||If you found a solution, please let me know. I'm getting the same error
message.
Thanks a lot.
Duncan wrote:
> *When I use the PivotTable Wizard in Excel 2003 to connect to a SQL
> 2005 cube,
> the wizard successfully finds and connects to the cube, but when I
> click
> 'finish' to retrieve the data, I get the following error:
> "Initialization of the data source failed.
> Check the database server or contact your database administrator.
> Make sure
> the external database is available, and then try the operation again.
> If you
> see this message again, create a new data source to connect to the
> database. "
> Any ideas what could be causing this? I have Excel 2003 and SQL 2005
> (June
> CTP) running on the same machine.
> Thanks,
> --
> Duncan *
hpanneflek
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1781676.html|||hpanneflek wrote:
> *If you found a solution, please let me know. I'm getting the same
> error message.
> Thanks a lot. *
I got around this by re-registering the OLAP v9.0 dll:
regsvr32 c:\program files\common files\system\oledb\msolap90.dll
This worked for me.
Good luck
Dave
Daffyd
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1781676.html|||Thank you! It worked.
I've been using AS 2K for 3 years now and I love it. I started playing
with AS2K5 and I am realizing that a lot of things changed. My email is
hpanneflek@.univision.net in case you have any question, I'll be glad to
help.
Thanks again.
Daffyd wrote:
> *I got around this by re-registering the OLAP v9.0 dll:
> regsvr32 c:\program files\common files\system\oledb\msolap90.dll
> This worked for me.
> Good luck
> Dave *
hpanneflek
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1781676.html

Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
the wizard successfully finds and connects to the cube, but when I click
'finish' to retrieve the data, I get the following error:
"Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again. If you
see this message again, create a new data source to connect to the database. "
Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
CTP) running on the same machine.
Thanks,
Duncan
Hi Duncan !
Have you got to resolve this problem ?
Unfortunately I also have it in my environment.
If possible tell me what you did.
Thank you !
Aduir.

Quote:

Originally posted by Duncan
When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
the wizard successfully finds and connects to the cube, but when I click
'finish' to retrieve the data, I get the following error:
"Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again. If you
see this message again, create a new data source to connect to the database. "
Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
CTP) running on the same machine.
Thanks,
Duncan

|||Hi both - I have exactly the same problem. Did you ever find a solution to this?
Yours in hope,

Quote:

Originally posted by Duncan
When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
the wizard successfully finds and connects to the cube, but when I click
'finish' to retrieve the data, I get the following error:
"Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again. If you
see this message again, create a new data source to connect to the database. "
Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
CTP) running on the same machine.
Thanks,
Duncan

|||Hi Duncan
I have the same error.
I have Excel 2000 and Excel 2003 installed on my pc and SQL server 2000 and
SQL Server 2005 installed on a server. It seems that I can use most
combinations of these 2 - Excel 2000 will read data from SQL server 2000 and
2005, Excel 2003 will read data from SQL Server 2000 cubes.
But I get the same error as you when I try to read data from SQL Server 2005
Analysis Services Cubes from Excel 2003. It knows the cubes are there but
can't read the data.
Did you manage to resolve this? Can anyone else help?
Regards
Dave
"Duncan" wrote:

> When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
> the wizard successfully finds and connects to the cube, but when I click
> 'finish' to retrieve the data, I get the following error:
> "Initialization of the data source failed.
> Check the database server or contact your database administrator. Make sure
> the external database is available, and then try the operation again. If you
> see this message again, create a new data source to connect to the database. "
> Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
> CTP) running on the same machine.
> Thanks,
> --
> Duncan