The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Failed to Attach Database
Posted: 27 Jul 07 1:10 PM
|
Does anyone know what this means and how to resolve it
Failed to attach database: [Microsoft] ODBC SQL Server Driver][DBNETLIB] SQLServer does not exist or access denied. ConnectionOpen(Connect()))
Got it while trying to install a new remote database. v7
I wiped the application on the remote and did a complete reinstall and same message.
Any ideas? |
|
|
| |
|
Re: Failed to Attach Database
Posted: 27 Jul 07 1:39 PM
|
| Yes it is and starts fine. I think it has something to do with the Computer Name? The helpdesk recently swapped pcs keeping my existing hard drive, but I noticed that the Computer Name is different. What do you think? |
|
|
|
Re: Failed to Attach Database
Posted: 27 Jul 07 1:47 PM
|
Try this:
"c:\program files\SalesLogix\AttachRemote.exe" \admin
Make sure the "MSDE Name" field contents is equal to your current local computer name. Also, check DNS to ensure there are not duplicate entries pointing to the wrong IP.
|
|
|
| |
|
Re: Failed to Attach Database
Posted: 27 Jul 07 2:03 PM
|
Make sure the "MSDE Name" field contents is equal to your current local computer name. In other words, type in your computer name in that field.
|
|
|
|
Re: Failed to Attach Database
Posted: 30 Jul 07 10:37 AM
|
| I can type in the name of the remote pc for Server, but nothing appears in the drop down under Services, what does that mean? And it says not connected \\pc name at the bottom of the SQL Server Service Manager |
|
|
|
Re: Failed to Attach Database
Posted: 31 Jul 07 1:29 PM
|
Open your SQL Server Service Manager and set the "Server" field to the local machine name. THen you can get the services information and it should say "Connected".
|
|
|
|
Re: Failed to Attach Database
Posted: 01 Aug 07 12:58 PM
|
Are you sure the SA password is correct? (blank is what it remember it always being). We've run into this in the past. What you can do is load up SQL Server Enterprise from a different box and try to connect to the remote user's local SQL Server. Try connecting as sa with a blank password. If you can't get in then the password is the issue.
I saw a couple post mentioning something about the box name. Was the name of the box renamed? That will reak havoc with SQL Server as well. Never change the box name. We've had a couple users here try that because they wanted to personalize the box. Not pretty. Usually easier to rebuild the box when that happens.
John G.
|
|
|
|
Re: Failed to Attach Database
Posted: 01 Aug 07 1:39 PM
|
Oh, something else we've run into here that you can check.. The version of MSDE on the box. There were a couple instances here when an old app was installed before SLX and it automatically installed MSDE - an older version as well.. I think 7.0. Anyway, check that the MSDE version is the correct version - SQL 2000. I think 8.00.313 and above is the version you should be looking for.
John G. |
|
|
|