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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 unable to start service

Author  Topic 

helpme
Posting Yak Master

141 Posts

Posted - 2009-04-24 : 13:00:12
I have a server hosting a default instance of sql 2008 and a named instance. On the named instance, if I set the port number to be a static number, I can't start the sql service, I get a service specific error of 13 (0xD). If I set it back to use dynam ports, I can start it. Any idea what I'm doing wrong?

helpme
Posting Yak Master

141 Posts

Posted - 2009-04-24 : 13:33:24
I've figured it out. I had a space in the tcp dynamic ports entry field.
Go to Top of Page

mikebird
Aged Yak Warrior

529 Posts

Posted - 2009-07-30 : 13:56:11
I'm having trouble getting SQL Server (instance) running when it's been fine for years. From what you say, you can set paramaeters! I don't see any in that service about TCP/IP port numbers or much else, just the general, log on and dependencies tabs... Where do you get to set those things?

Config app? Why a different app to do a simple thing? Nice design! Seperate application for each shoelace to tie!
Go to Top of Page

helpme
Posting Yak Master

141 Posts

Posted - 2009-08-04 : 08:22:14
see if this helps

http://technet.microsoft.com/en-us/library/ms345327.aspx
Go to Top of Page
   

- Advertisement -