Re: Problem connecting to an SQL 2005 Express Instance in RANU mod

AttachDbFilename still needs an initial catalog.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Olivier MATROT" <olivier.matrot.rte@xxxxxxxxxxxxx> wrote in message news:09CCAE10-FE2C-4429-B88A-620F743E91A5@xxxxxxxxxxxxxxxx
Remember that I'm working in RANU mode with the AttachDbFileName keyword in
the connection string.
Again, everything works fine with Windows XP. So this may be tied to the new
security model under VISTA, and I'm wondering where to search to find the
real problem here.
TIA.

"William Vaughn" wrote:

I expect you're missing the "Initial Catalog" or "Default Database" key in
the ConnectionString.
The error means you don't have access to the default database for the
selected user.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Olivier MATROT" <olivier.matrot.rte@xxxxxxxxxxxxx> wrote in message
news:59979870-E887-48A6-9A58-684730CED2F9@xxxxxxxxxxxxxxxx
>I should have looked in the error log to know more.
> Today I encountered the same problem on a Vista box.
>
> The error log shows :
> 2007-09-27 15:28:04.37 Logon Error: 18456, Severity: 14, State: > 11.
> 2007-09-27 15:28:04.37 Logon Login failed for user
> 'VistaEnt\rtefaxmfp'. [CLIENT: <named pipe>]
>
> State 11 means "Login is valid but server access failed".
> Where should I look to get more information about this issue ?
> TIA.
>
>
> "William Vaughn" wrote:
>
>> Ah, sort of. If a user is logged on to the domain then yes, you need a
>> visible (and functioning) domain controller to validate the >> credentials
>> (each time you execute Open). In some cases you can get away with not
>> having
>> a functioning domain controller for N hours but after that it will >> insist
>> on
>> reauthenticating with the DC.
>>
>> However, if the user logs on to the MACHINE (and not the domain), the
>> machine registered User credentials are used when using SSPI
>> authentication.
>>
>> -- >> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant, Dad, Grandpa
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com
>> www.betav.com/blog/billva
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest >> book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "Olivier MATROT" <olivier.matrot.rte@xxxxxxxxxxxxx> wrote in message
>> news:F46A8F26-2271-4471-8CF5-D5A49819D0B5@xxxxxxxxxxxxxxxx
>> > Solved the problem.
>> > When a computer is a domain member, only domain users are valid with
>> > SQL
>> > Integrated Security.
>> >
>> > "Olivier MATROT" wrote:
>> >
>> >> Hello,
>> >> I'm using SQL2005 Express User Instance Feature.
>> >> The OS is Windows XPSP2 up to date with updates.
>> >> I have a problem connecting to the SQL 2005 Express instance when >> >> it
>> >> is
>> >> installed while the computer is a domain member.
>> >> The user instance is accessed by a local user (as opposed to a >> >> domain
>> >> user)
>> >> attaching an MDB file with the following connection string :
>> >> "Data source=.\RTEFAXMFP;Trusted_Connection=yes;Application
>> >> Name=RTEFCDDBXP.DLL;AttachDbFileName='C:\Documents and Settings\All
>> >> Users\Application Data\RTE\RTE
>> >> FAX\SQLExpressDatabase\RTEFAXMFP.mdf';User
>> >> Instance=True".
>> >> The error is "Login failed for user 'SETUPRTEFAXEX\rtefaxmfp'.".
>> >>
>> >> When the SQL Express Instance is installed while the computer is in >> >> a
>> >> workgroup, there is no problem at all.
>> >> TIA.
>>
>>



.

Relevant Pages