Last post Apr 13, 2009 04:20 AM by Thomas Sun – MSFT
Apr 08, 2009 06:17 AM|bpranav|LINK
I created one asp.net website with some ajx controls vs2005 and published it to root of IIS.I am using aspnetdb for login purposes.I merged my aspnetdb with my cutom db PELICANBIO and attached to sql server 2005.Now i can login to PELICANBIO.
But problem is i cant access the data in my custom databse tables in PELICANBIO .i cant insert ,view data in my PELICANBIO databse.my connection string is
<add name="LocalSqlServer" connectionString="Data Source=SERVER\SQLEXPRESS;Initial Catalog=PELICANBIO;Integrated Security=True" providerName="System.Data.SqlClient"/>
"Web Deployment Project"
Apr 11, 2009 06:57 AM|soumendu|LINK
Apr 13, 2009 04:20 AM|Thomas Sun – MSFT|LINK
It seems that this post is duplicated one on
http://forums.asp.net/t/1406977.aspx. So we will focus on that post.
From your description, you use SQL Server 2005 instead of SQL Server Express. When you deploy it on IIS, you cannot retrieve the data from database, right? It seems the issue relates to connection string.
If we deploy website on the IIS, this website is running under IIS account, which does not have permission to log in your Sql Server by default.
To use Windows Authentication correctly, we need to add this account to new login and set SQL Server to either Integrated authentication or Mixed-Mode authentication.
For more information, see http://www.asp.net/learn/whitepapers/aspnet-and-iis6/ (Section: Supporting integrated authentication with SQL
We also can use SQL Server Authentication to login server. To do so, we need UserID and Password to connect database. The connection string should look like
For more information, see http://www.connectionstrings.com/?carrier=sqlserver2005
I look forward to receiving your test results.