Re: Cannot open database requested in login
From: Murali (murali_12180@yahoo.com)
Date: 12/16/02
- Next message: Paul: "Re: Cannot open database requested in login"
- Previous message: Paul: "Re: Cannot open database requested in login"
- In reply to: Paul: "Re: Cannot open database requested in login"
- Next in thread: Paul: "Re: Cannot open database requested in login"
- Reply: Paul: "Re: Cannot open database requested in login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Murali" <murali_12180@yahoo.com> Date: Mon, 16 Dec 2002 08:22:48 -0800
you sql server is in windows authentication mode, you
should set this mixed mode. in properties of yr sql server
you should see security tab, change authentication to "SQL
server and windows"
Murali - NY
>-----Original Message-----
>I can see the option for WIndows Authentication and
another option for SQL
>Server Authentication.
>
>I cannot see an option for both.
>
>Could you be more specific?
>
>
>"Murali" <murali_12180@yahoo.com> wrote in message
>news:043f01c2a515$c4fc23b0$89f82ecf@TK2MSFTNGXA01...
>> goto sql server properties and in security change the
>> authentication to sql server and windows...
>>
>> Murali
>> >-----Original Message-----
>> >The db is definatly fine. This is driving me nuts.
>> >
>> >WHy the hell can I connect with sql server
authentication
>> but not Windows?
>> >
>> >
>> >"Jobi" <johan.bijnens_n_o_s_p_a_m@alz.be> wrote in
message
>> >news:atkic2$1n7$1@reader10.wxs.nl...
>> >> Maybe the default-db for that user no longer exists
or
>> the user has
>> >nolonger
>> >> access to that db.
>> >> --attatch/restore could have that impact
>> >>
>> >> Jobi
>> >> "Paul" <paul@themedialounge.com> wrote in message
>> >> news:Om4V1JPpCHA.2360@TK2MSFTNGP09...
>> >> > 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.
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Paul: "Re: Cannot open database requested in login"
- Previous message: Paul: "Re: Cannot open database requested in login"
- In reply to: Paul: "Re: Cannot open database requested in login"
- Next in thread: Paul: "Re: Cannot open database requested in login"
- Reply: Paul: "Re: Cannot open database requested in login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
