Re: Cannot open database requested in login

From: Paul (paul@themedialounge.com)
Date: 12/16/02 

From: "Paul" <paul@themedialounge.com>
Date: Mon, 16 Dec 2002 12:11:31 -0000

DELL\VSdotNET is a Login and has been given permission to access the
database ITPSCustomers.

Within the Database node for ITPSCustomers database DELL\VSdotNET has been
added as a user and has been given all permisions to the tables and views
within the database.

I still get the same problem/error message.

I must be doing something wrong but I have no idea what.

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@reproms.si> wrote in
message news:eGJk9cPpCHA.1948@TK2MSFTNGP10...
> Paul,
>
> The Windows user you are using to login to SQL Server does not have access
> to the ITPSCustomers database - it is not mapped to a database user. Do
> please check the sp_grantdbaccess system SP in Books OnLine. Don't forget
> the permissions on objects as well - if you create a new database user,
it
> won't have any by default.
>
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "Paul" <paul@themedialounge.com> wrote in message
> news:Om4V1JPpCHA.2360@TK2MaSFTNGP09...
> > I have used the following string to succesfully connect to my SQL Server
> > database :
> >
> > "Provider=SQLOLEDB.1;
> > Password=monkey;
> > Persist Security Info=True;
> > User ID=VSdotNET;
> > Initial Catalog=ITPSCustomers;
> > Data Source=DELL\VSdotNET"
> >
> > The problem is that I do not want SQL Server authentication so I opened
up
> > SQL Server, removed the login VBdotNET, added it again and changed the
> user
> > authentication to Windows. I then changed the connection string to :
> >
> > "Provider=SQLOLEDB.1;
> > Integrated Security=SSPI;
> > Persist Security Info=False;
> > Initial Catalog=ITPSCustomers;
> > Data Source=DELL\VSdotNET"
> >
> > When I now run my web page I get the errors :
> >
> > System.Data.OleDb.OleDbException: Cannot open database requested in
login
> > 'ITPSCustomers'. Login fails.
> > at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
> > at System.Data.OleDb.OleDbConnection.InitializeProvider()
> > at System.Data.OleDb.OleDbConnection.Open()
> > at DreamweaverCtrls.DataSet.DoInit() System.Exception:
> > The DefaultView was requested but no tables yet exist.
> > at DreamweaverCtrls.DataSet.get_DefaultView()
> >
> > Can anyone help me out.
> >
> >
>
>

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
Quantcast