Domain user can't hit SQL Server

From: jason dettman (jasondettman_at_yahoo.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 07:38:48 -0800

Hello,

I have a user on Windows 2000 running an application written in VB.net
that uses a config file with a connection string to hit a SQL 2000 DB
running on a Windows 2000 Server box. The connection string looks
something like this:
Provider=SQLOLEDB;Server=MyServer;Database=MYDB;Persist Security
Info=False;User Id=shipio;

When the user tries to perform a task that requires a DB connection, a
message pops up saying that Domain\UserAccount does not have permissions
to access the SQL server. However, there is a sql server username and
password in the connection string. Why doesn't it user it?

The application works fine when it's installed on Win XP PCs, but it
doesn't work on a win 2000 PC. Does Win2000 have a different need for
connection strings? Or does it by default send the domain account to
the sql server?

Any thoughts are greatly appreciated.

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Why do I have to enable File and Printer sharing to connect through the XP firewall?
    ... the connection string. ... IS the client connecting using a Windows account or using a SQL Server account? ... the user is me and I'm a domain/olap admin. ...
    (microsoft.public.sqlserver.clients)
  • Re: Bizzare SQL Network Error
    ... Try making sure the SQL account that you put into the connection string ... The reason the Windows app worked was because it used the account of the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connecting to DB with Static IP over the internet
    ... I was getting mental over this because the settings on the sql server i did ... item on the connection string. ... stuff from the internet. ...
    (microsoft.public.sqlserver.setup)
  • Re: Connecting using Windows Authentication
    ... You would use the following to authenticate using Windows NT integrated ... > Dirk - the connection string looks like this: ... > the SQL Server provider is expecting something to let it know how to log ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL open error
    ... I wish to use Windows authentication rather than supplying ... in Enterprise Manager reads as. ... Source=localhost in my connection string I get the error ... "SQL server does not exist or access denied". ...
    (microsoft.public.dotnet.general)