Problem in Installing Sql Server 2005 Developer Edition

I tring to install SQL Server 2005 Developer Edition on Windows XP Pro but i not able to to so because of the following errors:-

Action "OpenPipeAction" failed during execution

Action "CreatePipeAction" failed during execution.

MsiOpenDatabase failed with 87

MsiOpenDatabase failed with 87 for MSI

Action "InstallDTSAction.9" failed during execution. Error information reported during run:
Action: "InstallDTSAction.9" will be marked as failed due to the following condition:
Condition "Package "9" either passed when it was last installed, or it has not been executed yet" returned false. Condition context:
Prereq package will be failed due to the previous installation attempt returning: 1605

Can Anyone help me out on this?

Thanks

VG

It seems that there are 2 versions of MSXML6 running on my machine using add remove programs was useless. If you use Windows Intall Clean Up tool to remove all traces of MSXML6 then reintall SQL SERVER it should work.

I think this is the link i used to download the tool.

http://www.softpedia.com/get/Security/Secure-cleaning/Windows-Installer-CleanUp-Utility.shtml

Problem in Installing SQL Server 2000 Personal

Hi... I recently reformatted my pc due to a very slow operation. Then I reinstall SQL Server 2000 Personal to my PC running Windows XP OS....As I run the setup, it will display INTERNAL ERROR and won't continue... What seemed to be the problem there? Before I reformatted the PC, it was installed well...

In windows XP I think you can only install Client tools ! ! ! anything from the setup log ?|||

Deepak... you can install Personal Edition on XP as well.. the problem seems to be something else... check error log or post the exact error what u get

BTW why u want to install 2000 , you have SQL Server 2005 Express downloadable edition. I think u should install that...

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

http://www.databasejournal.com/features/mssql/article.php/1442281

Madhu

|||Madhu, Thanks for pointing out my mistake.......apologize for my ignorance|||

No Deepak... we all make mistake... we all are there for a common cause to its help each other and there by improve our knowledge... so pse do not take it as personal...

Madhu

|||

Madhu, I didnt take it personnally.I am indeed happy that you pointed out my mistake so that i can learn from my mistakes.......i just felt like apologising for providing a wrong information........thanks once again friend

|||

Hi...Thanks for your immediate replies...Madhu the exact error displays

"Internal Error. Contact Microsoft Technical Support."

I already have SQL Server 2005 Express installed and it does not allow connections to other pc...

I have found out about SQL Management Studio and used it instead....And it really has a good environment...

Thank for replying here.... Happy programming!

sql

Problem in Installing 64-bit Reporting Services

Hi,

Trying to install 64-bit SQL Server 2005 RTM on Windows 2003 x64 Server with SP 1. The Reporting services option is not enabled in the installation steps. The installation process gets completed, but the Reporting Services is not installed.

The server does have IIS installed, the .NET framework 2.0 is installed by SQL Server 2005 RTM itself. Am I doing anything wrong.

Can anyone help/suggest ?

Thanks in advance.

Setup should show error message in case of error.

Also, you can check setup log files in %ProgramFiles%\Microsoft SQL Server\90\Setup BootStrap\LOG\Files

|||

Unfortunately, the setup doesnt show any error. The Reporting Services option is not "enabled" during the installation steps.

Can anyone suggest any other forum, where installation issues are discussed.

Thanks in advance.

|||

Rajeeb,

We have tested RS successfully on many x64 machines, so it is definitely possible! If RS is not selectable during setup, it is because some prereq is not met. Please look carefully at the System Configuration Check screen for anything that is not "green". It is possible for IIS to be installed, but not in a configuration that allows RS to be installed.

|||Please verify that IIS is installed before installing SQL Reporting Services. IIS is a required for Reporting Services.

problem in CPU utilization

I have windows 2003 server with SQL Server installed on it for live calls billing but the CPU utilization is reaching the maximam and it's average above 60% which is causing lot of problems specially for the live environment. I have enough memory and free hard disk space is more than 40GB,

so where is the problem?!

Have you run done any performance analysis? Is SQL Server the only application running on the server? Have you looked for any long running queries that might cause the problem? Have you look for blocks and locking issues? Have you kept the server and SQL Server up to date will all Service Packs, and patches? You need to provide a little more information to get any kind of usefull answer to your question.

Brad Feaker|||

the problem solved.

There ware triggers running every second on the server

problem in CPU utilization

I have windows 2003 server with SQL Server installed on it for live calls billing but the CPU utilization is reaching the maximam and it's average above 60% which is causing lot of problems specially for the live environment. I have enough memory and free hard disk space is more than 40GB,

so where is the problem?!

Have you run done any performance analysis? Is SQL Server the only application running on the server? Have you looked for any long running queries that might cause the problem? Have you look for blocks and locking issues? Have you kept the server and SQL Server up to date will all Service Packs, and patches? You need to provide a little more information to get any kind of usefull answer to your question.

Brad Feaker
|||

the problem solved.

There ware triggers running every second on the server

problem in connection with SQLServer using DSN

Hi all,
I am using OdbcConnection for coonectivity with SQL Server db. My code
is working fine with windows application but in ASP.NET or in
webservice its raising following exception -
"ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.
ERROR [01000] [Microsoft][ODBC SQL Server Driver]
[DBNETLIB]ConnectionOpen (Connect())."
at System.Data.Odbc.OdbcConnection.Open()
Same code is working fine for Orace DSN.
My code:
OdbcConnection conn = new
OdbcConnection("dsn=MyDsn;uid=sa;pwd=stars;");
conn.Open();
Please help me to sort out this problem
Thanks
Dharmendra
I expect the reason that no one jumped on this question (which has been
asked and answered a million times) is that you're clearly not following the
advice given here and elsewhere. I suggest you do some reading about getting
connected to SQL Server. The 4th through 6th Editions of my Hitchhiker's
Guide to Visual Basic and SQL Server discuss how to connect via ODBC to SQL
Server. However, they do not talk about the fact that recent versions of SQL
Server require that you enable connectivity before attempting to connect.
This is covered in detail in my latest book and in whitepapers posted on my
blog (see www.betav.com/blogs/billva). And be sure to stop using SA
credentials to handle your customer's data...
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"tomar" <dharmendratomar2000@.gmail.com> wrote in message
news:1179209227.270257.149380@.n59g2000hsh.googlegr oups.com...
> Hi all,
> I am using OdbcConnection for coonectivity with SQL Server db. My code
> is working fine with windows application but in ASP.NET or in
> webservice its raising following exception -
> "ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
> Server does not exist or access denied.
> ERROR [01000] [Microsoft][ODBC SQL Server Driver]
> [DBNETLIB]ConnectionOpen (Connect())."
> at System.Data.Odbc.OdbcConnection.Open()
> Same code is working fine for Orace DSN.
> My code:
> OdbcConnection conn = new
> OdbcConnection("dsn=MyDsn;uid=sa;pwd=stars;");
> conn.Open();
>
> Please help me to sort out this problem
> Thanks
> Dharmendra
>
|||Thanks for response.
I have tested it dsn through Odbcad32 . It gets connected with sql
server db but when I try to connect via ASP.NET code. It gives error.
Important thing is that
when I load the application with same code on other machine. It works
fine.
Regards
Dharmendra,
================================================== =======
On May 17, 1:20 am, "William \(Bill\) Vaughn"
<billvaRemoveT...@.betav.com> wrote:
> I expect the reason that no one jumped on this question (which has been
> asked and answered a million times) is that you're clearly not following the
> advice given here and elsewhere. I suggest you do some reading about getting
> connected to SQL Server. The 4th through 6th Editions of my Hitchhiker's
> Guide to Visual Basic and SQL Server discuss how to connect via ODBC to SQL
> Server. However, they do not talk about the fact that recent versions of SQL
> Server require that you enable connectivity before attempting to connect.
> This is covered in detail in my latest book and in whitepapers posted on my
> blog (seewww.betav.com/blogs/billva). And be sure to stop using SA
> credentials to handle your customer's data...
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speakerwww.betav.com/blog/billvawww.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visitwww.hitchhikerguides.netto get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----X---
> "tomar" <dharmendratomar2...@.gmail.com> wrote in message
> news:1179209227.270257.149380@.n59g2000hsh.googlegr oups.com...
>
>
>
>
>
> - Show quoted text -

problem in connection with SQLServer using DSN

Hi all,
I am using OdbcConnection for coonectivity with SQL Server db. My code
is working fine with windows application but in ASP.NET or in
webservice its raising following exception -
"ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]
SQL
Server does not exist or access denied.
ERROR [01000] [Microsoft][ODBC SQL Server Driver]
[DBNETLIB]ConnectionOpen (Connect())."
at System.Data.Odbc.OdbcConnection.Open()
Same code is working fine for Orace DSN.
My code:
OdbcConnection conn = new
OdbcConnection("dsn=MyDsn;uid=sa;pwd=stars;");
conn.Open();
Please help me to sort out this problem
Thanks
DharmendraI expect the reason that no one jumped on this question (which has been
asked and answered a million times) is that you're clearly not following the
advice given here and elsewhere. I suggest you do some reading about getting
connected to SQL Server. The 4th through 6th Editions of my Hitchhiker's
Guide to Visual Basic and SQL Server discuss how to connect via ODBC to SQL
Server. However, they do not talk about the fact that recent versions of SQL
Server require that you enable connectivity before attempting to connect.
This is covered in detail in my latest book and in whitepapers posted on my
blog (see www.betav.com/blogs/billva). And be sure to stop using SA
credentials to handle your customer's data...
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"tomar" <dharmendratomar2000@.gmail.com> wrote in message
news:1179209227.270257.149380@.n59g2000hsh.googlegroups.com...
> Hi all,
> I am using OdbcConnection for coonectivity with SQL Server db. My code
> is working fine with windows application but in ASP.NET or in
> webservice its raising following exception -
> "ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLI
B]SQL
> Server does not exist or access denied.
> ERROR [01000] [Microsoft][ODBC SQL Server Driver]
> [DBNETLIB]ConnectionOpen (Connect())."
> at System.Data.Odbc.OdbcConnection.Open()
> Same code is working fine for Orace DSN.
> My code:
> OdbcConnection conn = new
> OdbcConnection("dsn=MyDsn;uid=sa;pwd=stars;");
> conn.Open();
>
> Please help me to sort out this problem
> Thanks
> Dharmendra
>|||Thanks for response.
I have tested it dsn through Odbcad32 . It gets connected with sql
server db but when I try to connect via ASP.NET code. It gives error.
Important thing is that
when I load the application with same code on other machine. It works
fine.
Regards
Dharmendra,
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
On May 17, 1:20 am, "William \(Bill\) Vaughn"
<billvaRemoveT...@.betav.com> wrote:
> I expect the reason that no one jumped on this question (which has been
> asked and answered a million times) is that you're clearly not following =
the
> advice given here and elsewhere. I suggest you do some reading about gett=
ing
> connected to SQL Server. The 4th through 6th Editions of my Hitchhiker's
> Guide to Visual Basic and SQL Server discuss how to connect via ODBC to S=
QL
> Server. However, they do not talk about the fact that recent versions of =
SQL
> Server require that you enable connectivity before attempting to connect.
> This is covered in detail in my latest book and in whitepapers posted on =
my
> blog (seewww.betav.com/blogs/billva). And be sure to stop using SA
> credentials to handle your customer's data...
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speakerwww.betav.com/blog/billvawww.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no right=
s=2E
> __________________________________
> Visitwww.hitchhikerguides.netto get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----=
--=AD---
> "tomar" <dharmendratomar2...@.gmail.com> wrote in message
> news:1179209227.270257.149380@.n59g2000hsh.googlegroups.com...
>
>
>
>
>
>
>
>
> - Show quoted text -sql

problem in connecting to MSDE database from the same domain

Hi!
I have installed MSDE 2000 in "Mixed Windows and SQL mode authentication with network access" .following is the command:

setup.exe DISABLENETWORKPROTOCOLS=0 SAPWD="password" INSTANCENAME="TempInstance" SECURITYMODE=SQL

Then I created the database TempDB in it.

When I try to connect this database from my program running on my machine , it works fine. But when i try to connect to it from the same program running on a different machine on the same domain.It gives error:

"SQL Server does not exist or access denied ."

Even when i run the same program in my machine to access the same TempDB database on a remote machine that is not in my domain, it works fine.

this is my connection string:
Data Source={Database server's IP Address}\TempInstance;Initial Catalog=TempDB;User ID=sa;PWD=password;

Please help.

KT.What's the operating system for the client from which you are unsuccessfully attempting to connect? What version of MDAC is running on it?

Also, be aware that a named instance install of MSDE will set up to run on a non-default port (ie, not 1433). You can verify your connectivity by determining what port the SQL listener is running on and then using telnet {ip address} {port} from your client machine. You may need to account for the alternate port on your client machine. You can set up an alias for it by running cliconfg at a command prompt on your client machine.

Regards,

hmscott|||Thanks hmscott!

Actually my problem was caused by windows firewall.

regards.
Kuldeep.

Problem in browsing cube and dimension data

I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on cube and browse the data, it open the data browsing window and following message display

"Unspecified error unable to browes the data"

So please solve my problem and what can i doKnown problem, see 873440
This is typically caused by either not having SP4 installed or installing Office after SQL Server.

_-_-_ Dave

Problem in browsing cube and dimension data

I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on cube and browse the data, it open the data browsing window and following message display

"Unspecified error unable to browes the data"

So please solve my problem and what can i doKnown problem, see 873440
This is typically caused by either not having SP4 installed or installing Office after SQL Server.

_-_-_ Dave

problem in accessing report manager and server

hi,

i installed RS 2005 on windows XP with local system account,report manager does not access.it gives

The page cannot be displayed

HTTP 500 - Internal server error
Internet Explorer

although reportmanager and reportserver directory is available in its default location.

and also when i clicked on any report on report server it gives

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Requested registry access is not allowed.

i am using my account having admin privlge

please help me.....

Amit,

Could you, please, take a look at the log files for the windows service and for the web service and let me know what errors you find there?

The RS log files are located here:

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

The log files for the RS windows service look like this: ReportServerService_(timestamp).log and the log files for the RS web service look like this: ReportServer_(timestamp).log.

Mihaela

problem in accessing report manager and server

hi,

i installed RS 2005 on windows XP with local system account,report manager does not access.it gives

The page cannot be displayed

HTTP 500 - Internal server error
Internet Explorer

although reportmanager and reportserver directory is available in its default location.

and also when i clicked on any report on report server it gives

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Requested registry access is not allowed.

i am using my account having admin privlge

please help me.....

Amit,

Could you, please, take a look at the log files for the windows service and for the web service and let me know what errors you find there?

The RS log files are located here:

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

The log files for the RS windows service look like this: ReportServerService_(timestamp).log and the log files for the RS web service look like this: ReportServer_(timestamp).log.

Mihaela

Problem getting DTS object to work on a Web form

Hi;

I would like to run a DTS package from the On click button event on a web form.

I tried using code that works in a windows form.

But ASP.net, VS 2005 doesn't like the code.

Here are the libraries that I used with the windows form.

Imports System,Imports System.Data.Imports System.Data.SqlClient.

Is there a library that I am missing ?

And here are the lines of code that won't compile:

Dim oPackageAsNew DTS.Package2Class

Dim oStepAs DTS.Step

Package.LoadFromSQLServer("123WXYZ\TRSQL", , , DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , ,"cpyPrinters2Excel", )

I am able to run the above in a windows form with no problem.

Thanks for any insights,

Gordon

Hi GMann,

The Imports statement only imports namespaces. It is not add reference to a certain library.

Since you're running DTS packages, you will need to reference the Microsoft DTSPackage Object (COM) Library(DTS.DLL). Use add reference from the Project menu.

HTH. If this does not answer you question, please feel free to mark it as Not Answered and post your reply. Thanks!

|||

These KB articles will be helpful

http://support.microsoft.com/kb/321525/en-us

http://support.microsoft.com/kb/242391/en-us

Problem encountered during the installation of Visual Studio .NET 2005 Professional on a windows

Hi ALL,

I'd tried to install Visual Studio .NET 2005 Professional Edition on a Windows 2000 domain PC, and everything was fine except the last step (i.e. installing SQL Express). I got the error message "Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession***". Further investigation on the error in "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG" and found that "Product : SQL Server Database Services Error : SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot alter the login 'sa', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information." I used a domain account with local administrator privilege to install. I doubt whether my domain policy affect the installation. Could someone tell me what security policy I should set to allow the installation of the Visual Studio .NET 2005 Professional on a domain PC.

TIA.

M Chan

Try the workaround here:

http://blogs.msdn.com/quanto/archive/2005/12/16/504693.aspx

|||

We'd tried (Put the domain account into the local Users group as well) but still failed. As a domain account, how can we list it first in the local administrators group? PS. The domain account is already belonging to the local administrators group.

TIA.

M Chan

|||

Moving thread to SQL setup forum.

|||

Hi ALL,

The domain PC is Windows XP Prof. with SP2 _ latest patches installed. The installation is run by a domain account which has local administrator privilege on the domain PC.

M Chan

|||Did you ever get this resolved. I'm having the same issue.|||Not yet. I just wonder why the setup cannot be done if the Windows XP Prof. SP2 had joined to the domain with McAfee v8.0 installed. The problem should be related to some security settings.|||

I looked through our bugs and came up with something.

Looks like if SQL Server 2005 RTM is installed in a Domain where a windows Group named 'sa', 'SA', 'Sa' or 'sA' exists, installation fails when Integrated Security is chosen. However, despite having the Windows group in the Domain, installation with Mixed Security work fine. After having installed successfully with Mixed Secuirty, the server properties can be changed to accept Integrated Security connections only. This should work.

Hope this helps.

-Jeffrey

|||

Do you know if there are installation options in the Visual Studio .NET 2005 to specify the security mode for SQL Server 2005 RTM. If no, we need to separate out the SQL 2005 Express Edition from the Visual Studio .NET 2005 and install the SQL 2005 Express Edition individually.

TIA.

M Chan

|||No, there isn't an instgall option to specify the security mode separately. You should know, though, that with integrated security, the SA account is disabled.

Problem encountered during the installation of Visual Studio .NET 2005 Professional on a windows

Hi ALL,

I'd tried to install Visual Studio .NET 2005 Professional Edition on a Windows 2000 domain PC, and everything was fine except the last step (i.e. installing SQL Express). I got the error message "Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession***". Further investigation on the error in "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG" and found that "Product : SQL Server Database Services Error : SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot alter the login 'sa', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information." I used a domain account with local administrator privilege to install. I doubt whether my domain policy affect the installation. Could someone tell me what security policy I should set to allow the installation of the Visual Studio .NET 2005 Professional on a domain PC.

TIA.

M Chan

Try the workaround here:

http://blogs.msdn.com/quanto/archive/2005/12/16/504693.aspx

|||

We'd tried (Put the domain account into the local Users group as well) but still failed. As a domain account, how can we list it first in the local administrators group? PS. The domain account is already belonging to the local administrators group.

TIA.

M Chan

|||

Moving thread to SQL setup forum.

|||

Hi ALL,

The domain PC is Windows XP Prof. with SP2 _ latest patches installed. The installation is run by a domain account which has local administrator privilege on the domain PC.

M Chan

|||Did you ever get this resolved. I'm having the same issue.
|||Not yet. I just wonder why the setup cannot be done if the Windows XP Prof. SP2 had joined to the domain with McAfee v8.0 installed. The problem should be related to some security settings.|||

I looked through our bugs and came up with something.

Looks like if SQL Server 2005 RTM is installed in a Domain where a windows Group named 'sa', 'SA', 'Sa' or 'sA' exists, installation fails when Integrated Security is chosen. However, despite having the Windows group in the Domain, installation with Mixed Security work fine. After having installed successfully with Mixed Secuirty, the server properties can be changed to accept Integrated Security connections only. This should work.

Hope this helps.

-Jeffrey

|||

Do you know if there are installation options in the Visual Studio .NET 2005 to specify the security mode for SQL Server 2005 RTM. If no, we need to separate out the SQL 2005 Express Edition from the Visual Studio .NET 2005 and install the SQL 2005 Express Edition individually.

TIA.

M Chan

|||No, there isn't an instgall option to specify the security mode separately. You should know, though, that with integrated security, the SA account is disabled.

Problem encountered during the installation of Visual Studio .NET 2005 Professional on a windows

Hi ALL,

I'd tried to install Visual Studio .NET 2005 Professional Edition on a Windows 2000 domain PC, and everything was fine except the last step (i.e. installing SQL Express). I got the error message "Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession***". Further investigation on the error in "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG" and found that "Product : SQL Server Database Services Error : SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot alter the login 'sa', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information." I used a domain account with local administrator privilege to install. I doubt whether my domain policy affect the installation. Could someone tell me what security policy I should set to allow the installation of the Visual Studio .NET 2005 Professional on a domain PC.

TIA.

M Chan

Try the workaround here:

http://blogs.msdn.com/quanto/archive/2005/12/16/504693.aspx

|||

We'd tried (Put the domain account into the local Users group as well) but still failed. As a domain account, how can we list it first in the local administrators group? PS. The domain account is already belonging to the local administrators group.

TIA.

M Chan

|||

Moving thread to SQL setup forum.

|||

Hi ALL,

The domain PC is Windows XP Prof. with SP2 _ latest patches installed. The installation is run by a domain account which has local administrator privilege on the domain PC.

M Chan

|||Did you ever get this resolved. I'm having the same issue.
|||Not yet. I just wonder why the setup cannot be done if the Windows XP Prof. SP2 had joined to the domain with McAfee v8.0 installed. The problem should be related to some security settings.|||

I looked through our bugs and came up with something.

Looks like if SQL Server 2005 RTM is installed in a Domain where a windows Group named 'sa', 'SA', 'Sa' or 'sA' exists, installation fails when Integrated Security is chosen. However, despite having the Windows group in the Domain, installation with Mixed Security work fine. After having installed successfully with Mixed Secuirty, the server properties can be changed to accept Integrated Security connections only. This should work.

Hope this helps.

-Jeffrey

|||

Do you know if there are installation options in the Visual Studio .NET 2005 to specify the security mode for SQL Server 2005 RTM. If no, we need to separate out the SQL 2005 Express Edition from the Visual Studio .NET 2005 and install the SQL 2005 Express Edition individually.

TIA.

M Chan

|||No, there isn't an instgall option to specify the security mode separately. You should know, though, that with integrated security, the SA account is disabled.

Problem Deploying Reports when using SSL

Here is my current setup. I have Report Services sp1 installed on a Windows
2000 machine with SQL Server 2000. We have successfully configured RS to
produce reports over the internet via SSL. The actual viewing of the report
over the internet works great. However, in Visual Studio I receive the
following error when trying to deploy the reports...
"The underlying connection was closed. Could not establish trust
relationship with remote server"
The only work around I have found so far is to modify the
rsreportserver.config file and change secureconnectionlevel= from 2 to 0.
Then I am able to deploy the reports and do not receive this message.
Because SSL is a must, I then have to change the secureconnectionlevel= back
to 2.
Users externally are accessing the report server via
http://FQDN/reportserver. I had gone into the rswebapplication.config file
and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl> to
<ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck. My
certificate name uses the FQDN as the site name.
My question is why I am not able to deploy my reports when the SSL is turned
on?
I hope this makes sense and I am sure I left something out. Please let me
know your thoughts. Thanks!Sounds like you're hitting the issue in this KB article
http://support.microsoft.com/default.aspx?scid=kb;en-us;823177. Are you
specifying the FQDN in VS when deploying the reports?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:B42B3849-C5FA-45AB-AEDA-D769D49ED57D@.microsoft.com...
> Here is my current setup. I have Report Services sp1 installed on a
> Windows
> 2000 machine with SQL Server 2000. We have successfully configured RS to
> produce reports over the internet via SSL. The actual viewing of the
> report
> over the internet works great. However, in Visual Studio I receive the
> following error when trying to deploy the reports...
> "The underlying connection was closed. Could not establish trust
> relationship with remote server"
> The only work around I have found so far is to modify the
> rsreportserver.config file and change secureconnectionlevel= from 2 to 0.
> Then I am able to deploy the reports and do not receive this message.
> Because SSL is a must, I then have to change the secureconnectionlevel=> back
> to 2.
> Users externally are accessing the report server via
> http://FQDN/reportserver. I had gone into the rswebapplication.config
> file
> and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl>
> to
> <ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck.
> My
> certificate name uses the FQDN as the site name.
> My question is why I am not able to deploy my reports when the SSL is
> turned
> on?
> I hope this makes sense and I am sure I left something out. Please let me
> know your thoughts. Thanks!
>

Problem creating database diagram

I have both SQL Server 2000 and SQL Server 2005 installed on my PC running windows XP SP2.

In the Microsoft SQL Server Management Studio, when I right click Database Diagram in the Object Explorer, I cannot find any option to create a database diagram. What is given is "Working with SQL Server 2000 diagrams".

How can I fix my configuration so that I am able to create database diagrams in the SQL Server 2005?

Did you expand the database diagrams folder first to get the support objects created in the database?

What menu items do you get when you right click on the database diagrams folder?

Also in Help -> about, what version of SQL Server Management Studio do you have installed?

|||1. There isn't anything to expand under the database diagrams folder.
2. Right clicking on this folder gives three items:
a. Working with SQL Server 2000 diagrams
b. Reports --> Custom Report ...
c. Refresh
3. Version info:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Hope these info help. Thanks.

Problem copying DTS jobs with Database Copy Wizard

I am using the Database Copy Wizard to copy a database from one server
to the other. Here is the server information:
Source Server: Windows 2000 Server SP4, SQL Server 2000 SP4
Destination Server: Windows 2003 Enterprise Edition SP1, SQL Server
2000 SP4
I initiate the DCW from the Source server and use the sa account to
authenticate on both servers. I need to copy all logins, jobs, etc..
so I check the appropriate boxes for this. The copy completes
successfully.
When I log onto the destination server, the database is there, logins
are there, but I don't see anything under Data Transformation Services
- Local Packages.
Do I need to turn something on/off because of the different operating
systems? I have done this successfully several times before - the
only difference this time is the OS.
Thank you!
KarriB
I dont know Exactly What u mena when you said you have copied DTS with
Database copy wizard.
Database Copy Wizard is Implemented as a DTS by Microsoft.
you can only Copy Databases or Logins/SP or Jobs etc but not DTS
Packages.
When we RUn this Wizard, it can be Run Immideatly or Scheduled for
later RUN. (option in the Last Screens of the Wizard)
If you mean you want to save this DTS, you cna do So by specifying so
on the last screens.
Maninder
MCDBA
On Jan 30, 1:00 pm, zell...@.avaya.com wrote:
> I am using the Database Copy Wizard to copy a database from one server
> to the other. Here is the server information:
> Source Server: Windows 2000 Server SP4, SQL Server 2000 SP4
> Destination Server: Windows 2003 Enterprise Edition SP1, SQL Server
> 2000 SP4
> I initiate the DCW from the Source server and use the sa account to
> authenticate on both servers. I need to copy all logins, jobs, etc..
> so I check the appropriate boxes for this. The copy completes
> successfully.
> When I log onto the destination server, the database is there, logins
> are there, but I don't see anything under Data Transformation Services
> - Local Packages.
> Do I need to turn something on/off because of the different operating
> systems? I have done this successfully several times before - the
> only difference this time is the OS.
> Thank you!
> KarriB

Problem copying DTS jobs with Database Copy Wizard

I am using the Database Copy Wizard to copy a database from one server
to the other. Here is the server information:
Source Server: Windows 2000 Server SP4, SQL Server 2000 SP4
Destination Server: Windows 2003 Enterprise Edition SP1, SQL Server
2000 SP4
I initiate the DCW from the Source server and use the sa account to
authenticate on both servers. I need to copy all logins, jobs, etc..
so I check the appropriate boxes for this. The copy completes
successfully.
When I log onto the destination server, the database is there, logins
are there, but I don't see anything under Data Transformation Services
- Local Packages.
Do I need to turn something on/off because of the different operating
systems? I have done this successfully several times before - the
only difference this time is the OS.
Thank you!
KarriBI dont know Exactly What u mena when you said you have copied DTS with
Database copy wizard.
Database Copy Wizard is Implemented as a DTS by Microsoft.
you can only Copy Databases or Logins/SP or Jobs etc but not DTS
Packages.
When we RUn this Wizard, it can be Run Immideatly or Scheduled for
later RUN. (option in the Last Screens of the Wizard)
If you mean you want to save this DTS, you cna do So by specifying so
on the last screens.
Maninder
MCDBA
On Jan 30, 1:00 pm, zell...@.avaya.com wrote:
> I am using the Database Copy Wizard to copy a database from one server
> to the other. Here is the server information:
> Source Server: Windows 2000 Server SP4, SQL Server 2000 SP4
> Destination Server: Windows 2003 Enterprise Edition SP1, SQL Server
> 2000 SP4
> I initiate the DCW from the Source server and use the sa account to
> authenticate on both servers. I need to copy all logins, jobs, etc..
> so I check the appropriate boxes for this. The copy completes
> successfully.
> When I log onto the destination server, the database is there, logins
> are there, but I don't see anything under Data Transformation Services
> - Local Packages.
> Do I need to turn something on/off because of the different operating
> systems? I have done this successfully several times before - the
> only difference this time is the OS.
> Thank you!
> KarriB