Solved

SQL Server connection error

Posted on 2001-07-19
13
326 Views
Last Modified: 2011-08-18
Hi,

I have 30 workstations connecting to a SQL server, with the following connection string.

driver={SQL Server};server=" & <servername> & ";uid=sa;pwd=password;database=SAMS

Some of the workstations get the following error:

Run-time error  '-2147467259[80004005][Microsoft][ODBC SQL Server Driver][Named Pipes]Access Denied

This is after the workstation worked fine for a couple of weeks, but after getting the error for the first time, it will not connect to the server again.

Any ideas are welcome, this is quite urgent.
0
Comment
Question by:barendb
  • 4
  • 3
  • 2
  • +3
13 Comments
 
LVL 22

Accepted Solution

by:
CJ_S earned 200 total points
ID: 6297748
have you tried restarting the server? Are all connections being closed once you are done accessing the server?

try the following:
Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=sa;Initial Catalog=SAMS;Data Source=IPADDRESS
0
 
LVL 4

Expert Comment

by:VincentLawlor
ID: 6297764
What version of SQL Server are you using and what service pack ?

On your server check the number of concurrent users allowed to access your SQL server. It's under Tools SQL Server Properties.

Also make sure your Workstations all have the same versions of the NT service packs and MDAC.

Vin.





0
 

Expert Comment

by:madsun
ID: 6297865
Go to client configuration and add the server if it doesn't exist.
check whether it connects and then try connecting.
Are you using TCP/IP protocol ? Give the IP address of the server while adding the server.
This should work.
0
 
LVL 1

Expert Comment

by:loveneesh_bansal
ID: 6297883
Couple of days ago i face the same problem the main reason of the problem is that your proxy is not working properly.

The second cause is that you tcp/ip is not configure properly. Configure it from every client by giving them a proper port no.


loveneesh
0
 
LVL 1

Author Comment

by:barendb
ID: 6297899
I have enough client connections available, as all 30 workstations could access the database 2 days ago.

The server has been restarted, always the first thing I do when I get funny errors.

And I am closing all the connections once done accessing data.

Running SQL Server 7.0 SP1
Workstations all running 98
0
 
LVL 4

Expert Comment

by:VincentLawlor
ID: 6297919
He's using named pipes not TCP/IP this will work across the network also and apparently has been working for him.

This sounds like it's on an internal LAN so a proxy probably doesn't even come into it.

Also he will need to configure the Client Network utility to use TCP/IP, Named Pipes is the default.

Don't think this is the problem.

Vin.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 4

Expert Comment

by:VincentLawlor
ID: 6297926
Get SP3 for SQL Server it fixes a lot of problems like this.

http://www.microsoft.com/sql/downloads/sp3.asp

Vin.
0
 

Expert Comment

by:madsun
ID: 6297972

Try The connection string as follows,

"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=SAMS;Data Source=YourDataSourceName;Network Library=dbnmpntw"

0
 
LVL 1

Author Comment

by:barendb
ID: 6298244
I'm not rejecting your answer outright, but I don't have instant access to the network in question as it is a 5 hour drive from my offices.

I've instructed the person there to install remote control software so that I can try your proposed solution.

In the meantime I would like other people to be able to add comments, so in order to unlock the question I have to reject the answer for now.

Please insert answers as comments, it can also be selected as an aswer, but does not lock the thread.

Regards
Barend
0
 
LVL 1

Author Comment

by:barendb
ID: 6971367
No correct answers here, it was actually the user using a user id and password that did not have rights on the server, asked the user to check this first, but she's not that bright so I got the wrong answer from her.

Anyway, I'm closing all my questions and would like to award points here.  First on to respond gets the points.
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7156205
Hi barendb,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept CJ_S's comment(s) as an answer.

barendb, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Author Comment

by:barendb
ID: 7156422
OK, question is closed now, I haven't forgotten about it, just look at the last comment from me.
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7156461
Thanks for finalizing this.  -- Dan
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Vb.net 2008 2 56
VBA color chart bars 12 78
Saving history changes to sub form 4 36
how to know if my Checkbox is True in VB6.0? 9 40
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now