January 26, 2009 at 1:58 pm
Hello everyone,
I would like your assistance on this.
I have create a virtual machine (windows 2k3 enterprise) to test SQL server 2005. I went through the installation procedure without any problem.
I have my default instance that the installation created (called test) for me and can connect to it locally with the management console.
Now I want to create two more database instance called "prod" & "dev". so I logged in locally to startup the management studio console and add two new server registration with the name mentioned above.
Everytime I try to connect to these instances I get this error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
So I google it and some newsgroups tells me that I has to do with the SQL bowser service. Which I verify that It was running fine. Now, during the installation process I used a plain domain user account to run all my services.
Could this be the problem?
January 26, 2009 at 2:38 pm
I'm not sure I'm clear on what you're running into.
You were able to connect with management studio at first, but now you can't?
Is the service still running?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 26, 2009 at 2:48 pm
No.
What I am saying is that during the initial installation SQL server created my first database instance that I named SQL2005TEST.
Everything worked fine. I can connect to it with no problem.
THe problem is that I want to create two more instance called for example SQL2005\SQL2005DEV and SQL2005\SQL2005PROD.
I have done that within the managment console. but everytime I want to initiate a connection through the mangement comsole the error message appears.
Thanks
January 26, 2009 at 2:50 pm
When you say you are creating instances through the management consol, I'm not entirely sure what you mean.
The way I've always had to create new instances was to do an installation. Maybe I'm missing something.
What exactly is it you're doing to create these instances?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 26, 2009 at 3:22 pm
Hi,
What I mean was that I started the sql management studio console, under the registered servers pane I can see my SQL2005\SQL2005TEST instance.
Now I wnt to add two more instance. so I right click on database engine and then chose new:server registration. It then pop up the server registrtion window here i can put in my settings.After I have done that. My two instances appear under the registered pane.
After that I tried to connect to it (right click:connect:object explorer) and thats when my error appear.
My goal is to have three intances (1 is created during installation+ 2 that I created myself) under the same server.
Thanks
January 26, 2009 at 3:26 pm
You have to install new instances. A new instance is a completely separate set of binaries and database files on that host. You cannot install a new instance just by trying to access it through SSMS.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 26, 2009 at 5:31 pm
Hello,
If I understand it correctly, I have to put in my install DVD, run the install and give it another install name ?
Thanks
January 26, 2009 at 5:52 pm
Yes - that is correct. And, don't forget to apply all service packs that you need (SP3 would be my recommendation).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 26, 2009 at 6:26 pm
Thanks Jeffrey,
did what you told me and now I have 3 instances in my sql server.
Regards
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply