Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2007-08-15 : 18:46:27
|
| Sqlserver services was not being able to start.Please suggest how to resolve the issue.. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-15 : 19:18:50
|
What is the error message you get?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2007-08-16 : 12:14:39
|
| peso,Below is the error..Cannot connect to ....Additonal information:An error has occured while establishing a connection to the server.When connecting to sqlserver 2005,this failure may be caused by the fact that under the default settings sqlserver does not allow remote connections.(Provider:Named pipes provider,error:40-could not open a connection to sqlserver)(Microsoft sqlserver,error:2) |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-08-16 : 12:41:29
|
| Check whether instance name has been given or not (for eg if sql express then rknair\sqlexpress).if its also not working then give the port number along with name seperated by a comma...RKNAIR |
|
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2007-08-16 : 12:51:27
|
| rathesshknairSqlserver services was getting started.Where do you want me to check the provide the instance name\sqlexpress.is it in the server services? |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-08-16 : 20:07:40
|
| If u r having Sql Server 2005 Express Edition just give \sq1express after the machine name when connecting using SSMS.Do u have more than one sql instance on the same machine????RKNAIR |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-16 : 22:47:44
|
| Did you enable remote access on the server? Is sql server broswer service running? You can find instance name in sql server configuration manager. |
|
|
|
askben
Starting Member
8 Posts |
Posted - 2007-08-17 : 23:22:14
|
| To see what the instance name (if it exists) is you would simply go into Administrative Tools and then Services and look for SQL Server and if there is a SQL Server (instancename) then the instance name is in the ( ), otherwise it is the default instance which means that it is simply the machine name.If there is an instance name, then you would connect with machinename\instancename as the server name.------------Ben Miller |
|
|
|
|
|
|
Server services