I have some accounting software (Microsoft Office Accounting Professional 2009) which uses SQLExpress. I'm trying to restore a backup (the backup integrity is intact) which puts the data back into SQL, but I'm getting the error below:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is know.)"
I have spent the better part of yesterday using my good friend google with regards to this error, but so far, everything that would be remotely related hasn't worked for me. A little about my setup:
Machine: AMD Quadcore Memory: 8GB 160GB RAID1 boot 16TB RAID6+ (storage) OS: Windows Server 2003 Enterprise x64
Software running on the server: Exchange 2007 Standard x64, SQL Server 2005 Enterprise x86. Symantec Backup Exec 12.5 x64.
I've upgraded the SQL Express instances of BOTH Backup Exec and the accounting Software without any errors. SP3 of SQL 2005 has bee applied without any errors. All remaining Windows updates applicable are installed.
I've enabled TCP/IP for local and remote connections on any of the available instances. There is no firewall installed on the server (I have a commercial-grade hardware firewall in front of the box).
I have removed all 3 applications (Accounting, Backup Exec and SQL 2005) completely, including any registry entries, and re-installed all 3, etc.. no change in the error output.
I did have this identical setup working just fine when the OS was x86-based.. Could this be where my sticking point is, and if so, there must be something small somewhere I've overlooked.
Anyone have some ideas to toss around? Many thanks in advance!
asked Dec 31, 2009 at 06:51 PM in Default
You did do a SQL backup, not a file-system backup, right?
Plus, can you connect to the SQL instance in question?
answered Dec 31, 2009 at 10:58 PM
There's an option inside the accounting software to do a backup of the database files, which involves it pulling data out of the SQL instance and putting that into a single, named file. When restoring the company data, the application extracts the data from the file and inserts it into the SQL instance (the instance name is the default "MSSMLBIZ").
I have no idea how to "manually connect" to said instance; however, when I go to make a new (sample) company in the accounting software, it is able to utilize the SQL instance in question, and carry on as if nothing was wrong.
Any attempts to restore from the backup(s) fails. On another machine, I am able to do the restore, but I want the company data on the SERVER not scattered across 18 workstations.
BTW, I tried to reply via the "Comment" but the website is not taking comments to your reply.
answered Jan 02, 2010 at 09:56 PM
Not knowing the software being used, this is kind of difficult to answer, but do you have SQL Server Management Studio on your system or are you using some kind of third party TSQL querying tool? You'll need one or the other to try to connect to the Express server in order to run a backup.
answered Jan 04, 2010 at 10:54 AM
Grant Fritchey ♦♦
Is your instance installed as a named instance or default? If you are not sure how to tell, take a look at your services and give us the print out.
answered Sep 14, 2010 at 06:43 PM
Is the "SQL Server Browser" windows service running on the server? This is required for sql server to properly find named instances. I believe that SQLExpress does typically installs itself as a named instance.
answered Sep 14, 2010 at 12:05 PM