I am running Windowa XP, and I am trying to connect to any dataabase with ms sql server express, I know this is probably a newbee question, but I am a newbee kinda guy. When I try to connect I get the msg. ------------------------------Microsoft SQL Server Management Studio Error connecting to 'ABCD-6051A2AB71\SQLEXPRESS'. ------------------------------ ADDITIONAL INFORMATION: 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) At other times when I try to connect, it say's that possibly the server is not running, and indeed it is not. However I cannot get it to start, The Browser is running , both are NT AUTHORITY\LOCAL SERVICE. I could use some help here, I am trying to learn this, but at this rate I am getting nowhere fast. In advance, Thanks
Well the first issue you have to overcome is getting SQL Server to start. Have you reviewed your event logs for any type of errors? Many people have discovered after installing SQL server that their firewalls are blocking port 1433 and have to open the port. Also in Configuration Manager you have to allow remote connections and in some causes also enable TCP/IP. Post any errors you have in event viewer related to SQL Server so we can assist.
Thanks Tim, I don't for a second think that I will ever be a DBA, or a Developer. I am 60 years old and trying to learn this stuff, I am also retired (and getting more tired every second). However I will continue to try.. Thanks to you folks I may be successful. Eldon
Ok here is where I am at: I un-installed MS SQL SERVER 2008 R2, Then re-installed it. I did this several times, each time I would get errors, so finally I just tried to take everything that refered to MS SQL SERVER off (uninstall) off the ccomputer. The last time I could not get MS SQL SREVER 2008 R2 to totally un-install (it is still on the list in Add/Remove Programs Dialog Box), Also I could not get MS SQL SERVER Set-up (English) to uninstall. It is saying: MS SQL SERVER R2 Common Files, and MS SQL SERVER R2 Database Engine Shared, are still installed (in a Dialog), altho they are not on the list in Add/Remove.
I am currently trying to re-install MS SQL SERVER 2008 R2 With tools, I believe that the correct file is : SQLEXPRWT_x86_ENU.exe, and that is what I am installing, but on the Feature Selection page it has options for Advanced services. Am I trying to install the correct program ? Once Again thanks for your help. Eldon