x

Troublesome error when restoring backup data into SQL Server 2005

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!

Mike.

more ▼

asked Dec 31, 2009 at 06:51 PM in Default

mabbott gravatar image

mabbott
21 1 1 1

(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first

You did do a SQL backup, not a file-system backup, right?

Plus, can you connect to the SQL instance in question?

more ▼

answered Dec 31, 2009 at 10:58 PM

Rob Farley gravatar image

Rob Farley
5.7k 16 18 20

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Jan 02, 2010 at 09:56 PM

mabbott gravatar image

mabbott
21 1 1 1

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Jan 04, 2010 at 10:54 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered Sep 14, 2010 at 06:43 PM

Tim gravatar image

Tim
36.4k 38 41 139

(comments are locked)
10|1200 characters needed characters left

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.

See also: [http://msdn.microsoft.com/en-us/library/ms181087.aspx][1]

[1]: http://msdn.microsoft.com/en-us/library/ms181087.aspx
more ▼

answered Sep 14, 2010 at 12:05 PM

user-470 gravatar image

user-470
277 19 19 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x102

asked: Dec 31, 2009 at 06:51 PM

Seen: 2354 times

Last Updated: Dec 31, 2009 at 06:51 PM