August 11, 2010 at 3:16 am
I have VSS 2008 on my machine and an SQL Express 2005 installed. I installed SQL Standard and I cannot connect from Management studio but to Express. I looked into the services and I can see only the SQL(SQLEXPRESS) instance running and I don't know how to make the service for my instance running...
I looked in Configuration Tools -> SQL Server Configuration Manager and cannot see my new instance but only the old Express one...
The error I got is:
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
I am interested only to log local, so far.
Any idea would be much appreciated,
thanks
August 11, 2010 at 4:11 am
Which version of windows is installed ?
What is output of the script below when you run on SSMS ?
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Second when you installed what name did you give to your new instance , did you check in services.msc with instance name as MSSQL$<NAME OF INSTANCE>
Cheers 🙂
Cheer Satish 🙂
August 11, 2010 at 4:43 am
Hi TECHBABU,
1. I have win 7 ultimate
2. the script u gave me I could run only from EXPRESS since I can not connect in my new instance with SSMS (SQL Server Management Studio). So, teh output from there is:
9.00.4053.00SP3Express Edition
3. My new instance is Teo. In services.msc there is nothing like MS... but I have SQL Server (SQLEXPRESS) Started (Automatic); I also have SQL Server Browser and SQL Server VSS Writter Started (Automatic).
It seems to me that I should have also SQL Server (TEO)... on that list but it does not exist... Wonder how could I make it enter on that list of services and then I would be able to start it and make it automatic. In Config Tools->SQL Serv Config Manger, I have under SQL Server Services only 2 things: SQL Server (SQLEXPRES) and SQL Server Browser (both Running)... no trace of my new instance (TEO).
Thank you very much for looking into my post and for trying to support me.
Ah, meanwhile, I ran also SP2 for SQL 2008 and nothing changed...
I'm looking forward for some further help.
August 11, 2010 at 10:21 am
I can think of two possible issues here. Both could be present.
First off, you can't connect to SQL Server 2008 using SSMS for 2005. But you can connect to SQL SErver 2005 using SSMS for SQL Server 2008. Check that.
Also, if you do not see your new instance in the Services control panel then I suspect that you did not install SQL Server 2008 properly. Make sure you installed the DB engine and not only the client tools.
August 11, 2010 at 11:08 am
Hi Jerry,
Thanks for your post.
The first option falls since I was trying to connect from SSMS for SQL Server 2008.
The second seems to be the real one and I deinstalled ALL SQL instances from my computer and now I try to install again.
So, I'll consider this Post closed with many thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply