Installing SQL Server 2005

Hello.
I have a DC with a member server. I attempted installation and repeatedly
receive the warning regarding admin user rights. Since I can't get past
this, I can't install. I tried everything under the sun: create a new
admin, use current admin, log onto the member server locally, sign onto the
DC. Nothing works.
How can I do an installation? My only other thought was to begin the
install on the DC and point it to the C: drive of the member server.
Any thoughts.Hi Zig
Do you have any policy's running on the member server, have a look if the
user your trying to install with have the necessary permissions in the local
system policys.
Regards
Charl
http://www.sqlserver.co.za
"Zig" wrote:

> Hello.
> I have a DC with a member server. I attempted installation and repeatedly
> receive the warning regarding admin user rights. Since I can't get past
> this, I can't install. I tried everything under the sun: create a new
> admin, use current admin, log onto the member server locally, sign onto th
e
> DC. Nothing works.
> How can I do an installation? My only other thought was to begin the
> install on the DC and point it to the C: drive of the member server.
> Any thoughts.

Installing SQL Server 2005

Hello.
I have a DC with a member server. I attempted installation and repeatedly
receive the warning regarding admin user rights. Since I can't get past
this, I can't install. I tried everything under the sun: create a new
admin, use current admin, log onto the member server locally, sign onto the
DC. Nothing works.
How can I do an installation? My only other thought was to begin the
install on the DC and point it to the C: drive of the member server.
Any thoughts.
Hi Zig
Do you have any policy's running on the member server, have a look if the
user your trying to install with have the necessary permissions in the local
system policys.
Regards
Charl
http://www.sqlserver.co.za
"Zig" wrote:

> Hello.
> I have a DC with a member server. I attempted installation and repeatedly
> receive the warning regarding admin user rights. Since I can't get past
> this, I can't install. I tried everything under the sun: create a new
> admin, use current admin, log onto the member server locally, sign onto the
> DC. Nothing works.
> How can I do an installation? My only other thought was to begin the
> install on the DC and point it to the C: drive of the member server.
> Any thoughts.

Installing SQL Server 2005

Hello.
I have a DC with a member server. I attempted installation and repeatedly
receive the warning regarding admin user rights. Since I can't get past
this, I can't install. I tried everything under the sun: create a new
admin, use current admin, log onto the member server locally, sign onto the
DC. Nothing works.
How can I do an installation? My only other thought was to begin the
install on the DC and point it to the C: drive of the member server.
Any thoughts.Hi Zig
Do you have any policy's running on the member server, have a look if the
user your trying to install with have the necessary permissions in the local
system policys.
Regards
Charl
--
http://www.sqlserver.co.za
"Zig" wrote:
> Hello.
> I have a DC with a member server. I attempted installation and repeatedly
> receive the warning regarding admin user rights. Since I can't get past
> this, I can't install. I tried everything under the sun: create a new
> admin, use current admin, log onto the member server locally, sign onto the
> DC. Nothing works.
> How can I do an installation? My only other thought was to begin the
> install on the DC and point it to the C: drive of the member server.
> Any thoughts.

Installing Sql Server

Hi,

I downloaded the Sql server 2005 express advanced and installed it in my computer. Everything went well except for a warning message that said "minimum hardware requirements not met". I have dual core pentium 4 computer with 250 G hard disk and 1gb ram.

Anyways, after installing I cannot find the real application anywhere. When I goto start, programs, sql server it only shows sql server configuration tools. I have never used sql server before and how do I start the app?

Any help will be much appreciated. Please note I already installed net framework 2 and also visual studio 2005 professional.

You need to go and download Express Advanced Services which includes SQL Server Management Studio Express, thats the main GUI for SSE.|||

Hi Euan,

Thx for yr reply. Actually I downloaded & installed the sql server with advanced options but I did not see any gui. So after posting my question on this forum I downloaded the SQL Server Management Studio Express from microsoft and installed it and now I have got what I was looking for.

What I don't understand is how come if advanced options had the gui builtin it did not work in my computer?

Fareez...

|||

Hi Fareez,

Management Studio Express is included in Express Advanced, but you have to choose to install it from the Feature Tree in the Setup UI. It sounds like you just did a default install without changing the feature set being installed.

For other who experience this, you can go back into the Express Advanced setup from Add/Remove Programs and choose to install Management Studio Express, you don't have to download it separately. Just open Add/Remove Programs, select SQL Server 2005 and click Change. Follow the prompts to modify your installation.

Regards,

Mike Wachal
SQL Express team

Installing SQL Express 2K5 on a domain controller?

I want to install SQL Express 2K5 on a lightly used second Windows 2003 SP1 DC. I know about the warning not to do this type of install. However, the group is small and their budget does not allow for another server just for one application. With that being said, the error message I keep getting is "can't create local groups......" (I know that you do not have local groups with AD). So, is there a work around to this issue or can someone point me in the right direction as how to install on a domain controller? Thanks in advance for your time!!!

hi,

please have a look at http://download.microsoft.com/download/f/1/0/f10c4f60-630e-4153-bd53-c3010e4c513b/ReadmeSQLEXP2005.htm, paragraph 3.10

regards

|||

Andrea,

Thanks for the link, however that is the reason for the post. Paragrph 3.10 states "

3.10 Installing SQL Server Express on a Windows Domain Controller

Security Note:

We recommend against running SQL Server Express on a domain controller.

It is possible to install SQL Server Express on a Windows domain controller; however, it cannot run on a Windows Server 2003 domain controller as Local Service or Network Service. SQL Server service accounts should run as Windows domain user accounts. It is also possible to install SQL Server service accounts to run as Local System, but this option is not recommended."

I just need to know how to get SQLExpress to install without trying to create local accounts and use a specific network user account. Again thanks for your time and effort.

|||

You will have to create specific domain accounts for the SQL Server Services -BEFORE you attempt to install. Here are some articles with information about what accounts are needed and why.

Configuration -Service Accounts, SQL Server 2005 - Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Configuration -Service Accounts, SQL Server or SQL Server Agent service account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/en-us/library/ms143691.aspx

Configuration -Service Accounts,Selecting an Account for the SQL Server Agent Service
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
http://support.microsoft.com/kb/907557

installing sql 2005 standard on vista home premium

I have not been able to get iis to be seen correctly. I have turned on every service with IIS7 available and still get warning IIS in not running. I have changed computer name to all caps and I am running on admin account. I see IIS7 when I run localhost. What is wrong here. When I go on to install system I get stuck at detecting installed IIS. As I move forward with install owc, DB services,Notification, Intagrated, and workstation components all fail. I cant move onto sp2 because nothing is installed. I have worked on this for months off and on and now I have to have it running for deadline. Any help would be appreciated. I also have VS2005 and office 2007 on this system. I have worked on this the past two days solid and I have to have it now.

Jeff

when the install fails, what do you see in the files under the log folder under setup bootstrap?|||

Thanks Meher,

I had to uninstall all of the office components and then I was able to get past OWC11. Then I still failed with all the others. I then installed sp2. I then went back and did a mimimal install and it worked. Then I went back and reran sp2. Then I went back and did a complete reinstall and reran sp2. I now have DB on vista. On troublesome problem still is IIS7 I enabled everything I could restarted it and still system did not see it. Different forum and different issue I suspect.

Again Thanks for the williness to help.

Jeff

It would be nice put out updated install directions for sql 2005 standard(different flavors) on VISTA(different flavors). Maybe they did but hours of searching did not produce them.