ADO.net and SQL Server

[Sunil Sabir]

Dear All

I am having a problem trying to establish a connection with SQL Server using ASP.net page. I am using Server Explore
to establish a connection. The connection is perfectly established if I use Northwind or pubs Database. But I am unabl
to establish a connection if I make my own database.The error is

Server Error in '/Login' Application
-------------------------------------------------------------------------------

Cannot open database requested in login 'Database_Name'. Login fails. Login failed for user 'S-SABIR\ASPNET'.

This error never shows up.when a connection is established with Northwind and Pubs database

Please help me in this case

[Kevin Spencer]

Apparently, user "S-SABIR\ASPNET" doesn't have the necessary database
permissions to log into that database. You need to go into the database in
SQL Enterprise Manager and grant that user the necessary permissions for
that database.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Sunil Sabir" <an*******@discussions.microsoft.com> wrote in message
news:D8**********************************@microsof t.com...

Dear All,

I am having a problem trying to establish a connection with SQL Server using ASP.net page. I am using Server Explorer to establish a connection. The connection is perfectly established if I use Northwind or pubs Database. But I am unable to establish a connection if I make my own database.The error is :

Server Error in '/Login' Application.
-------------------------------------------------------------------------- ------
Cannot open database requested in login 'Database_Name'. Login fails. Login failed for user 'S-SABIR\ASPNET'.
This error never shows up.when a connection is established with Northwind and Pubs database.
Please help me in this case.