Where is Active Directory?
On my 2008 web server box, I go to Start, Programs, Administrative Tools, there is no Active Directory installed.
I go to Server Manager, Roles, and Web Server IIS is there, but no other options.
Where is Active Directory? I need to install a user on this box to also use for access on my sql server 2000 database server box.
thanks.
I go to Server Manager, Roles, and Web Server IIS is there, but no other options.
Where is Active Directory? I need to install a user on this box to also use for access on my sql server 2000 database server box.
thanks.
Dont you need to install role Domain Controller for Active Directory to appear?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I get it installed?
You can't on this version of Server, don't think you could on web server 2003 either.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tigermatt, John,
>>or use local user accounts (lusrmgr.msc).
Here is what I need to do:
I have windows 2008 web server, I want to connect my application to my remote SQL Server 2000 database. On my Web Server 2000 box, I just create a local user and on the SQL Server 2000 box, I create a local user with the same name. Then in IIS6 I setup my anonymous user as the one with the same name for ISUR and put in the password. Then that user has access to my database, since I granted permissios for dbreader, dbwriter, etc. on my SQL Server box.
I want to do that with 2008 web server to my sql server box. But I get the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I was told in another post I had to setup a user using Active Directory. So thus the search for AD.
Can anyone help me with this please?
>>or use local user accounts (lusrmgr.msc).
Here is what I need to do:
I have windows 2008 web server, I want to connect my application to my remote SQL Server 2000 database. On my Web Server 2000 box, I just create a local user and on the SQL Server 2000 box, I create a local user with the same name. Then in IIS6 I setup my anonymous user as the one with the same name for ISUR and put in the password. Then that user has access to my database, since I granted permissios for dbreader, dbwriter, etc. on my SQL Server box.
I want to do that with 2008 web server to my sql server box. But I get the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I was told in another post I had to setup a user using Active Directory. So thus the search for AD.
Can anyone help me with this please?
ASKER
Oh, and yes, it is just windows web server version. Sigh.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
jjreese,
Yes, I read these articles on Friday and although I tried to do what they say, sadly, they are written for IIS6, not IIS7 (2008), which doesn't have properties, but does have Authentication, and it is handled very differently. Sigh.
John,
I have tried using sql server authentication, and that doesn't work either. It claims it doesn't recognize my user, although my user is an administrator.
It's not like I haven't done all this sucessfully with Windows 2000. It's just this dag-nabbit Windows 2008 and IIS7 that are driving me nuts.
I don't know why Microsoft sells a Web Server edition of Windows 2008 if you can't connect to a remote database. What's a web server without database connectivity? Is this nuts or what? Has no one done it?
Thanks.
Yes, I read these articles on Friday and although I tried to do what they say, sadly, they are written for IIS6, not IIS7 (2008), which doesn't have properties, but does have Authentication, and it is handled very differently. Sigh.
John,
I have tried using sql server authentication, and that doesn't work either. It claims it doesn't recognize my user, although my user is an administrator.
It's not like I haven't done all this sucessfully with Windows 2000. It's just this dag-nabbit Windows 2008 and IIS7 that are driving me nuts.
I don't know why Microsoft sells a Web Server edition of Windows 2008 if you can't connect to a remote database. What's a web server without database connectivity? Is this nuts or what? Has no one done it?
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks jjreese,
Nothing there I haven't tried. Sigh.
Nothing there I haven't tried. Sigh.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the added suggestion, but my database has always been in mixed mode all along. Sigh.
:(
I suppose I may need to throw out this $400 piece of junk Web Server and get the Standard edition. I wonder if Microsoft will let us "upgrade" and pay the difference?
thanks.
:(
I suppose I may need to throw out this $400 piece of junk Web Server and get the Standard edition. I wonder if Microsoft will let us "upgrade" and pay the difference?
thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So you're saying that even though I do not have active directory, I should still be able to make web server 2008 web edition communicate with sql server 2000, like my IIS6 web server 2000 does?
Because if so, I'll keep plugging, although I've already spent 3 days on this.
Otherwise, I'll have to pay another $400 and get the standard version.
Because if so, I'll keep plugging, although I've already spent 3 days on this.
Otherwise, I'll have to pay another $400 and get the standard version.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well, I know you can if the database is loaded on the same box.
Maybe they figure that's all this version needs. Sigh.
Anyway, I've opened a new ticket on here, asking that question. And have also written some microsoft employees with blogs to ask if they know.
thanks.
Maybe they figure that's all this version needs. Sigh.
Anyway, I've opened a new ticket on here, asking that question. And have also written some microsoft employees with blogs to ask if they know.
thanks.
Sorry I couldn't be more help.. :(