Re: Cannot open database requested in login

From: Murali (murali_12180@yahoo.com)
Date: 12/16/02 

From: "Murali" <murali_12180@yahoo.com>
Date: Mon, 16 Dec 2002 07:18:19 -0800

goto sql server properties and in security change the
authentication to sql server and windows...

>-----Original Message-----
>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: code access security
    ... Error 1 CREATE ASSEMBLY for assembly 'GmsSqlClr' failed because assembly ... owner has EXTERNAL ACCESS ASSEMBLY permission and the database has the ... make sure the database owner is mapped to the correct login on ...
    (microsoft.public.dotnet.languages.csharp)
  • 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)
Loading