August 9, 2008 at 12:48 am
Hi everyone,
I have a SQL SERVER 2005 Developer edition.
It's been working fine for few months but now i encounter a problem: i cant log in !
Trying to log in I select the following parameters:
Server type: Database Engine
Server name: My SQL Server name
Authentication: Windows Authentication
Pressing the "Connect" button i get the following error message:
"An eror occured 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: named Pipes Provider, error 40 - could not open connection to SQL Server)
(Microsoft SQL Server, Error: 2)."
Any idea what went wrong ?
Thanks
August 9, 2008 at 2:04 am
Is the SQL server running?
Open surface area config and check that TCP/IP connections are enabled and set to local and remote.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 3:08 am
GilaMonster (8/9/2008)
Is the SQL server running?Open surface area config and check that TCP/IP connections are enabled and set to local and remote.
Hi Gail:
1. "Microsoft SQL Server Management Studio" is running
2. in "connect to server" (from "connction properties", i coldnt find "Open surface area config") i selected"tcp/ip" from "network protocol" How do i open "Surface area config" ? i couldnt find it anywhere.
Thanks
August 9, 2008 at 3:20 am
Not management studio. That's just the client tool. The SQL Server service.
Go to Microsoft SQL Server Server on your start menu, all programs. Got to configuration tools and open the SQL Server Configuration manager. Make sure that the SQL Server Service is running. I assume the SQL Server you're trying to connect to is on your local machine. If not, do this from the machine where it is installed
For surface area, go to Microsoft SQL Server Server on your start menu, all programs. Got to configuration tools and open the Surface Area config. Select the Service and Connections option. Click on remote connections on the left. What does it show on the right?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 4:43 am
Hi Gail,
This is what i did:
Start->
Programs->
SQL Server 2005->
Configuration tools->
SQL Server 2005 services->
SQL SERVER(MSSQLSERVER) - > state
The status is "stopped"
start mode->Automatic ->log on as->local system
I right cilcked on SQL SERVER (MSSQLSERVER) and clicked "start" and got an error message saying the following:
"The request failed or the service did not respond in atimely fashion.
Consult an event log or other application error logs for details".
Go to Microsoft SQL Server Server on your start menu, all programs. [/b]
August 9, 2008 at 4:58 am
Ok, so there's something wrong with the service. What's it running as? You can see that in service control manager.
See if you can find the error log (a text file called ERRORLOG), it will probably be somewhere under Program Files\Microsoft SQL Server. Exact location depends on the installation.
If you find it, what does it say?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 5:09 am
Hi Gail,
In "Surface Area Configuration for Services and Connections - localhost"
The following radio buttons are marked:
"Local and Remote connections"
"Using tcp/ip only".
Any hope ? 🙂
Thanks
August 9, 2008 at 5:13 am
See my previous post. It's a little pointless setting the connection properties for a service that isn't running.
First thing is to find out why the service isn't starting.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 5:22 am
Hi Gail,
Sorry i'm not updated with your responses. The moment i finish doing one thing i find newer response from you and i dont cope with your speed.
I found the errorlog file and this is what is says:
"SQL Server evaluation period has expired."
Strange, i have a "Developper" version and thats what i installed.
Can you solve that problem ?
Thanks
August 9, 2008 at 5:30 am
If its talking about expiration period, then its not developer.
Open the error log file. Right at the top there should be something like this:
2008-08-08 17:23:56.21 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
What does your one say?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 5:54 am
How do i do that ? This is a text file which i opened with notepad.
The "help", "about" says the following:
Microsoft SQL Server Management Studio9.00.1399.00
Microsoft Analysis Services Client Tools2005.090.1399.00
Microsoft Data Access Components (MDAC)2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer7.0.5730.13
Microsoft .NET Framework2.0.50727.1433
Operating System5.1.2600[/b]
August 9, 2008 at 5:54 am
ps (8/9/2008)
Hi Gail,Sorry i'm not updated with your responses. The moment i finish doing one thing i find newer response from you and i dont cope with your speed.
😀 Sorry. I have auto-mail notifications on the thread so I see your reply as soon as you make it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 5:59 am
ps (8/9/2008)
How do i do that ? This is a text file which i opened with notepad.
Wrong file. The one you're looking for is called "ERRORLOG". Just like that, no extension. On my machine it's in the following dir, but the dir may change depending on your installation. Easiest way, hit F3 and search for the file.
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 6:16 am
Mine has no extension either but how do i open it ? I opened it using "notepad" is there any other meaning to open it ?
Opening it using notepad there were only 2 rows inside it containing 2 columns of which one says the date and the other describes the error.
Anyway, if it is evantualy evaluation version (maybe i didt install my "developer" version waiting for the "evaluation" to expire forgetting all about it...) I might just install (or reinstall..) the "developer ?
Thanks a lot for your aid !:)
August 9, 2008 at 6:23 am
It's justa text file. Notepad works, as does everything else that can read text. The top two lines should show you the version and edition. If not, look at some of the older error log files (errorlog.1, errorlog.2, etc) they're also just text.
If it is evaluation, then you are going to have to uninstall and install developer edition.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply