December 13, 2009 at 5:40 am
Hi,
I installed SQL 2005 tools 9.00.1399 from my company , as requested. After installing Sql Server 2005, I am able to connect to a remote server but not to the local server on my machine. I cant find any instance of local server running. As the remote server hosts the production servers, I find it scary to test anything on them and hence would like to have a local instance of sql server running.
This is the message I receive when I connect to the server.
Cannot connect to .\MSSQLSERVER
A network related or instance specific error occured while connectoing to SQL SErver. The server was not found or was not accessible.Verify that the instance name is correct or SQL Server is configured to allow remote connections.(provider:SQL Network Interface,error:25,Connection string is not valid)(Microsoft Sql Error:87)
I am a complete newbie to SQL Server .Please help.
Thanks in advance.
December 13, 2009 at 6:08 am
You may need to start the SQL Server yourself first. On your start menu, look for "Microsoft SQL Server 2005", then the Configuration Tools menu under that, for the "SQL Server configuration Manager". Once it comes up, select "SQL Server 2005 Services" on the left-hand side, then right-click on "SQL Server (MSSQLSERVER)".
If it is stopped, its icon will have a red square instead of a green arrow and the "Start" option will be available on the popup menu. Click the Start option and wait (anywhere from 5 to 100 seconds, depending on your system) until you get the green arrow on your icon.
You should be able to connect now.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 13, 2009 at 6:32 am
Thanks for the response.
I went on as u suggested. But when I clicked on SQL Server 2005 services, there was no items listed with it. The right hand pane states ' There are no items to show in this view.'
What do I do next?
Thanks
Bindia
December 13, 2009 at 6:42 am
Hmmm, sounds like some problem in the installation. When you say:
I installed SQL 2005 tools 9.00.1399 from my company...
what exactly did you install? Was it just the Client Tools or was it a full install? And if so, then what Edition was it?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 13, 2009 at 6:51 am
The application was called 'SQL 2005 Tools 9.0.1399'. From the looks of it, I guess it is just the Client tools and not the full install.
regards,
Bindia
December 13, 2009 at 7:02 am
Is there anything I need to install further to have the local instance of sql server running?
Please guide.
Bindia
December 13, 2009 at 7:03 am
RBarryYoung (12/13/2009)
Hmmm, sounds like some problem in the installation. When you say:I installed SQL 2005 tools 9.00.1399 from my company...
what exactly did you install? Was it just the Client Tools or was it a full install? And if so, then what Edition was it?
Yep. And of course what the "Cleint Tools" are missing is the Server parts.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 13, 2009 at 7:04 am
bindia.wahab (12/13/2009)
Is there anything I need to install further to have the local instance of sql server running?
Yes, you need to install some edition of the Server itself. Right now all you have are the Client Tools.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 13, 2009 at 7:19 am
Thank you. Well, it seems very obvious , isnt it? 🙂 (My ignorance!)
So, if I download sql server 2005 express from the net, would there be an option to have only the server install and not the client tools. I just want to confirm that there wouldnt be any clash, cos reinstalling the sql 2005 tools is not an option for us.
Thanks
December 13, 2009 at 10:33 am
Sorry, I don't know.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 16, 2009 at 9:17 am
Yes, you do have option to select what you want to install. Go for custom install and not typical. After that screen, installer will ask you to select components to select, just choose server components and not the tools.
Hope this will help.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply