Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Upgraded MSDE

Author  Topic 

thekingster
Starting Member

6 Posts

Posted - 2005-12-05 : 16:42:37
Hi,

I have installed sql 2000 and upgraded MSDE rather than installing a new instance. This is because I didnt want another instance of SQL on my server. It was MSDE for Backup Exec. The problem is now in Enterprise Manager my instance is called SERVER\BKUPEXEC and I am having trouble connecting to it using my asp scripts. Is there any way I can reset this back to local?

Thanks in advance...

Dave

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-12-06 : 00:03:06
Hi,
you have to specify your instance name in your Connection string to along with servername as
* server\backupexec *

:-)
Regards

Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com
Go to Top of Page

thekingster
Starting Member

6 Posts

Posted - 2005-12-07 : 18:24:54
Yes I worked that out now thank you, but how can I change it back to no instance name?
Go to Top of Page
   

- Advertisement -