| Author |
Topic |
|
astralis
Yak Posting Veteran
62 Posts |
 Posted - 2013-07-29 : 13:50:00
|
| I have troubleshooted this for a while so I don't understand it.This 2008 Express DB has not changed for a while, then suddenly I am receiving this error and can't figure out what is wrong.I can still access the site via Management Studio, though, using the same username and password.Microsoft OLE DB Provider for SQL Server error '80004005'[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied./inc_db_setup.asp, line 10Line 10 is the last line (fixed for clarity):strBFCon = "Provider=SQLOLEDB;Data Source=REDACTED IP,PORT;database=redacted;uid=redacted;pwd=redacted;"Set adoCon = Server.CreateObject("ADODB.Connection")adoCon.connectionstring = strBFConadoCon.Open 'LINE 101. The Firewall has not changed.2. TCP/IP and Named Pipes are enabled.3. The SQL Server events do not point to any issues.4. Windows events log does not point to any issues.Please advise. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2013-07-29 : 14:05:42
|
| Yes, that's what I've been doing. I've used this same connection string for years, two years on the same machine, without a problem. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2013-07-29 : 14:20:25
|
| Sorry, I've always used the comma in the connection string. I didn't mean to put a slash in my post. I corrected it in the post. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2013-07-29 : 14:37:51
|
| Yes, the IP and Port works in Management Studio remotely and locally. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2013-07-29 : 14:46:31
|
| Tanya, I don't know what tcp is.Are you saying to post it like this? "data source =TCP:10.10.10.10,19181" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2013-07-29 : 14:58:03
|
| Tara, that worked in SSMS but not on the site. I'm still receiving the same error.My good friend's name is Tanya so my mind typed without my control. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2013-07-29 : 15:16:34
|
| I tested this on my connection that is remote from the SQL Server. Is this correct?This is inside the udl file:Provider=SQLOLEDB.1;Persist Security Info=False;User ID=redacted;Initial Catalog=redacted;Data Source=redacted ip,redacted portI was able to successfully, remotely connect and view the tables via the udl test.But when I plugged this into the connection string of the site,(along with the password) I received the same error.I guess this is pointing to a corrupt SQLOLEDB file? Or is this a permissions issue? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2013-07-29 : 16:56:10
|
| I tried it locally with no issues. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2013-07-29 : 17:18:30
|
| I tried the .1 on the site and it didn't work.I tried testing locally with and without it, too. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2013-07-29 : 18:21:15
|
| Just to confirm: how do you want me to test?1. Test connection via UDL file:I can't edit the string using this, right? I tested it remotely and locally and obtained the list of tables.2. Test connection via ASP file:This fails locally and remotely.3. Test connection via SSMS:Success remotely and locally. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Next Page
|
SQL Server does not exist or access denied.
Tara Kizer