April 24, 2007 at 1:21 pm
I am fairly new to SQL admin but have 15 years of other network admin knowledge. Here is my question:
We have a Windows 2003 server running sql2000 in a Windows 2k3 domain. It is not a DC. When trying to setup access to sql data thru the web browser by using xml web services I run into the following problem. When trying to setup the data source in "IIS Virtual Directory Management for SQL Server" if I try to use a Windows account (local or domain), when I try to display the listing of databases on the server, I get the error: "Unable to display the list of databases on '(local)'." If a use a SQL account instead of a windows account it will display the database listing just fine.
I have gone in and made the user "db_owner" just to make sure they had enough permissions to display the database listing but it did not help.
Can someone help me? I have found very little about this doing a web search. Thanks already, tom
April 25, 2007 at 9:10 am
Are you talking about they log into IIS with windows authentication and IIS uses their account to login to SQL? Or you are using a generic account for IIS which logins into SQL?
April 26, 2007 at 9:38 am
I think the answer to the first question is Yes. We have set up XML web services and are trying to set up the Virtual Directory Properties. On the security tab if you select SQL Server account type it works fine, if I chose windows account type it will not work for me regardless of what account I use or what permissions I give. It simply will not display the list of databases on the Data Source tab.
I can't figure out what I am doing wrong. It defaults to trying to use IUSR_computername and I made that user db_owner and it still will not work.
April 26, 2007 at 12:59 pm
Have you added computername\IUSR_computername as a Windows Login to SQL Server ???
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 18, 2007 at 1:03 pm
I am experiencing the same problem... I have tried to add the Windows login to the sql server and still no luck...
Ironically I get the list of databases when setting up through my dev machine, it only happens when I try to set up on my intranet server that the db droppdown does not display.
ideas?
June 18, 2007 at 1:06 pm
additional info
dev machine: win 2000 / IIS 5.0
intranet server: win 2003 server
sql server: win 2003, server sql server 2005
June 18, 2007 at 1:24 pm
I think that I have. We have basically abandoned this project because we were unable to figure it out and it was not critical enough to call MS and pay $250 for support.
Remind me on how to check to make sure the IUSR has been added as a Windows SQL user. I have not looked at it in 2 months so I will have to re-orient myself with the issue.
thanks for your post.
June 18, 2007 at 1:34 pm
Open Enterprise Manager and expand the SQL Server group and SQL Server instance that you want. Next go to Security and then to Logins. The Windows account should be listed, if it has been added. I hope that this helps. Thanks.
Chris
June 18, 2007 at 1:40 pm
I have tried adding the user into the SQL Server userlist
via: sql management studio --> security --> users --> add new
my username is webapps under server roles i gave all permissions (will change later)
under server roles i gave all dbs that I want it to be able to access
I also tried to add the user in the win server logins admin tools -->comp management -->local users and groups-->added servername\IUSR_compName
no dice ...
this all works from dev machine
I have double checked all settings but everything seems to be exactly the same.
June 18, 2007 at 1:51 pm
I have also tried the sql log to see if I could determine the error I was receiving but it doesnt generate an error for my webapps user.... if I try other available logins with invalid credentials it produces an error in the log. This leads me to believe that the issue is in another layer of security??
June 18, 2007 at 1:57 pm
something leads me to believe that this is an IIS issue on my intranet server (application pooling) maybe?
Are there any settings I should check therE?
June 19, 2007 at 3:14 pm
Yes, this has been done.
computername\IUSR_computername added as a Windows Login to SQL Server
June 19, 2007 at 3:35 pm
Yes I triedthat as well ... still no dropdown of databases... I typed the db name in though and it worked? something I changed along the way enabled it to work because intially I tried that and it did not. Thanks for all of the suggestions.
June 21, 2007 at 10:17 am
This is out of the blue, but have you used Profiler to monitor the DB and watch all activity when you try to log on? It might reveal something. I wish I could give you a better attack methodology, but I've never done web/IIS/SQL Server stuff.
Good luck!
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply