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 |
|
rpeters83
Starting Member
1 Post |
 Posted - 2009-06-17 : 12:42:11
|
| OK, I'm trying to figure out what I did. My issues started after I removed the domain controller role from my win 2008 server. Everything works except for SQL server. First, the service won't start. The login used for it was NETWORK SERVICE. Other instances of SQL had local account being the login, so I changed it to that. Now other things aren't working right that I assume are permissions related. When I change the SQL service to start using the local account, my .NET apps can no longer connect, giving my a "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'" error. First, should I be using NETWORK SERVICE or local account in the first place? I don't know which is messed up, my sql configuration or my IIS configuration. Thanks! |
|
|
|
|
|
Messed up my SQL configuration, Need help!