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 |
|
myhab
Starting Member
13 Posts |
 Posted - 2003-10-11 : 16:27:42
|
| Hello,SQL Server service manager was working perfectly but I changed TCP/IP Server port and after that I refesh the SQL Server manger but after that I get this errorthe server did not start due to log on failure,please tell me how can i solve this problem ?Regards |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-13 : 02:21:52
|
| What does "I changed TCP/IP Server port" mean? What exactly did you do? It sounds like you've only completed half of a change, like telling the server to listen on a different port, but not telling the client to communicate on that port.In the process, did you change anything else, such as the server name or SQL service login name?--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-13 : 12:37:32
|
| When you change the port that SQL Server listens on, the client machines need to have an alias created. You can do this using Client Network Utility. Did you restart the MSSQLSERVER service after the change?Tara |
|
|
|
|
|
|
Logon failure