This is going to be very confusing but ANY help would be greatly appreciated. We have 2 instances of SQL on our server - the first is the local instance. It is not named. It doesn't have anything in it -we've never used it for anything. I'm just scared to delete it. Anyway, the 2nd instance is TaneyDB. TaneyDB holds all of my databases. Since I've been working with ADP front ends, I've been assigning a system dsn to each computer. I attempted to do this on a system that has a Windows 2000 Pro Operating system (I don't know if that has any bearing?) Anyway, when I was creating the system DSN, it showed that I had 2 instances to choose from - both of them were TaneyDB. When I connected to the server - it looked like I had lost all of my databases. Actually, I had connected to the default instance. And, even better, I can't seem to connect to the correct instance!! How exactly did this happen? What can I do? I would really, really, really appreciate ANY help on this.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem with Default Instance
- Thread starter MelissaKT
- Start date
On the 'problem' computer....
Click start->run
Type: cliconfg
Click OK
The SQL Server Client Network Utility screen will appear. Check to see if there are any entries in the 'Alias' tab.
-George
Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
Click start->run
Type: cliconfg
Click OK
The SQL Server Client Network Utility screen will appear. Check to see if there are any entries in the 'Alias' tab.
-George
Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
- Thread starter
- #3
- Thread starter
- #5
Ok, I deleted the aliases. Then, I attempted to set up the DSN on the user's computer again. The user's computer is still seeing the default instance in place of the named instance. I then went to the server and deleted the local/default instance. Then, on my computer, I attempted to register a new Sql Server. I was still able to go to the default local instance. I haven't deleted the registry keys - that's an "in the morning project". I'd appreciate any ideas that you could throw my way.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question