Re: Visual Basic .NET connect to SQL Server 2000

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 10:38:12 -0700

Are you using MSDE? Are you using Integrated Security=SSPI in the connection
string or did you check SQL Server security? Did you enable mixed-mode
security in MSDE? Do you have the correct accounts setup on IIS? 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"cetlavie" <cetlavie@discussions.microsoft.com> wrote in message
news:33FD4EE3-A27E-4167-935F-580A197B4842@microsoft.com...
> I just started to use Visual Basic to create web based application
programs which get data from SQL Server 2000.
> From Server Explorer, I try to create new data connection. I select server
name, and input user name and password, and select Database name. And Test
connection works fine. After I click O.K. I was asked log-in then I
experience the error:
> Unable to connect to database. It is only possibe to SQL Server Desktop
Engine database and Microsoft databases with this version of Visual Studio.
>
> As I am not familiar with Visual Basic, if somebody helps me, appreciate.
>

Relevant Pages

  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: (Newbie)Application Roles
    ... level: the database itself. ... SQL Server accommodates these needs through the use of application ... the user's connection through a specific application. ... the connection permanently loses all permissions applied to ...
    (microsoft.public.sqlserver.security)
  • Re: Help! Set up Windows Group to access application
    ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
    (microsoft.public.sqlserver.security)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Visual Studio but not to VS 2003. ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Yep, my latest book can help too, but mostly if you're targeting SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)