Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Permissions Issue?

Posted on 2013-05-23
5
167 Views
Last Modified: 2013-06-03
We are using some DSN connections to retrieve and post data to our SQL database.  We recently switched servers and have been having major issues.  The server is 2003 R1 and the SQL is 10.0.5500 which I believe is 2008 SP3

We are getting this error:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Our company switched to using Windows 7 boxes and it seems like off and on we keeping having issues with permissions.  We had programs working 3 days ago and suddenly they are not working.  Programs we have not touched in months.  One in years.  

It can be in applications or a web page like below.  Always erroring out on the DSN connection.  

strConnectString = "DSN=AR;UID=user_name;PWD=password;Database=AR"

                  
if not IsObject("ojbConnection") then
      set objConnection=Server.CreateObject("ADODB.Connection")
      objConnection.ConnectionTimeout = 15
      objConnection.CommandTimeout =  10
      objConnection.Mode = 3 'adModeReadWrite
      if objConnection.state = 0 then
            objConnection.Open strConnectString
      end if
end if

HELP!!!  Anyone have any suggestions?
0
Comment
Question by:flfmmqp
  • 2
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
Matt V earned 250 total points
ID: 39193043
Do you see any errors in the event logs on the SQL server or anywhere else that might help direct us?
0
 
LVL 25

Assisted Solution

by:jogos
jogos earned 250 total points
ID: 39193312
" We recently switched servers and have been having major issues.  "

Server of the SQL or of the application?   And is your sql accessible from outside the application (management studion?) from a client that has problems.
0
 

Author Comment

by:flfmmqp
ID: 39216152
I found the problem to this issue.  Not sure how it happened but it seems as though a USER DSN connection got made somehow and that was overriding the system dsn connection.  The USER connection was pointing to the wrong server that has been decommisioned.
0
 

Author Closing Comment

by:flfmmqp
ID: 39216158
Thanks for trying to help.  I do appreciate it and am happy to give the points just for trying to help me.  Thanks.
0
 
LVL 25

Expert Comment

by:jogos
ID: 39216795
Thx,

(In future) You can also accept your own solution (without points) and the others as assisted. It's more clear what the real solution was for people who come across this question.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Home lab datacenter 9 101
Oracle DB Slows After Datapump Until Next Reboot 27 93
Cisco WRVS4400N 11 37
2960 not recognizing subinterface configuraton of 5510 11 29
#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

856 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