|
|
Posted by Erland Sommarskog on 09/19/07 07:31
AMD_GAMER (amdgamer18@gmail.com) writes:
> I am running the following configuration:
> Windows Server 2003 Enterprise Edition SP2
> ASP.NET 2.0
> SQL Server 2005
>
> I currently have a website in IIS that has ASP.NET enabled. I have a
> login.aspx page which has the login box with the username and
> password. When I click the login box, I want asp.net to check the SQL
> database to check if the username and password are valid, and then
> continue to a destination page. However, I receive an error when I
> click Login.
>...
> I have tried to do the following, but to no avail. I went into the SQL
> Server Management Studio and right clicked on the server, and selected
> Properties. I then went under Connections and made sure "Allow Remote
> Connections to this server" was enabled. I also setup in SQL Service
> Area Configuration to enable both Local and TCP/IP protocols. In IIS,
> I have the database string for SQL as the following:
> Data Source=.\MSSQLSERVER2005;Initial Catalog=aspnetdb.mdf;Integrated
> Security=True
So SQL Server is running on the same machine as IIS? (I don't think this is
a recommended setup, by the way).
When you connect to the server in SSMS do you specify .\MSSQLSERVER2005 as
well? That is, is SQL Server installed as a named instance?
Furthermore, is your database really called "aspnetdb.mdf"? That is not
causing any problem at this stage, but it could be the next road block
once you make into the server.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|