arghh.. can't get .NET to connect to sql server

From: NeverStill (sklett_2000_NoSpizay@yahoo.com)
Date: 09/20/02 

From: "NeverStill" <sklett_2000_NoSpizay@yahoo.com>
Date: Thu, 19 Sep 2002 21:06:31 -0700

K, 1 more quick question:
I have 2 machine on the network, "a" and "b"

I develop apps on "a" and test them on IIS running on "a", my SQL server is
installed on "b"
So, I'm trying to figure out a connection string that will work, I have
something like:
"Network Library=DBMSSOCN;Data Source=192.168.0.100,1433;User
ID=Administrator;Password=password!";

I read that I needed to define "Network Library" to tell it to use TCP/IP,
that for performance reasons, using the IP address is faster, then just the
username and hte password of the account on "b" that can use SQL server.

So I did all that, but it fails and I'm not sure why. THe username and
password that I'm defining are for the DOMAIN user on "b", could that be the
problem? How can I add additional users to the SQL server access list? This
is the same user that is listed in the enterprise manager under the security
tab. I have Authentication set to "SQL Server and Windows".

A working example or slight explanatio would be great.

Thanks!
Steve

Relevant Pages

  • Re: Network shares and printing
    ... Click Start, click Control Panel, click Network and Internet Connections, ... Type the correct DNS address in the Preferred DNS server box. ... shared drive and entering proper username and password. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Windows XP Pro and Home Connectivity
    ... What's strange though is that when I log in under the new/secondary username, ... it's as if the network wizard has not been run. ... d) The Guest account on the Pro computer is disabled. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Identify DECnet Plus (copy/fal) traffic?
    ... ON "NETWORK SECURITY" ... $ ENDIF ... GET THE REMOTE NODENAME AND USERNAME ... OBJECT FORMAT AND OBJECT NUMBER ...
    (comp.os.vms)
  • ODBC Connection with SQL Managed Provider
    ... on a "network drive". ... database using the Microsoft .NET Framework 1.1 Data Provider for SQL ... authorizing the user against a table in the SQL server database. ... for the app to display the "splash" screen (which is the first thing it does ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow per
    ... even gone as far as swapping network cables and updating NIC card drivers to ... If the box itself checked out fine, then move on to runnign SQL Server on ... Perfmon, Disk I/O, Pages, Profiler traces, checked locks/blocks, long running ... slow on these boxes to me. ...
    (microsoft.public.sqlserver.setup)