Web Development

FirstPrevNext

Can not connect to sql server database from web application(Configured in IIS) --- Hemant Thaker20-Jul-09 22:12 Hemant Thaker 20-Jul-09 22:12  Hi.. My web application is in Visual studio 2005 asp.net/c#. I have sql server 2005 database at back end. When run the project in visual studio my application connects with the database, but i have configured the website in local IIS, the website runs but it does not connect to the database. I am getting following error: Cannot open database "db1" requested by the login. The login failed. Login failed for user 'HEM-BE419D4FB41\ASPNET' I am using Windows authentication to connect to sql server. my connection string is as follows "Data Source=HEM-BE419D4FB41;Initial Catalog=db1;Integrated Security=True" Please tell me the solution thanks, Hemant Thaker By: Hemant Thaker Re: Can not connect to sql server database from web application(Configured in IIS) --- DoctorMick21-Jul-09 0:15 DoctorMick 21-Jul-09 0:15  In IIS, untick Anonymous access and check integrated windows authentication in the Directory Security tab. Re: Can not connect to sql server database from web application(Configured in IIS) --- Hemant Thaker22-Jul-09 0:39 Hemant Thaker 22-Jul-09 0:39  Hi... thanks for the response... I have same project in two machines. one has sql server 2005 and the other has sql server express. It works fine where i have Sql server 2005 but not in other. what happens is.. when i browse my website from IIS it prompts me to auto generated login screen with heading "connect to XPW(machine_name)" with username and pwd...so whats going on can u tell me. i could connect to database by doing some changes like... identity impersonate=true, IIS virtual directory -> security -> windows authentication ... etc... etc... so it works fine in that particular machine, and the other has the same settings... the difference is only the edition of sqlserver/ express.... so why it gives me the prompt for login... plz help me out thanks, hemant By: Hemant Thaker Re: Can not connect to sql server database from web application(Configured in IIS) --- Paddy Boyd21-Jul-09 0:25 Paddy Boyd 21-Jul-09 0:25  Also make sure you have your web.config set up to use windows authentication and not forms auth. Re: Can not connect to sql server database from web application(Configured in IIS) ----- Hemant Thaker22-Jul-09 0:41 Hemant Thaker 22-Jul-09 0:41  Hi... thanks for the response... I have same project in two machines. one has sql server 2005 and the other has sql server express. It works fine where i have Sql server 2005 but not in other. what happens is.. when i browse my website from IIS it prompts me to auto generated login screen with heading "connect to XPW(machine_name)" with username and pwd...so whats going on can u tell me. i could connect to database by doing some changes like... identity impersonate=true, IIS virtual directory -> security -> windows authentication ... etc... etc... so it works fine in that particular machine, and the other has the same settings... the difference is only the edition of sqlserver/ express.... so why it gives me the prompt for login... plz help me out thanks, hemant By: Hemant Thaker Re: Can not connect to sql server database from web application(Configured in IIS) --- Abhishek Sur21-Jul-09 3:02 Abhishek Sur 21-Jul-09 3:02  Just add a new User for HEM-BE419D4FB41\ASPNET on the database db1. If there is no Login created for ASPNET user in your current database instance, you need to create a login account as well. Abhishek Sur My Latest Articles Working with Excel using MDAC Basics on LINQ and Lambda Expressions Create .NET Templates Re: Can not connect to sql server database from web application(Configured in IIS) --- Hemant Thaker22-Jul-09 0:38 Hemant Thaker 22-Jul-09 0:38  Hi... thanks for the response... I have same project in two machines. one has sql server 2005 and the other has sql server express. It works fine where i have Sql server 2005 but not in other. what happens is.. when i browse my website from IIS it prompts me to auto generated login screen with heading "connect to XPW(machine_name)" with username and pwd...so whats going on can u tell me. i could connect to database by doing some changes like... identity impersonate=true, IIS virtual directory -> security -> windows authentication ... etc... etc... so it works fine in that particular machine, and the other has the same settings... the difference is only the edition of sqlserver/ express.... so why it gives me the prompt for login... plz help me out thanks, hemant By: Hemant Thaker Finally I got the solution Hemant Thaker23-Jul-09 21:55 Hemant Thaker 23-Jul-09 21:55  Hi... As u said, was right but was not getting my way out creating users and logins.I did search something and its like as follows Enabling SQL Authentication STEP1: You need to enable SQL Authentication on the machine. This is complex in SQLExpress and you need to edit the registry. Copy the following lines of text onto a Notepad and save it with extention .REG. -------------COPY BELOW--------------------------------- Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer] "LoginMode"=dword:00000002 -------------COPY TILL THIS--------------------------------- STEP2: Double Click on the .REG file to change the registry. This change the Authentication Mode to enable SQL Authentication. STEP3: Restart the SQL Server Express Service or reboot the machine for registry change to take effect. Next, you need to add a user with SQLLogin. To do this: Login to SQLExpress using Express Manager and run the script below: ------------------------------------------- USE MASTER sp_addLogin 'aspuser', 'aspuser@123' GO sp_addsrvrolemember 'aspuser', 'sysadmin' GO USE Cartridge EXEC sp_adduser 'aspuser' ------------------------------------------- In case you want to reduce the privilege for the user then you can specify something other than sysadmin, but we can think of that once this works. Now change your connection string as follows: connectionString = "server=.\\SQLExpress;uid=aspuser;pwd=aspuser@123;database=cartridge;"; //////////////////////////////////////// U may need to change connectionstring probably remove one '\' from server name May be this can help someone... thanks for ur support Hemant By: Hemant Thaker call serverside functions from javascript 220820-Jul-09 21:52 2208 20-Jul-09 21:52  i want to call server side asp.net(vb) function from java script how is that possible? i really need it Re: call serverside functions from javascript Marc Firth21-Jul-09 0:01 Marc Firth 21-Jul-09 0:01  Javascript runs client side - so I don't think that's possible. However, you can use ajax to run the asp page that runs the vb function. If you are new to ajax, I suggest using jQuery (It makes the whole process a lot simpler). Neonlight Re: call serverside functions from javascript dan!sh 21-Jul-09 18:08 dan!sh 21-Jul-09 18:08  ICallbackEventHandler would do that. change asp gridview mode using javascript 220820-Jul-09 21:50 2208 20-Jul-09 21:50  i want to change gridview into edit mode using javascript requirnment is code to chage mode of asp grid veiw how is that possible? Re: change asp gridview mode using javascript Abhishek Sur21-Jul-09 3:05 Abhishek Sur 21-Jul-09 3:05  Make the gridview yourself using Repeater and html Table. then you will be having better grip on the html it renders and place the javascript calls appropriately. Abhishek Sur My Latest Articles Working with Excel using MDAC Basics on LINQ and Lambda Expressions Create .NET Templates Can I view all crystal report pages as serial ? kindman_nb20-Jul-09 10:42 kindman_nb 20-Jul-09 10:42  Hi all , I'm using asp.net and crystal report I'd like to view all pages of the crystal report in the web page without using crystal toolbar to navigate the pages .. can I do that ? jooooo Dynamically Create a WebService BenClark20-Jul-09 6:03 BenClark 20-Jul-09 6:03  I hope this is the correct forumn for this. I need to have the following functionality in my application. The application is running as an NT service. It was written using C# with .NET 3.5. The application will read a record from a SQL Server database. The record will provide a Method name, a return type and a list of parametes and their types. The application will then generate a WebService with a WebMethod which matches the database record. Now, any user can call the WebMethod. Does this make sense? I know how to create WebServices using Visual Studio and several other languages. I need to create the Web Service on the fly. In fact, I need to create one or more Web Services. Depending on how many records are in the database. Any help would be greately appreciated. Thanks Ben Clark Re: Dynamically Create a WebService Robin_Roy22-Jul-09 16:31 Robin_Roy 22-Jul-09 16:31  Hey Ben, You got to understand that Web Services are specialiazed Web Application than needs to be hosted ans should have an address to be called by the client in order to get access of the Web Methods. Accordian control in AJAX Lonnie R Thomas20-Jul-09 6:02 Lonnie R Thomas 20-Jul-09 6:02  I am trying to add an accordion control to one of my pages. Following is the code: <asp:scriptmanager id="ScriptManager1" runat="server"> <cc1:accordion id="Accordion1" runat="server"> <panes> <cc1:accordionpane id="AccordionPane1" runat="server"> but I am getting this error: An unhandled exeception has occurred. Collection was modified; enumeration operation may not execute Searched on this error but no results seemed to pertain to my problem. Can someone tell me what I have done wrong? Thanks Lonnie Lonnie R Thomas Re: Accordian control in AJAX jinaka21-Jul-09 17:51 jinaka 21-Jul-09 17:51  Add CSS class for accordion header and content. then error will dissapear..... 56464564564 Re: Accordian control in AJAX Lonnie R Thomas23-Jul-09 3:00 Lonnie R Thomas 23-Jul-09 3:00  thank you very much for your answer Lonnie R Thomas How to write in php udch19-Jul-09 0:06 udch 19-Jul-09 0:06  <iframe> This in an HTML Code.How to write this code in php ? Re: How to write in php Marc Firth19-Jul-09 22:46 Marc Firth 19-Jul-09 22:46  you use php to write html. so it's no different. you can however enclose it in quotes. so: <iframe frameborder=0 src="http://www.gmodules.com/ig/ifr?url=http://raja.com/ig/ab.xml&amp;up_k1=&&amp;up_k2=&amp;up_k3=&amp;up_k4=&amp;up_k5=&amp;up_k6=&amp;up_k7=&amp;up_k8=&amp;up_k9=&amp;up_k10=&amp;up_interval=60&amp;synd=open&amp;w=400&amp;h=50&amp;title=&amp;border=%23ffffff%7C3px%2C1px+solid+%23999999&amp;" width=412 height=60;><iframe> is the same as: <?php echo "<iframe frameborder=0 src=\"http://www.gmodules.com/ig/ifr?url=http://raja.com/ig/ab.xml&amp;up_k1=&&amp;up_k2=&amp;up_k3=&amp;up_k4=&amp;up_k5=&amp;up_k6=&amp;up_k7=&amp;up_k8=&amp;up_k9=&amp;up_k10=&amp;up_interval=60&amp;synd=open&amp;w=400&amp;h=50&amp;title=&amp;border=%23ffffff%7C3px%2C1px+solid+%23999999&amp;\" width=412 height=60;><iframe>"; ?> note the escape character "\" before quotes within the statement. Neonlight Re: How to write in php Marc Firth19-Jul-09 22:47 Marc Firth 19-Jul-09 22:47  oh and there is a php forum on this site Neonlight What is a good way to high light text etc? ProtoBytes18-Jul-09 21:22 ProtoBytes 18-Jul-09 21:22  In a developer thread on SVG the topic of high lighting text came up. I offered the YUV luminosity transform method. What is the best approach? JavaScript Hight Light Test[^] How to create .txt file udch17-Jul-09 23:59 udch 17-Jul-09 23:59  How to create .txt file in web server. I want to read text file form other website and write it in my web server which can also update data after some time.In which programing language i can make this i don't want to use php.Please help me you all can. Thank You Re: How to create .txt file Abhijit Jana18-Jul-09 0:53 Abhijit Jana 18-Jul-09 0:53  udch wrote: I want to read text file form other website and write it in my web server which can also update data after some time. You want to read content from some other site and want to save it in your web server as text file. Am I correcct? cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net My Latest Article : IIS Remote Debugging

Last Visit: 31-Dec-99 18:00     Last Update: 25-Apr-24 5:48 Refresh ᐊ Prev1...325326327328329330331332333334 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.