ADO.net and SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
Dear All,

I am having a problem trying to establish a connection with SQL Server
Click to expand...
using ASP.net page. I am using Server Explorer
to establish a connection. The connection is perfectly established if I
Click to expand...
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.
Click to expand...
Login failed for user 'S-SABIR\ASPNET'.
 
Back
Top